tweets

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

13 rows where "created_at" is on date 2021-08-12 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, retweet_count, favorite_count, retweeted

source 1 ✖

  • Twitter Web App · 13 ✖

created_at (date) 1 ✖

  • 2021-08-12 · 13 ✖
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
1425618222787686404 swyx 33521530 2021-08-12T00:40:45+00:00 @betterbomb @vercel By 14 my father will finally get his pack of cigarettes and come back       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 89] 1425608082353115140 127461367 betterbomb       0 1 20 0 0   en  
1425624206524379136 swyx 33521530 2021-08-12T01:04:32+00:00 @temporalio something we debated at work that @martinfowler's Event Sourcing article leaves unclear: does Event Sourcing require you to fully reapply each function, or is it enough to just "dedupe" and restore state? https://news.ycombinator.com/item?id=28140598       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 242] 1422424339589189633 33521530 swyx       0 0 2 0 0 0 en  
1425677272644677633 swyx 33521530 2021-08-12T04:35:24+00:00 At what point did we stop having fires in fireside chats and when do we get them back       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 85]             0 0 39 0 0   en  
1425706688607260681 swyx 33521530 2021-08-12T06:32:17+00:00 @drikerf @coreyhainesco side note its pretty cool that your URL unfurls to a video!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 83] 1425702492596224002 1227758149 drikerf       0 0 2 0 0   en  
1425707376414392321 swyx 33521530 2021-08-12T06:35:01+00:00 @visakanv @boop Tech specific media sequence for the uninitiated https://medium.com/backchannel/how-the-tech-press-forces-a-narrative-on-companies-it-covers-5f89fdb7793e       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 90] 1425490068274225155 16884623 visakanv       0 0 3 0 0 0 en  
1425707553929908238 swyx 33521530 2021-08-12T06:35:43+00:00 @boop oh so you make product demo videos? Name a background musical instrument that isn't the ukelele       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 101] 1425565963986952193 14782048 boop       0 0 19 0 0   en  
1425825423837974545 ppk 🇪🇺 887251 2021-08-12T14:24:06+00:00 Breaking the web forward https://www.quirksmode.org/blog/archives/2021/08/breaking_the_we.html       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 49]             0 45 75 0 1 0 en  
1425825714788503552 James Long 14615235 2021-08-12T14:25:15+00:00 🎉 It's finally ready! I've been hacking on something for the past couple months and it's absurdly great. It's time for more powerful web apps. Announcing "A future for SQL on the web": https://jlongster.com/future-sql-web       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 209]             0 566 2316 0 1 0 en  
1425877361011027977 swyx 33521530 2021-08-12T17:50:29+00:00 RT @rob_rich: https://dev.to/swyx/an-annotated-guide-to-the-react-server-components-demo-2a83 - a look at the #React #Server #Components announcement. Nice tl;dr analysis @swyx 1425868308708999176 1425868308708999176     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 120]             0 4 0 0 1 0 en  
1425877825165221889 swyx 33521530 2021-08-12T17:52:19+00:00 @trivikram @reactjs @sveltejs @solid_js its great. its supporters get very mad when i say anything else       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [40, 103] 1425865149085224965 21297217 trivikram       0 0 9 0 0   en  
1425889455643119616 swyx 33521530 2021-08-12T18:38:32+00:00 No Apple, I don't have any music on iTunes. No Apple, I don't run my email on Apple Mail. No Apple, I don't need to look up the meaning of a word I accidentally selected and force clicked.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 190]             0 6 87 0 0   en  
1425892922717704192 swyx 33521530 2021-08-12T18:52:19+00:00 Fixes for each: 🚫 iTunes: https://krausefx.com/blog/introducing-overkill-dont-let-itunes-interrupt-your-workflow 🚫 Mail: https://discussions.apple.com/thread/1856375 🚫 Dictionary: https://apple.stackexchange.com/questions/245592/el-capitan-how-to-disable-force-click-dictionary-pop-ups-in-chrome 💁🏽‍♂️ https://twitter.com/swyx/status/1425892922717704192/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 129] 1425889455643119616 33521530 swyx       0 1 31 0 0 0 en  
1425894798477594626 swyx 33521530 2021-08-12T18:59:46+00:00 @QuinnyPig @dabit3 @undef_obj ayy this podcast finally happened!!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 66] 1344467557428809728 97114171 QuinnyPig       0 0 0 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]);