tweets

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

16 rows where "created_at" is on date 2021-11-11, is_quote_status = 0 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_screen_name, retweet_count, favorite_count

user 2 ✖

retweeted 1 ✖

created_at (date) 1 ✖

  • 2021-11-11 · 16 ✖
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
1458607415075631105 swyx 33521530 2021-11-11T01:28:02+00:00 I challenge you to find any code that has higher value per character than video.playbackRate = 2       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 98]             0 9 174 0 0   en  
1458623605357432832 swyx 33521530 2021-11-11T02:32:22+00:00 @gitpod @temporalio Today I tried running the exact same docker compose with @GitHub's Codespaces. failed :( strange error I cannot figure out: https://github.com/github/feedback/discussions/7566 in case any codespaces experts are here i think it tries to run some magic `docker-compose.codespaces.yml` file that is not mine https://twitter.com/swyx/status/1458623605357432832/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 298] 1458129030029316100 33521530 swyx       0 1 4 0 0 0 en  
1458643184418914304 swyx 33521530 2021-11-11T03:50:10+00:00 @dabit3 @gitpod ayyy fellow gitpod convert       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 42] 1458463243547070469 17189394 dabit3       0 0 7 0 0   en  
1458644215131303938 swyx 33521530 2021-11-11T03:54:15+00:00 @spitleaf third age of js man. it’s happening       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 45] 1458468972785963008 357427736 spitleaf       0 0 1 0 0   en  
1458652387313258500 swyx 33521530 2021-11-11T04:26:44+00:00 @dabit3 @gitpod for me it was general laziness, i understood the concept from Codespaces and @mikenikles like a year ago, but didnt switch because i didnt see examples that looked like my usecase, plus Docker Desktop had to degenerate to absolutely unacceptable levels of perf for me to do it 😅       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 294] 1458651102715523073 17189394 dabit3       0 0 4 0 0   en  
1458659990219018245 swyx 33521530 2021-11-11T04:56:56+00:00 @acemarke any way you can record this in video form? show the use cases you want and the stuff you tried so far. kinda hard to follow from just this description. last resort is to change the api. generally subscribe to the idea that if its too hard to type you’re prob being too fancy       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 285] 1458632138278899715 727704217012604928 acemarke       0 0 0 0 0   en  
1458682064908161027 swyx 33521530 2021-11-11T06:24:39+00:00 It's remarkably different writing docs for a company than writing for myself. If my blogpost is great, I hear about it from my dear readers. If my docs are great, I don't hear anything.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 187]             0 3 132 0 0   en  
1458683314823315456 swyx 33521530 2021-11-11T06:29:37+00:00 @roguesherlock inverse applies if bad :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 40] 1458682505528184833 921654041641304065 roguesherlock       0 0 1 0 0   en  
1458684981954244608 swyx 33521530 2021-11-11T06:36:15+00:00 Devtools pride is seeing users casually taking our API designs, docs, and error messages for granted having no idea how much *worse* they used to be       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 148] 1458682064908161027 33521530 swyx       0 2 42 0 0   en  
1458685937907499011 swyx 33521530 2021-11-11T06:40:03+00:00 @philnash what % of visitors actually click those things? i admit i click them like <1% of the time       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 102] 1458685670457679878 9152632 philnash       0 0 2 0 0   en  
1458700727027585024 swyx 33521530 2021-11-11T07:38:49+00:00 @loujaybee @mikenikles @gitpod ah sad, i bet i couldve shown you some fun stuff in my first hour where i bounced between product and docs put a popup for people to signup for usability testing, some pple like me wouldve loved to take you up on it if i knew       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [31, 257] 1458698942036815872 1290693397 loujaybee       0 0 1 0 0   en  
1458868645577183237 swyx 33521530 2021-11-11T18:46:04+00:00 @mjwhansen @DeployEmpathy nice       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 30] 1458866685746819083 21612095 mjwhansen       0 0 2 0 0   en  
1458876201884270596 swyx 33521530 2021-11-11T19:16:05+00:00 @levelsio my fave video on a topic https://www.youtube.com/watch?v=oAHbLRjF0vo that said.. i think the 2hrs includes cleaning and unloading luggage       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 128] 1458871024141815845 1577241403 levelsio       0 0 19 0 0 0 en  
1458876680257236998 swyx 33521530 2021-11-11T19:17:59+00:00 @levelsio Nomad Airlines when       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 29] 1458876305437446146 1577241403 levelsio       0 0 15 0 0   en  
1458878573532651527 Lee Robinson 81712767 2021-11-11T19:25:31+00:00 New post: Rust Is The Future of JavaScript Infrastructure 🦀 Why is Rust being used to replace parts of the JavaScript web ecosystem like minification, transpilation, formatting, bundling, linting, and more? https://leerob.io/blog/rust       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 232]             0 305 1523 0 0 0 en  
1458889246123565057 swyx 33521530 2021-11-11T20:07:55+00:00 @hunterwalk @calvinfo i call this my Lindy Library! top of the list is @patio11's classic on Negotiations https://www.kalzumeus.com/2012/01/23/salary-negotiation/ celebrating its 10th year in a couple months https://codingcareer.circle.so/c/lindy-library       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 199] 1458849867233566727 46063 hunterwalk       0 0 4 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]);