tweets
13 rows where "created_at" is on date 2021-09-12 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, retweeted
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
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]);