tweets

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

17 rows where favorite_count = 31 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, retweet_count, retweeted

favorited 2 ✖

  • 0 15
  • 1 2

lang 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
1412032180465831939 Brittney Postma 36686876 2021-07-05T12:54:40+00:00 Check it out, I was on Svelte Radio! I still can't believe it. Thank you for having me, I had so much fun! Also, check out the Purrfect dev with @swyx talking about Svelte. https://codingcat.dev/podcast/1-15-whats-up-with-svelte #svelte @sveltejs https://twitter.com/svelteradio/status/1411882780959596549       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 217]             1 4 31 0 0 0 en  
1421190477571710978 swyx 33521530 2021-07-30T19:26:28+00:00 this is incredible to watch. I thought that Flippa/Empire Flippers had cornered this sleepy market, but Andrew is shaking it up with his infectious energy and focus. Building a credible “Zestimate for SaaS” is going to set this thing on 🔥 https://twitter.com/agazdecki/status/1421069160973434880   1421069160973434880 1421069160973434880   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 239]             1 2 31 0 0 0 en  
1421683811981488132 swyx 33521530 2021-08-01T04:06:49+00:00 How To Write Funny: https://copywritingcourse.com/writing-funny/ Really enjoying @nevmed's newsletter, quality, entertaining, lighthearted stuff 🔥 Giving me inspo for my own work.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 161]             0 2 31 0 0 0 en  
1425892922717704192 swyx 33521530 2021-08-12T18:52:19+00:00 Fixes for each: 🚫 iTunes: https://krausefx.com/blog/introducing-overkill-dont-let-itunes-interrupt-your-workflow 🚫 Mail: https://discussions.apple.com/thread/1856375 🚫 Dictionary: https://apple.stackexchange.com/questions/245592/el-capitan-how-to-disable-force-click-dictionary-pop-ups-in-chrome 💁🏽‍♂️ https://twitter.com/swyx/status/1425892922717704192/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 129] 1425889455643119616 33521530 swyx       0 1 31 0 0 0 en  
1430222201588895745 swyx 33521530 2021-08-24T17:35:19+00:00 🚵🏽‍♂️ If you're in Denver, I'm in town with the UI team from @temporalio for an offsite and will be hosting a small group dinner tomorrow! we'll be talking @sveltejs, microservices, design, webdev, startups, whatever else @stolinski and @mdharrington_ are up to! DM if interested       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 281]             0 2 31 0 0   en  
1434966467909402629 swyx 33521530 2021-09-06T19:47:20+00:00 i go through big crashes in confidence with my writing so comments like these really make my day 😊 for those who want more tips on writing process, I have a little trilogy! starting with Mise en Place Writing: https://twitter.com/swyx/status/1241858255195865090 https://twitter.com/swyx/status/1434966467909402629/photo/1   1241858255195865090 1241858255195865090   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 235]             1 1 31 0 0 0 en  
1438122214818152449 swyx 33521530 2021-09-15T12:47:09+00:00 Holy shit, a rare @buildsghost sighting on the @replayio launch today 🤯 https://www.producthunt.com/posts/replay-4 You can't pay for this kind of endorsement. https://twitter.com/swyx/status/1438122214818152449/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 141]             0 0 31 0 0 0 en  
1445533835945414662 rita ❄️ 232076816 2021-10-05T23:38:17+00:00 A+ write up from @swyx. the great thing about “from the outside in” metaphor is that it works figuratively and literally — cloudflare, by sitting in front of the cloud allows customers to gradually shift their workloads from the centralized cloud to the edge https://twitter.com/swyx/status/1445044267508850695   1445044267508850695 1445044267508850695 San Francisco 5a110d312052166f Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 259]             1 3 31 0 1 0 en  
1451622739450552320 swyx 33521530 2021-10-22T18:53:25+00:00 FOMOing about not being at #ReactAdvanced this year 😂 but couldn't go anyway or i'd have to spend 2 weeks in Mexico again shoutout to all my lovely @Reactjs peeps across the pond!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 180]             0 0 31 0 0   en  
1452762935210622976 Michael Grinich 16602665 2021-10-25T22:24:09+00:00 🚀 We're launching a podcast!🎙 Focused 20-minute interviews that distill advice and tactics from top SaaS founders on how to build (and sell) to enterprise. Including @Vercel, @Webflow, @TrustVanta, and more every week! Listen (and subscribe) here 👇 https://workos.com/podcast       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275]             0 3 31 1 1 0 en  
1453073193304936449 swyx 33521530 2021-10-26T18:57:00+00:00 @dabit3 web420 will be BLAZing fast       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 35] 1453066554975924231 17189394 dabit3       0 0 31 0 0   en  
1460785448876331010 Svelte Society 🧡 1176969867733479424 2021-11-17T01:42:45+00:00 Svelte Summit viewing parties are springing up all over! Organize here or on Discord! NYC 🗽 @swyx Mainz 🇩🇪@einbuhrmi Zagreb 🇭🇷 @letourpowerscombine on Discord Barcelona 🇪🇸@stefanmaric on Discord Chicago 🍕@kennethkunz👇 https://twitter.com/kennethkunz/status/1460725443133415424   1460725443133415424 1460725443133415424   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 219]             1 6 31 1 1 0 en  
1465526450119856133 swyx 33521530 2021-11-30T03:41:48+00:00 @umachingunde @dan_abramov the question assumes that my library has tests 😈       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 75] 1465525155158011915 938901720016363520 umachingunde       0 0 31 0 0   en  
1469093196860837888 swyx 33521530 2021-12-09T23:54:47+00:00 @moseeds just a very rough attempt at market segmentation and not paying attention to the transition experience. happens everywhere.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 132] 1469092772812664833 33969506 moseeds       0 0 31 0 0   en  
1469125633884110853 swyx 33521530 2021-12-10T02:03:40+00:00 @DavidKPiano @tldraw ok if Vercel is ▲ then whos gonna start the ■ and the ○ so we can go full squid game on this biz       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 117] 1469079212124356609 992126114 DavidKPiano       0 0 31 0 0   en  
1471203286820655105 swyx 33521530 2021-12-15T19:39:31+00:00 Lol, every company coming out with their own version of Spotify Wrapped, love this CLI-in-browser experience from @Netlify! https://your-year-on.netlify.com/ very creative. https://twitter.com/swyx/status/1471203286820655105/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 164]             0 1 31 0 0 0 en  
1472746901711855617 swyx 33521530 2021-12-20T01:53:18+00:00 "Good open standards, both for software interfaces and for data formats, are more important than for software itself to be open source." *profound* insight from Peter Deutsch, on @jeffdoolittle's @seradio episode https://www.se-radio.net/2021/07/episode-470-l-peter-deutsch-on-the-fallacies-of-distributed-computing/ (44-46 mins) https://twitter.com/swyx/status/1472746901711855617/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 250]             0 5 31 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]);