tweets

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

13 rows where is_quote_status = 1, retweet_count = 3 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, favorite_count, favorited, retweeted

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
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  
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  
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  
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  
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]);