tweets

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

4 rows where favorite_count = 80 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status

created_at (date) 4 ✖

user 1 ✖

retweeted 1 ✖

  • 0 4

favorite_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
968688836468453376 swyx 33521530 2018-02-28T03:26:30+00:00 This passage from @DanielPink 's Drive is the realest thing I have ever read. Have to keep the fire burning or be dead inside. https://twitter.com/swyx/status/968688836468453376/photo/1       Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 0 [0, 126]             0 13 80 0 0 0 en  
1436594934002458626 swyx 33521530 2021-09-11T07:38:17+00:00 I’d really love to hear behind the scenes on GitHub’s decision to launch this shortcut. The obvious downside: launching an expensive action on a single keypress may negatively surprise users. The upside: the barrier to using Codespaces can’t be lower. I use it once a day now. https://twitter.com/github/status/1425505817827151872   1425505817827151872 1425505817827151872   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             1 1 80 0 0 0 en  
1436973708304863238 swyx 33521530 2021-09-12T08:43:24+00:00 Lifechanging travel tip I am only learning too late in life: You can travel in shorts! Nothing in the flight rules that say you have to be in tight jeans or nice shoes. And most airports require waaay too much walking. (yes, looking at you, @Airport_FRA!) https://twitter.com/swyx/status/1436973708304863238/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 256]             0 4 80 0 0 0 en  
1449825610625212417 swyx 33521530 2021-10-17T19:52:16+00:00 @patrickc More data to back up @levelsio - I moved my book sales platform from Podia to Stripe Checkout last year. I have anonymous numbers for traffic and compared it against purchases. Conversion went up ~20% for 2 hours of work 🤯 https://twitter.com/swyx/status/1330608936660025344   1330608936660025344 1330608936660025344   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 258] 1449823925400076289 4939401 patrickc       1 4 80 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]);