tweets

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

13 rows where "created_at" is on date 2021-10-28 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, is_quote_status, retweet_count, favorite_count, favorited, retweeted, lang

created_at (date) 1 ✖

  • 2021-10-28 · 13 ✖
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
1453583269354622978 swyx 33521530 2021-10-28T04:43:52+00:00 @jhooks solid @aprildunford plug alongside derpy cat       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 52] 1453455564730560514 12087242 jhooks       0 0 6 0 0   de  
1453532106563338241 swyx 33521530 2021-10-28T01:20:34+00:00 @anildash honestly out of the possible range of things to emerge from before you were famous, this has got to be up there in terms of “makes you relatable and even more endearing”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 179] 1453368190763929602 36823 anildash       0 0 2 0 0   en  
1453535469132652548 swyx 33521530 2021-10-28T01:33:55+00:00 @QuinnyPig COREY COME DROP BY @CASCADIAJS if you are free!!! cc @crtr0 i *Really* like http://optimismbrewing.com. Just beer, **bring your own food**, huge venue with lots of air.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 178] 1453529346048622593 97114171 QuinnyPig       0 0 3 0 0 0 en  
1453538330176413704 swyx 33521530 2021-10-28T01:45:18+00:00 RT @seldo: I don't think enough has been made of the discovery that Google's funding of AMP was an explicitly anti-competitive move designe… 1453377986791575552 1453377986791575552     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 353 0 1 1   en  
1453538950572691458 swyx 33521530 2021-10-28T01:47:45+00:00 RT @whereistanya: Hey, so, I've been a bit shy about announcing this, but I'm writing a book! It's called the Staff Engineer's Path. It i… 1453510557122846722 1453510557122846722     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 218 0 1 1   en  
1453539770630492162 swyx 33521530 2021-10-28T01:51:01+00:00 @mjackson i wrote a post about this phenomenon last year! https://twitter.com/swyx/status/1262062882050596864   1262062882050596864 1262062882050596864   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 57] 1452146698323591173 734903 mjackson       1 0 6 0 0 0 en  
1453560383306809350 swyx 33521530 2021-10-28T03:12:55+00:00 @robwalling started very strong! loved the meta discussion about what makes it a good podcast and then the joke about “sooo what have you built” 😂 got a good lol out of me       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 171] 1453523669322539012 86174269 robwalling       0 0 2 0 0   en  
1453581382760820741 swyx 33521530 2021-10-28T04:36:22+00:00 @Madisonkanna jealous!! please take many photos and congrats 🎉       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 62] 1453533601857822720 1087957969915006976 Madisonkanna       0 0 4 0 0   en  
1453581980247855105 swyx 33521530 2021-10-28T04:38:44+00:00 @TurnerNovak @VandelayIndust9 @EddyElfenbein we live in an economy       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [45, 66] 1453538971942858753 35647451 TurnerNovak       0 0 9 0 0   en  
1453585223594041351 swyx 33521530 2021-10-28T04:51:38+00:00 just found out Garry blocked me :( this was our last interaction…which he retweeted so i think he was ok with it? people can block or mute however they want, and i try not to care. but it hurts a little when its someone i look up to and i dont know what i did :(       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 264] 1394440978199506947 33521530 swyx       0 1 17 0 0   en  
1453585919110385667 swyx 33521530 2021-10-28T04:54:24+00:00 @businessbarista my money is on Snoop       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 37] 1453499399666024463 846417084192055296 businessbarista       0 0 4 0 0   en  
1453644616461271041 swyx 33521530 2021-10-28T08:47:38+00:00 RT @emanuel__sol: Every single software team with a SDK needs to watch this video by @swyx . Wow!! So many insights. https://youtu.be/ddKDPikKbNk 1453546267116703745 1453546267116703745     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 5 0 1 1 0 en  
1453537742986493955 swyx 33521530 2021-10-28T01:42:58+00:00 @ken_wheeler hahahahhaa omg unintentional burns       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 47] 1453532433895276545 167193309 ken_wheeler       0 0 2 0 0   nl  

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]);