tweets
5 rows where "created_at" is on date 2021-07-29, favorited = 0 and retweeted = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, display_text_range, retweet_count, favorite_count
user 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1420541906979749889 | swyx 33521530 | 2021-07-29T00:29:17+00:00 | RT @mollyfmielke: My thesis is out! "Computers and Creativity" asks: How can we utilize the full potential of creative thought and computa… | 1374387504174927878 1374387504174927878 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 213 | 0 | 0 | 1 | en | ||||||||||
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 | ||||||||||
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 | ||||||||||
1420825810877915136 | swyx 33521530 | 2021-07-29T19:17:25+00:00 | RT @KennethCassel: 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… | 1420584976576286722 1420584976576286722 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 23 | 0 | 0 | 1 | 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]);