tweets

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

12 rows where "created_at" is on date 2021-07-29 and is_quote_status = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, display_text_range, retweet_count, favorite_count, 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
1420538889102495744 swyx 33521530 2021-07-29T00:17:18+00:00 @lmatteis how will Storybook make money from their great market share? 🤔 @domyen keen on how you monetize this, i think its super challenging but potentially huge if done right       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 176] 1420298810266370048 281950081 lmatteis       0 0 0 0 0   en  
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  
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  
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  
1420794468379226121 swyx 33521530 2021-07-29T17:12:53+00:00 @domyen @CodyBontecou @lmatteis @chromaui @storybookjs ayyy secret master plan! i love it       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [55, 89] 1420784518118641668 274703970 domyen       0 0 1 0 0   en  
1420801305119911941 swyx 33521530 2021-07-29T17:40:03+00:00 @CharlesStover @code @stolinski or use a framework that embraces single file components idk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [32, 91] 1420800760309186562 30982985 CharlesStover       0 0 2 0 0   en  
1420811599560937474 swyx 33521530 2021-07-29T18:20:57+00:00 @dan_abramov @jhooks yarn upgrade --yolo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 40] 1420811260682285063 70345946 dan_abramov       0 0 38 0 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  
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  

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