tweets

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

19 rows where is_quote_status = 1 and retweet_count = 3 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_screen_name, favorited

retweet_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
1419836176681213952 swyx 33521530 2021-07-27T01:44:58+00:00 Suddenly reminded of this @bcantrill talk: https://youtu.be/30jNsCVLpAE and I think I have my answer - If it takes you 2 days to chase down an intermittent bug, perhaps that *IS* the bug. Even though this talk is 4 years old but feels like @mipsytipsy is beating the same drum today. https://twitter.com/swyx/status/1419434119319093250   1419434119319093250 1419434119319093250   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 3 15 0 0 0 en  
1421273039648399364 joel ⛈ 12087242 2021-07-31T00:54:33+00:00 a couple of years ago @swyx asked us what our big hairy audacious goal was... this is still my answer I am super motivated to help people escape the work-a-day grind and leverage their expertise to help others do the same long game shit https://twitter.com/jhooks/status/1158920626272268289?s=20   1158920626272268289 1158920626272268289   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 263] 1421215273659506688 12087242 jhooks       1 3 63 0 1 0 en  
1421277387413606403 swyx 33521530 2021-07-31T01:11:49+00:00 RT @jhooks: a couple of years ago @swyx asked us what our big hairy audacious goal was... this is still my answer I am super motivated to… 1421273039648399364 1421273039648399364     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1432682080912084998 swyx 33521530 2021-08-31T12:30:00+00:00 So excited to be presenting my latest talk, the Third Age of JavaScript at the @InfobipShift Conference! It will be Europe’s largest Developer conference in 2021 - hope to see you there! Learn more at https://shift.infobip.com/#devconf https://twitter.com/swyx/status/1263123032328925186 https://twitter.com/swyx/status/1432682080912084998/photo/1   1263123032328925186 1263123032328925186   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 249]             1 3 28 0 0 0 en  
1433232061964251137 swyx 33521530 2021-09-02T00:55:26+00:00 Sincere recommendation. If you: - are interested in GraphQL - dislike tribalism and cargo culting - want to see a constructive example of how to criticize with love You should watch this talk 👇 I was in the audience and immediately knew this was one for the ages. So. Good. https://twitter.com/swyx/status/1433126939850465284   1433126939850465284 1433126939850465284   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 275]             1 3 48 0 0 0 en  
1441062360811143175 Brian LeRoux 676363 2021-09-23T15:30:15+00:00 This in no way assuaged my overall skepticism but super appreciate the hype-free honesty of the current state of "web3". More of this and I'll be waaaay less skeptical. https://twitter.com/iam_preethi/status/1441059558454136834   1441059558454136834 1441059558454136834   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 168]             1 3 22 0 1 0 en  
1441072853168840705 swyx 33521530 2021-09-23T16:11:56+00:00 RT @brianleroux: This in no way assuaged my overall skepticism but super appreciate the hype-free honesty of the current state of "web3". M… 1441062360811143175 1441062360811143175     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 0 1   en  
1443467407352205312 swyx 33521530 2021-09-30T06:47:02+00:00 It really is a tall order to retell the Apple origin story in an engaging way, when so much of it is well known. So I really mean it when I say @pkafka has done the best ~40 minute recap of the story from Homebrew to iPhone I've ever heard. Recommend. https://www.listennotes.com/podcasts/land-of-the-giants/how-apple-got-its-groove-back-vTYLIF5XaSD/ https://twitter.com/waltmossberg/status/1443242219650142209   1443242219650142209 1443242219650142209   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 3 18 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  
1445537727131176967 swyx 33521530 2021-10-05T23:53:45+00:00 RT @ritakozlov_: A+ write up from @swyx. the great thing about “from the outside in” metaphor is that it works figuratively and literally —… 1445533835945414662 1445533835945414662     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1448053408393428996 swyx 33521530 2021-10-12T22:30:10+00:00 ok, ok, 1 more way you can beat Amazon: Support. Offer a shared Slack with SLA. Enterprise contracts are being closed on basic premise that "someone who knows what the heck is going on is on Slack with you, whether we are down or you are". Beats this: https://twitter.com/QuinnyPig/status/1402049900079026184   1402049900079026184 1402049900079026184   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278] 1448049750901551108 33521530 swyx       1 3 16 0 0 0 en  
1453408357935583234 swyx 33521530 2021-10-27T17:08:50+00:00 GitHub adds a Command Palette!! this suddenly became a lot more high priority in devtools: https://twitter.com/swyx/status/1453401130994520068   1453401130994520068 1453401130994520068   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 114] 1427361704241877017 33521530 swyx       1 3 26 0 0 0 en  
1455261914297249798 Hillel 397782926 2021-11-01T19:54:12+00:00 Other examples are preemptive pluralization (https://twitter.com/swyx/status/1370513317379280897) and preemptive pagination. Not always the right choice, but right often enough that you should seriously consider them even when following YAGNI   1370513317379280897 1370513317379280897   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 214] 1455261278335913984 397782926 hillelogram       1 3 35 1 1 0 en  
1455263219027628034 swyx 33521530 2021-11-01T19:59:23+00:00 RT @hillelogram: Other examples are preemptive pluralization (https://twitter.com/swyx/status/1370513317379280897) and preemptive pagination. Not always the right choi… 1455261914297249798 1455261914297249798     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 1 1 0 en  
1458868196329492480 swyx 33521530 2021-11-11T18:44:17+00:00 Super excited for Rich, Svelte, and my friends at Vercel! Sign up for Svelte Summit 🏔️ (in 9 days! 😱 https://sveltesummit.com/) where you can catch up on the latest! 🗽 NYC party (with Rich, team Vercel, and myself): https://lu.ma/sveltenyc 🇩🇪 Mainz: https://lu.ma/sveltesummit-2021-mainz 🧡 https://twitter.com/Rich_Harris/status/1458822051263823875   1458822051263823875 1458822051263823875   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 3 62 0 0 0 en  
1462550780683161607 swyx 33521530 2021-11-21T22:37:33+00:00 Shopify is a surprise new entrant in the React Distros game, with Hydrogen claiming to be better for ecommerce than Jamstack or Next.js in @ricmac’s interview https://thenewstack.io/dynamic-by-default-shopifys-hydrogen-a-new-take-on-react/ also enjoyed @igrigorik’s @changelog interview: https://changelog.com/podcast/469 https://twitter.com/igrigorik/status/1457760823074451458   1457760823074451458 1457760823074451458   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 255] 1374492662061953034 33521530 swyx       1 3 23 0 0 0 en  
1466846573078487043 CoRecursive Podcast 947150325424803840 2021-12-03T19:07:30+00:00 A great list to be a part of! 🏆 https://twitter.com/swyx/status/1466447829149237249   1466447829149237249 1466447829149237249   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 31]             1 3 18 1 1 0 en  
1466847530872762370 swyx 33521530 2021-12-03T19:11:18+00:00 RT @corecursive: A great list to be a part of! 🏆 1466846573078487043 1466846573078487043     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 48]             1 3 0 1 1   en  
1469025856878268416 swyx 33521530 2021-12-09T19:27:12+00:00 gave this talk again thanks to @giorgio_boa! https://twitter.com/italian_coders/status/1468996525653209094?s=20   1468996525653209094 1468996525653209094   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 68] 1442647414326714370 33521530 swyx       1 3 3 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]);