tweets

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

26 rows where "created_at" is on date 2021-10-28 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, created_at, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, favorited, retweeted, lang

created_at (date) 1 ✖

  • 2021-10-28 · 26 ✖
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  
1453522590094413825 swyx 33521530 2021-10-28T00:42:45+00:00 😍 Just heard back from someone in the @Coding_Career community that they got promoted to Senior! I think that's my 3rd this year. Yeah sex is great, but, have you tried mentoring complete strangers looking for help?? and have them actually follow through your advice?? 👩‍🍳😘       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275]             0 3 50 0 0   en  
1453522590941597697 swyx 33521530 2021-10-28T00:42:45+00:00 It's only been ~1.5 years since I wrote the @coding_career book. When I first put up the http://learninpublic.org page, "From Junior to Senior" was just a tagline. Now it's a reality!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 185] 1453522590094413825 33521530 swyx       0 4 17 0 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  
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  
1453546267116703745 emnul.eth 1379874346005635074 2021-10-28T02:16:50+00:00 Every single software team with a SDK needs to watch this video by @swyx . Wow!! So many insights. https://youtu.be/ddKDPikKbNk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 122]             0 5 10 1 1 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  
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  
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  
1453795383109324800 swyx 33521530 2021-10-28T18:46:44+00:00 @wongmjane poor Microsoft with 2.4 trillion market cap still waiting for senpais to notice them       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 95] 1453794889091588100 337119125 wongmjane       0 6 360 0 0   en  
1453804507385634817 swyx 33521530 2021-10-28T19:22:59+00:00 Zuck ES Modules 🤝 putting everything in meta       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 79]             0 2 61 0 0   en  
1453850194689200130 swyx 33521530 2021-10-28T22:24:32+00:00 Which of the four possible billionaire exits do you take when reality is no longer to your liking?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 99]             0 1 8 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]);