tweets

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

9 rows where in_reply_to_user_id = 33521530 and source = "295366d0fb34352a1961af2413827f072adefdb9" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at, favorite_count, created_at (date)

retweet_count 4 ✖

source 1 ✖

  • Typefully · 9 ✖

favorited 1 ✖

  • 0 9
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
1417165280522821632 swyx 33521530 2021-07-19T16:51:47+00:00 Why Orchestration: Every time you cross service boundaries, the probability of network or system failure increases. Instead of having every team write their own retries and timeouts and provisioning infrastructure, give them "reliability on rails". https://twitter.com/swyx/status/1417165280522821632/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 251] 1417165272008433682 33521530 swyx       0 4 28 0 0 0 en  
1435801433253695491 swyx 33521530 2021-09-09T03:05:12+00:00 2/ I’ll be guiding you through all the best ideas I’ve found from the #LearnInPublic movement. My goal is to make this a community experience and inspire you to start your own blog, newsletter, meetup, YouTube, Twitch, etc.       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 223] 1435801431978635267 33521530 swyx       0 1 6 0 0   en  
1435801439331241987 swyx 33521530 2021-09-09T03:05:13+00:00 3/ I’ve handpicked 4 weeks of content, and you can expect about 90 mins/week in total. The interactions are asynchronous, which allows me to answer more of your questions. I’d love for you to join me! https://twitter.com/swyx/status/1435801439331241987/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 200] 1435801433253695491 33521530 swyx       0 0 5 0 0 0 en  
1435801440929427456 swyx 33521530 2021-09-09T03:05:14+00:00 4/ I've enjoyed working with Chapter to set this up. @KyleLadewig and @stflory have an admirable mission to make learning more accessible...chapters are 99% cheaper than other premium online cohort based courses.       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 212] 1435801439331241987 33521530 swyx       0 0 3 0 0   en  
1435801442145554443 swyx 33521530 2021-09-09T03:05:14+00:00 5/ If you like the work I do, I’d appreciate a retweet of this thread. Again, here is the invite link to register: https://getchapter.app/@swyx/learn Looking forward to seeing you in my chapter!       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 185] 1435801440929427456 33521530 swyx       0 1 4 0 0 0 en  
1466447829149237249 swyx 33521530 2021-12-02T16:43:02+00:00 🏆 Best Tech Podcast Finds of 2021 - @CoRecursive by @adamgordonbell - @Sourcegraph by @beyang - Stevey's Tech Talk by @Steve_Yegge - @Podrocketpod by @LogRocket - @DevToolsFM by @Zephraph @hipstersmoothie https://twitter.com/swyx/status/1466447829149237249/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 207] 1466447823801491458 33521530 swyx       0 7 42 0 0 0 en  
1466447833154740227 swyx 33521530 2021-12-02T16:43:03+00:00 🏆 Best Business/Crypto Podcast Finds of 2021 - Business Breakdowns by @jspujji @joincolossus - The @BreakdownNLW by @NLW - Not Boring by @packym - @BanklessHQ https://twitter.com/swyx/status/1466447833154740227/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 159] 1466447829149237249 33521530 swyx       0 1 11 0 0 0 en  
1466447837193854979 swyx 33521530 2021-12-02T16:43:04+00:00 🏆 Best Creator Podcast Finds of 2021 - Creator Lab by @bzaidi - Masters of Community by @DavidSpinks - Talking Too Loud by @csavage - Brains by @csallen @julian - Not Overthinking by @AliAbdaal @taimurabdaal https://twitter.com/swyx/status/1466447837193854979/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 208] 1466447833154740227 33521530 swyx       0 1 11 0 0 0 en  
1466447838531833859 swyx 33521530 2021-12-02T16:43:04+00:00 🧡 The Still Good Awards Given to 2020's picks that are: - Still alive - Still good! Here goes: 🧡 @tiesto's Clublife 🧡 @ConanOBrien's pod 🧡 @SoftwareSocPod by @mjwhansen and @leenyburger 🧡 @WritingExcuses! See full list: https://www.swyx.io/fave-podcasts-2021       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 250] 1466447837193854979 33521530 swyx       0 1 3 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]);