tweets

This is data scraped from swyx's timeline! See blog post

15 rows where in_reply_to_user_id = 3246815913 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, is_quote_status, retweet_count, favorite_count, created_at (date)

in_reply_to_user_id 1 ✖

  • 3246815913 · 15 ✖

favorited 1 ✖

  • 0 15
id user created_at full_text retweeted_status quoted_status place source truncated display_text_range in_reply_to_status_id in_reply_to_user_id in_reply_to_screen_name geo coordinates contributors is_quote_status retweet_count favorite_count favorited retweeted possibly_sensitive lang ▼ scopes
1421684074167427076 swyx 33521530 2021-08-01T04:07:51+00:00 @Nutlope yes! be effective with the minimum spanning set of technologies to do everything you need. The hard part is figuring out how deep you wanna go as these rabbit holes are endless.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 187] 1421677709726412800 3246815913 Nutlope       0 0 2 0 0   en  
1421685384572932098 swyx 33521530 2021-08-01T04:13:03+00:00 @Nutlope see if you can come up with your own version of "7 GUIs" for the PERN stack https://eugenkiss.github.io/7guis/ and go detail everything you need to build that       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 156] 1421685143274549249 3246815913 Nutlope       0 0 4 0 0 0 en  
1421693652225589254 swyx 33521530 2021-08-01T04:45:55+00:00 @Nutlope 7guis is explicitly frontend focused, you’re more going for full stack so make your own eg in @alexbdebrie’s book he has 4 increasingly harder projects finishing in building a github clone       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 198] 1421687846428020737 3246815913 Nutlope       0 0 2 0 0   en  
1423489319247880193 swyx 33521530 2021-08-06T03:41:15+00:00 @Nutlope @designkojo yup its probably what you were gonna do anyway but giving yourself explicit permission to f around 20% of the time helps quieten your mind the remaining 80%       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 177] 1423485414246010880 3246815913 Nutlope       0 0 4 0 0   en  
1424145984620154880 swyx 33521530 2021-08-07T23:10:36+00:00 @Nutlope @thisismahmoud_ this is a crossover i haven't expected       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 63] 1424064843766657025 3246815913 Nutlope       0 0 2 0 0   en  
1424176144643878912 swyx 33521530 2021-08-08T01:10:27+00:00 @Nutlope @thisismahmoud_ yea but i didnt know specifically about Fig.. thats cool :) btw happy if clueless user here       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 117] 1424175825151152129 3246815913 Nutlope       0 0 1 0 0   en  
1424263154272333829 swyx 33521530 2021-08-08T06:56:12+00:00 @Nutlope reject 80-20, embrace 90-001       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 37] 1424206940129742852 3246815913 Nutlope       0 0 4 0 0   en  
1427547450735165440 swyx 33521530 2021-08-17T08:26:49+00:00 @Nutlope i fear not the man who has read 1000 books. i fear the man who has read 1 book 1000 times.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 99] 1427470046343925760 3246815913 Nutlope       0 0 10 0 0   en  
1435762052807659521 swyx 33521530 2021-09-09T00:28:43+00:00 @Nutlope @lauren_n_roth aww thanks man :) ironically #LearnInPublic is a form of engagement game... one that values quality/relationships, over quantity/short lived gratification       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 179] 1435751113223917574 3246815913 Nutlope       0 1 1 0 0   en  
1441465484277280775 swyx 33521530 2021-09-24T18:12:07+00:00 @Nutlope @redpointvc @SaiVC_ sign up != show up haha       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 52] 1441465303024607235 3246815913 Nutlope       0 0 0 0 0   en  
1447431259299319808 swyx 33521530 2021-10-11T05:17:58+00:00 @Nutlope “techbros have discovered resting on weekends”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 55] 1447025764868640768 3246815913 Nutlope       0 0 49 0 0   en  
1458248502941609986 swyx 33521530 2021-11-10T01:41:50+00:00 @Nutlope @alexdgus you're allowed to change it, just change it everywhere and make it mean something (joining nextjs is a pretty good reason)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 141] 1458247942029160454 3246815913 Nutlope       0 0 2 0 0   en  
1459945207097556994 swyx 33521530 2021-11-14T18:03:56+00:00 @Nutlope @ChrisSamiullah great minds https://twitter.com/david_perell/status/1261851180881174529?s=20   1261851180881174529 1261851180881174529   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 60] 1459932508129222662 3246815913 Nutlope       1 1 6 0 0 0 en  
1465524682376069129 Hassan El Mghari 3246815913 2021-11-30T03:34:47+00:00 @swyx I honestly think the highest ROI thing I ever did on Twitter was following you a year and a half ago       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 106] 1465524651719897089 3246815913 Nutlope       0 0 8 0 0   en  
1465524048574627841 swyx 33521530 2021-11-30T03:32:15+00:00 @Nutlope https://twitter.com/elzr/status/1381105950602461189   1381105950602461189 1381105950602461189   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 32] 1465521492331016193 3246815913 Nutlope       1 1 13 0 0 0 und  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [tweets] (
   [id] INTEGER PRIMARY KEY,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [full_text] TEXT,
   [retweeted_status] INTEGER,
   [quoted_status] INTEGER,
   [place] TEXT REFERENCES [places]([id]),
   [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT,
   FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]),
   FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id])
);
CREATE INDEX [idx_tweets_source]
    ON [tweets] ([source]);