tweets

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

8 rows where "created_at" is on date 2021-08-05, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: retweet_count, favorite_count

user 1 ✖

source 1 ✖

  • Twitter Web App · 8 ✖

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-08-05 · 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
1423326514393669632 swyx 33521530 2021-08-05T16:54:19+00:00 @biantris_ thank you!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 21] 1423314547847409677 1338510819743719424 biantris_       0 0 1 0 0   en  
1423327998556606464 swyx 33521530 2021-08-05T17:00:13+00:00 *starts startup* "well as you know all the legacy solutions are slow, insecure and expensive"       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 95]             0 2 70 0 0   en  
1423354263686631425 swyx 33521530 2021-08-05T18:44:35+00:00 Great "You may not need a dropdown" reminder from @erikdkennedy: https://learnui.design/blog/4-rules-intuitive-ux.html Who ever at @Twitter designed Scheduled Tweets should take note of the last one https://twitter.com/swyx/status/1423354263686631425/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 171]             0 34 282 0 0 0 en  
1423361516082847747 swyx 33521530 2021-08-05T19:13:24+00:00 @JustJake thats awful i'm so sorry.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 35] 1423274062940237824 607528502 JustJake       0 0 1 0 0   en  
1423365577091866626 swyx 33521530 2021-08-05T19:29:33+00:00 @maxlynch i know but i just love the shameless superiority complex of an early stage startup making ~$0 just shitting on stable, moneymaking incumbents while downplaying their own flaws       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 185] 1423344700640145417 15103611 maxlynch       0 1 12 0 0   en  
1423387793175113730 swyx 33521530 2021-08-05T20:57:49+00:00 Thread of things and tips I ran into as I learn @Figmadesign:       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 61]             0 2 40 0 0   en  
1423388158746451970 swyx 33521530 2021-08-05T20:59:16+00:00 How to make things float in Figma https://twitter.com/swyx/status/1423388158746451970/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 33] 1423387793175113730 33521530 swyx       0 1 27 0 0 0 en  
1423393466902482944 swyx 33521530 2021-08-05T21:20:22+00:00 @samseely i just tried it and that didn't work at all, it just switched to the "move canvas" hand. is there some setting that you had or are we talking about the same mode?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 172] 1423391229593759747 29101388 samseely       0 0 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]);