tweets

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

9 rows where in_reply_to_screen_name = "simonw" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, is_quote_status, retweet_count, favorite_count

user 1 ✖

in_reply_to_screen_name 1 ✖

  • simonw · 9 ✖
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
1424310472350654464 swyx 33521530 2021-08-08T10:04:13+00:00 @simonw tragedy of the critical bug commons: if everyone waits a few weeks before upgrades then the purpose of waiting a few weeks before upgrades is defeated! optimal - round robin upgrades to share bug discovery load?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 220] 1424078556406042625 12497 simonw       0 1 3 0 0   en  
1426670450613002241 swyx 33521530 2021-08-14T22:21:56+00:00 @simonw @rachelnabors the economist’s explanation is underrated: you can decompose an economy’s total output into a mix of capital and labor multiplied by technology as a dev your labor (code) can harness capital (computers) far more than anyone bar financiers, plus a % chance of improving technology       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 302] 1426632495957561345 12497 simonw       0 0 0 0 0   en  
1429159691452436482 swyx 33521530 2021-08-21T19:13:17+00:00 @simonw @datasetteproj very frustrating. sorry to hear. had this happen to @Coding_Career twice. both times basically had to know someone in Twitter to escalate it :(       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 166] 1428971520269844480 12497 simonw       0 0 0 0 0   en  
1431324138493284352 swyx 33521530 2021-08-27T18:34:01+00:00 @simonw @RamaswmySridhar is working on this! https://www.nytimes.com/2020/06/19/technology/google-neeva-executive.html       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 68] 1431319126425817088 12497 simonw       0 0 0 0 0 0 en  
1436603173133770752 swyx 33521530 2021-09-11T08:11:01+00:00 @simonw swap URLs to swap UIs/apps! i’ve enjoyed documenting some of these in the past, mostly userland: https://twitter.com/swyx/status/1360316059987808256?s=21   1360316059987808256 1360316059987808256   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 129] 1436597379101118466 12497 simonw       1 0 6 0 0 0 en  
1436716037202980868 swyx 33521530 2021-09-11T15:39:30+00:00 @simonw i genuinely think this one assumption made many remaining decisions for them: https://twitter.com/slightlylate/status/1436708762115473411?s=20 I hear unexamined assumptions like these a lot and people don't realize these are far weightier decisions than they seem at first glance. Rhyme shortcircuits reason.   1436708762115473411 1436708762115473411   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 276] 1436710644045152262 12497 simonw       1 0 4 0 0 0 en  
1437025662603341829 swyx 33521530 2021-09-12T12:09:51+00:00 @simonw @pradyunsg to me, that is @anacondainc - i know it has its drawbacks, but it’s so nice living in Anaconda’s world. I’m unclear about how the larger Python community feels about it (similar to how Apollo dominates GraphQL) but they’ve certainly done a better job than anyone else i know       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 293] 1436728586669477894 12497 simonw       0 0 2 0 0   en  
1437993424045711365 swyx 33521530 2021-09-15T04:15:23+00:00 @simonw yes your data collection stuff is incredible!! feel like im fine with it just being on my phone though, i just never go anywhere without the phone       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 154] 1437983950526246912 12497 simonw       0 0 2 0 0   en  
1474458850686160896 swyx 33521530 2021-12-24T19:15:58+00:00 @simonw trading volume != market value but yeah. 🦗       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 50] 1474222983417794562 12497 simonw       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]);