home / twitter

tweets

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

50 rows where is_quote_status = 0, retweet_count = 1 and retweeted = 1 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, favorite_count, favorited

user 26 ✖

  • swyx 25
  • Rick Blalock 1
  • Flaherty.eth 1
  • Alex Ilchenko 1
  • Sebastien Lorber 🇫🇷 🦖 ⚛️ 📨 1
  • Rahul Goma Phulore 1
  • Brian Vaughn 🏳️‍🌈🖤 1
  • Jakub Neander (Zaiste) 1
  • Lucas Bernalte 1
  • Randall 1
  • Andrew Hansen 1
  • CascadiaJS 🇺🇸 🇨🇦 1
  • Rahul Sawant 1
  • Joe Previte 1
  • 🦊 Eric B. | httpjunkie.eth 1
  • Rahul Padalkar 1
  • The New Stack 1
  • 4 9 s 1
  • Mark Erikson 1
  • Kurt 🍩 1
  • Geoff Rich 1
  • React Advanced Conference 1
  • Nebojsa (Cookie Duster) 1
  • Coding Career Community 1
  • Common Room 1
  • Turborepo 1

created_at (date) 23 ✖

  • 2021-08-01 4
  • 2021-10-21 4
  • 2021-11-04 4
  • 2021-11-29 4
  • 2021-08-13 2
  • 2021-08-23 2
  • 2021-08-24 2
  • 2021-09-22 2
  • 2021-09-23 2
  • 2021-10-01 2
  • 2021-10-05 2
  • 2021-10-20 2
  • 2021-11-06 2
  • 2021-11-08 2
  • 2021-11-09 2
  • 2021-11-12 2
  • 2021-11-15 2
  • 2021-12-08 2
  • 2021-12-11 2
  • 2021-11-19 1
  • 2021-11-20 1
  • 2021-12-01 1
  • 2021-12-04 1

retweeted 1 ✖

  • 1 · 50 ✖

retweet_count 1 ✖

  • 1 · 50 ✖

is_quote_status 1 ✖

  • - · 50 ✖
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  
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  
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  
1451086357732855810 Kurt 🍩 878874259707367424 2021-10-21T07:22:02+00:00 Trust @swyx to have incredible "birds eye view" insights of the industry. I'm a little late, but this is really great talk: https://www.youtube.com/watch?v=Dz4q_bNDqfo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 148]             0 1 10 1 1 0 en  
1451089293565325315 swyx 33521530 2021-10-21T07:33:42+00:00 RT @IrevDev: Trust @swyx to have incredible "birds eye view" insights of the industry. I'm a little late, but this is really great talk: h… 1451086357732855810 1451086357732855810     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 1 1   en  
1451276860172738563 The New Stack 2327560616 2021-10-21T19:59:01+00:00 What It Takes to Become a Senior Engineer https://bit.ly/3pplucR @bcamerongain @darrylktaft @Swizec @swyx #SeniorEngineer       Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 0 [0, 123]             0 1 8 1 1 0 en  
1451289107863269394 swyx 33521530 2021-10-21T20:47:41+00:00 RT @thenewstack: What It Takes to Become a Senior Engineer https://bit.ly/3pplucR @bcamerongain @darrylktaft @Swizec @swyx #SeniorEngineer 1451276860172738563 1451276860172738563     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 1 1 0 en  
1456078047501852680 Flaherty.eth 15412900 2021-11-04T01:57:13+00:00 Love the craft displayed on this page. Who cares about scroll bar aesthetics in 2021? @swyx does and it is glorious. https://twitter.com/josephflaherty/status/1456078047501852680/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 116]             0 1 10 1 1 0 en  
1456089620051939330 swyx 33521530 2021-11-04T02:43:12+00:00 RT @josephflaherty: Love the craft displayed on this page. Who cares about scroll bar aesthetics in 2021? @swyx does and it is glorious. ht… 1456078047501852680 1456078047501852680     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 1 1   en  
1456368848634986508 Coding Career Community 1249002899897647105 2021-11-04T21:12:46+00:00 Poll: Is it a good idea to look at open source contributions when hiring? No "it depends" - there's always pros and cons - give your 80% response       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 146]             0 1 6 1 1   en  
1456388798019878931 swyx 33521530 2021-11-04T22:32:02+00:00 RT @Coding_Career: Poll: Is it a good idea to look at open source contributions when hiring? No "it depends" - there's always pros and con… 1456368848634986508 1456368848634986508     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 1 1   en  
1457020940345229314 🦊 Eric B. | httpjunkie.eth 1594100137 2021-11-06T16:23:56+00:00 Another great podcast with @swyx on @GatsbyJS with Abhi Ayer and Ward Peeters! Love the long form format! https://youtu.be/R6_ZB4tpE4g       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 130]             0 1 8 1 1 0 en  
1457028453333491715 swyx 33521530 2021-11-06T16:53:48+00:00 RT @httpJunkie: Another great podcast with @swyx on @GatsbyJS with Abhi Ayer and Ward Peeters! Love the long form format! https://t.co/De4… 1457020940345229314 1457020940345229314     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 1 1   en  
1457535874837749765 Mark Erikson 727704217012604928 2021-11-08T02:30:06+00:00 The "workflow support" comes from adding a new `condition` option that's `(predicate) => Promise<boolean>`. It's based off of http://Temporal.io's https://docs.temporal.io/docs/typescript/workflows/#condition API. You can now wait for actions, state diffs, etc. Thanks to @swyx for suggesting this!       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 276] 1457535446674718725 727704217012604928 acemarke       0 1 7 1 1 0 en  
1457543086255403018 swyx 33521530 2021-11-08T02:58:46+00:00 RT @acemarke: The "workflow support" comes from adding a new `condition` option that's `(predicate) => Promise<boolean>`. It's based off of… 1457535874837749765 1457535874837749765     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 149]             0 1 0 1 1   en  
1458068399318253582 Sebastien Lorber 🇫🇷 🦖 ⚛️ 📨 40663578 2021-11-09T13:46:10+00:00 🧵 🎙️🎥 Podcast with @swyx & @leeerob Lots of interesting subjects! Couldn't listen to it this week 😅 But definitely will, I'll comment next week! https://www.youtube.com/watch?v=mlsTlFW7BSo https://twitter.com/sebastienlorber/status/1458068399318253582/photo/1       FeedHive.io 6746f3a6d1b3aa371a4a2dc1c08c7862cd6e911e 0 [0, 178] 1458068394197098505 40663578 sebastienlorber       0 1 16 1 1 0 en  
1458126539308998665 swyx 33521530 2021-11-09T17:37:12+00:00 RT @sebastienlorber: 🧵 🎙️🎥 Podcast with @swyx & @leeerob Lots of interesting subjects! Couldn't listen to it this week 😅 But definitel… 1458068399318253582 1458068399318253582     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 144]             0 1 0 1 1   en  
1459274455583281160 Jakub Neander (Zaiste) 112849341 2021-11-12T21:38:36+00:00 Tomorrow (Nov 13) at 11am PT / 8pm CET together with @swyx we will be discussing React Server Components in Next.js 12 (a feature currently in alpha) along with a coding session ➝ re-doing the official notes demo from the React.js team See you! https://www.youtube.com/watch?v=qIPWzRvPSxk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 270]             0 1 11 1 1 0 en  
1459285436816261121 swyx 33521530 2021-11-12T22:22:15+00:00 RT @zaiste: Tomorrow (Nov 13) at 11am PT / 8pm CET together with @swyx we will be discussing React Server Components in Next.js 12 (a featu… 1459274455583281160 1459274455583281160     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 1 1   en  
1460045488904970240 Rahul Goma Phulore 56127471 2021-11-15T00:42:25+00:00 Growing a Meta-Language: https://www.youtube.com/watch?v=Dz4q_bNDqfo. Very interesting talk by @swyx.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 81]             0 1 6 1 1 0 en  
1460189455273234432 swyx 33521530 2021-11-15T10:14:29+00:00 RT @missingfaktor: Growing a Meta-Language: https://www.youtube.com/watch?v=Dz4q_bNDqfo. Very interesting talk by @swyx. 1460045488904970240 1460045488904970240     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 100]             0 1 0 1 1 0 en  
1461843236671131653 Brian Vaughn 🏳️‍🌈🖤 99973385 2021-11-19T23:46:02+00:00 Looking forward to going to the @sveltejs Summit tomorrow in NYC. Will I see any of you there? 🙂       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 96]             0 1 56 1 1   en  
1461935761218056192 swyx 33521530 2021-11-20T05:53:41+00:00 RT @brian_d_vaughn: Looking forward to going to the @sveltejs Summit tomorrow in NYC. Will I see any of you there? 🙂 1461843236671131653 1461843236671131653     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 116]             0 1 0 1 1   en  
1465117279339696136 Geoff Rich 886958568427077632 2021-11-29T00:35:54+00:00 .@swyx's tips on precording talks were also very helpful! As was the speaker prep session he hosted for Svelte Summit speakers that went over these in more detail. (6/) https://www.swyx.io/prerecording-talks/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 192] 1465117277032910854 886958568427077632 geoffrich_       0 1 12 1 1 0 en  
1465145505055313924 swyx 33521530 2021-11-29T02:28:04+00:00 RT @geoffrich_: .@swyx's tips on precording talks were also very helpful! As was the speaker prep session he hosted for Svelte Summit speak… 1465117279339696136 1465117279339696136     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 1 1   en  
1465442383294652420 Common Room 1331053779341348864 2021-11-29T22:07:45+00:00 It's time! Welcome to the 13 Days of Community, a two-week adventure celebrating our favorite content covering growth, engagement, and all the good bits in between. Up first? DevRel expert @swyx, of course, talking "Why You Should Get Good at Events" 🔥 https://www.commonroom.io/uncommon/blog/community-heat/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1465069236188024847 1331053779341348864 CommonRoomHQ       0 1 2 1 1 0 en  
1465444016179146752 swyx 33521530 2021-11-29T22:14:14+00:00 RT @CommonRoomHQ: It's time! Welcome to the 13 Days of Community, a two-week adventure celebrating our favorite content covering growth, en… 1465442383294652420 1465442383294652420     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 1 1   en  
1466091140868886536 Turborepo 1346129485024911360 2021-12-01T17:05:41+00:00 We think these kinds of packages are only getting more and more popular as we continue toward the next generation of JS build tools. So that's why we want them to be first class citizens. https://www.swyx.io/js-third-age/ https://leerob.io/blog/rust       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 236] 1466091140013346817 1346129485024911360 turborepo       0 1 4 1 1 0 en  
1466984868319928325 swyx 33521530 2021-12-04T04:17:02+00:00 RT @turborepo: We think these kinds of packages are only getting more and more popular as we continue toward the next generation of JS buil… 1466091140868886536 1466091140868886536     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 1 0 1 1   en  
1468703734062624773 Rick Blalock 9083902 2021-12-08T22:07:12+00:00 Quote of the day goes to @swyx : "You can learn a lot on the internet for the low low price of your ego" 🔥 https://mongodb.libsyn.com/ep-93-swyx-learn-in-public-and-temporal       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 130]             0 1 17 1 1 0 en  
1468710357472452608 swyx 33521530 2021-12-08T22:33:31+00:00 RT @rblalock: Quote of the day goes to @swyx : "You can learn a lot on the internet for the low low price of your ego" 🔥 https://t.co/jZXKx… 1468703734062624773 1468703734062624773     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 1 1   en  
1469677279315959810 Rahul Padalkar 1939826354 2021-12-11T14:35:43+00:00 Was searching for videos that explain React Hooks. Came across @swyx 's "Getting Closure on React Hooks", from @jsconfasia 2019. Such an awesome talk. Highly recommended! Tried it myself and here's the repl link 👇 https://replit.com/@RahulPadalkar/AmpleSpitefulExtension#index.js Talk 👉 https://www.youtube.com/watch?v=KJP1E-Y-xyo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 272]             0 1 14 1 1 0 en  
1469727766308286473 swyx 33521530 2021-12-11T17:56:20+00:00 RT @rahulnpadalkar: Was searching for videos that explain React Hooks. Came across @swyx 's "Getting Closure on React Hooks", from @jsconfa… 1469677279315959810 1469677279315959810     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 1 0 1 1   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]);
Powered by Datasette · Queries took 827.468ms