tweets

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

18 rows where "created_at" is on date 2021-11-17 and retweet_count = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, in_reply_to_user_id, favorite_count, lang, 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
1460765511684280329 swyx 33521530 2021-11-17T00:23:32+00:00 @isamlambert on the competitive threat of the big clouds: “The one thing clouds cannot clone is taste.” https://techcrunch.com/2021/11/16/planetscale-raises-50m-series-c-as-its-enterprise-database-service-hits-general-availability/ https://twitter.com/swyx/status/1460765511684280329/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 130] 1448162617973825541 33521530 swyx       0 0 7 0 0 0 en  
1460882858789146627 swyx 33521530 2021-11-17T08:09:50+00:00 @theptrk aww thanks man! its a great book you wont regret it       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 60] 1460815988392296448 30587765 theptrk       0 0 0 0 0   en  
1460883261047988224 swyx 33521530 2021-11-17T08:11:25+00:00 @bjorntheart @robhope @m1guelpf @jesseddy @WeirdoWizard @matthieunapoli @dannypostmaa @JanelSGM @valentin_gef @neverything thanks Bjorn enjoy the book! i really did… be sure to check out the audio version where he added cool sound effects!       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [123, 239] 1460856053499838471 707569101707694085 bjorntheart       0 0 3 0 0   en  
1460902862192406534 swyx 33521530 2021-11-17T09:29:19+00:00 @seldo img script a canvas (wanted to go with div but @paul_irish already got that one so dark horse)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [7, 102] 1460779991772188675 15453 seldo       0 0 1 0 0   en  
1460920753835044864 swyx 33521530 2021-11-17T10:40:24+00:00 @AByteOfCodeAlex @dvassallo and opportunism is antifragile.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [28, 59] 1460919698812391425 1455586383901331462 AByteOfCodeAlex       0 0 2 0 0   en  
1460923584486854658 swyx 33521530 2021-11-17T10:51:39+00:00 @RozenMD its kinda new! (just added to safari yesterday). turn notifs on for @addyosmani, his twitter is basically a changelog for the web platform https://addyosmani.com/blog/lazy-loading/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 171] 1460868748974436353 276480142 RozenMD       0 0 3 0 0 0 en  
1461018459022655490 swyx 33521530 2021-11-17T17:08:39+00:00 @technoheads you mean this research? :) https://twitter.com/swyx/status/1093670844495089664   1093670844495089664 1093670844495089664   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 39] 1460944792016371714 19136507 technoheads       1 0 0 0 0 0 en  
1461024874630053889 swyx 33521530 2021-11-17T17:34:09+00:00 @Netlify @marcusbragg @Forbes well that didn't take long! 🚀       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 59] 1448299743151538180 2571501973 Netlify       0 0 1 0 0   en  
1461029504957104130 swyx 33521530 2021-11-17T17:52:33+00:00 @jkup @chantastic Nothing but $NETLIFY       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 38] 1461028626393141254 255634108 jkup       0 0 5 0 0   en  
1461047808308383747 swyx 33521530 2021-11-17T19:05:17+00:00 @gerardketuma @Netlify yep. was tempted to take some money off the table but decided to let it ride haha       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 104] 1461046660885356547 177109652 gerardketuma       0 0 3 0 0   en  
1461057350299631618 swyx 33521530 2021-11-17T19:43:12+00:00 @AdamTuttle @Netlify yikes.. thanks for heads up, reverted to old build. i was trying to debug the super flaky @ThePracticalDev api https://twitter.com/swyx/status/1461057350299631618/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 131] 1461055881873956866 9686352 AdamTuttle       0 0 1 0 0 0 en  
1461058299852320769 swyx 33521530 2021-11-17T19:46:58+00:00 @Swizec infinite games, not long term games https://twitter.com/swyx/status/1281424520100737025?s=20   1281424520100737025 1281424520100737025   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 67] 1461057956171059202 15353121 Swizec       1 0 1 0 0 0 en  
1461074784591101955 swyx 33521530 2021-11-17T20:52:28+00:00 @iansu @Netlify write about it every now and then! its a special stage not many get to experience       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 97] 1461050661877915651 15755614 iansu       0 0 2 0 0   en  
1461076647822512128 swyx 33521530 2021-11-17T20:59:52+00:00 @trybeehiiv very cool! i took a quick glance on your landing page and didnt see it so gotta ask - do you support custom domains? because i dont wanna tie my subscribers/internet traffic to your domain thanks to @jsjoeio for pointing me to you       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 243] 1460971897592582154 1352439395903791106 beehiiv       0 0 3 0 0   en  
1461107635512659970 swyx 33521530 2021-11-17T23:03:01+00:00 @coderinheels @antony @onlyspaceghost @spences10 @Mappletons @isnit0 @sveltejs @SvelteSociety @SvelteSirens what an amazing crew!!! hope you had a great time!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [108, 159] 1461072524771528712 32330308 coderinheels       0 0 3 0 0   en  
1461113510927077380 swyx 33521530 2021-11-17T23:26:21+00:00 @_jayphelps @Netlify https://twitter.com/swyx/status/1461113510927077380/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 20] 1271518329526779904 29961025 _jayphelps       0 0 3 0 0 0 und  
1461114281416482822 swyx 33521530 2021-11-17T23:29:25+00:00 @technoheads yes indeed. unfortunately i believe @hillelogram has consistently pointed out that other empirical research on whether or not type systems actually help has been more equivocal. ultimately we spread the research that supports the POV we want to tell anyway.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 270] 1461113837332176897 19136507 technoheads       0 0 1 0 0   en  
1461115548406714369 swyx 33521530 2021-11-17T23:34:27+00:00 ugly cry everytim https://twitter.com/swyx/status/1271221917517668352?s=20 https://twitter.com/swyx/status/1461115548406714369/video/1   1271221917517668352 1271221917517668352   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 42] 1461046537224527877 33521530 swyx       1 0 5 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]);