tweets

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

26 rows where "created_at" is on date 2021-09-23 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, retweeted, 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
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  
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  
1440867912089161728 swyx 33521530 2021-09-23T02:37:34+00:00 RT @kentcdodds: I spent most of yesterday on my @RideOnewheel and listening to @swyx's audio reading of The @Coding_Career Handbook (https:… 1440684812885315597 1440684812885315597     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 10 0 0 1   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  
1440872926513819651 swyx 33521530 2021-09-23T02:57:30+00:00 RT @ryantakesoff: The biggest lesson I’ve learned in building a $4B company: It’s all about the people. I’m thrilled to announce today t… 1440843960776228865 1440843960776228865     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2013 0 0 1   en  
1441059558454136834 Preethi Kasireddy 1478433775 2021-09-23T15:19:06+00:00 This one is for aspiring Web 3.0 developers Many people spend months figuring out the tech stack for a Web 3.0 application... I hope this post saves you some time :) https://www.preethikasireddy.com/post/the-architecture-of-a-web-3-0-application       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 191]             0 111 485 0 0 0 en  
1441061789643403277 Ash Jogalekar 38474934 2021-09-23T15:27:58+00:00 This is the kind of content I’m on the internet for. https://twitter.com/curiouswavefn/status/1441061789643403277/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 52]             0 33 317 0 1 0 en  
1441062360811143175 Brian LeRoux 676363 2021-09-23T15:30:15+00:00 This in no way assuaged my overall skepticism but super appreciate the hype-free honesty of the current state of "web3". More of this and I'll be waaaay less skeptical. https://twitter.com/iam_preethi/status/1441059558454136834   1441059558454136834 1441059558454136834   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 168]             1 3 22 0 1 0 en  
1441070950208913413 swyx 33521530 2021-09-23T16:04:22+00:00 RT @ReactAdvanced: He's the head of #developer experience, author of a bestselling book on progressing career in IT, and a sought-after men… 1441069852127543299 1441069852127543299     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 0 1   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  
1441072853168840705 swyx 33521530 2021-09-23T16:11:56+00:00 RT @brianleroux: This in no way assuaged my overall skepticism but super appreciate the hype-free honesty of the current state of "web3". M… 1441062360811143175 1441062360811143175     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 0 1   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  
1441096838216491009 swyx 33521530 2021-09-23T17:47:15+00:00 Free startup idea: selectively rewrite some sentences of a text when distributing it, keeping original meaning but subtly tweaking words. Can use GPT-3, or synonym/grammar bank. This allows painless watermarking of secret documents, eg internal memos and scripts       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 263]             0 3 46 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  
1441147744991596544 swyx 33521530 2021-09-23T21:09:32+00:00 Just saying I'm floored by the quality of connections that I've made here. Struggling to keep up with everyone getting in touch about the book/podcast/Temporal! I do pay it fwd too. If I can help you out w a quick answer or blogpost, my email is in bio. Will eventually respond!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 1 63 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  
1441154688418783233 swyx 33521530 2021-09-23T21:37:07+00:00 If you enjoyed this thread, I'll be teaching a 4 week class with @chapter_HQ (90 min reading each week) all about career growth and Learning in Public, starting Sep 27. Open to all. Sign up at link below https://getchapter.app/@swyx/learn       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 232] 1369347682465091587 33521530 swyx       0 3 42 0 0 0 en  
1441190031939420174 swyx 33521530 2021-09-23T23:57:34+00:00 Seeking opinions - when should a startup hire its first "data person"? (not data scientist; just someone who gets data fed into one place, proactively find insights, and make it easy for others to dig up their own) whats a good milestone? B round? # employees? # "data sources"?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 1 50 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]);