tweets

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

15 rows where is_quote_status = 1, lang = "und" and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count

source 1 ✖

  • Twitter Web App · 15 ✖

lang 1 ✖

  • und · 15 ✖
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
1420433131895623684 swyx 33521530 2021-07-28T17:17:03+00:00 @TylertheHaas @mark_volkmann @kentcdodds @matiasfha @sergiodxa @goncy @stolinski @LevelUpTuts @sveltejs https://twitter.com/swyx/status/1420211877276049408?s=20   1420211877276049408 1420211877276049408   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [104, 127] 1420429733427257344 43845766 TylertheHaas       1 0 5 0 0 0 und  
1427497832848658434 swyx 33521530 2021-08-17T05:09:39+00:00 @jhooks https://twitter.com/celothedev/status/1427460022284419073?s=20   1427460022284419073 1427460022284419073   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 31] 1427492570733584385 12087242 jhooks       1 0 4 0 0 0 und  
1428103782810873859 swyx 33521530 2021-08-18T21:17:29+00:00 @mozzius @reactjs @jquery https://twitter.com/swyx/status/1093200303254466561   1093200303254466561 1093200303254466561   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 49] 1428103288537354241 1266850963429752832 mozzius       1 0 4 0 0 0 und  
1432471987071246336 swyx 33521530 2021-08-30T22:35:10+00:00 @ksylor @lT0mm @ohshitgit https://twitter.com/swyx/status/1432471431850299397?s=20   1432471431850299397 1432471431850299397   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 49] 1432462751436140544 33521530 swyx       1 0 1 0 0 0 und  
1432796518281453570 swyx 33521530 2021-08-31T20:04:44+00:00 @CntrvaslDev it's @temporalio ! https://twitter.com/swyx/status/1417165270641045505   1417165270641045505 1417165270641045505   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 56] 1432791593396936704 930727203876364289 CntrvaslDev       1 0 0 0 0 0 und  
1432931687441133568 swyx 33521530 2021-09-01T05:01:51+00:00 @chantastic https://twitter.com/swyx/status/1372013877731368961?s=20   1372013877731368961 1372013877731368961   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 35] 1432930900325535750 12745092 chantastic       1 0 15 0 0 0 und  
1444781745409179655 swyx 33521530 2021-10-03T21:49:45+00:00 @threepointone 👁️‍👄👁️ https://twitter.com/swyx/status/1417165280522821632   1417165280522821632 1417165280522821632   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 46] 1444737710116196353 1593171 threepointone       1 0 12 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  
1451285680412258309 swyx 33521530 2021-10-21T20:34:04+00:00 @clemmihai https://twitter.com/sahilbloom/status/1443712206558871558   1443712206558871558 1443712206558871558   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 34] 1451274296991510537 4796832195 clemmihai       1 0 3 0 0 0 und  
1457411078372020229 swyx 33521530 2021-11-07T18:14:13+00:00 https://twitter.com/rrhoover/status/1457353577819746321?s=20   1457353577819746321 1457353577819746321   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 23] 1416526365172506624 33521530 swyx       1 0 11 0 0 0 und  
1465524048574627841 swyx 33521530 2021-11-30T03:32:15+00:00 @Nutlope https://twitter.com/elzr/status/1381105950602461189   1381105950602461189 1381105950602461189   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 32] 1465521492331016193 3246815913 Nutlope       1 1 13 0 0 0 und  
1467306253172887552 swyx 33521530 2021-12-05T01:34:06+00:00 @BrittneyPostma @argyleink https://twitter.com/swyx/status/1467304180003917824   1467304180003917824 1467304180003917824   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 50] 1467302465578045441 33521530 swyx       1 1 1 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  
1473026177833275392 swyx 33521530 2021-12-20T20:23:02+00:00 @buildsghost @tmcw https://twitter.com/swyx/status/1142025639744008194   1142025639744008194 1142025639744008194   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 42] 1473025536419004416 1175464650395111424 buildsghost       1 0 0 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]);