tweets

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

18 rows where favorited = 1 and retweet_count = 4 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, is_quote_status, retweeted

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
1451584443534102533 swyx 33521530 2021-10-22T16:21:15+00:00 Me before we ship: "this is great! we worked so hard on it and it shows!" Me after even a little bit of user feedback: "wow this is terrible we have so much more work to do 😅" if you think you're done, you haven't talked to users enough.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 239]             0 4 124 1 0   en  
1456447836803854336 Cedric Chin 14243237 2021-11-05T02:26:38+00:00 “In reality, a mentor is mostly just somebody that answers questions more than once. That’s it. It’s not cinematic.” https://staysaasy.com/career/2021/10/16/mentorship.html       Tweetbot for iΟS 85449edeaa7f6ae7eddac4a17a652ba08b5f536a 0 [0, 140]             0 4 36 1 1 0 en  
1456466989912707076 swyx 33521530 2021-11-05T03:42:44+00:00 RT @ejames_c: “In reality, a mentor is mostly just somebody that answers questions more than once. That’s it. It’s not cinematic.” https://… 1456447836803854336 1456447836803854336     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 1 1   en  
1462481486733623302 ⚡ Dylan is Teaching Marketing to Creators 🚢 1469796096 2021-11-21T18:02:12+00:00 Some interesting thoughts on... → More Than Just Money → #PartTimeCreator → Making Part Time Work → Making Part Time Cool → A Creator Middle Path for the Creator Middle Class https://www.swyx.io/part-time-creator-manifesto/       Hypefury 22fbdb1440c40f2ec53256ed88f9d60ddd2889fc 0 [0, 200] 1462481483512356864 1469796096 growthcurrency       0 4 23 1 1 0 en  
1462550956537790465 swyx 33521530 2021-11-21T22:38:15+00:00 RT @growthcurrency: Some interesting thoughts on... → More Than Just Money → #PartTimeCreator → Making Part Time Work → Making Part Time C… 1462481486733623302 1462481486733623302     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 1 1   en  
1462819374251741185 Art Lapinsch 154491048 2021-11-22T16:24:51+00:00 Using Launch Cheat Sheet by @swyx as the basis for the rework. It's a fantastic resource. https://github.com/sw-yx/launch-cheatsheet       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 114] 1462819032730517512 154491048 artlapinsch       0 4 14 1 1 0 en  
1462820793318973445 swyx 33521530 2021-11-22T16:30:29+00:00 RT @artlapinsch: Using Launch Cheat Sheet by @swyx as the basis for the rework. It's a fantastic resource. https://github.com/sw-yx/launch-cheatsheet 1462819374251741185 1462819374251741185     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 131]             0 4 0 1 1 0 en  
1464876415153803268 Josh Goldberg 💖 2551208653 2021-11-28T08:38:48+00:00 I've been playing around with @temporalio for a couple of weeks now and have to say I'm *thoroughly* impressed. There are just so many little well-thought-out details. Real pleasure to work with. Like, logging sinks & instrumentation for queue workers & activities. Really cool!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 287]             0 4 11 1 1   en  
1465437441687371776 swyx 33521530 2021-11-29T21:48:07+00:00 RT @JoshuaKGoldberg: I've been playing around with @temporalio for a couple of weeks now and have to say I'm *thoroughly* impressed. There… 1464876415153803268 1464876415153803268     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 139]             0 4 0 1 1   en  
1465439478269493258 Temporal 1204202807298969600 2021-11-29T21:56:12+00:00 Ever find a race condition bug and then look again, only to see that it is gone? 😱 This exact thing happened to @christoomey of the @_bikeshed recently, and we recorded a great followup discussion with Sidekiq and Temporal experts! ft. @ANTstorm @mfateev https://www.youtube.com/watch?v=Rr4DnHmy6eE       Agorapulse app 86e9766d5e36b5847fe04f82904117b15d8fde9c 0 [0, 279]             0 4 13 1 1 0 en  
1466104198018191362 swyx 33521530 2021-12-01T17:57:34+00:00 RT @temporalio: Ever find a race condition bug and then look again, only to see that it is gone? 😱 This exact thing happened to @christoom… 1465439478269493258 1465439478269493258     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 4 0 1 1   en  
1466447823801491458 swyx 33521530 2021-12-02T16:43:01+00:00 🆕 For my third year in a row, I've compiled my list of favorite new podcasts to feature up-and-comers and my favorite episodes of each. Presenting: Favorite New Podcasts of 2021! https://www.swyx.io/fave-podcasts-2021       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 207]             0 4 24 1 1 0 en  
1466659029715853315 swyx 33521530 2021-12-03T06:42:16+00:00 RT @swyx: 🆕 For my third year in a row, I've compiled my list of favorite new podcasts to feature up-and-comers and my favorite episodes o… 1466447823801491458 1466447823801491458     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 4 0 1 1   en  
1469313115598860293 Josh W. Comeau 2308474213 2021-12-10T14:28:39+00:00 I had a bill recently go from $20/month to $660/month because I exceeded a magic threshold. My actual usage increased maybe 20% 😬 https://twitter.com/swyx/status/1469092201376354305   1469092201376354305 1469092201376354305   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 129]             1 4 71 1 1 0 en  
1469801943019110401 swyx 33521530 2021-12-11T22:51:05+00:00 RT @JoshWComeau: I had a bill recently go from $20/month to $660/month because I exceeded a magic threshold. My actual usage increased mayb… 1469313115598860293 1469313115598860293     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 4 0 1 1   en  
1470789190417719303 swyx 33521530 2021-12-14T16:14:03+00:00 The same consolidation play Microsoft made for developer tools, @Vercel is now making for developers       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 100] 1470788640846462979 33521530 swyx       0 4 87 1 0   en  
1473316076893081602 Coding Career Community 1249002899897647105 2021-12-21T15:35:00+00:00 "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to perform, and there is space for your performance to really make an impact." @li_haoyi with some gold career advice on where to work: https://www.lihaoyi.com/post/ReflectingonFourYearsatDatabricks.html https://twitter.com/Coding_Career/status/1473316076893081602/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 4 17 1 1 0 en  
1473343069819142144 swyx 33521530 2021-12-21T17:22:15+00:00 RT @Coding_Career: "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to… 1473316076893081602 1473316076893081602     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 4 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]);