tweets
45 rows where retweet_count = 2 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"
This data as json, CSV (advanced)
Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, favorited, retweeted, created_at (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1418435083237687311 | swyx 33521530 | 2021-07-23T04:57:31+00:00 | Listening to @yishan talk about Terraformation on @jjacobs2’s @mcjpod has me more techno-optimistic than I’ve been in a long time. This man is out here literally taking the VC exponential growth playbook to planting trees to solve climate change. https://my-climate-journey.simplecast.com/episodes/startup-series-terraformation | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 273] | 0 | 2 | 12 | 0 | 0 | 0 | en | ||||||||||
1420211877276049408 | swyx 33521530 | 2021-07-28T02:37:52+00:00 | @matiasfha @Rich_Harris @stolinski @gndx Svelte also has one way data flow under the hood, but uses binding and syntax sugar to simulate LOCAL two way data flow. its not that different. data propagation with stores vs context however are very different. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [41, 255] | 1420201456108441603 | 12816182 | matiasfha | 0 | 2 | 24 | 0 | 0 | en | ||||||||
1421136292423684100 | swyx 33521530 | 2021-07-30T15:51:10+00:00 | RT @iBakasura: This talk on Growing a Meta-Language by @swyx is just amazing! He goes in depth into talking about the how the trifecta of l… | 1421095739195756549 1421095739195756549 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 0 | 1 | en | ||||||||||
1421190477571710978 | swyx 33521530 | 2021-07-30T19:26:28+00:00 | this is incredible to watch. I thought that Flippa/Empire Flippers had cornered this sleepy market, but Andrew is shaking it up with his infectious energy and focus. Building a credible “Zestimate for SaaS” is going to set this thing on 🔥 https://twitter.com/agazdecki/status/1421069160973434880 | 1421069160973434880 1421069160973434880 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 239] | 1 | 2 | 31 | 0 | 0 | 0 | en | |||||||||
1427636302325981188 | swyx 33521530 | 2021-08-17T14:19:53+00:00 | RT @jim_ej: Brilliant talk brought to me by @swyx: https://swyx.transistor.fm/episodes/weekend-drop-what-we-know-we-dont-know-hillel-wayne. What we know about coding based on evidence. TDD is no better t… | 1427577933074505728 1427577933074505728 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 0 | 1 | 0 | en | |||||||||
1431046098223779844 | swyx 33521530 | 2021-08-27T00:09:12+00:00 | What amazes me about Streamyard is that it wasn’t… *great*. The onscreen graphics were limited and the streaming wasn’t high quality. But it was easier to use than OBS, and scaled fine thru the pandemic. I hope both founders made $100m, and I hope someone makes a competitor! https://twitter.com/nathanbarry/status/1430995711575793667 | 1430995711575793667 1430995711575793667 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 1 | 2 | 22 | 0 | 0 | 0 | en | |||||||||
1432375239464263682 | swyx 33521530 | 2021-08-30T16:10:43+00:00 | RT @pratheekhegde: Concurrent React from Scratch by @swyx (lesson on @eggheadio) https://egghead.io/lessons/react-concurrent-react-from-scratch Watch 1/20 Maybe. Will probably… | 1432341565028978694 1432341565028978694 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 2 | 0 | 0 | 1 | 0 | en | |||||||||
1432848411418529797 | swyx 33521530 | 2021-08-31T23:30:56+00:00 | @zkwentz counter point - v few agencies/service companies ever ACTUALLY successfully transition to product, there seems to be an insurmountable cultural shift needed. see Heptio: https://www.listennotes.com/podcasts/the-swyx-mixtape/the-origin-of-kubernetes-and-UI2E4z3BaVu/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 202] | 1432848155129704449 | 33521530 | swyx | 0 | 2 | 1 | 0 | 0 | 0 | en | |||||||
1433718525420470279 | swyx 33521530 | 2021-09-03T09:08:28+00:00 | If you work in Silicon Valley, or in the technology world, and you can explain complex topics / terms in an easy to understand* way, that’s an INSANELY valuable skill. *But don’t gloss over the details! All the good stuff is in the details - develop a keen eye for those! https://twitter.com/BullandBaird/status/1433424538025349120 | 1433424538025349120 1433424538025349120 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 272] | 1 | 2 | 30 | 0 | 0 | 0 | en | |||||||||
1434389932177559555 | swyx 33521530 | 2021-09-05T05:36:24+00:00 | Taken from this excellent compendium of Visual Programming - a very valuable format of blogpost! https://drossbucket.com/2021/06/30/hacker-news-folk-wisdom-on-visual-programming/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 121] | 1434388834087800832 | 33521530 | swyx | 0 | 2 | 14 | 0 | 0 | 0 | en | |||||||
1435327567796506624 | swyx 33521530 | 2021-09-07T19:42:13+00:00 | RT @brianleroux: I've been thinking about @swyx's 'self provisioning runtime' thought experiment a bunch. while I do think 'self provisioni… | 1435324306238619649 1435324306238619649 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 0 | 1 | en | ||||||||||
1436008517845008388 | swyx 33521530 | 2021-09-09T16:48:05+00:00 | RT @DevtoolsFM: How do you view software? @swyx approaches tools with a "Would I Invest in this thing" mindset! https://twitter.com/DevtoolsFM/status/1436002996660363267/video/1 | 1436002996660363267 1436002996660363267 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 135] | 0 | 2 | 0 | 0 | 1 | 0 | en | |||||||||
1440676595056840706 | swyx 33521530 | 2021-09-22T13:57:21+00:00 | RT @seancdavis29: I really this article from @swyx because it reframes the GraphQL vs REST debate. There's much more nuance to the conversa… | 1440666213382717453 1440666213382717453 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 0 | 1 | en | ||||||||||
1441569415917678592 | swyx 33521530 | 2021-09-25T01:05:06+00:00 | 🤘🏽 Today’s mixtape clip covers the 6 year formation story of Adam and the Metal Hawks! http://share.transistor.fm/s/56304829 Rock on your weekend everyone! https://twitter.com/AMHband/status/1398777575514771459/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 169] | 0 | 2 | 6 | 0 | 0 | 0 | en | ||||||||||
1441863319317516290 | swyx 33521530 | 2021-09-25T20:32:58+00:00 | Specific things you can do that turn experts into mentors and friends: - Explain X in your own words - “Yes, and” their demos - Summarize their talks - Help repro issues - Answer FAQs Pick Up What They Put Down and you’ll be expert soon enough. How do you think they started?! https://twitter.com/techgirl1908/status/1441794957543608324 | 1441794957543608324 1441794957543608324 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 279] | 1 | 2 | 35 | 0 | 0 | 0 | en | |||||||||
1443093060473090051 | swyx 33521530 | 2021-09-29T05:59:31+00:00 | It’s been incredible to watch @nutlope’s career grow ever since he joined webdev twitter in college! He’s been a daily positive presence in the @Coding_Career discord and I feel lucky to have met him before he was “famous” Great hire by @leeerob and @rauchg — only the beginning! https://twitter.com/Nutlope/status/1442926717635477504 | 1442926717635477504 1442926717635477504 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 2 | 30 | 0 | 0 | 0 | en | |||||||||
1444372437722824713 | swyx 33521530 | 2021-10-02T18:43:18+00:00 | Seeing two extremes: 1. “Our blog is for top of funnel” - @logrocket, @digitalocean 2. “Our blog is for hiring” - @cloudflare, @figma, @airbnb, @NetflixEng, @RazorpayEngg, @GitHubEng, @WixEng, @ShopifyEng, @ArtsyOpenSource “bit of both”: @flydotio, @thoughbot, @testdouble https://twitter.com/eastdakota/status/1444337534759149574 | 1444337534759149574 1444337534759149574 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 276] | 1444098448874086400 | 33521530 | swyx | 1 | 2 | 38 | 0 | 0 | 0 | en | ||||||
1446671799131934720 | swyx 33521530 | 2021-10-09T03:00:09+00:00 | Gifted program saved my life. I was a weirdo that struggled to fit in and would absolutely have blamed or harmed myself if they had not put me in with other weirdos and made it ok to be weird together. It didn’t privilege us so much as put us on a gentler path to socialization. https://twitter.com/primalpoly/status/1446485504468398085 | 1446485504468398085 1446485504468398085 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1 | 2 | 77 | 0 | 0 | 0 | en | |||||||||
1447785276395253765 | swyx 33521530 | 2021-10-12T04:44:43+00:00 | Twitter be like “You are unable to view this tweet because this person is either very private or hates your guts but we’re going to tease you anyway because curiosity = time on site” | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 183] | 0 | 2 | 121 | 0 | 0 | en | |||||||||||
1450355145917677569 | swyx 33521530 | 2021-10-19T06:56:27+00:00 | @AdamRackis xstate isn’t popular enough to be hated yet | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 55] | 1450299212319580163 | 68567860 | AdamRackis | 0 | 2 | 42 | 0 | 0 | en | ||||||||
1450702539347750917 | Nicole Sullivan 15629200 | 2021-10-20T05:56:52+00:00 | @sambreed @swyx @gregwhitworth We’re building selectmenu, anchor, & popup. And prototyping tabs, toggle, accordion, nav, & treeview. And researching stuff like dialog, carousel & image zoom. Button wasn’t on my radar, but it could be? Caveat: super early days, maybe none of this ships, but maybe it does? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [31, 318] | 1450696392029061125 | 14217249 | sambreed | 0 | 2 | 15 | 0 | 0 | en | ||||||||
1451412869065547777 | swyx 33521530 | 2021-10-22T04:59:28+00:00 | how many vacation days have you taken this year? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 48] | 0 | 2 | 22 | 1 | 0 | en | |||||||||||
1452046180683161609 | swyx 33521530 | 2021-10-23T22:56:01+00:00 | it worries me that there’s an uncritical acceptance of @Reactjs conclusions without examining if those assumptions apply to you. React is verbose React is successful Must be verbose to be successful Here’s my attempt to articulate more timeless lessons than “2 way binding bad”: https://twitter.com/swyx/status/1383516418205835264 | 1383516418205835264 1383516418205835264 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 2 | 49 | 0 | 0 | 0 | en | |||||||||
1452160034482253826 | swyx 33521530 | 2021-10-24T06:28:26+00:00 | RT @shrirambalaji: Such a wonderful video by @swyx on "How to Outlive React?". If you're into frontend and plan on being invested in it for… | 1452120199180603393 1452120199180603393 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1456035423231242240 | swyx 33521530 | 2021-11-03T23:07:51+00:00 | @JoshuaKGoldberg @CascadiaJS amazing talk!! and nice #LearnInPublic shoutout! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 77] | 1455708121104621574 | 2551208653 | JoshuaKGoldberg | 0 | 2 | 3 | 0 | 0 | en | ||||||||
1457543817964392458 | swyx 33521530 | 2021-11-08T03:01:40+00:00 | RT @acemarke: I spent the afternoon hacking on the experimental RTK "action listener middleware" API. After applying multiple suggestions,… | 1457535446674718725 1457535446674718725 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1458653534212132864 | swyx 33521530 | 2021-11-11T04:31:17+00:00 | RT @acemarke: In the spirit of "working in public", but also "I'm human" and "ARGH THIS IS BROKEN SOMEONE HELP ME": I've spent the last fe… | 1458630426709442562 1458630426709442562 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1461898243294515205 | swyx 33521530 | 2021-11-20T03:24:36+00:00 | Preemptive apologies for @SvelteSociety taking over Tech Twitter tomorrow, the excitement is off the charts 🧡 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 109] | 0 | 2 | 57 | 0 | 0 | en | |||||||||||
1462123489914245121 | Thilo Maier 226148486 | 2021-11-20T18:19:39+00:00 | Dream team @Rich_Harris and @rauchg at #SvelteSummit NYC. https://twitter.com/maiertech/status/1462123489914245121/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 57] | 0 | 2 | 46 | 1 | 1 | 0 | en | ||||||||||
1462223074946863110 | Marc Anthony Card 19242083 | 2021-11-21T00:55:22+00:00 | Glad I was able to stumble upon @swyx’s tweet for the #SvelteSummit NYC watch party. My first tech meetup but surely not my last. Met so many interesting people with a variety of backgrounds in software development. https://twitter.com/Marcard/status/1462223074946863110/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 217] | 0 | 2 | 38 | 1 | 1 | 0 | en | ||||||||||
1462229776295469057 | swyx 33521530 | 2021-11-21T01:22:00+00:00 | RT @Marcard: Glad I was able to stumble upon @swyx’s tweet for the #SvelteSummit NYC watch party. My first tech meetup but surely not my… | 1462223074946863110 1462223074946863110 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1462276996596174850 | swyx 33521530 | 2021-11-21T04:29:38+00:00 | RT @coderinheels: At the #SvelteSummit After Party, after the After Party, after the New York Watch Party - We know how the party!n 😄 @Sve… | 1462249320221233152 1462249320221233152 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1462975159548088332 | swyx 33521530 | 2021-11-23T02:43:53+00:00 | P.S. if you want to see the latest in JS reinvention come join the @temporalio meetup tomorrow where we are launching our new TypeScript SDK in beta! https://twitter.com/temporalio/status/1462970544379162627 | 1462970544379162627 1462970544379162627 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 149] | 1462923803189645315 | 33521530 | swyx | 1 | 2 | 15 | 0 | 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 | ||||||
1465445082308349959 | swyx 33521530 | 2021-11-29T22:18:28+00:00 | @kapehe_ok Finance was zero sum. Tech is positive sum. World of difference even at a psychological level. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 105] | 1465355637487910922 | 913527939177652224 | kapehe_ok | 0 | 2 | 147 | 0 | 0 | en | ||||||||
1469093401203150848 | swyx 33521530 | 2021-12-09T23:55:35+00:00 | @moseeds see also: http://sso.tax | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 42] | 1469093196860837888 | 33521530 | swyx | 0 | 2 | 21 | 0 | 0 | 0 | en | |||||||
1470462000001994754 | swyx 33521530 | 2021-12-13T18:33:55+00:00 | Free startup idea / Request for startup: Eco-friendly cable disposal 1. Let anyone mail their “big box of cables” to you. 2. You keep them for 1 year and ship back equivalent cables on demand. 3. Sell/responsibly recycle the rest. 4. Donate 20% proceeds to #TeamTrees | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 269] | 0 | 2 | 44 | 0 | 0 | en | |||||||||||
1470487931332792324 | swyx 33521530 | 2021-12-13T20:16:57+00:00 | RT @jasonlaster11: This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It d… | 1470487534132154378 1470487534132154378 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | 0 | en | |||||||||
1470787094750449665 | swyx 33521530 | 2021-12-14T16:05:43+00:00 | At this point they might as well rename Vercel’s slack to VC39 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 62] | 1470786647788765201 | 33521530 | swyx | 0 | 2 | 128 | 1 | 0 | en | ||||||||
1471580713946214402 | swyx 33521530 | 2021-12-16T20:39:17+00:00 | an unqualified, low effort “it depends” isn’t wisdom. it’s lazy and nihilistic. here’s how to give a great “it depends”: https://twitter.com/swyx/status/1100275989622505472 | 1100275989622505472 1100275989622505472 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 121] | 1202207460292988929 | 33521530 | swyx | 1 | 2 | 10 | 0 | 0 | 0 | en | ||||||
1472033075865563137 | swyx 33521530 | 2021-12-18T02:36:48+00:00 | RT @JeffMorhous: So I just finished reading “The Coding Career Handbook” by @swyx - it was a really great read and I can’t wait to re-refer… | 1471993625231773700 1471993625231773700 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1473206717403959297 | swyx 33521530 | 2021-12-21T08:20:26+00:00 | RT @Nina_Ledid: Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "wh… | 1473192929414070273 1473192929414070273 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 2 | 0 | 1 | 1 | en | ||||||||||
1473962147965112320 | Theodorus Clarence 1228336168892170241 | 2021-12-23T10:22:15+00:00 | + opinions about tailwindcss 👀 awesome book by the way @swyx https://twitter.com/th_clarence/status/1473962147965112320/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 61] | 0 | 2 | 14 | 0 | 0 | 0 | en | ||||||||||
1473991924285538304 | swyx 33521530 | 2021-12-23T12:20:34+00:00 | I wrote down my personal “rules of Twitter” in my @Coding_Career book and love it when newcomers find it useful! Twitter can be so confusing with the firehose of hot takes, petty squabbles, and serious announcements, but it’s a career hack for dev networking when done right. https://twitter.com/th_clarence/status/1473962147965112320 | 1473962147965112320 1473962147965112320 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 1 | 2 | 33 | 0 | 0 | 0 | en | |||||||||
1474271524110491649 | swyx 33521530 | 2021-12-24T06:51:36+00:00 | Strong Opinions on heading tags in HTML (h1, h2, h3, etc): - should all have id’s set - should all have discoverable anchor links (see: github markdown, or my blogposts) - (when appropriate) highlight link target, eg when one item in a multiple column layout (using :target) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 275] | 1474267015334752257 | 33521530 | swyx | 0 | 2 | 25 | 1 | 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]);