tweets

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

5 rows where "created_at" is on date 2021-07-29 and retweeted = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, retweet_count, favorite_count

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

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