tweets

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

11 rows where retweet_count = 14 sorted by lang descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, is_quote_status, favorite_count, favorited, 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
1284597930398105600 swyx 33521530 2020-07-18T21:16:27+00:00 The primary beneficiary of you being #1 on Product Hunt is Product Hunt. The primary beneficiary of you being Employee of the Month is your Employer. The primary beneficiary of you going viral on Twitter is Twitter. Youre surprised *everything* around you is designed this way?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1284596781779767297 33521530 swyx       0 14 136 0 0   en  
1430880791316373512 Forrest Brazeal 3239330680 2021-08-26T13:12:19+00:00 The Cloud Resume Challenge Book has officially LAUNCHED! 🚀First 100 sales are 15% off with this link - move fast. https://forrestbrazeal.gumroad.com/l/cloud-resume-challenge-book/launch-deal But I haven't even told you the best part yet. Here is Cool Announcement #2 of the week:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 227]             0 14 93 0 1 0 en  
1430939976254988288 swyx 33521530 2021-08-26T17:07:30+00:00 RT @forrestbrazeal: The Cloud Resume Challenge Book has officially LAUNCHED! 🚀First 100 sales are 15% off with this link - move fast. https… 1430880791316373512 1430880791316373512     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 14 0 0 1   en  
1453489774073765888 swyx 33521530 2021-10-27T22:32:21+00:00 RT @swyx: The primary beneficiary of you being #1 on Product Hunt is Product Hunt. The primary beneficiary of you being Employee of the Mo… 1284597930398105600 1284597930398105600     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 14 0 0 1   en  
1462132521139937286 Gen Ashley 32330308 2021-11-20T18:55:32+00:00 Great to see people IRL here at #SvelteSummit Watch Party in Brooklyn - @AdamRackis @swyx @BrittneyPostma @SvelteSociety @SvelteSirens @sveltejs #javascript #typescript #webdev #webdevelopment #sveltejs #svelte #womenintech https://twitter.com/coderinheels/status/1462132521139937286/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 225]             0 14 45 1 1 0 en  
1462135459287547909 swyx 33521530 2021-11-20T19:07:13+00:00 RT @coderinheels: Great to see people IRL here at #SvelteSummit Watch Party in Brooklyn - @AdamRackis @swyx @BrittneyPostma @SvelteSociet… 1462132521139937286 1462132521139937286     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 14 0 1 1   en  
1464265965546483722 Lea Verou 22199970 2021-11-26T16:13:05+00:00 New blog post! On Yak Shaving and <md-block>, a new HTML element for Markdown https://lea.verou.me/2021/11/on-yak-shaving-and-md-block-an-html-element-for-markdown/ It talks about how my multi-levels deep yak shaving this week led me to create and release a new web component for Markdown, as well as Stretchy v2. Enjoy!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 264]             0 14 62 1 1 0 en  
1464299864934666240 swyx 33521530 2021-11-26T18:27:47+00:00 RT @LeaVerou: New blog post! On Yak Shaving and <md-block>, a new HTML element for Markdown https://lea.verou.me/2021/11/on-yak-shaving-and-md-block-an-html-element-for-markdown/ It talks about how my… 1464265965546483722 1464265965546483722     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 145]             0 14 0 1 1 0 en  
1467304180003917824 swyx 33521530 2021-12-05T01:25:52+00:00 🎙️ My latest podcast is with @argyleink! *Complexity Cliffs, DX, and the Disruption of Web Design* https://www.youtube.com/watch?v=xEyJ6LY7DKI - UI Complexity Cliffs - Open UI - UX vs DX - @Adobe vs @Figma vs @Webflow - Thoughtleading for Good - @dalmaer - and of course: How to Learn CSS! https://twitter.com/swyx/status/1451667101412954114 https://twitter.com/swyx/status/1467304180003917824/video/1   1451667101412954114 1451667101412954114   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 297]             1 14 120 1 1 0 en  
1467343666473623557 swyx 33521530 2021-12-05T04:02:46+00:00 RT @swyx: 🎙️ My latest podcast is with @argyleink! *Complexity Cliffs, DX, and the Disruption of Web Design* https://www.youtube.com/watch?v=xEyJ6LY7DKI - U… 1467304180003917824 1467304180003917824     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 14 0 1 1 0 en  
1470786647788765201 swyx 33521530 2021-12-14T16:03:57+00:00 The Great Resignation to @Vercel pipeline       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 41]             0 14 447 1 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]);