tweets

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

13 rows where "created_at" is on date 2021-10-22, is_quote_status = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, retweet_count, lang

favorite_count 8 ✖

retweeted 2 ✖

  • 0 11
  • 1 2

favorited 2 ✖

  • 0 10
  • 1 3

source 1 ✖

  • Twitter for iPhone · 13 ✖

created_at (date) 1 ✖

  • 2021-10-22 · 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
1451387846053433348 Dion Almaer 4216361 2021-10-22T03:20:02+00:00 This is one of the most impactful things I read when I first saw it at Google: “How orgs are like slime moulds” by the platform thinker that is @komorama https://komoroske.com/slime-mold/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 177]             0 198 784 1 1 0 en  
1451392508756299781 swyx 33521530 2021-10-22T03:38:34+00:00 RT @mitchellh: I love this “Willingness to look stupid” post. For me, I’d also flip this and say that people who go out of their way to be… 1451287571481325569 1451287571481325569     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             0 56 0 1 1   en  
1451403800510566400 swyx 33521530 2021-10-22T04:23:26+00:00 @FoolAllTheTime lol suprised to see DECK analysis from you. i used to cover consumer for a hot minute. love when a stale name finds new legs.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 141] 1451280403696963591 986801772676157440 FoolAllTheTime       0 0 1 0 0   en  
1451407771400761346 swyx 33521530 2021-10-22T04:39:13+00:00 @yongfook @ahrefs the fact that browsers dont auto do this by default upsets me       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 79] 1451386949894230019 7895442 yongfook       0 0 4 0 0   en  
1451410103001698305 swyx 33521530 2021-10-22T04:48:29+00:00 @acdlite its all opaque anyway, that was always the point       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 57] 1451310475724169223 21782915 acdlite       0 0 1 0 0   en  
1451410441012273155 swyx 33521530 2021-10-22T04:49:49+00:00 @sebastienlorber honestly miss getting excited about stuff like this. love that react continues to innovate. 💜       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 110] 1451216514779172867 40663578 sebastienlorber       0 0 12 0 0   en  
1451412869065547777 swyx 33521530 2021-10-22T04:59:28+00:00 how many vacation days have you taken this year?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 48]             0 2 22 1 0   en  
1451417925353500676 swyx 33521530 2021-10-22T05:19:34+00:00 @dvassallo you are post-vacation       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 32] 1451414435319345157 24179991 dvassallo       0 0 2 0 0   en  
1451459461109846020 swyx 33521530 2021-10-22T08:04:36+00:00 i think ive taken like 9. when i was an options trader in London we had TWENTY EIGHT days vacation, including mandatory 2 week block vacation. i think that was my peak work life balance. i have so many things i would go back and do differently.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 246] 1451412869065547777 33521530 swyx       0 0 11 0 0   en  
1451460947449573378 swyx 33521530 2021-10-22T08:10:31+00:00 @mozzius @nocashirl yea and i was a junior trader too. i think seniors got 32. thats like 2 months of the year not working lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [20, 126] 1451460372200927235 1266850963429752832 mozzius       0 0 2 0 0   en  
1451461828819652612 swyx 33521530 2021-10-22T08:14:01+00:00 @AntWilson try to make more friends outside of work. #learninpublic. force myself to date more. recognize that i was really freaking good at coding compared to most people and believe that i could change careers despite not having a degree. learn guitar/piano. buy bitcoin.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 273] 1451460743459577862 22399680 AntWilson       0 1 11 0 0   en  
1451463117456633860 swyx 33521530 2021-10-22T08:19:08+00:00 @haroenv whats shocking is the 29% that have taken <7 days… wtf       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 66] 1451462825180811264 365550734 haroenv       0 0 2 0 0   en  
1451411483795939330 swyx 33521530 2021-10-22T04:53:58+00:00 @Madisonkanna @RandallKanna Coyote       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 34] 1451366109479796741 1087957969915006976 Madisonkanna       0 0 1 0 0   es  

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