tweets

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

8 rows where retweet_count = 14 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, is_quote_status, favorite_count, favorited, retweeted

created_at (date) 5 ✖

source 1 ✖

  • Twitter Web App · 8 ✖
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  
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  

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