tweets
30 rows where "created_at" is on date 2021-11-25 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, favorited, retweeted
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1463665318732046337 | swyx 33521530 | 2021-11-25T00:26:20+00:00 | @preetster @dalmaer smol is beautiful | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 37] | 1463634168047226880 | 16343912 | preetster | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1463665495928815621 | swyx 33521530 | 2021-11-25T00:27:02+00:00 | @BenAPatton @remix_run sorry to miss you! next time... i dont have ambitions to be a livestreamer so this stuff is always gonna be ad hoc for me haha | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 149] | 1463638406995525645 | 999866712739676160 | BenAPatton | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463665543009865732 | swyx 33521530 | 2021-11-25T00:27:13+00:00 | @robertbalazsi @remix_run no worries, it was pretty fun! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [26, 56] | 1463638065713451019 | 1015811186 | robertbalazsi | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463666344147120132 | Eugene Yan 35109534 | 2021-11-25T00:30:24+00:00 | I'm excited to share something I've been working on for a while—http://ApplyingML.com! It collects the tacit, tribal, ghost knowledge on how to apply machine learning from papers, guides, and interviews with ML practitioners. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 229] | 0 | 288 | 1626 | 1 | 1 | 0 | en | ||||||||||
| 1463681245888405507 | swyx 33521530 | 2021-11-25T01:29:37+00:00 | @supabase supa based | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 20] | 1463408579931557888 | 1219566488325017602 | supabase | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1463691217078607875 | swyx 33521530 | 2021-11-25T02:09:14+00:00 | @johnlindquist @typescript this also works in javascript! https://twitter.com/swyx/status/1172604337366941697 | 1172604337366941697 1172604337366941697 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 57] | 1463576962891276298 | 15430177 | johnlindquist | 1 | 2 | 32 | 0 | 0 | 0 | en | ||||||
| 1463692023278358534 | swyx 33521530 | 2021-11-25T02:12:27+00:00 | RT @swyx: TIL you can use object destructuring on an *array* to get at its properties... and immediately use them in an index with `[ ]` no… | 1172604337366941697 1172604337366941697 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 336 | 0 | 0 | 1 | en | ||||||||||
| 1463695718057578498 | swyx 33521530 | 2021-11-25T02:27:07+00:00 | @levelsio yes and here is the Singapore tax code! https://twitter.com/swyx/status/1381324888216981504 | 1381324888216981504 1381324888216981504 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 49] | 1463404709100736513 | 1577241403 | levelsio | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
| 1463699475306729474 | swyx 33521530 | 2021-11-25T02:42:03+00:00 | @Saeris @argyleink i prefer lindy tweet | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [19, 39] | 1463699229805727752 | 14865775 | Saeris | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1463704111602233351 | swyx 33521530 | 2021-11-25T03:00:29+00:00 | @acemarke i hope you use textexpander or something for the amount of canned answers you do | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 90] | 1463684133218050051 | 727704217012604928 | acemarke | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1463705610503921666 | swyx 33521530 | 2021-11-25T03:06:26+00:00 | @ashleymayer @jarridvtingle this is also why we can’t have equality of opportunity without equality of outcome, despite it being a nice tagline. the opportunity *is* the outcome for all high stakes games. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 205] | 1463610376730202114 | 18994034 | ashleymayer | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1463717308505808898 | swyx 33521530 | 2021-11-25T03:52:55+00:00 | @NHeinDev @developer_dao what kind of projects? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 47] | 1463690278468997121 | 1333059155154907138 | NHeinDev | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1463718231454011393 | swyx 33521530 | 2021-11-25T03:56:35+00:00 | @jkup @AdamRackis finding so many people to mute, this is bliss | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 63] | 1463676727431946241 | 255634108 | jkup | 0 | 0 | 14 | 0 | 0 | en | ||||||||
| 1463723354813186057 | swyx 33521530 | 2021-11-25T04:16:57+00:00 | @dhaiwat10 @NHeinDev @developer_dao appreciated :) will keep a look out for that newsletter. feeling old and out if touch | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [36, 121] | 1463718674162880513 | 1025757442594889734 | dhaiwat10 | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1463727631669469184 | swyx 33521530 | 2021-11-25T04:33:56+00:00 | @andy_matuschak @danluu are substack’s leaderboards not a form of social proof and therefore distribution? curious about how you easily dismiss it | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 146] | 1456409147583336456 | 10724012 | andy_matuschak | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1463730306666557446 | swyx 33521530 | 2021-11-25T04:44:34+00:00 | @spitleaf my perennial question is is it uniquely cringe or is every big language like this when you are close enough to it | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 123] | 1463608205213380610 | 357427736 | spitleaf | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1463764094788378626 | swyx 33521530 | 2021-11-25T06:58:50+00:00 | @brianleroux senator i cant define it but i know it when i see it | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 65] | 1463575554674741251 | 676363 | brianleroux | 0 | 0 | 17 | 0 | 0 | en | ||||||||
| 1463906446052003843 | Estee Tey 🌻🐧 1257543813012189185 | 2021-11-25T16:24:29+00:00 | New article is out!🌻 Learn in a fun visual & hands-on way about: 🔸The parts that make up the scrollbar 🔸CSS Pseudo-elements for styling a scrollbar #UI #FrontEndDevelopment #CSS https://esteetey.dev/make-your-website-stand-out-with-a-custom-scrollbar | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 212] | 0 | 9 | 41 | 1 | 1 | 0 | en | ||||||||||
| 1463928523429605384 | swyx 33521530 | 2021-11-25T17:52:13+00:00 | @andy_matuschak @danluu there’s a second hand effect going on - i dont look at the leaderboard myself, but every author that makes it on the leaderboard makes sure that everyone who follows them knows that they are on the leaderboard :) kinda like how i dont look at NYT Bestseller lists | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 288] | 1463927215289110529 | 10724012 | andy_matuschak | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463940387223982080 | swyx 33521530 | 2021-11-25T18:39:21+00:00 | RT @altalogy: Black Friday deals? We prefer giveaways🥰 How about a $5,000 worth design sprint to tweak your landing page or product? To e… | 1463612122026450946 1463612122026450946 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 6 | 0 | 1 | 1 | en | ||||||||||
| 1463949874638905345 | swyx 33521530 | 2021-11-25T19:17:03+00:00 | @iansu girl knows what she wants | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 32] | 1463948635209560069 | 15755614 | iansu | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463958849069608989 | swyx 33521530 | 2021-11-25T19:52:43+00:00 | @samjulien my real question is if you should immediately move on or if you should take some time to write your thoughts. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 120] | 1463936510802087950 | 14228668 | samjulien | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1463960690759135242 | swyx 33521530 | 2021-11-25T20:00:02+00:00 | @chrisdhanaraj @supabase something ive been saying for our docs at Temporal is “every click has a cost. assume you lose 50% of readers every time you make them navigate to a different page” | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 189] | 1463706983366684676 | 25361025 | chrisdhanaraj | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1463966459244146696 | swyx 33521530 | 2021-11-25T20:22:57+00:00 | TIL I couldve used `git grep` instead and it would have probably worked 🤦♂️ https://will-keleher.com/posts/5-Useful-Bash-Patterns.html https://twitter.com/swyx/status/1463966459244146696/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 100] | 1455012914620813321 | 33521530 | swyx | 0 | 0 | 17 | 0 | 0 | 0 | en | |||||||
| 1463987461978144769 | swyx 33521530 | 2021-11-25T21:46:25+00:00 | Just saved $1000 over 2 years. I'm trading in my old iPhone for new hotness and finally did the math. Carrier trade-ins always seemed appealing (on both environmental and cost angles) until I really looked into it. TL;DR: switch to MVNO's like @Mintmobile, trade in with Apple! https://twitter.com/swyx/status/1463987461978144769/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 11 | 0 | 0 | 0 | en | ||||||||||
| 1464006310177873922 | swyx 33521530 | 2021-11-25T23:01:18+00:00 | @kentcdodds so realistic! how did you do the water rendering! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 61] | 1463995119216914439 | 389681470 | kentcdodds | 0 | 0 | 100 | 0 | 0 | en | ||||||||
| 1464009618460274739 | swyx 33521530 | 2021-11-25T23:14:27+00:00 | Sure, this is a reason to be thankful, but also just reminded me that if there is another huge solar flare from the Sun I am about 8.3 minutes from certain doom... https://dynomight.net/thanks/ how do we prep against solar flares? - water? - canned food? - backup generators? - books? https://twitter.com/swyx/status/1464009618460274739/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 21 | 0 | 0 | 0 | en | ||||||||||
| 1464010411401834504 | swyx 33521530 | 2021-11-25T23:17:36+00:00 | RT @eugeneyan: I'm excited to share something I've been working on for a while—http://ApplyingML.com! It collects the tacit, tribal, gh… | 1463666344147120132 1463666344147120132 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 288 | 0 | 1 | 1 | 0 | en | |||||||||
| 1464013496639655937 | swyx 33521530 | 2021-11-25T23:29:52+00:00 | Open source knowledge is an enormously powerful form of #LearnInPublic. Eugene started a list last year and it snowballed into 17k stars -> *only then* is he turning it into a site + newsletter! Genius. And entirely replicable on whatever you learn. https://twitter.com/eugeneyan/status/1463666344147120132?s=20 | 1463666344147120132 1463666344147120132 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1375853465923022856 | 33521530 | swyx | 1 | 1 | 5 | 0 | 0 | 0 | en | ||||||
| 1464016737167241248 | swyx 33521530 | 2021-11-25T23:42:44+00:00 | @sgrove i stayed away from those because assuming those will also be fried | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 74] | 1464015408915103744 | 14435843 | sgrove | 0 | 0 | 0 | 0 | 0 | en |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);