tweets
8 rows where "created_at" is on date 2021-07-29 and possibly_sensitive = 0 sorted by in_reply_to_status_id
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, is_quote_status, retweet_count, retweeted
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1420584976576286722 | kennethcassel.eth 🍊 1319269656264409088 | 2021-07-29T03:20:26+00:00 | I'm building a new course on @SlipApp! If you've ever wanted to go the extra mile and delight your users, If you've ever wanted someone to share your website because the experience made them happy, This is the course for you. I'm calling it "Animated Applications" https://twitter.com/KennethCassel/status/1420584976576286722/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 23 | 159 | 0 | 1 | 0 | en | ||||||||||
1420614194265686017 | swyx 33521530 | 2021-07-29T05:16:32+00:00 | Met @Aella_Girl today and experienced that rare feeling when someone collects better questions than I do. It was unnerving and exciting at the same time. Check hers out: https://www.askhole.io The right question at the right time in your life can be a Nexus event. https://twitter.com/swyx/status/1349271110492196870 | 1349271110492196870 1349271110492196870 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 268] | 1 | 0 | 13 | 0 | 0 | 0 | en | |||||||||
1420635902032846852 | swyx 33521530 | 2021-07-29T06:42:47+00:00 | Today's mixtape: A clip from 1984, inspired by the Loki TV Series https://swyx.transistor.fm/episodes/1984-vs-brave-new-world-pt-1-intelligence-squared https://twitter.com/swyx/status/1419128271799656449 https://twitter.com/swyx/status/1420635902032846852/photo/1 | 1419128271799656449 1419128271799656449 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 114] | 1 | 0 | 14 | 0 | 0 | 0 | en | |||||||||
1420663531653926912 | Savio Martin ⚡️ 1331060842494758913 | 2021-07-29T08:32:35+00:00 | The wait is over!! 🎉🎉 Introducing Slickr. The most powerful cover image generator for your @hashnode blog ✨️ Enjoy creating cover image for your hashnode blog like never before, get started in seconds. #DEVCommunity #CodeNewbie #sidehustle https://savio.xyz/introducing-slickr-the-most-powerful-cover-image-generator-for-your-hashnode-blog | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 266] | 0 | 45 | 268 | 0 | 1 | 0 | en | ||||||||||
1420758051049459725 | Bob Nystrom 38167592 | 2021-07-29T14:48:10+00:00 | Today is the day! Crafting Interpreters is available for purchase in print, Kindle, ebook, and PDF! Behold: http://craftinginterpreters.com/ It took a lot longer than I expected, but it's all done now. So long that I wrote a blog post about it: http://journal.stuffwithstuff.com/2021/07/29/640-pages-in-15-months/ 🎉📖🎉📖🎉📖🎉📖🎉 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 492 | 2018 | 0 | 1 | 0 | en | ||||||||||
1420772267772968960 | swyx 33521530 | 2021-07-29T15:44:39+00:00 | If you're using VS @Code, you should probably be making custom snippets to speed up your workflow and save your keystrokes. Shoutout to @stolinski for pointing me to the Easy Snippets extension! https://twitter.com/swyx/status/1420772267772968960/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 195] | 0 | 105 | 812 | 0 | 0 | 0 | en | ||||||||||
1420843541266268160 | swyx 33521530 | 2021-07-29T20:27:52+00:00 | TIL about the time Mythbusters put literal bulls in a china shop to see what happens https://twitter.com/swyx/status/1420843541266268160/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 84] | 0 | 9 | 41 | 0 | 0 | 0 | en | ||||||||||
1420642639037091841 | swyx 33521530 | 2021-07-29T07:09:34+00:00 | Reflections on 10 years of Containers, from Bryan Cantrill some history at the start https://youtu.be/xXWaECk9XqM | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 110] | 1381331610319036416 | 33521530 | swyx | 0 | 0 | 6 | 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]);