tweets

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

20 rows where retweet_count = 4, source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" and user = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, favorite_count, favorited, retweeted

user 1 ✖

  • swyx · 20 ✖

retweet_count 1 ✖

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
1421234755794657280 swyx 33521530 2021-07-30T22:22:25+00:00 RT @acdlite: @swyx @reactjs Any test that you don't run continuously is destined to break without anyone noticing 1421233345716002820 1421233345716002820     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 113]             0 4 0 0 1   en  
1424953927426928646 swyx 33521530 2021-08-10T04:41:05+00:00 @moretothat’s unification of the power and money divides into a single bell curve dimension is indirectly an incredible rebuttal of the Michael Scott Theory of Social Class - arguing FOR being peak Michael Scott! https://twitter.com/alex_danco/status/1352701338833072135?s=21 https://twitter.com/swyx/status/1424953927426928646/photo/1   1352701338833072135 1352701338833072135   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 237] 1424951893864816644 33521530 swyx       1 4 24 0 0 0 en  
1428114812249071618 swyx 33521530 2021-08-18T22:01:18+00:00 RT @sugarpirate_: I'm sorta back from a long twitter break! I've been spending my free time slowly getting through @thorstenball's excellen… 1428061205902630916 1428061205902630916     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 0 1   en  
1428890875757699074 swyx 33521530 2021-08-21T01:25:06+00:00 Passing along my fave two reads on how optionality is overrated: - https://www.thecrimson.com/article/2017/5/25/desai-commencement-ed/ - https://radreads.co/collecting-options-isnt-best-life-strategy/ by @khemaridh Clearly articulated how I screwed up my own life by continuously collecting paper and never betting on myself. https://twitter.com/noampomsky/status/1428771895936049158   1428771895936049158 1428771895936049158   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 244]             1 4 34 0 0 0 en  
1429120212687736837 swyx 33521530 2021-08-21T16:36:25+00:00 I get qtns from “lurkers” who ask about my Twitter/newsletter/podcast strategy and are surprised to hear I have no strategy. Just principles. 1. Write about stuff that fascinates you 2. Find others who share your interests 3. Keep going thats the infinite game of #LearnInPublic       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             0 4 52 0 0   en  
1434928945774972931 swyx 33521530 2021-09-06T17:18:15+00:00 RT @ryanatkn: as @sveltejs passes 50k GitHub stars, here's the https://is.gd/artmachine AI interpreting "sveltejs space elevator", a 🚀 metap… 1434918776462585856 1434918776462585856     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 4 0 0 1 0 en  
1436973708304863238 swyx 33521530 2021-09-12T08:43:24+00:00 Lifechanging travel tip I am only learning too late in life: You can travel in shorts! Nothing in the flight rules that say you have to be in tight jeans or nice shoes. And most airports require waaay too much walking. (yes, looking at you, @Airport_FRA!) https://twitter.com/swyx/status/1436973708304863238/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 256]             0 4 80 0 0 0 en  
1440216236680376327 swyx 33521530 2021-09-21T07:28:03+00:00 @noIPv6 give this user a serious answer award https://twitter.com/swyx/status/1440216236680376327/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 45] 1440131905014411265 1087814174019743745 noIPv6       0 4 7 0 0 0 en  
1440676648290951180 swyx 33521530 2021-09-22T13:57:34+00:00 RT @BenNadel: Good morning my beautiful, beautiful friends! Ep. 041 of @WorkingCodePod is out! This week, @AdamTuttle @k_Roll242 @timcunnin… 1440657316441776135 1440657316441776135     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 0 1   en  
1446318251542147072 swyx 33521530 2021-10-08T03:35:17+00:00 RT @Nutlope: I'm using a technique called "Following the Graph" (coined by @swyx) to better understand the Next.js ecosystem. This means e… 1446276421882581011 1446276421882581011     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 0 1   en  
1447312313426460672 swyx 33521530 2021-10-10T21:25:19+00:00 Obsessed by how turning sync into async processes improves UX. Imagine an API call w/ 5 requirements fails bc 2 inputs were invalid. Instead of keeping state on client or duplicating validation, the API call starts a session and you “talk” with it to resolve the invalid inputs. https://twitter.com/swyx/status/1445299225974095877   1445299225974095877 1445299225974095877   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 279]             1 4 82 0 0 0 en  
1448819207689310220 swyx 33521530 2021-10-15T01:13:11+00:00 Invest in your network. People you actually know and talk to, not blindly chasing raw follower count. Absolutely amazing the kind of news, opportunities, support (and dirt! 👀) that you get from building relationships and giving more than you get.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 248]             0 4 78 0 0   en  
1456024072052215814 swyx 33521530 2021-11-03T22:22:45+00:00 #NewProfilePic thanks to @samjulien at the @cascadiajs @auth0 booth! https://twitter.com/swyx/status/1456024072052215814/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 68]             0 4 29 0 0 0 en  
1456466989912707076 swyx 33521530 2021-11-05T03:42:44+00:00 RT @ejames_c: “In reality, a mentor is mostly just somebody that answers questions more than once. That’s it. It’s not cinematic.” https://… 1456447836803854336 1456447836803854336     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 1 1   en  
1456866520395509765 swyx 33521530 2021-11-06T06:10:20+00:00 Apparently the line is 10 years and 1.5 months old so it was impossible to believe in it earlier unless you literally made the language haha https://twitter.com/BrendanEich/status/1456758350419480580   1456758350419480580 1456758350419480580   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140] 1456706638010667012 33521530 swyx       1 4 42 0 0 0 en  
1462550956537790465 swyx 33521530 2021-11-21T22:38:15+00:00 RT @growthcurrency: Some interesting thoughts on... → More Than Just Money → #PartTimeCreator → Making Part Time Work → Making Part Time C… 1462481486733623302 1462481486733623302     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 1 1   en  
1462820793318973445 swyx 33521530 2021-11-22T16:30:29+00:00 RT @artlapinsch: Using Launch Cheat Sheet by @swyx as the basis for the rework. It's a fantastic resource. https://github.com/sw-yx/launch-cheatsheet 1462819374251741185 1462819374251741185     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 131]             0 4 0 1 1 0 en  
1465885934029737984 swyx 33521530 2021-12-01T03:30:16+00:00 Laver’s Law for technology: 10yrs before its time - Academic 5yrs - Cute, Daring 1yr - Nice for small projects Current - Modern, use everywhere 1yr after its time - Safe 5yrs - Terrible, Horrible, No Good, Very Bad 10yrs - Flawed but beautiful 50y - Wisdom of the ancients https://twitter.com/floydophone/status/1465757361155428356   1465757361155428356 1465757361155428356   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 4 34 0 0 0 en  
1469801943019110401 swyx 33521530 2021-12-11T22:51:05+00:00 RT @JoshWComeau: I had a bill recently go from $20/month to $660/month because I exceeded a magic threshold. My actual usage increased mayb… 1469313115598860293 1469313115598860293     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 4 0 1 1   en  
1470789190417719303 swyx 33521530 2021-12-14T16:14:03+00:00 The same consolidation play Microsoft made for developer tools, @Vercel is now making for developers       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 100] 1470788640846462979 33521530 swyx       0 4 87 1 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]);