tweets

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

8 rows where "created_at" is on date 2021-12-04, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: retweet_count, favorite_count, favorited

user 2 ✖

source 1 ✖

  • Twitter Web App · 8 ✖

retweeted 1 ✖

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-12-04 · 8 ✖
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
1466921654592753667 swyx 33521530 2021-12-04T00:05:51+00:00 @chantastic hey you're the best pizza I ever had       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 48] 1466898635820449796 12745092 chantastic       0 0 1 0 0   en  
1466922643517427713 swyx 33521530 2021-12-04T00:09:46+00:00 @VictorPontis @vikingkarwur @BAT_Indonesia luma is really great. i tell every community builder i can to use it       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [43, 111] 1466921812357529610 186993579 VictorPontis       0 0 1 0 0   en  
1466940940229046273 nicebyte 3220870002 2021-12-04T01:22:29+00:00 @ID_AA_Carmack your son has inspired me https://twitter.com/nice_byte/status/1466940940229046273/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 39] 1466934223831506951 175624200 ID_AA_Carmack       0 831 5926 0 0 0 en  
1466943081115111428 swyx 33521530 2021-12-04T01:30:59+00:00 @ken_wheeler @chantastic man that looks gooood       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 46] 1466922124963164165 167193309 ken_wheeler       0 0 3 0 0   en  
1467221457725915136 swyx 33521530 2021-12-04T19:57:09+00:00 @temporalio @typescript Workshop video is live! https://youtu.be/CeHSmv8oF_4       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 71] 1465793834739068932 33521530 swyx       0 0 6 0 0 0 en  
1467247151323365380 swyx 33521530 2021-12-04T21:39:15+00:00 @0x49fa98 i think the 100iq people have glommed on to tweet threading but am curious what you think works for single-tweet bangers       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 130] 1467242483344097283 854746255431315456 0x49fa98       0 0 1 0 0   en  
1467249786604584961 swyx 33521530 2021-12-04T21:49:43+00:00 What's the best way to be confident without being overconfident?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 64]             0 9 91 1 0   en  
1467262164377341954 swyx 33521530 2021-12-04T22:38:55+00:00 @thisismahmoud_ @garrytan haha btw idk if you know but he has me blocked. still not sure what i did.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 100] 1467260997874429965 2675247881 thisismahmoud_       0 0 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]);