tweets

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

14 rows where favorite_count = 2, lang = "und" and possibly_sensitive = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, is_quote_status, 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
1427140305439006720 swyx 33521530 2021-08-16T05:28:58+00:00 @chantastic 👀 https://twitter.com/swyx/status/1294310598419689472?s=21   1294310598419689472 1294310598419689472   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 37] 1427086478924943361 12745092 chantastic       1 0 2 0 0 0 und  
1436660689892872192 swyx 33521530 2021-09-11T11:59:34+00:00 @DavidKPiano @Zephraph 👀 https://twitter.com/davidkpiano/status/1200507988529860609?s=21   1200507988529860609 1200507988529860609   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 48] 1436651833448075265 992126114 DavidKPiano       1 0 2 0 0 0 und  
1436777099608666122 swyx 33521530 2021-09-11T19:42:09+00:00 @adriendenat https://developers.google.com/web/tools/chrome-user-experience-report https://web.dev/vitals/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 61] 1436775019619700754 45521599 adriendenat       0 0 2 0 0 0 und  
1441815757847887879 swyx 33521530 2021-09-25T17:23:58+00:00 @supaspoida @tailwindcss WIP https://github.com/temporalio/samples-node/pull/15       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 52] 1441803246343843847 14205289 supaspoida       0 0 2 0 0 0 und  
1442904582070308871 swyx 33521530 2021-09-28T17:30:34+00:00 @superpatell @temporalio https://twitter.com/swyx/status/1442904582070308871/photo/1       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [24, 24] 1442842283909566469 34404279 superpatell       0 0 2 0 0 0 und  
1449483350285058051 swyx 33521530 2021-10-16T21:12:15+00:00 @thisismahmoud_ @stripe https://twitter.com/swyx/status/1113478881086988288   1113478881086988288 1113478881086988288   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 47] 1448962093638631425 2675247881 thisismahmoud_       1 0 2 0 0 0 und  
1450835544527675399 swyx 33521530 2021-10-20T14:45:23+00:00 @atomarranger https://react-typescript-cheatsheet.netlify.app/docs/advanced/patterns_by_usecase/#polymorphic-components-eg-with-as-props       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 37] 1450834415744020486 562711776 dylan_h_vann       0 0 2 0 0 0 und  
1452876111482818560 swyx 33521530 2021-10-26T05:53:52+00:00 @mike_hasarms https://twitter.com/swyx/status/1452876111482818560/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 13] 1452875630249332737 123131219 mike_hasarms       0 0 2 0 0 0 und  
1466203212977885189 swyx 33521530 2021-12-02T00:31:01+00:00 @statelyai https://twitter.com/swyx/status/1466203212977885189/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 10] 1466069029966295041 1214951331942850562 statelyai       0 0 2 0 0 0 und  
1468159004132052992 swyx 33521530 2021-12-07T10:02:38+00:00 @jakobgreenfeld https://twitter.com/swyx/status/1468159004132052992/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 15] 1468154599290949638 1285142519525892098 jakobgreenfeld       0 0 2 0 0 0 und  
1471242253012062208 swyx 33521530 2021-12-15T22:14:22+00:00 @elliotclydenz @0xKFN https://twitter.com/swyx/status/1193817952593707008?s=20   1193817952593707008 1193817952593707008   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 45] 1471029674092359680 1315039343686287360 elliotclydenz       1 0 2 0 0 0 und  
1471242384486715393 swyx 33521530 2021-12-15T22:14:53+00:00 @elliotclydenz @0xKFN https://twitter.com/GergelyOrosz/status/1287798586651049985?s=20   1287798586651049985 1287798586651049985   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 45] 1471242253012062208 33521530 swyx       1 0 2 0 0 0 und  
1474432139449958400 swyx 33521530 2021-12-24T17:29:50+00:00 @trun222 https://twitter.com/swyx/status/1210295490853490688?s=21   1210295490853490688 1210295490853490688   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 32] 1474412488435253249 3080674485 trun222       1 0 2 0 0 0 und  
1474943492757458946 swyx 33521530 2021-12-26T03:21:46+00:00 @dcedrych @arvidkahl @businessbarista https://twitter.com/swyx/status/1381242204379701252?s=21   1381242204379701252 1381242204379701252   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 61] 1474878557163823110 2437435208 dcedrych       1 0 2 0 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]);