tweets

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

13 rows where "created_at" is on date 2021-09-12 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang descending

✎ 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, retweeted

source 1 ✖

  • Twitter for iPhone · 13 ✖

lang 1 ✖

created_at (date) 1 ✖

  • 2021-09-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
1436960825005252610 swyx 33521530 2021-09-12T07:52:12+00:00 @maninak_ 43mb! i hope they were building photoshop or something.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 65] 1436959270285815809 1408407818558918666 maninak_       0 1 5 0 0   en  
1436966057563013120 swyx 33521530 2021-09-12T08:13:00+00:00 @PCurell not exact answer but heres my research https://twitter.com/swyx/status/1239756967423467522   1239756967423467522 1239756967423467522   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 47] 1436731423663267843 375232562 PCurell       1 0 0 0 0 0 en  
1436973708304863238 swyx 33521530 2021-09-12T08:43:24+00:00 Lifechanging travel tip I am only learning too late in life: You can travel in shorts! Nothing in the flight rules that say you have to be in tight jeans or nice shoes. And most airports require waaay too much walking. (yes, looking at you, @Airport_FRA!) https://twitter.com/swyx/status/1436973708304863238/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 256]             0 4 80 0 0 0 en  
1436978827679387650 swyx 33521530 2021-09-12T09:03:44+00:00 @tlakomy @Airport_FRA same!! i feel like we already met before lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 66] 1436974160434106370 1903060381 tlakomy       0 0 3 0 0   en  
1436979163794223107 swyx 33521530 2021-09-12T09:05:05+00:00 @coderinheels @Airport_FRA many airports need a proper UX redesign lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 70] 1436978353249128451 32330308 coderinheels       0 0 1 0 0   en  
1436982325909364736 swyx 33521530 2021-09-12T09:17:38+00:00 RT @CouchNish: A person called OwlKitty changed the Business Card scene from “American Psycho” to the guys showing each other pictures of t… 1436104144801067033 1436104144801067033     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 49409 0 0 1   en  
1436986796680810496 swyx 33521530 2021-09-12T09:35:24+00:00 @TaliaRinger @vamchale wait what you cant leave us with that, please elaborate??       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 80] 1436379623785472004 715582520197156865 TaliaRinger       0 0 1 0 0   en  
1437025662603341829 swyx 33521530 2021-09-12T12:09:51+00:00 @simonw @pradyunsg to me, that is @anacondainc - i know it has its drawbacks, but it’s so nice living in Anaconda’s world. I’m unclear about how the larger Python community feels about it (similar to how Apollo dominates GraphQL) but they’ve certainly done a better job than anyone else i know       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 293] 1436728586669477894 12497 simonw       0 0 2 0 0   en  
1437026369163124740 swyx 33521530 2021-09-12T12:12:39+00:00 @QuinnyPig @awscloud @AWScwoud this was an absolute mangled mess lmao https://twitter.com/awscwoud/status/1436520685778530307?s=21   1436520685778530307 1436520685778530307   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [31, 94] 1436524584681963522 97114171 QuinnyPig       1 0 0 0 0 0 en  
1437048380958679042 swyx 33521530 2021-09-12T13:40:07+00:00 Valuable peek into what it is like to debate syntax inside @TC39, from someone who was actively involved but no longer is. This sort of thing is above my paygrade, but standards work affects us all, and I’m glad people this passionate have a voice in the future of JavaScript. https://twitter.com/BenLesh/status/1436890184449236994   1436890184449236994 1436890184449236994   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             1 1 33 0 0 0 en  
1437132448798806017 swyx 33521530 2021-09-12T19:14:11+00:00 Another mindchanger on Tailwind! https://twitter.com/thamasky/status/1437039454967975938   1437039454967975938 1437039454967975938   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 32] 1413018688077238273 33521530 swyx       1 0 4 0 0 0 en  
1437132718928695301 swyx 33521530 2021-09-12T19:15:15+00:00 expanded in a blogpost: https://twitter.com/swyx/status/1312603851581652994?s=21   1312603851581652994 1312603851581652994   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 47] 1253303455961079810 33521530 swyx       1 1 4 0 0 0 en  
1437134330615173123 swyx 33521530 2021-09-12T19:21:39+00:00 @markdalgleish web apps were the original decentralized apps       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 60] 1436874489816510465 257765996 markdalgleish       0 0 11 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]);