tweets

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

23 rows where retweet_count = 8 sorted by coordinates

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, is_quote_status, favorite_count, favorited, retweeted, lang

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
1281842370602889216 Ethan 3315647862 2020-07-11T06:46:51+00:00 The Coding Career Handbook by @swyx has been such a great resource for coders at the beginning of their journey such as myself. I highly recommend the book to all software engineers especially those early in their careers. Things I like about the book-       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 253]             0 8 35 0 1   en  
1326509989347921925 swyx 33521530 2020-11-11T13:00:01+00:00 API Economy in five words: Turn non-core features into products.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 65]             0 8 165 0 1   en  
1426318522242588675 Chanta Clause 🧑‍🎄 12745092 2021-08-13T23:03:30+00:00 i’m on sveltejs hype       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 20]             0 8 189 0 0   da  
1429536652196651012 swyx 33521530 2021-08-22T20:11:12+00:00 forgot who said this: There are two schools of thought in tech vs humanity. The Zuckerberg school: “Done FOR you”, Algorithm is king, Data wins debate. The Jobs school: “Done WITH you”, Tech is a “bicycle for the mind”, Intuitiveness wins debate. I hope we remember the latter.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             0 8 121 0 0   en  
1431829714671476737 𝚂𝚆𝙸𝙽𝙳𝙻𝙴𝙳 877551680451162112 2021-08-29T04:03:00+00:00 S05E09: The Scheme (Bernie Madoff) // A Wall Street tycoon's money management firm is revealed to be the world's largest Ponzi scheme. Listen: https://swindledpodcast.com/podcasts/season-5/69-the-scheme/ https://twitter.com/SwindledPodcast/status/1431829714671476737/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 167]             0 8 65 0 0 0 en  
1435258964242059268 Ives van Hoorne 153524496 2021-09-07T15:09:37+00:00 It's still pretty crazy that for a normal devenv you have the linter, typechecker, editor and bundler all generating the same ASTs for the same code. That's a LOT of double work, a very good point from @swyx in his talk. I can't wait for tools like Rome to consolidate this. https://twitter.com/CompuIves/status/1435258964242059268/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 275]             0 8 147 0 1 0 en  
1435269040323321858 swyx 33521530 2021-09-07T15:49:39+00:00 RT @CompuIves: It's still pretty crazy that for a normal devenv you have the linter, typechecker, editor and bundler all generating the sam… 1435258964242059268 1435258964242059268     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 8 0 0 1   en  
1439920494967459843 swyx 33521530 2021-09-20T11:52:53+00:00 RT @ethansooo: The Coding Career Handbook by @swyx has been such a great resource for coders at the beginning of their journey such as myse… 1281842370602889216 1281842370602889216     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 8 0 0 1   en  
1445252192877694983 swyx 33521530 2021-10-05T04:59:08+00:00 @jdan this is a fkin masterpiece. the circular pfp crop. the missing pfp in the second message. the inconsistent spacing. the missing timestamps. and ofc, the Pièce de résistance, that last line. Let's see Paul Allen's DMs.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 224] 1445186388270452740 23481558 jdan       0 8 590 0 0   en  
1449069225704714246 swyx 33521530 2021-10-15T17:46:40+00:00 Temporal: React for the Backend (🌩️ talk) https://youtu.be/WRYozSljSpw Just posted last night's @cascadiajs lightning talk on my channel! • Explaining @temporalio in <10mins • First public demo of our @TypeScript SDK! • Lots of docs updates merged this week       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 8 110 0 1 0 en  
1449526697242468359 swyx 33521530 2021-10-17T00:04:30+00:00 RT @swyx: Temporal: React for the Backend (🌩️ talk) https://youtu.be/WRYozSljSpw Just posted last night's @cascadiajs lightning talk on my cha… 1449069225704714246 1449069225704714246     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 8 0 0 1 0 en  
1450992549141704704 swyx 33521530 2021-10-21T01:09:16+00:00 Devtools space is absolutely on fire. If you have a dream, and a credible plan, someone somewhere will pay you to do it full time, make you a paper millionaire, and you get a roll of the dice to make it reality. Can't imagine a better gig on Earth tbh.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 254]             0 8 275 0 0   en  
1458876998491664405 swyx 33521530 2021-11-11T19:19:15+00:00 RT @swyx: API Economy in five words: Turn non-core features into products. 1326509989347921925 1326509989347921925     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 75]             0 8 0 0 1   en  
1460615907139411970 Ron Au 🦆 18333169 2021-11-16T14:29:03+00:00 Keen on developer productivity and wellbeing? r/webdev + r/web_design are officially running a 6-week talk series on exactly that 🙌 Kindly sponsored by @Reddit, the theme is "Ingenious ways to work smarter, faster and healthier" and we begin next week! https://redditweb.dev       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 8 36 1 1 0 en  
1460703767066656768 swyx 33521530 2021-11-16T20:18:11+00:00 RT @ronvoluted: Keen on developer productivity and wellbeing? r/webdev + r/web_design are officially running a 6-week talk series on exact… 1460615907139411970 1460615907139411970     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 8 0 1 1   en  
1461043514641305600 swyx 33521530 2021-11-17T18:48:13+00:00 🦄 @Netlify was the first unicorn I ever worked at in more ways than one: It remains the only company I've been at that has an active Alumni slack. I can ping old coworkers and it's like I never left. If you can build a strong culture, you can do anything. :netlilove:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 271]             0 8 354 0 0   en  
1464316615453986818 Adam Wathan 716933677 2021-11-26T19:34:21+00:00 Execute Program is way too under the radar for how good it is. If they have a course on something, it is the best way to learn that thing on the entire internet. @garybernhardt's standards for quality and attention to detail are the highest in the industry, huge inspiration. https://twitter.com/exec_prog/status/1464293076948635655   1464293076948635655 1464293076948635655   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276]             1 8 92 1 1 0 en  
1464320734533017600 swyx 33521530 2021-11-26T19:50:43+00:00 RT @adamwathan: Execute Program is way too under the radar for how good it is. If they have a course on something, it is the best way to le… 1464316615453986818 1464316615453986818     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 8 0 1 1   en  
1465601156449804290 Thomas Paul Mann 3322693991 2021-11-30T08:38:39+00:00 Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and API. Read more about it here: https://www.raycast.com/blog/series-a/ Also, we're on @ProductHunt today: https://www.producthunt.com/posts/raycast-api-and-store https://twitter.com/raycastapp/status/1465599554913550340   1465599554913550340 1465599554913550340   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 231]             1 8 190 1 1 0 en  
1465823027497607171 swyx 33521530 2021-11-30T23:20:18+00:00 RT @thomaspaulmann: Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and A… 1465601156449804290 1465601156449804290     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 8 0 1 1   en  
1473218830210330627 swyx 33521530 2021-12-21T09:08:34+00:00 If Web3 merely stood for "yes we accept all cookies from now til the end of time" it would have been adopted yesterday       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 118]             0 8 177 0 0   en  
1474082755550257152 swyx 33521530 2021-12-23T18:21:30+00:00 Updating @KentBeck's law of Software Development: Make it work Make it right Make it fast Make it low-code* *configurable, extensible, and programmable by end users, whether or not they are developers       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 202]             0 8 76 1 1   en  
1474222541191499779 swyx 33521530 2021-12-24T03:36:58+00:00 RT @swyx: Updating @KentBeck's law of Software Development: Make it work Make it right Make it fast Make it low-code* *configurable, exte… 1474082755550257152 1474082755550257152     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 8 0 1 1   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]);