tweets
13 rows where "created_at" is on date 2021-10-28 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, is_quote_status, retweet_count, favorite_count, favorited, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1453583269354622978 | swyx 33521530 | 2021-10-28T04:43:52+00:00 | @jhooks solid @aprildunford plug alongside derpy cat | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 52] | 1453455564730560514 | 12087242 | jhooks | 0 | 0 | 6 | 0 | 0 | de | ||||||||
1453532106563338241 | swyx 33521530 | 2021-10-28T01:20:34+00:00 | @anildash honestly out of the possible range of things to emerge from before you were famous, this has got to be up there in terms of “makes you relatable and even more endearing” | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 179] | 1453368190763929602 | 36823 | anildash | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1453535469132652548 | swyx 33521530 | 2021-10-28T01:33:55+00:00 | @QuinnyPig COREY COME DROP BY @CASCADIAJS if you are free!!! cc @crtr0 i *Really* like http://optimismbrewing.com. Just beer, **bring your own food**, huge venue with lots of air. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 178] | 1453529346048622593 | 97114171 | QuinnyPig | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1453538330176413704 | swyx 33521530 | 2021-10-28T01:45:18+00:00 | RT @seldo: I don't think enough has been made of the discovery that Google's funding of AMP was an explicitly anti-competitive move designe… | 1453377986791575552 1453377986791575552 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 353 | 0 | 1 | 1 | en | ||||||||||
1453538950572691458 | swyx 33521530 | 2021-10-28T01:47:45+00:00 | RT @whereistanya: Hey, so, I've been a bit shy about announcing this, but I'm writing a book! It's called the Staff Engineer's Path. It i… | 1453510557122846722 1453510557122846722 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 218 | 0 | 1 | 1 | en | ||||||||||
1453539770630492162 | swyx 33521530 | 2021-10-28T01:51:01+00:00 | @mjackson i wrote a post about this phenomenon last year! https://twitter.com/swyx/status/1262062882050596864 | 1262062882050596864 1262062882050596864 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 57] | 1452146698323591173 | 734903 | mjackson | 1 | 0 | 6 | 0 | 0 | 0 | en | ||||||
1453560383306809350 | swyx 33521530 | 2021-10-28T03:12:55+00:00 | @robwalling started very strong! loved the meta discussion about what makes it a good podcast and then the joke about “sooo what have you built” 😂 got a good lol out of me | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 171] | 1453523669322539012 | 86174269 | robwalling | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1453581382760820741 | swyx 33521530 | 2021-10-28T04:36:22+00:00 | @Madisonkanna jealous!! please take many photos and congrats 🎉 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 62] | 1453533601857822720 | 1087957969915006976 | Madisonkanna | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1453581980247855105 | swyx 33521530 | 2021-10-28T04:38:44+00:00 | @TurnerNovak @VandelayIndust9 @EddyElfenbein we live in an economy | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [45, 66] | 1453538971942858753 | 35647451 | TurnerNovak | 0 | 0 | 9 | 0 | 0 | en | ||||||||
1453585223594041351 | swyx 33521530 | 2021-10-28T04:51:38+00:00 | just found out Garry blocked me :( this was our last interaction…which he retweeted so i think he was ok with it? people can block or mute however they want, and i try not to care. but it hurts a little when its someone i look up to and i dont know what i did :( | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 264] | 1394440978199506947 | 33521530 | swyx | 0 | 1 | 17 | 0 | 0 | en | ||||||||
1453585919110385667 | swyx 33521530 | 2021-10-28T04:54:24+00:00 | @businessbarista my money is on Snoop | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 37] | 1453499399666024463 | 846417084192055296 | businessbarista | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1453644616461271041 | swyx 33521530 | 2021-10-28T08:47:38+00:00 | RT @emanuel__sol: Every single software team with a SDK needs to watch this video by @swyx . Wow!! So many insights. https://youtu.be/ddKDPikKbNk | 1453546267116703745 1453546267116703745 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | 0 | en | |||||||||
1453537742986493955 | swyx 33521530 | 2021-10-28T01:42:58+00:00 | @ken_wheeler hahahahhaa omg unintentional burns | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 47] | 1453532433895276545 | 167193309 | ken_wheeler | 0 | 0 | 2 | 0 | 0 | nl |
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]);