tweets

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

26 rows where "created_at" is on date 2021-09-25, favorited = 0 and retweeted = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, display_text_range, in_reply_to_user_id, is_quote_status, retweet_count, favorite_count

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
1441569415917678592 swyx 33521530 2021-09-25T01:05:06+00:00 🤘🏽 Today’s mixtape clip covers the 6 year formation story of Adam and the Metal Hawks! http://share.transistor.fm/s/56304829 Rock on your weekend everyone! https://twitter.com/AMHband/status/1398777575514771459/video/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 169]             0 2 6 0 0 0 en  
1441578413437841420 swyx 33521530 2021-09-25T01:40:51+00:00 @Contextify1 @tlakomy @mthenw @cloudashdev ouch wtf       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [43, 51] 1441567963002261509 1032371837974396928 Contextify1       0 0 1 0 0   en  
1441578531641643008 swyx 33521530 2021-09-25T01:41:19+00:00 @tlakomy @mthenw @cloudashdev https://twitter.com/swyx/status/1423025792783568899?s=21   1423025792783568899 1423025792783568899   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [30, 53] 1441451260138319873 1903060381 tlakomy       1 0 3 0 0 0 und  
1441597202959421441 swyx 33521530 2021-09-25T02:55:31+00:00 @monicalimco music. wanna perform in a bar band before i die       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 60] 1441579301262872581 1265436714136297473 monicalimco       0 0 7 0 0   en  
1441597923771523072 swyx 33521530 2021-09-25T02:58:23+00:00 @beyang 1. learning how compilers work 2. learning how operating systems work 3. learning how networks work 4. learning how databases work basically all the shit people complain about in cs undergrad becomes very real very fast the second you try to do something nontrivial       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 274] 1441558898012422146 16520821 beyang       0 1 20 0 0   en  
1441604190472638464 swyx 33521530 2021-09-25T03:23:17+00:00 @QuinnyPig who ever wrote that needs their twitter access revoked good god       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 74] 1441399535054376966 97114171 QuinnyPig       0 0 5 0 0   en  
1441605814414766083 swyx 33521530 2021-09-25T03:29:44+00:00 @dprophecyguy @beyang theyd have to be self interested in learning it which is kind of where i am. but cant begrudge people for taking a 3 month bootcamp, getting a 6 figure job, and considering themselves done learning       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 219] 1441604919698419712 3314336580 dprophecyguy       0 0 1 0 0   en  
1441606638075404288 swyx 33521530 2021-09-25T03:33:00+00:00 @boop @ariel_n if i animate scrolling down between your two profile pics its like watching one person bop back and forth       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 120] 1441591451054325766 14782048 boop       0 0 1 0 0   en  
1441614613242580994 swyx 33521530 2021-09-25T04:04:42+00:00 @ryan_castner @tailwindcss haha yeah youre right. just slightly different semantic about using child selectors. will be much better with flex gap       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [27, 145] 1441511222667534352 702534787542622208 ryan_castner       0 0 3 0 0   en  
1441615374525546498 swyx 33521530 2021-09-25T04:07:43+00:00 @stephsmithio @calvin_rosser Doing Life Right ✅ congrats to you both!!!! that escalated quickly!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [29, 97] 1441129740476186633 626691391 stephsmithio       0 0 3 0 0   en  
1441635007899049992 swyx 33521530 2021-09-25T05:25:44+00:00 @flyin1501 @tailwindcss yes       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 27] 1441631459865874439 2684994602 flyin1501       0 0 0 0 0   und  
1441635264003284997 swyx 33521530 2021-09-25T05:26:45+00:00 @MathCrln @beyang actually read the textbooks and share what you learn :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 73] 1441626005609725957 369219338 MathCrln       0 0 1 0 0   en  
1441794957543608324 Angie Jones 2932738834 2021-09-25T16:01:19+00:00 The problem with learning from experts is that they are so far removed from square one. Their material assumes some foundational knowledge. Newbies, don't be afraid to share what you're learning. From the beginning. We - even the experts - need your fresh perspective!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 269]             0 470 2330 0 0   en  
1441815757847887879 swyx 33521530 2021-09-25T17:23:58+00:00 @supaspoida @tailwindcss WIP https://github.com/temporalio/samples-node/pull/15       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 52] 1441803246343843847 14205289 supaspoida       0 0 2 0 0 0 und  
1441818486636888066 swyx 33521530 2021-09-25T17:34:49+00:00 I had a wonderful chat with @liormech and @pgupta about @getamberflo and how AWS does Usage Metering and Billing! https://www.youtube.com/watch?v=zelDLiG4SLE       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 138] 1429888354192019476 33521530 swyx       0 3 4 0 0 0 en  
1441836267092709382 swyx 33521530 2021-09-25T18:45:28+00:00 Recorded next podcast with @mhevery 🔥 its a banger We talked: - @BuilderIO vs #Jamstack CMSes - @adamdbradley's Partytown - @QwikDev - Lessons from @Angular - Metabolic Health! so grateful to @ivanburazin for connecting us at @InfobipShift! Subscribe: http://youtube.com/swyxTV       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 7 50 0 0 0 en  
1441860508013903877 swyx 33521530 2021-09-25T20:21:48+00:00 @buildsghost see where you went wrong is you didnt use all caps https://twitter.com/lottelydia/status/1441335975867682817   1441335975867682817 1441335975867682817   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 63] 1441514727654318083 1175464650395111424 buildsghost       1 0 3 0 0 0 en  
1441863319317516290 swyx 33521530 2021-09-25T20:32:58+00:00 Specific things you can do that turn experts into mentors and friends: - Explain X in your own words - “Yes, and” their demos - Summarize their talks - Help repro issues - Answer FAQs Pick Up What They Put Down and you’ll be expert soon enough. How do you think they started?! https://twitter.com/techgirl1908/status/1441794957543608324   1441794957543608324 1441794957543608324   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 279]             1 2 35 0 0 0 en  
1441865756187234311 swyx 33521530 2021-09-25T20:42:39+00:00 @boop @roonmate …shit       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 21] 1441860697588002818 14782048 boop       0 0 2 0 0   en  
1441866360313634823 Shreyas Doshi 2048741 2021-09-25T20:45:03+00:00 How to pick a North Star Metric? Start with the chemical(s) your product deals with & consider the associated metric: Oxytocin - Brand metric Cortisol - Revenue metric Dopamine - Usage Frequency metric Adrenaline - Session Duration metric Endorphins - Freemium Conversion metric       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 284]             0 219 1389 0 0   en  
1441868475711037445 swyx 33521530 2021-09-25T20:53:27+00:00 Interesting alternative measure for the less biblically inclined: brain chemicals! https://twitter.com/shreyas/status/1441866360313634823?s=21   1441866360313634823 1441866360313634823   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 107] 1411461620497223681 33521530 swyx       1 0 4 0 0 0 en  
1441869112804839426 swyx 33521530 2021-09-25T20:55:59+00:00 @sompylasar @tailwindcss html structure had the pre tag in front of the buttons. so space inserted and then the block wrapped around i didnt really set up the demo to be cross scrutinized by 1500 people haha i was just tweeting a quick screenshot of my work in progress       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 270] 1441868370928812038 701571650 sompylasar       0 0 1 0 0   en  
1441903939855781891 swyx 33521530 2021-09-25T23:14:23+00:00 @Dingman @tailwindcss cool!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 27] 1441885913580195843 7765902 Dingman       0 0 0 0 0   en  
1441906183363829761 swyx 33521530 2021-09-25T23:23:18+00:00 @OphiraE @NPRAskMeAnother @jonathancoulton thank you both so, so much for 9 years of laughs and joy 🧡 Congrats on an incredible run and I will drop everything to see whatever you two get up to next       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [43, 197] 1441083393467301888 302765767 OphiraE       0 0 1 0 0   en  
1441908391211716608 swyx 33521530 2021-09-25T23:32:04+00:00 @jkup my site is still under construction with over a million visitors per year       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 79] 1441872380016701440 255634108 jkup       0 0 14 0 0   en  
1441915035194908676 swyx 33521530 2021-09-25T23:58:28+00:00 @Swizec whoo congrats swiz!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 28] 1439272771586904065 15353121 Swizec       0 0 2 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]);