tweets

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

49 rows where favorite_count = 6 and possibly_sensitive = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, quoted_status, source, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorited, retweeted

lang 3 ✖

possibly_sensitive 1 ✖

favorite_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
1468185206628642816 swyx 33521530 2021-12-07T11:46:45+00:00 @peer_rich https://airbyte.io/connectors/google-analytics cc @AVaidyanatha gotchu fam       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 62] 1468182970750185477 1004742187 peer_rich       0 0 6 0 0 0 cy  
1128284234928418816 GraphQL Asia 1065983970616045568 2019-05-14T13:01:38+00:00 Serverless GraphQL - Shawn Wang @swyx https://www.youtube.com/watch?v=lq_He6Buv14&list=PLYLxE0c1nvDDB2O8K2a2m9I8u9KW9HxFG&index=19 Gatsby and GraphQL: Today and the Future - Sidhartha Chatterjee @chatsidhartha https://www.youtube.com/watch?v=VaBjfmSfyN4&list=PLYLxE0c1nvDDB2O8K2a2m9I8u9KW9HxFG&index=20       Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 0 [0, 165] 1128284232697016320 1065983970616045568 graphqlasia       0 2 6 0 0 0 en  
1420642639037091841 swyx 33521530 2021-07-29T07:09:34+00:00 Reflections on 10 years of Containers, from Bryan Cantrill some history at the start https://youtu.be/xXWaECk9XqM       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 110] 1381331610319036416 33521530 swyx       0 0 6 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  
1422417171884306436 swyx 33521530 2021-08-03T04:40:55+00:00 Trying this now with @temporalio :) PSA even though you start with a queue you can still block until your work is done, aka "synchronous start" of a workflow https://twitter.com/swyx/status/1417165270641045505?s=20   1417165270641045505 1417165270641045505   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 184] 1241482183472295939 33521530 swyx       1 0 6 0 0 0 en  
1422809609442500609 swyx 33521530 2021-08-04T06:40:20+00:00 More notes on Category creation, from @paigepaquette's @heavybit interview of folks from Netlify, Slack, and Datastax: https://codingcareer.circle.so/c/devtools/category-creation-netlify-slack-datastax#comment_wrapper_2653625       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 142] 1385125844826222592 33521530 swyx       0 0 6 0 0 0 en  
1424501065668468739 swyx 33521530 2021-08-08T22:41:34+00:00 Love this explanation of 成语 for a non Chinese speaking audience! Pros: the Chinese a way to efficiently serialize 4000 years of wisdom into everyday conversation. Cons: Chinese culture spends a lot of time dwelling on the past, while Western dreamers look to the future. https://twitter.com/michlimlim/status/1375835640919642122   1375835640919642122 1375835640919642122   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 272]             1 0 6 0 0 0 en  
1425634237361754117 swyx 33521530 2021-08-12T01:44:23+00:00 @rachelnabors this piece by @wes_kao nails how the CBC trend solves for completion https://future.a16z.com/cohort-based-courses/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 106] 1425505298337370112 9550352 rachelnabors       0 0 6 0 0 0 en  
1427577933074505728 James Ellis-Jones 65615053 2021-08-17T10:27:57+00:00 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 than any other testing, Code Review is more effective at removing defects than any kind of testing, many other things we get told to do have no effect.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277]             0 2 6 0 1 0 en  
1431079797220786180 swyx 33521530 2021-08-27T02:23:06+00:00 @robwalling i’ve termed this the “Meta-Creator Ceiling”, alternatively, “the Men who stare at GOATs” https://twitter.com/swyx/status/1351931174424231936?s=21   1351931174424231936 1351931174424231936   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 125] 1430993537684881409 86174269 robwalling       1 0 6 0 0 0 en  
1431843200520495106 swyx 33521530 2021-08-29T04:56:36+00:00 Really enjoyed this coverage of the Madoff scheme today. the scale of this fraud, the belligerent incompetence of investigators, and the human toll on victims are laid out with detailed sources. surprised to learn that apparently $14b of the total $17b invested has been recovered https://twitter.com/SwindledPodcast/status/1431829714671476737   1431829714671476737 1431829714671476737   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 280]             1 0 6 0 0 0 en  
1432797787863744519 swyx 33521530 2021-08-31T20:09:47+00:00 just discovered this MongoDB song parody *from MongoDB*, promoting Atlas: https://www.youtube.com/watch?v=0vPt7GI-2kc holy crap seems like a fun company to work at!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 145] 1432569213688823810 33521530 swyx       0 0 6 0 0 0 en  
1433476245136678918 swyx 33521530 2021-09-02T17:05:44+00:00 @gumroad with this! thank you gumroad! https://swyx.gumroad.com/l/bAZJq       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 62] 1433394042717577216 276271004 gumroad       0 0 6 0 0 0 en  
1434248052898820100 swyx 33521530 2021-09-04T20:12:37+00:00 My Chat with @vladchers on Enterprise DevRel! https://youtu.be/9zrKMoOw5VI       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 70]             0 2 6 0 0 0 en  
1434404727664558080 swyx 33521530 2021-09-05T06:35:11+00:00 Another rarity in this category: the sober retrospective where people close to the matter discuss mistakes made in dev marketing. excellent post by @ahmetb kNative’s initial marketing definitely spoke to too niche a usecase and it suffered for it. https://ahmet.im/blog/knative-positioning/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 273] 1416543395976151040 33521530 swyx       0 1 6 0 0 0 en  
1435330643576119306 swyx 33521530 2021-09-07T19:54:27+00:00 nice decade-lookback advice from Amanda here who is, in her words, “35 & single” and in the best shape of her life. Part 2 in quote tweet. Still looking for the “person i am excited to do life with”. Gnawing, endless suspicion that i already found her, but let her slip away. https://twitter.com/AmandaMGoetz/status/1420012738412220425   1420012738412220425 1420012738412220425   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 282] 1432598502060675073 33521530 swyx       1 0 6 0 0 0 en  
1436603173133770752 swyx 33521530 2021-09-11T08:11:01+00:00 @simonw swap URLs to swap UIs/apps! i’ve enjoyed documenting some of these in the past, mostly userland: https://twitter.com/swyx/status/1360316059987808256?s=21   1360316059987808256 1360316059987808256   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 129] 1436597379101118466 12497 simonw       1 0 6 0 0 0 en  
1441441832932573188 swyx 33521530 2021-09-24T16:38:08+00:00 Whoops i think i was supposed to tweet this - 10% off for friends! https://2021.cascadiajs.com/tickets/459       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 91] 1441441101626306566 33521530 swyx       0 0 6 0 0 0 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  
1442243016740069389 swyx 33521530 2021-09-26T21:41:45+00:00 1 year on - React 17 has been out for 6 months, no notable minor version bump since then. But React 18 seems to be ramping up! we got a little preview here https://twitter.com/swyx/status/1439702355553886211 and will likely get strong hints at Next.js conf next month as well   1439702355553886211 1439702355553886211   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 249] 1309840846485766144 33521530 swyx       1 0 6 0 0 0 en  
1443057317470081029 swyx 33521530 2021-09-29T03:37:29+00:00 @brianleroux i saw jeremy casually log out of the @goserverless CLI and log back in like it was nothing on this live stream (early on like 5ish mins in) and mind was fcking blown. i dont recall it ever being that smooth at @netlify https://twitter.com/swyx/status/1443024483170729989   1443024483170729989 1443024483170729989   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 231] 1443012651039133698 676363 brianleroux       1 0 6 0 0 0 en  
1444122755880787970 swyx 33521530 2021-10-02T02:11:10+00:00 Sep 2021: 139k+12k views, 37k uniques A really good month! Two big hits: - Self Provisioning Runtime: https://twitter.com/swyx/status/1432864028842356736?s=20 - Smart Clients vs Smart Servers: https://twitter.com/swyx/status/1439966955570618376 I also crossed 5k followers on @ThePracticalDev. Ironically I didn't feel very productive. https://twitter.com/swyx/status/1444122755880787970/photo/1   1439966955570618376 1439966955570618376   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 277] 1433716826660167680 33521530 swyx       1 0 6 0 0 0 en  
1445439018359996417 React New York 1074605328694722560 2021-10-05T17:21:31+00:00 2 more to go! @deekshasharma25 will talk about headless architecture and we finish React Day New York with @swyx You can watch the event over at https://reactnewyork.com/ or on YouTube https://www.youtube.com/playlist?list=PLiKqsi6CxPy6Njsj1WuTSYkDKmPtPy95O Be sure to join the live chat and ask questions.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 4 6 0 1 0 en  
1447028051653525504 swyx 33521530 2021-10-10T02:35:46+00:00 posted! https://twitter.com/swyx/status/1439966955570618376?s=20   1439966955570618376 1439966955570618376   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 31] 1437109166334783494 33521530 swyx       1 0 6 0 0 0 en  
1447250019233386504 swyx 33521530 2021-10-10T17:17:47+00:00 @levelsio @stephsmithio more benefits https://twitter.com/rothgar/status/1446867332748300288   1446867332748300288 1446867332748300288   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 37] 1446052399324356609 33521530 swyx       1 0 6 0 0 0 en  
1447377668312236032 swyx 33521530 2021-10-11T01:45:01+00:00 @vmcheung 👋! my first Kubecon, i’ll be at the @temporalio sponsor booth, we have two speakers and we have a happy hour on wednesday! http://temporal.io/happy-hour       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 157] 1447299233959186432 62923439 vmcheung       0 0 6 0 0 0 en  
1447999307924213761 swyx 33521530 2021-10-12T18:55:12+00:00 Some nice data on cold starts today: https://filia-aleks.medium.com/aws-lambda-battle-2021-performance-comparison-for-all-languages-c1b441005fd1 If you stay off Java and dotNet, you're fine, basically. https://twitter.com/swyx/status/1447999307924213761/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 118] 1363442491127701504 33521530 swyx       0 0 6 0 0 0 en  
1449925621375660035 swyx 33521530 2021-10-18T02:29:41+00:00 One of the reasons I put music into my mixtape (despite it being the least popular segment I do - basically only @PKodmad likes it lol) is b/c I am so inspired by @tiesto. He's been DJing by radio for 14 years, and its the best thing in my podcast feed. https://www.youtube.com/watch?v=39wON-CaIP4&list=PLAxy1YpvZDdW0aXeTdT7kFyyER5QAKWb5&index=76       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 1 6 0 0 0 en  
1450539279973699586 swyx 33521530 2021-10-19T19:08:08+00:00 @Cloudflare This blogpost was on the front page of HN for 16 hours yesterday! Traffic and stats for the nosy: Mentions: https://twitter.com/search?q=https%3A%2F%2Fwww.swyx.io%2Fcloudflare-go%2F&src=typed_query https://twitter.com/swyx/status/1450148471718043652?s=20 https://twitter.com/swyx/status/1450539279973699586/photo/1   1450148471718043652 1450148471718043652   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 169] 1445044267508850695 33521530 swyx       1 0 6 0 0 0 en  
1453539770630492162 swyx 33521530 2021-10-28T01:51:01+00:00 @mjackson i wrote a post about this phenomenon last year! https://twitter.com/swyx/status/1262062882050596864   1262062882050596864 1262062882050596864   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 57] 1452146698323591173 734903 mjackson       1 0 6 0 0 0 en  
1456915351241990145 Lou ☁️ 👨‍💻🏋️‍♂️🎸🚴🏻‍♂️🏍 1290693397 2021-11-06T09:24:22+00:00 In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tech it feels natural to write "beginner content" or sometimes meta-content (content about content—wait, that's *this thread* 😱 😆) https://www.swyx.io/meta-creator-ceiling/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276] 1456915349639680008 1290693397 loujaybee       0 2 6 1 1 0 en  
1459330286764711936 swyx 33521530 2021-11-13T01:20:28+00:00 @leeerob @camiinthisthang @Nutlope (i use nextjs for http://temporal.io, gimme gimme) https://twitter.com/swyx/status/1459330286764711936/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [35, 90] 1458908374347702281 81712767 leeerob       0 0 6 0 0 0 en  
1459698081688010755 swyx 33521530 2021-11-14T01:41:57+00:00 lol @spacehey replicated MySpace right down to the downtime https://twitter.com/swyx/status/1459698081688010755/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 59] 1459696420160638977 33521530 swyx       0 0 6 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  
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  
1460405005626662912 swyx 33521530 2021-11-16T00:31:01+00:00 @veritasium Fantastic followup video breaking down YouTube's shifting incentives and the virality formula that it has led to. The combination of Watch Time + CTR is *nonlinear* in the result. https://www.youtube.com/watch?v=fHsa9DqmId8 https://twitter.com/swyx/status/1460405005626662912/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 216] 1436628297039982592 33521530 swyx       0 0 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  
1462659131815477252 swyx 33521530 2021-11-22T05:48:06+00:00 YouTube blogged about their algorithm, which adds a couple things to @veritasium's list: - Clickthru Rate - Watch Time - Survey Responses - Sharing, Likes, Dislikes Interestingly, they refute Zuck's claim that "borderline content" gets more engagement: https://blog.youtube/inside-youtube/on-youtubes-recommendation-system/ https://twitter.com/swyx/status/1462659131815477252/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279] 1460405005626662912 33521530 swyx       0 1 6 0 0 0 en  
1462701329176940545 swyx 33521530 2021-11-22T08:35:47+00:00 Beautiful illustration of Facebook's Invisible Asymptotes here from @gustaf https://www.youtube.com/watch?v=T9ikpoF2GH0&list=WL&index=29 (10mins in) https://twitter.com/swyx/status/1462701329176940545/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 112] 1129047995163586563 33521530 swyx       0 0 6 0 0 0 en  
1462956709178052610 swyx 33521530 2021-11-23T01:30:34+00:00 @edgarasben its a Rorschach https://twitter.com/okikio_dev/status/1462945508662648841?s=20       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 52] 1462948604428144647 45556012 edgarasben       1 0 6 0 0 0 en  
1464053372575571969 swyx 33521530 2021-11-26T02:08:19+00:00 @threepointone github is extreme upper bound - our designers and PMs also had github accounts, but just to leave comments on PRs or manage issues not coding as the main job. it’s probably closer to 40-50m. my list of estimates of devs: https://github.com/sw-yx/tracking#how-many-developers-are-there-in-the-world       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 260] 1463897640542818310 1593171 threepointone       0 0 6 0 0 0 en  
1465806937111416836 swyx 33521530 2021-11-30T22:16:21+00:00 @buildsghost someone shop this in pls https://twitter.com/swyx/status/1465806937111416836/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 37] 1465799694177607681 1175464650395111424 buildsghost       0 0 6 0 0 0 en  
1466475407826292739 swyx 33521530 2021-12-02T18:32:37+00:00 Our meetup video with our launch and two TS SDK examples from @BDevessier (Temporal + XState) and @abadir_ (Temporal + @FlightControlHQ) is live! https://www.youtube.com/watch?v=GpbOkDjpeYU       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 170] 1463283116030652416 33521530 swyx       0 1 6 0 0 0 en  
1466500763400630272 swyx 33521530 2021-12-02T20:13:22+00:00 @chantastic @sveltejs http://svelte.holiday when       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 50] 1466481138763919361 12745092 chantastic       0 0 6 0 0 0 en  
1467221457725915136 swyx 33521530 2021-12-04T19:57:09+00:00 @temporalio @typescript Workshop video is live! https://youtu.be/CeHSmv8oF_4       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 71] 1465793834739068932 33521530 swyx       0 0 6 0 0 0 en  
1467261215915364353 Adam Gordon Bell 🤓 191034488 2021-12-04T22:35:08+00:00 @swyx I wrote a thing about this: https://earthly.dev/blog/confidently-uncertain/       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [6, 57] 1467260899874512906 191034488 adamgordonbell       0 1 6 0 0 0 en  
1472034381292347393 swyx 33521530 2021-12-18T02:42:00+00:00 @gudmundur @vercel sooo basically this https://twitter.com/swyx/status/1470786647788765201?s=21 congrats!!   1470786647788765201 1470786647788765201   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 73] 1471876856404230147 13009822 gudmundur       1 0 6 0 0 0 en  
1458976641057640456 swyx 33521530 2021-11-12T01:55:12+00:00 @flybayer :) https://twitter.com/swyx/status/1450992549141704704?s=21   1450992549141704704 1450992549141704704   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 36] 1458881768594067461 2826554209 flybayer       1 0 6 0 0 0 und  
1462318808950054916 swyx 33521530 2021-11-21T07:15:47+00:00 @jasonlaster11 https://twitter.com/swyx/status/1462318808950054916/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 14] 1462298784595996673 312750384 jasonlaster11       0 0 6 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]);