tweets

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

16 rows where "created_at" is on date 2021-11-11 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_screen_name, retweet_count, favorite_count, favorited

source 1 ✖

  • Twitter Web App · 16 ✖

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
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  
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  
1458693704764383241 swyx 33521530 2021-11-11T07:10:55+00:00 somehow missed that @Netilfy hired an official Technical Community Builder! 🚀 https://twitter.com/domitriusclark/status/1447988170293923841?s=20   1447988170293923841 1447988170293923841   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 102] 1397912340893294598 33521530 swyx       1 2 11 0 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  
1458822051263823875 Rich Harris 19487837 2021-11-11T15:40:55+00:00 today is a big day for @sveltejs: i've joined @vercel to work on it full time! so happy about what this means for svelte's future. it'll be the same independent, pluralistic project as before, but with Vercel's backing we can get ✨ a m b i t i o u s ✨ https://vercel.com/blog/vercel-welcomes-rich-harris-creator-of-svelte       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 1088 9259 1 1 0 en  
1458868196329492480 swyx 33521530 2021-11-11T18:44:17+00:00 Super excited for Rich, Svelte, and my friends at Vercel! Sign up for Svelte Summit 🏔️ (in 9 days! 😱 https://sveltesummit.com/) where you can catch up on the latest! 🗽 NYC party (with Rich, team Vercel, and myself): https://lu.ma/sveltenyc 🇩🇪 Mainz: https://lu.ma/sveltesummit-2021-mainz 🧡 https://twitter.com/Rich_Harris/status/1458822051263823875   1458822051263823875 1458822051263823875   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 3 62 0 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  
1458876998491664405 swyx 33521530 2021-11-11T19:19:15+00:00 RT @swyx: API Economy in five words: Turn non-core features into products. 1326509989347921925 1326509989347921925     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 75]             0 8 0 0 1   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  
1458910483176517632 swyx 33521530 2021-11-11T21:32:19+00:00 The emerging consensus is that Rust has won out over Go as the preferred language for "Systems Core, Scripting Shell". Key reason: JS interop, Performance, WASM potential, Community https://twitter.com/leeerob/status/1458878573532651527?s=20 https://twitter.com/swyx/status/1458910483176517632/photo/1   1458878573532651527 1458878573532651527   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 207] 1441486732516544513 33521530 swyx       1 10 56 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]);