tweets

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

16 rows where "created_at" is on date 2021-10-28, retweet_count = 0 and user = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, favorite_count, lang

user 1 ✖

  • swyx · 16 ✖

retweet_count 1 ✖

created_at (date) 1 ✖

  • 2021-10-28 · 16 ✖
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

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]);