tweets

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

28 rows where favorited = 0, retweet_count = 1 and retweeted = 1 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: favorite_count

favorited 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
1421686377670856704 4 9 s 2351378232 2021-08-01T04:17:00+00:00 “It is always going to be a truth that the more you know, the more you also learn about that stuff that you didn’t know that you didn’t know. So if you are doing it right at all you are going to feel like you are terrible at what you are doing…” — @swyx https://link.medium.com/KUqnxq1Ybib       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 1 15 0 1 0 en  
1421693412441395205 swyx 33521530 2021-08-01T04:44:57+00:00 RT @radenagus17_: “It is always going to be a truth that the more you know, the more you also learn about that stuff that you didn’t know t… 1421686377670856704 1421686377670856704     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 0 1   en  
1421968022814658561 Joe Previte 1567529924 2021-08-01T22:56:10+00:00 🎙️ jsjoeio's mixtape Alright, trying out this podcast/mixtape thing as a hobby and an excuse to meet cool people. First segment focus -> "How'd you solve it?" Interviews with indie hackers & devs about how they solved specific problems. https://twitter.com/jsjoeio/status/1421968022814658561/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 246]             0 1 21 0 1 0 en  
1421981745625276419 swyx 33521530 2021-08-01T23:50:41+00:00 RT @jsjoeio: 🎙️ jsjoeio's mixtape Alright, trying out this podcast/mixtape thing as a hobby and an excuse to meet cool people. First segm… 1421968022814658561 1421968022814658561     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 0 1   en  
1426069279674232836 Rahul Sawant 749556404 2021-08-13T06:33:06+00:00 I like @swyx Mixtape, especially Fridays..🎶 https://swyx.transistor.fm/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 67]             0 1 4 0 1 0 en  
1426075900441874438 swyx 33521530 2021-08-13T06:59:24+00:00 RT @Raalzz: I like @swyx Mixtape, especially Fridays..🎶 https://swyx.transistor.fm/ 1426069279674232836 1426069279674232836     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 79]             0 1 0 0 1 0 en  
1427370301495652354 Andy Hattemer 20355043 2021-08-16T20:42:53+00:00 Lots of great info in this post! @swyx categorizes devrel programs into "Community", "Content" and "Product". For me, here are the "exemplary" companies for each: - Community: @getdbt - Content: @digitalocean (I'm biased) - Product: @Netlify or @vercel https://twitter.com/swyx/status/1427351638872772633   1427351638872772633 1427351638872772633   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 254]             1 1 22 0 1 0 en  
1427393308997783602 swyx 33521530 2021-08-16T22:14:19+00:00 RT @andyhattemer: Lots of great info in this post! @swyx categorizes devrel programs into "Community", "Content" and "Product". For me, he… 1427370301495652354 1427370301495652354     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 1 0 0 1   en  
1429725966335713281 Nebojsa (Cookie Duster) 1055736485830451200 2021-08-23T08:43:28+00:00 Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hear about you at least 7 times before they decide to buy; for developer tools, Matt Biilmann from Netlify says it's more like 14.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 246]             0 1 9 0 1 0 en  
1429727373503524864 swyx 33521530 2021-08-23T08:49:03+00:00 RT @CookieDuster_N: Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hea… 1429725966335713281 1429725966335713281     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 0 1 0 en  
1430254888869502977 Andrew Hansen 360717290 2021-08-24T19:45:13+00:00 @Madisonkanna I like @swyx's take on the topic https://www.swyx.io/why-tailwind/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 70] 1430226205106573313 1087957969915006976 Madisonkanna       0 1 8 0 1 0 en  
1430258542523551746 swyx 33521530 2021-08-24T19:59:44+00:00 RT @arahansen: @Madisonkanna I like @swyx's take on the topic https://www.swyx.io/why-tailwind/ 1430254888869502977 1430254888869502977     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 85]             0 1 0 0 1 0 en  
1440741221236764674 Lucas Bernalte 174750936 2021-09-22T18:14:09+00:00 I just read about the Four Gears of Learning in Public by @swyx and it clicked. I have only been trying to use the Connector gear and skipped the “previous” two. The Coding Career Handbook is so good 👏       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 201]             0 1 10 0 1   en  
1440745728595271684 swyx 33521530 2021-09-22T18:32:04+00:00 RT @lucasbernalte: I just read about the Four Gears of Learning in Public by @swyx and it clicked. I have only been trying to use the Conne… 1440741221236764674 1440741221236764674     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 0 1   en  
1441069852127543299 React Advanced Conference 1031313930734460928 2021-09-23T16:00:01+00:00 He's the head of #developer experience, author of a bestselling book on progressing career in IT, and a sought-after mentor and speaker. This interview on @GitNationOrg is with @swyx who got some valuable advice on self #marketing for career development: https://portal.gitnation.org/contents/shawn-swyx-wangs-career-tips-knowing-how-to-market-yourself-authentically-is-not-scammy       Twitter for Advertisers fbceb240777efd04e705e7d9e72d864f60964124 0 [0, 280]             0 1 4 0 1 0 en  
1441070950208913413 swyx 33521530 2021-09-23T16:04:22+00:00 RT @ReactAdvanced: He's the head of #developer experience, author of a bestselling book on progressing career in IT, and a sought-after men… 1441069852127543299 1441069852127543299     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 0 1   en  
1443976506858823683 CascadiaJS 🇺🇸 🇨🇦 716869094 2021-10-01T16:30:01+00:00 Announcing the second of 3 lightning ⚡️ talks for the official #CascadiaJS pre-conference meetup on Oct 14! Temporal: React Suspense for the Backend by @swyx This event is FREE and we have *one more* surprise speaker to come 👀 https://2021.cascadiajs.com/pre-conf-meetup https://twitter.com/CascadiaJS/status/1443976506858823683/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 255]             0 1 5 0 1 0 en  
1443977557859180548 swyx 33521530 2021-10-01T16:34:12+00:00 RT @CascadiaJS: Announcing the second of 3 lightning ⚡️ talks for the official #CascadiaJS pre-conference meetup on Oct 14! Temporal: Reac… 1443976506858823683 1443976506858823683     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 0 1   en  
1445463239475621898 Randall 206918128 2021-10-05T18:57:46+00:00 Today at 2pm PT! And it’s actually my very first Twitter space. https://twitter.com/i/spaces/1rmGPgLvlgmKN https://twitter.com/RandallKanna/status/1445463239475621898/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 88]             0 1 13 0 1 0 en  
1445463346916986885 swyx 33521530 2021-10-05T18:58:11+00:00 RT @RandallKanna: Today at 2pm PT! And it’s actually my very first Twitter space. https://twitter.com/i/spaces/1rmGPgLvlgmKN https://twitter.com/RandallKanna/status/1445463239475621898/photo/1 1445463239475621898 1445463239475621898     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 130]             0 1 0 0 1 0 en  
1445564661965807617 Kristofer Baxter 14080437 2021-10-06T01:40:47+00:00 Some of the best writing in our industry comes from @swyx. This is yet another great read. https://twitter.com/swyx/status/1445044267508850695   1445044267508850695 1445044267508850695   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 90]             1 1 38 0 1 0 en  
1445565723502264331 swyx 33521530 2021-10-06T01:45:00+00:00 RT @kristoferbaxter: Some of the best writing in our industry comes from @swyx. This is yet another great read. 1445564661965807617 1445564661965807617     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 111]             1 1 0 0 1   en  
1449103297839763459 Chi is 🈺 47987794 2021-10-15T20:02:03+00:00 I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 20% of the work to get 80% results as is often opined. 100% of the work (and more) is required. Thanks for this article @swyx https://twitter.com/swyx/status/1387487111964626945   1387487111964626945 1387487111964626945   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 245]             1 1 5 0 1 0 en  
1449105641797128192 swyx 33521530 2021-10-15T20:11:22+00:00 RT @ChibuzorObilom: I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 2… 1449103297839763459 1449103297839763459     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   en  
1449112317917110276 sunil pai, inc. 1593171 2021-10-15T20:37:54+00:00 Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you literally do: while(true){ charge(); sleep(30 days); } That's awesome. https://twitter.com/swyx/status/1449069225704714246 https://twitter.com/threepointone/status/1449112317917110276/photo/1   1449069225704714246 1449069225704714246   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 212]             1 1 50 0 1 0 en  
1449117060265492481 swyx 33521530 2021-10-15T20:56:45+00:00 RT @threepointone: Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you liter… 1449112317917110276 1449112317917110276     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   en  
1450748944976424989 Alex Ilchenko 18936221 2021-10-20T09:01:16+00:00 Nice article about pros (a lot) and cons (some) of Tailwind by @swyx https://www.swyx.io/why-tailwind       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 92]             0 1 9 0 1 0 en  
1450756269229309959 swyx 33521530 2021-10-20T09:30:22+00:00 RT @wialy: Nice article about pros (a lot) and cons (some) of Tailwind by @swyx https://www.swyx.io/why-tailwind 1450748944976424989 1450748944976424989     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 103]             0 1 0 0 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]);