tweets
16 rows where "created_at" is on date 2021-10-28, favorited = 0, retweet_count = 0 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, favorite_count, lang
quoted_status 3 ✖
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 | ||||||||
1453516525172715530 | swyx 33521530 | 2021-10-28T00:18:39+00:00 | @lorendsr @stubailo @stolinski i think this is where I plug the food delivery app that Loren has been working on while he's been contracting with us on our TS SDK :) https://github.com/lorensr/food-delivery/blob/main/pages/api/orders/index.ts this is all that is needed to kick off an order | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [31, 239] | 1453501197609054215 | 215488966 | lorendsr | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1453516639698186243 | swyx 33521530 | 2021-10-28T00:19:06+00:00 | @NoelDavila @shl haha yes ty tho! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 33] | 1453515782369988608 | 20837537 | NoelDavila | 0 | 0 | 1 | 0 | 0 | en | ||||||||
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 | |||||||
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 | ||||||
1453551362961133571 | swyx 33521530 | 2021-10-28T02:37:05+00:00 | @thijsniks @anildash @cabel also the Upton Sinclair effect "It is difficult to get a man to understand something when his salary depends upon his not understanding it." | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 169] | 1453545916728676361 | 20427743 | thijsniks | 0 | 0 | 4 | 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 | ||||||||
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 | ||||||||
1453723230104133632 | swyx 33521530 | 2021-10-28T14:00:01+00:00 | this was an incredibly good read on why Amazon (mostly) doesn’t write fallback code for when things go wrong(!) https://aws.amazon.com/builders-library/avoiding-fallback-in-distributed-systems/ from @jacobgabrielson of the infamous Zero Config paper very pertinent to us at @temporalio bc we ENABLE fallbacks but dont discourage them… | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 0 | 0 | 16 | 0 | 0 | 0 | en | ||||||||||
1453791449800056834 | swyx 33521530 | 2021-10-28T18:31:06+00:00 | @github @editingemily that. was. incredible!!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 46] | 1453760137005518848 | 13334762 | github | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1453793577364905984 | swyx 33521530 | 2021-10-28T18:39:33+00:00 | got a really nice note from a mixtape listener today :) :) i joined @jerodsanto and @adamstac on the @changelog podcast yesterday (episode coming up next week!) and we were really excited about the mixtape format: - short clips - with commentary - eclectic lootbox of curation https://twitter.com/swyx/status/1398108861354057728 https://twitter.com/swyx/status/1453793577364905984/photo/1 | 1398108861354057728 1398108861354057728 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 303] | 1 | 0 | 2 | 0 | 0 | 0 | en | |||||||||
1453794483976343566 | swyx 33521530 | 2021-10-28T18:43:09+00:00 | @kvlly there are DOZENS of us!! https://twitter.com/swyx/status/1360373746897326081?s=20 | 1360373746897326081 1360373746897326081 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [7, 55] | 1453794249087102986 | 123543103 | kvlly | 1 | 0 | 7 | 0 | 0 | 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]);