tweets

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

33 rows where favorited = 1 and retweet_count = 2 sorted by coordinates

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_screen_name, is_quote_status, favorite_count, retweeted, created_at (date)

retweet_count 1 ✖

favorited 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
1451412869065547777 swyx 33521530 2021-10-22T04:59:28+00:00 how many vacation days have you taken this year?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 48]             0 2 22 1 0   en  
1452120199180603393 Shriram Balaji 2498289235 2021-10-24T03:50:09+00:00 Such a wonderful video by @swyx on "How to Outlive React?". If you're into frontend and plan on being invested in it for a while, this is a must watch. https://youtu.be/yLgq-Foc1EE       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 176]             0 2 47 1 1 0 en  
1452160034482253826 swyx 33521530 2021-10-24T06:28:26+00:00 RT @shrirambalaji: Such a wonderful video by @swyx on "How to Outlive React?". If you're into frontend and plan on being invested in it for… 1452120199180603393 1452120199180603393     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1   en  
1453508738241814533 swyx 33521530 2021-10-27T23:47:42+00:00 For Developer Experience peeps: I met @Silassao at KubeCon recently and he was thinking thru a lot of the same problems at @DataStax. We had a recorded conversation today about how we're using feature mapping to harmonize the DX for @Temporalio! https://youtu.be/ddKDPikKbNk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 272]             0 2 11 1 0 0 en  
1456915351241990145 Lou ☁️ 👨‍💻🏋️‍♂️🎸🚴🏻‍♂️🏍 1290693397 2021-11-06T09:24:22+00:00 In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tech it feels natural to write "beginner content" or sometimes meta-content (content about content—wait, that's *this thread* 😱 😆) https://www.swyx.io/meta-creator-ceiling/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276] 1456915349639680008 1290693397 loujaybee       0 2 6 1 1 0 en  
1457002741113319430 swyx 33521530 2021-11-06T15:11:37+00:00 RT @loujaybee: In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tec… 1456915351241990145 1456915351241990145     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             0 2 0 1 1   en  
1457466032365445120 Zev Averbach 38199764 2021-11-07T21:52:35+00:00 gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, but the value he crams into these 10-minute episodes is 🔥       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 183]             0 2 13 1 1 0 en  
1457471762258546691 swyx 33521530 2021-11-07T22:15:21+00:00 RT @zevav: gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, bu… 1457466032365445120 1457466032365445120     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1 0 en  
1457535446674718725 Mark Erikson 727704217012604928 2021-11-08T02:28:24+00:00 I spent the afternoon hacking on the experimental RTK "action listener middleware" API. After applying multiple suggestions, I'm excited to report that: **it now has support for long-running async workflows!** Changelog, discussion, and "docs" here: https://github.com/reduxjs/redux-toolkit/discussions/1648#discussioncomment-1603347       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 277]             0 2 32 1 1 0 en  
1457543817964392458 swyx 33521530 2021-11-08T03:01:40+00:00 RT @acemarke: I spent the afternoon hacking on the experimental RTK "action listener middleware" API. After applying multiple suggestions,… 1457535446674718725 1457535446674718725     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 2 0 1 1   en  
1457803089230974983 Changelog 90286855 2021-11-08T20:11:55+00:00 📢 We had @swyx on The Changelog! 1️⃣ Why learn in public 2️⃣ The dark side of the #API economy 3️⃣ @Cloudflare's Go game vs @awscloud's Chess 4️⃣ The #frontend pay ceiling & his move to the back 5️⃣ What @temporalio is about This is a good one! http://changelog.fm/467       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 274]             0 2 7 1 1 0 en  
1457804131762991104 swyx 33521530 2021-11-08T20:16:04+00:00 RT @changelog: 📢 We had @swyx on The Changelog! 1️⃣ Why learn in public 2️⃣ The dark side of the #API economy 3️⃣ @Cloudflare's Go game vs… 1457803089230974983 1457803089230974983     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1   en  
1458630426709442562 Mark Erikson 727704217012604928 2021-11-11T02:59:28+00:00 In the spirit of "working in public", but also "I'm human" and "ARGH THIS IS BROKEN SOMEONE HELP ME": I've spent the last few days trying to rewrite the new RTK middleware types. Thus far I have completely failed. The _horribly_ hacked-up code is here: https://github.com/reduxjs/redux-toolkit/commits/feature/listener-middleware-fixes       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 280]             0 2 20 1 1 0 en  
1458653534212132864 swyx 33521530 2021-11-11T04:31:17+00:00 RT @acemarke: In the spirit of "working in public", but also "I'm human" and "ARGH THIS IS BROKEN SOMEONE HELP ME": I've spent the last fe… 1458630426709442562 1458630426709442562     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1   en  
1459667585272713218 swyx 33521530 2021-11-13T23:40:46+00:00 🗽 Just booked a giant AirBnB for next week's NYC Svelte Summit (https://lu.ma/sveltenyc)! If any out of towners are considering flying in for #SvelteSummit, we have 1-2 beds left in the SvelteShack. DM to join! If you're local and interested in the future of the Web, join us:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 2 33 1 0 0 en  
1461748429764239361 Andrew Culver 11467732 2021-11-19T17:29:18+00:00 Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @swyx's recent post which I think is one of the most important things written in software development in the last ten years. https://twitter.com/andrewculver/status/1461748429764239361/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 242] 1461746021306830852 11467732 andrewculver       0 2 10 1 1 0 en  
1461750746072899586 swyx 33521530 2021-11-19T17:38:30+00:00 RT @andrewculver: Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @sw… 1461748429764239361 1461748429764239361     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 2 0 1 1   en  
1462110266536124425 Pier 1360839410 2021-11-20T17:27:06+00:00 @sveltejs @vercel @Rich_Harris @rauchg @steph_dietz from Vercel just said publicly: "Svelte is the future of web development" 🔥🔥🔥🔥🔥🔥🔥       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [39, 135] 1462108361621745664 1360839410 PierB       0 2 16 1 1   en  
1462123489914245121 Thilo Maier 226148486 2021-11-20T18:19:39+00:00 Dream team @Rich_Harris and @rauchg at #SvelteSummit NYC. https://twitter.com/maiertech/status/1462123489914245121/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 57]             0 2 46 1 1 0 en  
1462128820325077003 swyx 33521530 2021-11-20T18:40:50+00:00 RT @maiertech: Dream team @Rich_Harris and @rauchg at #SvelteSummit NYC. https://twitter.com/maiertech/status/1462123489914245121/photo/1 1462123489914245121 1462123489914245121     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 96]             0 2 0 1 1 0 en  
1462128832266313736 swyx 33521530 2021-11-20T18:40:53+00:00 RT @PierB: @sveltejs @vercel @Rich_Harris @rauchg @steph_dietz from Vercel just said publicly: "Svelte is the future of web development"… 1462110266536124425 1462110266536124425     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 138]             0 2 0 1 1   en  
1462223074946863110 Marc Anthony Card 19242083 2021-11-21T00:55:22+00:00 Glad I was able to stumble upon @swyx’s tweet for the #SvelteSummit NYC watch party. My first tech meetup but surely not my last. Met so many interesting people with a variety of backgrounds in software development. https://twitter.com/Marcard/status/1462223074946863110/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 217]             0 2 38 1 1 0 en  
1462229776295469057 swyx 33521530 2021-11-21T01:22:00+00:00 RT @Marcard: Glad I was able to stumble upon @swyx’s tweet for the #SvelteSummit NYC watch party. My first tech meetup but surely not my… 1462223074946863110 1462223074946863110     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 2 0 1 1   en  
1462249320221233152 Gen Ashley 32330308 2021-11-21T02:39:39+00:00 At the #SvelteSummit After Party, after the After Party, after the New York Watch Party - We know how the party!n 😄 @SvelteSociety @SvelteSirens @sveltejs #sveltejs https://twitter.com/coderinheels/status/1462249320221233152/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 165]             0 2 20 1 1 0 en  
1462276996596174850 swyx 33521530 2021-11-21T04:29:38+00:00 RT @coderinheels: At the #SvelteSummit After Party, after the After Party, after the New York Watch Party - We know how the party!n 😄 @Sve… 1462249320221233152 1462249320221233152     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1   en  
1470487534132154378 Jason Laster 312750384 2021-12-13T20:15:23+00:00 This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It doesn't matter if you're technically support, success, product, qa, leadership, or dev, if you care about quality, we want to talk to you! 🐛👋       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 260]             0 2 4 1 1 0 en  
1470487931332792324 swyx 33521530 2021-12-13T20:16:57+00:00 RT @jasonlaster11: This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It d… 1470487534132154378 1470487534132154378     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1 0 en  
1470787094750449665 swyx 33521530 2021-12-14T16:05:43+00:00 At this point they might as well rename Vercel’s slack to VC39       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 62] 1470786647788765201 33521530 swyx       0 2 128 1 0   en  
1471993625231773700 Jeff Morhous 🎄🎁🍪 633360612 2021-12-18T00:00:03+00:00 So I just finished reading “The Coding Career Handbook” by @swyx - it was a really great read and I can’t wait to re-reference it over the years. Some tips really stuck out to me, especially as someone pretty early in my career       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 228]             0 2 39 1 1   en  
1472033075865563137 swyx 33521530 2021-12-18T02:36:48+00:00 RT @JeffMorhous: So I just finished reading “The Coding Career Handbook” by @swyx - it was a really great read and I can’t wait to re-refer… 1471993625231773700 1471993625231773700     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 1 1   en  
1473192929414070273 Nina 1354787371494084612 2021-12-21T07:25:39+00:00 Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "what we're really talking about here is turning fixed costs to variable costs which makes sense for a startup getting off the ground." https://twitter.com/briansowards/status/1472731566732414979   1472731566732414979 1472731566732414979   Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 255]             1 2 12 1 1 0 en  
1473206717403959297 swyx 33521530 2021-12-21T08:20:26+00:00 RT @Nina_Ledid: Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "wh… 1473192929414070273 1473192929414070273     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 2 0 1 1   en  
1474271524110491649 swyx 33521530 2021-12-24T06:51:36+00:00 Strong Opinions on heading tags in HTML (h1, h2, h3, etc): - should all have id’s set - should all have discoverable anchor links (see: github markdown, or my blogposts) - (when appropriate) highlight link target, eg when one item in a multiple column layout (using :target)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 275] 1474267015334752257 33521530 swyx       0 2 25 1 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]);