tweets

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

7 rows where "created_at" is on date 2021-12-03 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, retweet_count, favorite_count, lang

created_at (date) 1 ✖

  • 2021-12-03 · 7 ✖
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
1466616760228974598 swyx 33521530 2021-12-03T03:54:18+00:00 @jordienr @AntWilson @fig @vercel @supabase dammit. you may have just nerd sniped me into making one       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [44, 100] 1466482441636429838 2340086665 jordienr       0 0 19 0 0   en  
1466616985500848129 swyx 33521530 2021-12-03T03:55:12+00:00 @_dijonmusters @AntWilson @supabase next time ship actual ships or we riot       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [36, 74] 1466598706057154561 1052334971799535616 jonmeyers_io       0 0 7 0 0   en  
1466651985176776710 swyx 33521530 2021-12-03T06:14:16+00:00 @pacman326 i do. cheers thank you. idk how common it is to always keep activity monitor up since it itself has some load. but cant hurt, i need to root cause this bc its so bad       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 176] 1466650938106650629 28897143 pacman326       0 0 0 0 0   en  
1466718569975017473 swyx 33521530 2021-12-03T10:38:52+00:00 @seldo what does twitter api have to do with it?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [7, 48] 1466484198907125765 15453 seldo       0 0 0 0 0   en  
1466719647504343045 swyx 33521530 2021-12-03T10:43:08+00:00 @EmilyKager @farazamiruddin this was intensely triggering and i want to send it to every recruiter so we can skip all this       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 122] 1466488709549674498 2347475803 EmilyKager       0 0 12 0 0   en  
1466875921818861577 Relay 1441943134112403460 2021-12-03T21:04:07+00:00 Hey all, We've just published the first release candidate of the upcoming Relay v13 to NPM. This is very exciting for us, as it has the new version of the Relay Compiler that we've been working on for a few years now! https://github.com/facebook/relay/releases/tag/v13.0.0-rc.0       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 243]             0 43 216 0 0 0 en  
1466652061802516481 swyx 33521530 2021-12-03T06:14:35+00:00 @jasonlaster11 🚀       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 16] 1466647442523258881 312750384 jasonlaster11       0 0 1 0 0   und  

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