tweets

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

18 rows where favorite_count = 5 and in_reply_to_user_id = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, is_quote_status, retweet_count

in_reply_to_user_id 1 ✖

  • 33521530 · 18 ✖

favorite_count 1 ✖

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
1423001554496507905 Ben Patton 999866712739676160 2021-08-04T19:23:03+00:00 @swyx "You don't have to agree with somebody to offer them loving attention. All you're admitting at that moment is there's a possibility that they are as complicated as you are. And everybody deserves to be heard and respected." Speaking in anything other than loves breeds hate       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 281] 1422998593158275073 33521530 swyx       0 3 5 0 1   en  
1427108654029758468 swyx 33521530 2021-08-16T03:23:12+00:00 @kspaans on our @dev_invest_feed Discord shares this digraph reverse engineering technique so you can pretty much tell at a glance what kind of file it is without any other knowledge https://recon.cx/2013/slides/Recon2013-Christopher%20Domas-The%20Future%20of%20RE-Dynamic%20Binary%20Visualization.pdf (warning... big PDF) https://twitter.com/swyx/status/1427108654029758468/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 228] 1427092639250149378 33521530 swyx       0 0 5 0 0 0 en  
1427141503743193089 swyx 33521530 2021-08-16T05:33:44+00:00 I think this is where I plug my soundcloud Gals: https://www.youtube.com/watch?v=PaghIdSJKvQ Guys: https://www.youtube.com/watch?v=9V7nQrtMQEw early 2010s collegehumor was best collegehumor       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 152] 1426711010291847170 33521530 swyx       0 0 5 0 0 0 en  
1427351641095753755 swyx 33521530 2021-08-16T19:28:44+00:00 🧑‍🤝‍🧑 Community focused DevRel is the new hotness Nothing can build loyalty like helping your users find, hire and help each other. But beware the optics of relying on unpaid labor. Events are underrated, and "superuser" programs are on the rise! https://twitter.com/swyx/status/1367518496326709251   1367518496326709251 1367518496326709251   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 273] 1427351639904571412 33521530 swyx       1 0 5 0 0 0 en  
1434967384578826245 swyx 33521530 2021-09-06T19:50:59+00:00 then after the publish, theres still lots of work to do! title taken from Simulated Annealing, which itself takes a metallurgic analogy in repeatedly reforging iron while it is hot. https://twitter.com/swyx/status/1376720619400650752 https://twitter.com/swyx/status/1434967384578826245/photo/1   1376720619400650752 1376720619400650752   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 206] 1434966806461095936 33521530 swyx       1 0 5 0 0 0 en  
1435801439331241987 swyx 33521530 2021-09-09T03:05:13+00:00 3/ I’ve handpicked 4 weeks of content, and you can expect about 90 mins/week in total. The interactions are asynchronous, which allows me to answer more of your questions. I’d love for you to join me! https://twitter.com/swyx/status/1435801439331241987/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 200] 1435801433253695491 33521530 swyx       0 0 5 0 0 0 en  
1436263100752310276 swyx 33521530 2021-09-10T09:39:42+00:00 @JanelSGM this swipe file is just growing passively over the last 2 years, waiting for me to convert it into something more serious https://twitter.com/swyx/status/1434206569881694210?s=20 https://twitter.com/swyx/status/1436263100752310276/photo/1   1434206569881694210 1434206569881694210   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 155] 1310951720269361153 33521530 swyx       1 0 5 0 0 0 en  
1441524053659947013 swyx 33521530 2021-09-24T22:04:51+00:00 Developers will literally tweet about how they have 25 years experience and still spent 4 hours chasing down an errant semicolon instead of moving to FP       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 152] 1422811409683914752 33521530 swyx       0 0 5 0 0   en  
1443999185473212416 swyx 33521530 2021-10-01T18:00:08+00:00 Google Search drops support from IE11. First a trickle, then the flood. https://twitter.com/cramforce/status/1443962459723755533?s=20   1443962459723755533 1443962459723755533   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 97] 1422432418569474050 33521530 swyx       1 0 5 0 0 0 en  
1447374493186285572 swyx 33521530 2021-10-11T01:32:24+00:00 great recap and podcast episode on Morris. Looking forward to the Jensen Huang episode @AcquiredFM !! https://twitter.com/dunkhippo33/status/1447291658739978243?s=21   1447291658739978243 1447291658739978243   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 126] 1242543872326033408 33521530 swyx       1 0 5 0 0 0 en  
1450660179976933380 swyx 33521530 2021-10-20T03:08:33+00:00 4 years on and still in awe. https://youtu.be/H3By4DZyTNM       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 53] 830637054417571840 33521530 swyx       0 0 5 0 0 0 en  
1456878684548173827 swyx 33521530 2021-11-06T06:58:40+00:00 4 day old comment on a 1 year old video getting 15k likes. https://www.youtube.com/watch?v=oC4RqrxzfMI https://twitter.com/swyx/status/1456878684548173827/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 83] 1453585223594041351 33521530 swyx       0 0 5 0 0 0 en  
1461115548406714369 swyx 33521530 2021-11-17T23:34:27+00:00 ugly cry everytim https://twitter.com/swyx/status/1271221917517668352?s=20 https://twitter.com/swyx/status/1461115548406714369/video/1   1271221917517668352 1271221917517668352   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 42] 1461046537224527877 33521530 swyx       1 0 5 0 0 0 en  
1464013496639655937 swyx 33521530 2021-11-25T23:29:52+00:00 Open source knowledge is an enormously powerful form of #LearnInPublic. Eugene started a list last year and it snowballed into 17k stars -> *only then* is he turning it into a site + newsletter! Genius. And entirely replicable on whatever you learn. https://twitter.com/eugeneyan/status/1463666344147120132?s=20   1463666344147120132 1463666344147120132   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1375853465923022856 33521530 swyx       1 1 5 0 0 0 en  
1464740702714155008 swyx 33521530 2021-11-27T23:39:31+00:00 @goEnjoy How do they make money? The suitcase has upsells - airpods, phone cases and such. They also get compensated for every install of Apple Services, e.g. if I sign up for a free month of Apple One through them. Went public at $1.1b via SPAC last month. SPAC holders *hate it* lol https://twitter.com/swyx/status/1464740702714155008/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 286] 1464739372167688193 33521530 swyx       0 0 5 0 0 0 en  
1466486562145726466 swyx 33521530 2021-12-02T19:16:57+00:00 @supabase @logflare_logs @chasers note to self: make brand color of next startup vivid green       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [34, 92] 1466486286437412873 33521530 swyx       0 0 5 0 0   en  
1469861433256992769 swyx 33521530 2021-12-12T02:47:29+00:00 I have substantial philosophical differences with the way “Twitter Growth” is framed here, but have to give credit to @tdinh_me for actually building a decent iOS app. Excited to take it for a spin! https://twitter.com/tdinh_me/status/1469706551157919746   1469706551157919746 1469706551157919746   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 198] 1462569053420244992 33521530 swyx       1 1 5 0 0 0 en  
1475138273899323393 swyx 33521530 2021-12-26T16:15:45+00:00 For those who like economics: High luck industries have a huge amount of deadweight loss from all the people trying their luck (call it search/friction cost). Who's working on better models of industrial organization that more quickly identifies talent and incentivizes work?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1475112373283598346 33521530 swyx       0 0 5 0 0   en  

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