tweets

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

5 rows where in_reply_to_screen_name = "rauchg" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, retweet_count

created_at (date) 5 ✖

user 2 ✖

is_quote_status 2 ✖

in_reply_to_screen_name 1 ✖

  • rauchg · 5 ✖
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
1316808667925082112 Guillermo Rauch 15540222 2020-10-15T18:30:26+00:00 Temporal's engine is quite complex, much like React's, but the surface exposed to the developer is a beautiful "render()" function to organize your backend workflows. Check it out: https://docs.temporal.io       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 205] 1316808667304390657 15540222 rauchg       0 1 28 0 0 0 en  
1436716757436321799 swyx 33521530 2021-09-11T15:42:22+00:00 @rauchg @leeerob yeah i don't doubt that switching from CSR to SSR was the unmitigated win here. Still they have characterized it as "initial required JS", sounds like you would have phrased it differently. also no way Nextjs takes up 800kb, something else is going on that they couldnt rip out       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [17, 294] 1436710278494707719 15540222 rauchg       0 0 8 0 0   en  
1442204116151771136 swyx 33521530 2021-09-26T19:07:10+00:00 @rauchg @ConvertKit - theres a race condition that only infrequently lets you select text, paste url, and it converts into a link. when you miss the race you have to use the dialog box, where after pasting, you cant just hit enter to make it a link, you have to use the mouse to click!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 285] 1442175055102767106 15540222 rauchg       0 0 12 0 0   en  
1455019275614232579 swyx 33521530 2021-11-01T03:50:02+00:00 @rauchg oh my god i didnt know that. i bet this is my problem because the flags are just not working!!! thank you!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 115] 1455014320987787271 15540222 rauchg       0 0 14 0 0   en  
1468383195120889856 swyx 33521530 2021-12-08T00:53:29+00:00 @rauchg i gotchu https://twitter.com/sarah_edo/status/1240642567827406849   1240642567827406849 1240642567827406849   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 16] 1468279703291129859 15540222 rauchg       1 0 7 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]);