tweets

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

19 rows where favorite_count = 5 and is_quote_status = 1 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, retweeted, lang

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
1420261009583788032 swyx 33521530 2021-07-28T05:53:06+00:00 @matiasfha @Rich_Harris @stolinski @gndx btw you can implement the same thing for React too. its just that the React core team prefers boilerplate to sugar syntax. https://twitter.com/swyx/status/1294310598419689472?lang=en   1294310598419689472 1294310598419689472   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [41, 187] 1420216170402091009 12816182 matiasfha       1 1 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  
1431072897099911169 swyx 33521530 2021-08-27T01:55:41+00:00 @heathedan for example, you dont have to spend 2 months researching the right choice if you can just try each in turn until one fits. key is to make it cheap to switch; have a decoupled test suite, don’t tie your brand/identity to any one solution, seek “good enough” https://twitter.com/swyx/status/1221129594146840577?s=21   1221129594146840577 1221129594146840577   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 291] 1431070301308211203 784577340638625792 heathedan       1 0 5 0 0 0 en  
1432636294555791362 swyx 33521530 2021-08-31T09:28:04+00:00 @tlakomy actually understanding charts like these and how much youre not doing! https://twitter.com/swyx/status/1423025792783568899   1423025792783568899 1423025792783568899   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 79] 1432420643853713411 1903060381 tlakomy       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  
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  
1439771209625862147 swyx 33521530 2021-09-20T01:59:40+00:00 @mikesherov btw we discussed your tweets here! https://twitter.com/swyx/status/1439702355553886211   1439702355553886211 1439702355553886211   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 70] 1438491315629613057 4241651 mikesherov       1 0 5 0 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  
1444498121854124035 swyx 33521530 2021-10-03T03:02:44+00:00 this is a worthwhile talk (direct link https://youtu.be/hV3dJur69SU) We are dealing w/ similar issues at @temporalio: how to guide someone to learn your system and be able to find the answer to every important question in the shortest time? Docs, like the SDLC, should be nonlinear. https://twitter.com/editingemily/status/1443381760935534592   1443381760935534592 1443381760935534592   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             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  
1449103297839763459 Chi is 🈺 47987794 2021-10-15T20:02:03+00:00 I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 20% of the work to get 80% results as is often opined. 100% of the work (and more) is required. Thanks for this article @swyx https://twitter.com/swyx/status/1387487111964626945   1387487111964626945 1387487111964626945   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 245]             1 1 5 0 1 0 en  
1449143399659892736 swyx 33521530 2021-10-15T22:41:24+00:00 @jkup @Cloudflare ah love it when good ideas get great execution https://twitter.com/netlify/status/1115638145725403136?s=21   1115638145725403136 1115638145725403136   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 88] 1448790326215389190 255634108 jkup       1 0 5 0 0 0 en  
1451404553715212304 swyx 33521530 2021-10-22T04:26:26+00:00 @theandreboso had this experience recently. narrowly missed it https://twitter.com/swyx/status/1434322252334571524?s=21   1434322252334571524 1434322252334571524   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 86] 1451126963649851393 1095437639380017157 theandreboso       1 0 5 0 0 0 en  
1457835765530980357 swyx 33521530 2021-11-08T22:21:46+00:00 @JoshuaKGoldberg @acemarke redux toolkit - the missing api's that redux should always have had :) https://twitter.com/acemarke/status/1457535446674718725   1457535446674718725 1457535446674718725   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 121] 1457835443584749577 2551208653 JoshuaKGoldberg       1 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  
1469803081206415361 swyx 33521530 2021-12-11T22:55:36+00:00 @techgirl1908 wouldve loooved to talk to you about joining @temporalio but figured you already had your next thing tied up + you’d be swamped. gotta follow my own rule of thumb here 😱 https://twitter.com/swyx/status/1383101776627331072?s=21   1383101776627331072 1383101776627331072   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 209] 1469354511865196544 2932738834 techgirl1908       1 0 5 0 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  
1420433131895623684 swyx 33521530 2021-07-28T17:17:03+00:00 @TylertheHaas @mark_volkmann @kentcdodds @matiasfha @sergiodxa @goncy @stolinski @LevelUpTuts @sveltejs https://twitter.com/swyx/status/1420211877276049408?s=20   1420211877276049408 1420211877276049408   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [104, 127] 1420429733427257344 43845766 TylertheHaas       1 0 5 0 0 0 und  

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