tweets

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

10 rows where display_text_range = "[0, 258]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, retweeted, created_at (date)

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
1264836620831711232 swyx 33521530 2020-05-25T08:32:04+00:00 👍 @igrigorik's @perfnowconf 2019 talk https://www.youtube.com/watch?v=vtIfVPtN6io An instant classic I just referenced for @Sveltejs Radio today. There is a huge difference between the head (us) and torso/tail (everyone else). If you care about impact, you *have* to simplify. https://twitter.com/swyx/status/1264836620831711232/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 0 15 0 0 0 en  
1424724444048658436 SnorkelAI 1149142678715527169 2021-08-09T13:29:12+00:00 We are delighted to announce our $85 million Series C at a $1 billion valuation to accelerate #DataCentricAI, with funding by @blackrock, Addition Capital, @lightspeedvp, @greylockvc, @googleventures, and more. Read more in @Fortune ↓ https://snkl.ai/seriesc       Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 0 [0, 258]             0 42 290 0 0 0 en  
1427442268064030730 swyx 33521530 2021-08-17T01:28:51+00:00 The @Official_GDC breakdowns of how they made the game are a must watch btw. So, so much work went into the traversal algorithm, simulation, and polish of making Spider-man swing across New York, trading off physics with user intent. https://youtu.be/OEaGEaCUq3g       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 258] 1422416105226657792 33521530 swyx       0 0 3 0 0 0 en  
1433910190466736134 swyx 33521530 2021-09-03T21:50:04+00:00 I gotta hand it to Aldo Bucchi (not on Twitter) for leaving the best blogpost comment I've had all year 🙇‍♂️ https://dev.to/aldonline/comment/1hln8 Even if its an exaggeration (it probably is?) it captured my attention and left me no choice but to check out his product 👏 https://twitter.com/swyx/status/1433910190466736134/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 2 24 0 0 0 en  
1434206574055022592 swyx 33521530 2021-09-04T17:27:48+00:00 The Strategy: 1. Start a Swipe File 2. Collect examples 3. Offer newsletter signup 4. Offer login + faving 5. Build a Community 6. Hit the Media Circuit 7. Make Generators 8: Monetize - Ads - Workshop - Book - Course https://youtu.be/2r7fSeMCcK8       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258] 1434206572608049156 33521530 swyx       0 1 9 0 0 0 en  
1441469889315622912 scott belsky 15698507 2021-09-24T18:29:37+00:00 That a prototype is worth a hundred meetings, and almost all product meetings that aren’t grounded with a prototype are a waste of time (or worse). A prototype immediately surfaces gaps in logic or business concerns. It is the fastest way to drive alignment.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258] 1441469888246259715 15698507 scottbelsky       0 50 426 0 0   en  
1445439018359996417 React New York 1074605328694722560 2021-10-05T17:21:31+00:00 2 more to go! @deekshasharma25 will talk about headless architecture and we finish React Day New York with @swyx You can watch the event over at https://reactnewyork.com/ or on YouTube https://www.youtube.com/playlist?list=PLiKqsi6CxPy6Njsj1WuTSYkDKmPtPy95O Be sure to join the live chat and ask questions.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 4 6 0 1 0 en  
1445795629049864197 devon ko ☻ 19130153 2021-10-06T16:58:34+00:00 I'm in desperate search of a kidney donor who meets the following requirements: ∙ Blood type: O+/- ∙ Age: 18-55 ∙ Location: Based in US ∙ No history of kidney disease, diabetes, high blood pressure Could this be you? Let me know at http://kidneyfordevon.com. https://twitter.com/devonko_/status/1445795629049864197/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258] 1445795616785723395 19130153 devonko_       0 2233 2057 0 1 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  
1459979460397068295 swyx 33521530 2021-11-14T20:20:03+00:00 Super underrated way to level up: 1. Find an industry leader who has more ideas than bandwidth (read: all of them) 2. Do something small for them 3. Do something bigger with them 4. Start something with them 5. Realize you now have more ideas than bandwidth       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 36 306 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]);