tweets

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

21 rows where "created_at" is on date 2021-09-23 and retweet_count = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, created_at (date)

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
1440846596405542916 swyx 33521530 2021-09-23T01:12:52+00:00 oh damn @chriscoyier just featured my site on his video about styling scrollbars!! https://youtu.be/Ri5GSREpqRI       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 108] 1225559755080585216 33521530 swyx       0 0 4 0 0 0 en  
1440846833014566912 swyx 33521530 2021-09-23T01:13:49+00:00 @acemarke awww thank you Mark!! we should do the same one of these days when my social bar is back up, also i have a backlog of like 5 guests to record with rn haha       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [10, 164] 1440821566439186433 727704217012604928 acemarke       0 0 3 0 0   en  
1440847495626571792 swyx 33521530 2021-09-23T01:16:27+00:00 @AbhiAiyer @Netlify @ascorbic its very cool!! the natural conclusion to ssg evolution i reckon, probably better than ISR       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [30, 120] 1440846566848274436 167315972 AbhiAiyer       0 0 4 0 0   en  
1440854336297320452 swyx 33521530 2021-09-23T01:43:38+00:00 @AbhiAiyer @Netlify @ascorbic i really hope either Netlify or Gatsby invest in a good infographic that helps people choose modes and mix and match for their needs... you and i get it but i bet this is all confusing as hell for people less close to the story       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 257] 1440853737631748100 167315972 AbhiAiyer       0 0 0 0 0   en  
1440855059051343876 swyx 33521530 2021-09-23T01:46:30+00:00 @IndieHackers @mubashariqbal @mubashariqbal how are you feeling about BitClout now? is DeSo what you were expecting?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 116] 1382395742803791873 756326958946922496 IndieHackers       0 0 2 0 0   en  
1440855839384895488 swyx 33521530 2021-09-23T01:49:36+00:00 @AbhiAiyer @Netlify @ascorbic mm 404 on that link       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [30, 49] 1440855300119023617 167315972 AbhiAiyer       0 0 0 0 0   en  
1440857896078565384 swyx 33521530 2021-09-23T01:57:46+00:00 @AbhiAiyer @Netlify @ascorbic cool yeah so what i have in mind is this @_developit classic... but prettier https://developers.google.com/web/updates/2019/02/rendering-on-the-web you're gonna lose a lot of detail but just capture the essence and this is all people are going to remember anyway https://twitter.com/swyx/status/1440857896078565384/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 246] 1440856288817147905 167315972 AbhiAiyer       0 0 4 0 0 0 en  
1440866385421238276 swyx 33521530 2021-09-23T02:31:30+00:00 Today's clip: The Math Behind @theSamParr's $800k Email https://share.transistor.fm/s/7afb99a4       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 80]             0 0 4 0 0 0 en  
1440867665451503618 swyx 33521530 2021-09-23T02:36:36+00:00 @itunpredictable @supabase @GraphQL @remix_run true! cant fit it all in       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [47, 71] 1440760359292325896 637197054 itunpredictable       0 0 2 0 0   en  
1440867738625269760 swyx 33521530 2021-09-23T02:36:53+00:00 @lucasbernalte glad you are enjoying it Lucas! 🤗       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 48] 1440741221236764674 174750936 lucasbernalte       0 0 1 0 0   en  
1440867895676850178 swyx 33521530 2021-09-23T02:37:31+00:00 @tnorthcutt will do!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 20] 1440689557725319172 18384476 tnorthcutt       0 0 1 0 0   en  
1440868015386492932 swyx 33521530 2021-09-23T02:37:59+00:00 @k_Roll242 i had loads of fun! thank you for having me on and it was so nice to hang out with y'all!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 100] 1440671235617136647 573208642 k_Roll242       0 0 1 0 0   en  
1441053510225711104 swyx 33521530 2021-09-23T14:55:04+00:00 @BenAPatton yea ofc! http://swyx.io/hooks       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 44] 1441050286521569290 999866712739676160 BenAPatton       0 0 1 0 0 0 en  
1441061144517615616 swyx 33521530 2021-09-23T15:25:25+00:00 @thorwebdev @supabase yay!!! didnt see the announcement but congrats on the move!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 81] 1441041268411277322 2908098340 thorwebdev       0 0 5 0 0   en  
1441071322675699715 swyx 33521530 2021-09-23T16:05:51+00:00 @thorwebdev @supabase no no you need to announce that you're announcing something then when you announce you need to say Life Update accompanied by 10 tweet thread about why your entire life has been leading up to joining a postgres startup       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 240] 1441064449696096256 2908098340 thorwebdev       0 0 6 0 0   en  
1441072640094056453 swyx 33521530 2021-09-23T16:11:05+00:00 @Rich_Harris 12 is for Java developers       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 38] 1441055193634848768 19487837 Rich_Harris       0 0 20 0 0   en  
1441074061644386317 swyx 33521530 2021-09-23T16:16:44+00:00 @dan_charvat @localazy haha no but your app looks cool! i wonder if we could use for http://docs.temporal.io...       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 111] 1440569686194675719 959897232236535808 dan_charvat       0 0 0 0 0 0 en  
1441075713231175681 swyx 33521530 2021-09-23T16:23:18+00:00 @SvelteSociety @syntaxfm @stolinski @wesbos enjoyed this discussion! as well as the responsible disclaimer about it being apples vs oranges. also re: ecosystem - its growing, but also arguably bigger than React! https://twitter.com/SvelteSociety/status/1390082681753374723?s=20   1390082681753374723 1390082681753374723   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [44, 236] 1441016244832849929 1176969867733479424 SvelteSociety       1 0 4 0 0 0 en  
1441101547287367689 swyx 33521530 2021-09-23T18:05:57+00:00 @cassiozen haha you got it       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 26] 1441100631020761094 17484146 cassiozen       0 0 2 0 0   en  
1441138844754227202 swyx 33521530 2021-09-23T20:34:10+00:00 @sqs actually providing value with software? get out of here, this is Twitter where we argue tabs vs spaces and create fomo about magic internet money       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [5, 150] 1441126460379385856 784008 sqs       0 0 6 0 0   en  
1441154200218456067 swyx 33521530 2021-09-23T21:35:11+00:00 @ChaiWithJai @fullstack was an amazing launching pad for me!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 60] 1441151599154503685 896059763129298953 ChaiWithJai       0 0 1 0 0   en  

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]);