tweets

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

8 rows where "created_at" is on date 2021-09-12, is_quote_status = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: retweet_count, favorite_count, retweeted, 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
1436960825005252610 swyx 33521530 2021-09-12T07:52:12+00:00 @maninak_ 43mb! i hope they were building photoshop or something.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 65] 1436959270285815809 1408407818558918666 maninak_       0 1 5 0 0   en  
1436973708304863238 swyx 33521530 2021-09-12T08:43:24+00:00 Lifechanging travel tip I am only learning too late in life: You can travel in shorts! Nothing in the flight rules that say you have to be in tight jeans or nice shoes. And most airports require waaay too much walking. (yes, looking at you, @Airport_FRA!) https://twitter.com/swyx/status/1436973708304863238/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 256]             0 4 80 0 0 0 en  
1436978827679387650 swyx 33521530 2021-09-12T09:03:44+00:00 @tlakomy @Airport_FRA same!! i feel like we already met before lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 66] 1436974160434106370 1903060381 tlakomy       0 0 3 0 0   en  
1436979163794223107 swyx 33521530 2021-09-12T09:05:05+00:00 @coderinheels @Airport_FRA many airports need a proper UX redesign lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 70] 1436978353249128451 32330308 coderinheels       0 0 1 0 0   en  
1436982325909364736 swyx 33521530 2021-09-12T09:17:38+00:00 RT @CouchNish: A person called OwlKitty changed the Business Card scene from “American Psycho” to the guys showing each other pictures of t… 1436104144801067033 1436104144801067033     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 49409 0 0 1   en  
1436986796680810496 swyx 33521530 2021-09-12T09:35:24+00:00 @TaliaRinger @vamchale wait what you cant leave us with that, please elaborate??       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 80] 1436379623785472004 715582520197156865 TaliaRinger       0 0 1 0 0   en  
1437025662603341829 swyx 33521530 2021-09-12T12:09:51+00:00 @simonw @pradyunsg to me, that is @anacondainc - i know it has its drawbacks, but it’s so nice living in Anaconda’s world. I’m unclear about how the larger Python community feels about it (similar to how Apollo dominates GraphQL) but they’ve certainly done a better job than anyone else i know       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 293] 1436728586669477894 12497 simonw       0 0 2 0 0   en  
1437134330615173123 swyx 33521530 2021-09-12T19:21:39+00:00 @markdalgleish web apps were the original decentralized apps       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 60] 1436874489816510465 257765996 markdalgleish       0 0 11 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]);