tweets

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

15 rows where "created_at" is on date 2021-09-25 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ 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, retweet_count, favorite_count, lang

created_at (date) 1 ✖

  • 2021-09-25 · 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
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  
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  
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  
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  
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  
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  
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  

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