tweets
12 rows where lang = "en", source = "295366d0fb34352a1961af2413827f072adefdb9" and user = 33521530
This data as json, CSV (advanced)
Suggested facets: created_at, display_text_range, retweet_count, favorite_count, favorited, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1417165270641045505 | swyx 33521530 | 2021-07-19T16:51:44+00:00 | I'm excited to finally share why I've joined @temporalio as Head of Developer Experience! Here's my explainer on 3 core opinions of Temporal, why they're hard to do well, and the business opportunities it presents: https://www.swyx.io/why-temporal/ | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 240] | 0 | 30 | 396 | 0 | 0 | 0 | en | ||||||||||
| 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 | |||||||
| 1435801431978635267 | swyx 33521530 | 2021-09-09T03:05:11+00:00 | 1/ I'm excited to announce a new learning experience I’m launching today with @chapter_HQ. My 4 week long “chapter” includes curated content, in-depth discussion and private Q&A for your own #LearnInPublic journey! https://getchapter.app/@swyx/learn | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 243] | 0 | 12 | 72 | 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 | |||||||
| 1466447823801491458 | swyx 33521530 | 2021-12-02T16:43:01+00:00 | 🆕 For my third year in a row, I've compiled my list of favorite new podcasts to feature up-and-comers and my favorite episodes of each. Presenting: Favorite New Podcasts of 2021! https://www.swyx.io/fave-podcasts-2021 | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 207] | 0 | 4 | 24 | 1 | 1 | 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
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]);