tweets

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

16 rows where "created_at" is on date 2021-12-06 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, is_quote_status, retweet_count, created_at (date)

user 3 ✖

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
1467666370988965888 swyx 33521530 2021-12-06T01:25:05+00:00 RT @mojombo: When I was interviewed on Live TV by Fox News after the big GitHub Series A, they got the investor wrong, spelled "repository"… 1458878468150620181 1458878468150620181     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 1 1   en  
1467772165466431492 swyx 33521530 2021-12-06T08:25:28+00:00 Was going thru my old 2010-2014 laptop and realized there was no way to play anything at >1x speed back then. A decade later and I chafe at my 1.5x Netflix, blast through podcasts at 2x, and VCs discuss how to find 10x developers. We’ve been frogs, and the water’s come to boil.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 283]             0 0 20 0 0   en  
1467772242029277184 swyx 33521530 2021-12-06T08:25:47+00:00 @kilianvalkhof @argyleink thanks vm Kilian!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 44] 1467435250687033347 9335882 kilianvalkhof       0 0 1 0 0   en  
1467802166588952578 swyx 33521530 2021-12-06T10:24:41+00:00 @d_kozickis oh i slow down a lot on the weekends :) thank you for the kind caring.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 82] 1467774581972901891 18565797 d_kozickis       0 0 0 0 0   en  
1467804281306636289 swyx 33521530 2021-12-06T10:33:05+00:00 Periodic reminder to go through your *Google* app permissions and revoke old apps. https://myaccount.google.com/security?pli=1 "Third-party apps with account access" Just realized I have >2 year old apps in there that I don't use but have full access to my Gmail/Calendar 😱 https://twitter.com/swyx/status/1353067401093410824 https://twitter.com/swyx/status/1467804281306636289/photo/1   1353067401093410824 1353067401093410824   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 282]             1 7 38 0 0 0 en  
1467892371480186886 joel ⛈ 12087242 2021-12-06T16:23:08+00:00 these 20 awesome courses are free for the month https://egghead.io/20-days       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 71]             0 66 193 1 1 0 en  
1467926004798672898 swyx 33521530 2021-12-06T18:36:46+00:00 @thomasfindlay94 @temporalio looking forward to see what you think!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 67] 1467918243075706880 798982780273229828 thomasfindlay94       0 0 1 0 0   en  
1467926599790067719 swyx 33521530 2021-12-06T18:39:08+00:00 @spikebrehm @temporalio hey! yeah this is the tricky part with supporting build tooling, everyone has their own situation going on... we've had 2 people request pnpm so far and this is the tracking issue we just opened https://github.com/temporalio/sdk-typescript/issues/421       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 243] 1467890150810259461 17802123 spikebrehm       0 0 1 0 0 0 en  
1467928980590186498 swyx 33521530 2021-12-06T18:48:36+00:00 @threepointone rewrite react with rust       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 38] 1467899179540353033 1593171 threepointone       0 0 53 0 0   en  
1467929389857841156 swyx 33521530 2021-12-06T18:50:14+00:00 @andrewingram 👀 one of my wishlist holiday projects!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 52] 1467929110605225988 9164512 andrewingram       0 0 1 0 0   en  
1467930807868088321 swyx 33521530 2021-12-06T18:55:52+00:00 @_egoistlily @threepointone based       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [28, 33] 1467929187092942848 2813249270 _egoistlily       0 0 7 0 0   en  
1467947006911864832 Jason Laster 312750384 2021-12-06T20:00:14+00:00 http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looking to add a print statement in a file, the Outline View is your friend! 1/3 https://twitter.com/jasonlaster11/status/1467947006911864832/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 196]             0 5 73 1 1 0 en  
1467958083007565826 swyx 33521530 2021-12-06T20:44:14+00:00 RT @jasonlaster11: http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looki… 1467947006911864832 1467947006911864832     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 5 0 1 1 0 en  
1467978846150430724 swyx 33521530 2021-12-06T22:06:45+00:00 My @MongoDB podcast episode is live! https://mongodb.libsyn.com/ep-93-swyx-learn-in-public-and-temporal Ever since I heard the epic @mlynn and @marklovestech episode I've been really enjoying the podcast so it was an honor to join and talk about #LearnInPublic, @Coding_Career, and @temporalio!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 254]             0 7 17 0 0 0 en  
1467984394220552192 swyx 33521530 2021-12-06T22:28:48+00:00 @danluu i suspect its more the "Familiarity breeds contempt" effect       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 67] 1467982643237044225 18275645 danluu       0 0 2 0 0   en  
1467989240138985475 swyx 33521530 2021-12-06T22:48:03+00:00 @spitleaf i am only hearing meta commentary about the benchmark drama, havent actually even seen the benchmarks themselves lol       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 126] 1467988554106167297 357427736 spitleaf       0 0 1 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]);