tweets

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

21 rows where favorite_count = 4 and is_quote_status = 1 sorted by lang descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, lang

is_quote_status 1 ✖

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
1427497832848658434 swyx 33521530 2021-08-17T05:09:39+00:00 @jhooks https://twitter.com/celothedev/status/1427460022284419073?s=20   1427460022284419073 1427460022284419073   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 31] 1427492570733584385 12087242 jhooks       1 0 4 0 0 0 und  
1428103782810873859 swyx 33521530 2021-08-18T21:17:29+00:00 @mozzius @reactjs @jquery https://twitter.com/swyx/status/1093200303254466561   1093200303254466561 1093200303254466561   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 49] 1428103288537354241 1266850963429752832 mozzius       1 0 4 0 0 0 und  
1432504165440184321 swyx 33521530 2021-08-31T00:43:02+00:00 @shreyas “Good Enough” is better than “Best”: https://twitter.com/swyx/status/1221129594146840577?s=21   1221129594146840577 1221129594146840577   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 70] 1432501769989357568 2048741 shreyas       1 0 4 0 0 0 en  
1434500277567115266 swyx 33521530 2021-09-05T12:54:52+00:00 awesome writeup on adding custom monaco autocompletes for in-app editors! https://twitter.com/tim_nolet/status/1402925458623172611   1402925458623172611 1402925458623172611   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 73] 1321978673868599296 33521530 swyx       1 0 4 0 0 0 en  
1436716037202980868 swyx 33521530 2021-09-11T15:39:30+00:00 @simonw i genuinely think this one assumption made many remaining decisions for them: https://twitter.com/slightlylate/status/1436708762115473411?s=20 I hear unexamined assumptions like these a lot and people don't realize these are far weightier decisions than they seem at first glance. Rhyme shortcircuits reason.   1436708762115473411 1436708762115473411   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 276] 1436710644045152262 12497 simonw       1 0 4 0 0 0 en  
1437095732436258816 swyx 33521530 2021-09-12T16:48:17+00:00 @jamonholmgren yes! I call this Lampshading. Ignorance can be Power, when wielded correctly. https://twitter.com/swyx/status/1238321393374298112   1238321393374298112 1238321393374298112   TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [15, 117] 1437089665018826754 30273948 jamonholmgren       1 1 4 0 0 0 en  
1437132448798806017 swyx 33521530 2021-09-12T19:14:11+00:00 Another mindchanger on Tailwind! https://twitter.com/thamasky/status/1437039454967975938   1437039454967975938 1437039454967975938   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 32] 1413018688077238273 33521530 swyx       1 0 4 0 0 0 en  
1437132718928695301 swyx 33521530 2021-09-12T19:15:15+00:00 expanded in a blogpost: https://twitter.com/swyx/status/1312603851581652994?s=21   1312603851581652994 1312603851581652994   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 47] 1253303455961079810 33521530 swyx       1 1 4 0 0 0 en  
1440514869715898376 swyx 33521530 2021-09-22T03:14:43+00:00 @TrungTPhan damn son is there such a thing as a QT ratio cuz you got ratioed hard https://twitter.com/i_zzzzzz/status/1440053089822601216?s=21   1440053089822601216 1440053089822601216   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 105] 1403475948477976577 945817135816654848 TrungTPhan       1 0 4 0 0 0 en  
1441075713231175681 swyx 33521530 2021-09-23T16:23:18+00:00 @SvelteSociety @syntaxfm @stolinski @wesbos enjoyed this discussion! as well as the responsible disclaimer about it being apples vs oranges. also re: ecosystem - its growing, but also arguably bigger than React! https://twitter.com/SvelteSociety/status/1390082681753374723?s=20   1390082681753374723 1390082681753374723   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [44, 236] 1441016244832849929 1176969867733479424 SvelteSociety       1 0 4 0 0 0 en  
1441868475711037445 swyx 33521530 2021-09-25T20:53:27+00:00 Interesting alternative measure for the less biblically inclined: brain chemicals! https://twitter.com/shreyas/status/1441866360313634823?s=21   1441866360313634823 1441866360313634823   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 107] 1411461620497223681 33521530 swyx       1 0 4 0 0 0 en  
1443437632067813377 swyx 33521530 2021-09-30T04:48:43+00:00 @geddski join us, we need you, it would be helluva lot of fun https://twitter.com/swyx/status/1440389897336938502?s=21   1440389897336938502 1440389897336938502   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 86] 1443225300901507075 39607761 geddski       1 0 4 0 0 0 en  
1443492279939842048 swyx 33521530 2021-09-30T08:25:52+00:00 @posobin launched @ampie_app today which is a nice take on this. I still prefer @round's extension for its minimalism (my fork https://github.com/sw-yx/Twitter-Links-beta) https://twitter.com/posobin/status/1443269476464664584?s=20   1443269476464664584 1443269476464664584   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 177] 1240475079718420480 33521530 swyx       1 0 4 0 0 0 en  
1444014341469081601 swyx 33521530 2021-10-01T19:00:22+00:00 @_developit @acemarke @alexandereardon prior art, for those who dont know what i am referencing https://twitter.com/swyx/status/1281896981049356288   1281896981049356288 1281896981049356288   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [39, 119] 1443997699208933380 33521530 swyx       1 0 4 0 0 0 en  
1455805392500318208 swyx 33521530 2021-11-03T07:53:47+00:00 @kiwicopple @supabase @zernonia this is incredible @zernonia! is it open source by any chance? wanted to see how you do search/tagging. idea for you - special "sea" view that just lists all the projects in one screen this way you can visualize the growth of the ecosystem like this https://twitter.com/mattturck/status/1445144517439541255   1445144517439541255 1445144517439541255   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [32, 307] 1455764288686080003 832817861844275200 kiwicopple       1 0 4 0 0 0 en  
1462694167402844161 swyx 33521530 2021-11-22T08:07:19+00:00 @AntWilson @supabase this is the genre of “how it started/how its going” that @paulg likes to see in a yc company! https://twitter.com/paulg/status/403183731449413632?s=21   403183731449413632 403183731449413632   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 138] 1462645962971566081 22399680 AntWilson       1 0 4 0 0 0 en  
1463283116030652416 swyx 33521530 2021-11-23T23:07:36+00:00 @temporalio What is Temporal, and why should you care? I wrote about it earlier this year: https://twitter.com/swyx/status/1417165270641045505 https://twitter.com/swyx/status/1463283116030652416/photo/1   1417165270641045505 1417165270641045505   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 115] 1463194116515196942 33521530 swyx       1 0 4 0 0 0 en  
1463695718057578498 swyx 33521530 2021-11-25T02:27:07+00:00 @levelsio yes and here is the Singapore tax code! https://twitter.com/swyx/status/1381324888216981504   1381324888216981504 1381324888216981504   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 49] 1463404709100736513 1577241403 levelsio       1 0 4 0 0 0 en  
1464843139416346629 swyx 33521530 2021-11-28T06:26:34+00:00 @shreyas i am liking this genre https://twitter.com/shreyas/status/1459931369019035649   1459931369019035649 1459931369019035649   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 31] 1464832326483939329 2048741 shreyas       1 0 4 0 0 0 en  
1468158323992059904 swyx 33521530 2021-12-07T09:59:56+00:00 @jakobgreenfeld that's some pretty damn quick number crunching skills there! i have another fun metric for you to try: Number of PH #1 of the day winners that now 404. it was roughly 10-15% when i checked 2017's winners in 2018 https://twitter.com/swyx/status/970106789189636098?s=20   970106789189636098 970106789189636098   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 253] 1468157620741722121 1285142519525892098 jakobgreenfeld       1 0 4 0 0 0 en  
1471985415137726477 swyx 33521530 2021-12-17T23:27:25+00:00 @forrestbrazeal Postel's Law ("be conservative in what you do, be liberal in what you accept from others" aka Robustness Principle) becoming relevant as I learn about API design. However, too much defensive coding from too many layers can cause overhead & confusion. https://twitter.com/mfeathers/status/995896831165919232?s=20   995896831165919232 995896831165919232   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 296] 1323643707271213056 33521530 swyx       1 0 4 0 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]);