tweets
4 rows where favorite_count = 20 and retweet_count = 1
This data as json, CSV (advanced)
Suggested facets: source, is_quote_status, lang, created_at (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1425618222787686404 | swyx 33521530 | 2021-08-12T00:40:45+00:00 | @betterbomb @vercel By 14 my father will finally get his pack of cigarettes and come back | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 89] | 1425608082353115140 | 127461367 | betterbomb | 0 | 1 | 20 | 0 | 0 | en | ||||||||
1441597923771523072 | swyx 33521530 | 2021-09-25T02:58:23+00:00 | @beyang 1. learning how compilers work 2. learning how operating systems work 3. learning how networks work 4. learning how databases work basically all the shit people complain about in cs undergrad becomes very real very fast the second you try to do something nontrivial | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 274] | 1441558898012422146 | 16520821 | beyang | 0 | 1 | 20 | 0 | 0 | en | ||||||||
1459750702800986115 | swyx 33521530 | 2021-11-14T05:11:03+00:00 | @rakyll yes! this is why I was extremely inspired when Sarah implemented product rotations for us at @Netlify. It meant that we literally spent 3 months each year as engineers, not as developer advocates. Huge investment from both eng and DX, was very grateful. https://twitter.com/sarah_edo/status/1346842506722308099 | 1346842506722308099 1346842506722308099 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 286] | 1459640319352344576 | 10809412 | rakyll | 1 | 1 | 20 | 0 | 0 | 0 | en | ||||||
1468767124906668035 | swyx 33521530 | 2021-12-09T02:19:05+00:00 | @DavidKPiano https://twitter.com/netlify/status/1276232504337465344?s=21 | 1276232504337465344 1276232504337465344 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 36] | 1468615741981302791 | 992126114 | DavidKPiano | 1 | 1 | 20 | 0 | 0 | 0 | und |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);