tweets

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

45 rows where favorited = 0, is_quote_status = 1, retweet_count = 1, retweeted = 0 and user = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, favorite_count, lang

user 1 ✖

  • swyx · 45 ✖

retweeted 1 ✖

retweet_count 1 ✖

is_quote_status 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
1420050980310183936 swyx 33521530 2021-07-27T15:58:31+00:00 This is an incredible video: https://twitter.com/discord/status/1418617539404308482?s=20 Writeup: https://blog.discord.com/meet-the-discord-users-who-imagined-a-place-657325b75fa6 It's a quirky amalgam of Discord memes with Awkwafina, Danny Devito, Grimes, MKBHD, flying flaming cows, and eggs. Totally ineffective at explaining what Discord is, but captures how it FEELS.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1378408503597965316 33521530 swyx       1 1 8 0 0 0 en  
1420261009583788032 swyx 33521530 2021-07-28T05:53:06+00:00 @matiasfha @Rich_Harris @stolinski @gndx btw you can implement the same thing for React too. its just that the React core team prefers boilerplate to sugar syntax. https://twitter.com/swyx/status/1294310598419689472?lang=en   1294310598419689472 1294310598419689472   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [41, 187] 1420216170402091009 12816182 matiasfha       1 1 5 0 0 0 en  
1421221582031056897 swyx 33521530 2021-07-30T21:30:04+00:00 @reactjs I don't mean "working with React", I mean "contributing TO React" - you can see how much React relies on fixtures to help ourselves manually reproduce all the things we can't in tests (and there are many!) See links below: https://twitter.com/swyx/status/1421220603197939713?s=20   1421220603197939713 1421220603197939713   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 257] 1421180194384084995 33521530 swyx       1 1 6 0 0 0 en  
1424154174778843136 swyx 33521530 2021-08-07T23:43:09+00:00 TLDR of @cloudflare's solution: - introduce intuitive "locking" behavior on in-/out-bound messages based on storage operations - in-memory cache for speed and coalescing multiple writes - opt-outs for latency/memory efficiency - no breaking changes detailed yet accessible read! https://twitter.com/KentonVarda/status/1422553148099645451   1422553148099645451 1422553148099645451   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             1 1 28 0 0 0 en  
1426327484316884992 swyx 33521530 2021-08-13T23:39:06+00:00 @chantastic 🙌🏽 my writeup ICYMI https://twitter.com/swyx/status/1221586490674696193?s=20   1221586490674696193 1221586490674696193   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 56] 1426318522242588675 12745092 chantastic       1 1 10 0 0 0 en  
1427361704241877017 swyx 33521530 2021-08-16T20:08:44+00:00 @CommandBar is now a startup! https://twitter.com/dazzeloid/status/1424769790107820032   1424769790107820032 1424769790107820032   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 55] 1383146902133239813 33521530 swyx       1 1 8 0 0 0 en  
1428094708899745793 swyx 33521530 2021-08-18T20:41:25+00:00 2 years on... nice explanation and discussion of JWTs here, and I pretty much am exactly where Emelia is at https://twitter.com/ThisIsMissEm/status/1427988073292476418?s=20   1427988073292476418 1427988073292476418   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 132] 1133780714988736512 33521530 swyx       1 1 10 0 0 0 en  
1428130743381762055 swyx 33521530 2021-08-18T23:04:37+00:00 Just got reminded its the 3 year anniversary of my first conf talk: https://www.youtube.com/watch?v=nyFHR0dDZo0 I remember being so nervous, just 1 year out of bootcamp talking React in front of my heroes @ReactRally. Never regretted it. If you can, speak at a conference. Will change your life. https://twitter.com/swyx/status/1030130810588819456   1030130810588819456 1030130810588819456   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             1 1 71 0 0 0 en  
1431856166041112580 swyx 33521530 2021-08-29T05:48:07+00:00 @amasad “bring class to the masses” is my favorite phrasing of this. also can dissect by expertise instead of wealth: “let non X do X” https://twitter.com/swyx/status/1287893745103286272?s=21   1287893745103286272 1287893745103286272   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 160] 1431694805977878535 166138615 amasad       1 1 27 0 0 0 en  
1432598502060675073 swyx 33521530 2021-08-31T06:57:53+00:00 here's 91 quotes from Warren Buffett, who just turned 91. https://twitter.com/GRDecter/status/1432365846438027276?s=20 This one stuck out given my recent blogpost on devrel metrics: "Games are won by players who focus on the playing field –- not by those whose eyes are glued to the scoreboard." 🎯   1432365846438027276 1432365846438027276   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 265] 1386482851026112515 33521530 swyx       1 1 7 0 0 0 en  
1432864050895994890 swyx 33521530 2021-09-01T00:33:05+00:00 I previously wrote about Cloud Distros, my term for the "second layer" of clouds forming atop the Big Three: https://twitter.com/swyx/status/1252699745883062272 Self Provisioning Runtimes are one step further into the breach - instead of YAML config and SDK code, these platforms *read the app code*.   1252699745883062272 1252699745883062272   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 273] 1432864048677154818 33521530 swyx       1 1 12 0 0 0 en  
1433918146348343297 swyx 33521530 2021-09-03T22:21:41+00:00 I think why I struggle with OKRs so much: Suits set them as a system of external control, a way to manage by spreadsheet rather than get hands dirty, defining quality as quantity, when the best work of knowledge workers and creatives comes from doing epic shit for the sake of it. https://twitter.com/petergyang/status/1433807042590875654   1433807042590875654 1433807042590875654   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 1 30 0 0 0 en  
1434966467909402629 swyx 33521530 2021-09-06T19:47:20+00:00 i go through big crashes in confidence with my writing so comments like these really make my day 😊 for those who want more tips on writing process, I have a little trilogy! starting with Mise en Place Writing: https://twitter.com/swyx/status/1241858255195865090 https://twitter.com/swyx/status/1434966467909402629/photo/1   1241858255195865090 1241858255195865090   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 235]             1 1 31 0 0 0 en  
1435223333398843397 swyx 33521530 2021-09-07T12:48:02+00:00 sorry for my shitty photos - lighting not great and my phone is pretty old. read his @QwikDev intro blogpost series if you are interested in his take - it really is sufficiently different than existing paradigms that it is worth a look. https://twitter.com/mhevery/status/1415436174685089793?s=20   1415436174685089793 1415436174685089793   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 263] 1435218549946073092 33521530 swyx       1 1 10 0 0 0 en  
1435232963600556041 swyx 33521530 2021-09-07T13:26:18+00:00 34 days until I saw my own meme on a conference stage in person! enjoying this talk by @tlakomy about executing untrusted code atop a fullstack @typescript + AWS stack! however there is a surprising lack of jQuery, unclear if real @tlakomy was kidnapped https://twitter.com/tlakomy/status/1434969999572094983 https://twitter.com/swyx/status/1435232963600556041/photo/1   1434969999572094983 1434969999572094983   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278] 1426638568714227712 33521530 swyx       1 1 19 0 0 0 en  
1436594934002458626 swyx 33521530 2021-09-11T07:38:17+00:00 I’d really love to hear behind the scenes on GitHub’s decision to launch this shortcut. The obvious downside: launching an expensive action on a single keypress may negatively surprise users. The upside: the barrier to using Codespaces can’t be lower. I use it once a day now. https://twitter.com/github/status/1425505817827151872   1425505817827151872 1425505817827151872   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             1 1 80 0 0 0 en  
1437048380958679042 swyx 33521530 2021-09-12T13:40:07+00:00 Valuable peek into what it is like to debate syntax inside @TC39, from someone who was actively involved but no longer is. This sort of thing is above my paygrade, but standards work affects us all, and I’m glad people this passionate have a voice in the future of JavaScript. https://twitter.com/BenLesh/status/1436890184449236994   1436890184449236994 1436890184449236994   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 277]             1 1 33 0 0 0 en  
1437095732436258816 swyx 33521530 2021-09-12T16:48:17+00:00 @jamonholmgren yes! I call this Lampshading. Ignorance can be Power, when wielded correctly. https://twitter.com/swyx/status/1238321393374298112   1238321393374298112 1238321393374298112   TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [15, 117] 1437089665018826754 30273948 jamonholmgren       1 1 4 0 0 0 en  
1437132718928695301 swyx 33521530 2021-09-12T19:15:15+00:00 expanded in a blogpost: https://twitter.com/swyx/status/1312603851581652994?s=21   1312603851581652994 1312603851581652994   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 47] 1253303455961079810 33521530 swyx       1 1 4 0 0 0 en  
1437730180068483077 swyx 33521530 2021-09-14T10:49:21+00:00 @danluu people have a hunger for depth; but many options. therefore we must demonstrate quality early, or build reputation for it over time. https://twitter.com/Julian/status/1348001394758799361   1348001394758799361 1348001394758799361   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 140] 1437539076324790274 18275645 danluu       1 1 9 0 0 0 en  
1444556693673701378 swyx 33521530 2021-10-03T06:55:28+00:00 @jlengstorf @astrodotbuild right here with ya :) https://twitter.com/swyx/status/1172690454363672577?s=20   1172690454363672577 1172690454363672577   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 72] 1442707241627385860 15668072 jlengstorf       1 1 14 0 0 0 en  
1445111500931153922 swyx 33521530 2021-10-04T19:40:05+00:00 Events are underrated for community building 🔥 Find ways to get off Slack! All year we've been hosting @temporalio meetups with a good mix of users and employees speaking. Most recently we've been really ramping up guest speakers, from @Bolt to @AirbyteHQ and now @NetflixEng 🚀 https://twitter.com/temporalio/status/1445091864244207618   1445091864244207618 1445091864244207618   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             1 1 14 0 0 0 en  
1447688291818508296 swyx 33521530 2021-10-11T22:19:20+00:00 One of my favorite things at work is flipping low-trust situations into high-trust ones. Teams move at the speed of trust. I think it is one of the most critical things you can do early on in any job. RTing this bc first time I've seen Trust broken down to an equation! https://twitter.com/ryan_caldbeck/status/1013626221601738754   1013626221601738754 1013626221601738754   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 270]             1 1 14 0 0 0 en  
1448049750901551108 swyx 33521530 2021-10-12T22:15:38+00:00 @temporalio - Product: what else can you build to serve power users? eg Apollo Studio, MongoDB Atlas, Hashicorp Vault Companies become platforms when they ship the *2nd* blockbuster product. They become generational when their loops make any product a blockbuster. https://twitter.com/swyx/status/1367518496326709251 https://twitter.com/swyx/status/1448049750901551108/photo/1   1367518496326709251 1367518496326709251   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 290] 1448047600318365697 33521530 swyx       1 1 8 0 0 0 en  
1455820522915127299 swyx 33521530 2021-11-03T08:53:55+00:00 Hard to read but handy report for Community Builders. Some picks: - Typical community spans 6 platforms - Community builders use 13 tools, try 3, no integration - @circleapp has 19% market share!? 🤯 - Chat > Social media > Email > Events Dark horses: Affiliates, QoTD, Advocacy https://twitter.com/OrbitModel/status/1455535930660564995 https://twitter.com/swyx/status/1455820522915127299/photo/1   1455535930660564995 1455535930660564995   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 311]             1 1 15 0 0 0 en  
1458556941316149251 swyx 33521530 2021-11-10T22:07:28+00:00 @chadwhitacre_ @getsentry congrats!! what does "head of open source" entail at Sentry? i enjoyed this perspective on the job from @cdibona recently: https://twitter.com/cdibona/status/1457887975115612164   1457887975115612164 1457887975115612164   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 172] 1458553600104411147 34175404 chadwhitacre_       1 1 1 0 0 0 en  
1459227112577986561 swyx 33521530 2021-11-12T18:30:29+00:00 "Red is about to be mine again, but it has always been ours." Scooter Braun becomes the dictionary definition of what happens when you try to NFT an artist against their will. Streaming #RedTaylorsVersion now and forever. https://twitter.com/taylorswift13/status/1459023801480474632   1459023801480474632 1459023801480474632   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 222]             1 1 19 0 0 0 en  
1459252833140629504 swyx 33521530 2021-11-12T20:12:41+00:00 Python just became the #1 programming language in the world, according to the TIOBE index. https://www.tiobe.com/tiobe-index/ Sharp declines in C and Java in 2021. It rates JavaScript #7, so you know not to take it *too* seriously. https://twitter.com/swyx/status/1326786181447766019 https://twitter.com/swyx/status/1459252833140629504/photo/1   1326786181447766019 1326786181447766019   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 246]             1 1 24 0 0 0 en  
1459750702800986115 swyx 33521530 2021-11-14T05:11:03+00:00 @rakyll yes! this is why I was extremely inspired when Sarah implemented product rotations for us at @Netlify. It meant that we literally spent 3 months each year as engineers, not as developer advocates. Huge investment from both eng and DX, was very grateful. https://twitter.com/sarah_edo/status/1346842506722308099   1346842506722308099 1346842506722308099   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 286] 1459640319352344576 10809412 rakyll       1 1 20 0 0 0 en  
1459945207097556994 swyx 33521530 2021-11-14T18:03:56+00:00 @Nutlope @ChrisSamiullah great minds https://twitter.com/david_perell/status/1261851180881174529?s=20   1261851180881174529 1261851180881174529   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 60] 1459932508129222662 3246815913 Nutlope       1 1 6 0 0 0 en  
1460920410250235908 swyx 33521530 2021-11-17T10:39:03+00:00 @calebmer @umbrant @airtable @technoheads writes an excellent recap of Etsy's migration to TypeScript! wish it had some quotable attestations about the business impact but this is a great description of process. https://twitter.com/ksylor/status/1457730231301705730?s=20   1457730231301705730 1457730231301705730   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [29, 236] 1389523548121698305 33521530 swyx       1 1 6 0 0 0 en  
1462895745615351808 swyx 33521530 2021-11-22T21:28:19+00:00 My favorite nontraditional measure of dev community traction is # of mentions in job descriptions. By this measure, @Temporalio is in incredibly good company for a 2 year old startup: https://temporal.io/careers#external-jobs Help your users hire/get hired and they will be loyal for life. https://twitter.com/swyx/status/1427351638872772633 https://twitter.com/swyx/status/1462895745615351808/photo/1   1427351638872772633 1427351638872772633   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 297]             1 1 30 0 0 0 en  
1463266140847677454 swyx 33521530 2021-11-23T22:00:08+00:00 And now @SvelteSociety gets its own fulltime Technical Community Builder in @kevmodrome! https://twitter.com/kevmodrome/status/1463151477174714373?s=20   1463151477174714373 1463151477174714373   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 113] 1458693704764383241 33521530 swyx       1 1 15 0 0 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  
1465589050652303363 swyx 33521530 2021-11-30T07:50:33+00:00 The production quality on this one is epic. I don’t think i’ve seen a better conference opener in the last 10 years. congrats @webflow and seriously @mcguirebrannon is a *superstar* 🤯 https://twitter.com/webflow/status/1461052708400549891   1461052708400549891 1461052708400549891   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 184]             1 1 11 0 0 0 en  
1465917129954234371 swyx 33521530 2021-12-01T05:34:13+00:00 Ok I finally made a private alt: @swyxio If you want the no-filter firehose from me, that's gonna be the outlet. No need to be mutuals just be a non-crazy person with an open mind. profile pic is from my fraternity days when i used to be fun https://twitter.com/qoouep/status/1465237879693590532       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 243]             1 1 19 0 0 0 en  
1466828614247206913 swyx 33521530 2021-12-03T17:56:08+00:00 "Cloud vendors will increasingly focus on the lowest layers in the stack: basically leasing capacity in their data centers through an API. Other pure-software providers will build all the stuff on top of it. Databases, running code, you name it." https://twitter.com/bernhardsson/status/1465732837173252101?s=20 https://twitter.com/swyx/status/1466828614247206913/photo/1   1465732837173252101 1465732837173252101   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 271] 1400228924307611649 33521530 swyx       1 1 9 0 0 0 en  
1466996913153007617 swyx 33521530 2021-12-04T05:04:54+00:00 Relay compiler has been completely rewritten in Rust. “TL;DR: The main goal was drastically improve the speed of the build step.” https://twitter.com/RelayFramework/status/1466875921818861577   1466875921818861577 1466875921818861577   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 130] 1458910483176517632 33521530 swyx       1 1 11 0 0 0 en  
1468339703237599233 swyx 33521530 2021-12-07T22:00:40+00:00 Replay seems to have identified the biggest opportunity to improve the state of browser devtools and is just going for it. If you ever had feature requests for any tab in your dev tools, join their discord (https://discord.gg/F5a4kvb6wu) and chat with their engineers! https://twitter.com/jasonlaster11/status/1468330375881510916   1468330375881510916 1468330375881510916   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 263]             1 1 16 0 0 0 en  
1468673459689431042 swyx 33521530 2021-12-08T20:06:54+00:00 @adamwathan Tailwind is the new gold standard in developer experience, from API design to docs to release management to blog/video content! https://twitter.com/swyx/status/1312603851581652994   1312603851581652994 1312603851581652994   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 164] 1468648955240230918 716933677 adamwathan       1 1 25 0 0 0 en  
1469861433256992769 swyx 33521530 2021-12-12T02:47:29+00:00 I have substantial philosophical differences with the way “Twitter Growth” is framed here, but have to give credit to @tdinh_me for actually building a decent iOS app. Excited to take it for a spin! https://twitter.com/tdinh_me/status/1469706551157919746   1469706551157919746 1469706551157919746   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 198] 1462569053420244992 33521530 swyx       1 1 5 0 0 0 en  
1474097799491112960 swyx 33521530 2021-12-23T19:21:17+00:00 Extremely impressed by @AirbyteHQ's 2021: Mar: 5m Seed @Accel May: 26m Series A @Benchmark Dec: 150m Series B @altcap + Coatue Took 1 yr to get to 1/4 of Fivetran (founded 2012) 🤯 Was only tipped off by @roopakv + case study with @temporalio, but have to pay close attn now. https://twitter.com/MichelTricot/status/1474055955734319112 https://twitter.com/swyx/status/1474097799491112960/photo/1   1474055955734319112 1474055955734319112   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 302]             1 1 14 0 0 0 en  
1465524048574627841 swyx 33521530 2021-11-30T03:32:15+00:00 @Nutlope https://twitter.com/elzr/status/1381105950602461189   1381105950602461189 1381105950602461189   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 32] 1465521492331016193 3246815913 Nutlope       1 1 13 0 0 0 und  
1467306253172887552 swyx 33521530 2021-12-05T01:34:06+00:00 @BrittneyPostma @argyleink https://twitter.com/swyx/status/1467304180003917824   1467304180003917824 1467304180003917824   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 50] 1467302465578045441 33521530 swyx       1 1 1 0 0 0 und  
1468767124906668035 swyx 33521530 2021-12-09T02:19:05+00:00 @DavidKPiano https://twitter.com/netlify/status/1276232504337465344?s=21   1276232504337465344 1276232504337465344   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 36] 1468615741981302791 992126114 DavidKPiano       1 1 20 0 0 0 und  

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]);