tweets
44 rows where favorite_count = 12 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorited, retweeted, lang
created_at (date) 38 ✖
- 2021-10-26 3
- 2021-08-05 2
- 2021-08-18 2
- 2021-08-31 2
- 2021-09-01 2
- 2020-05-19 1
- 2021-07-23 1
- 2021-07-28 1
- 2021-08-01 1
- 2021-08-04 1
- 2021-08-08 1
- 2021-08-20 1
- 2021-08-28 1
- 2021-08-30 1
- 2021-09-03 1
- 2021-09-07 1
- 2021-09-18 1
- 2021-09-21 1
- 2021-09-26 1
- 2021-09-27 1
- 2021-09-30 1
- 2021-10-03 1
- 2021-10-05 1
- 2021-10-06 1
- 2021-10-11 1
- 2021-10-12 1
- 2021-10-22 1
- 2021-10-24 1
- 2021-10-29 1
- 2021-11-02 1
- 2021-11-03 1
- 2021-11-16 1
- 2021-11-29 1
- 2021-12-03 1
- 2021-12-10 1
- 2021-12-14 1
- 2021-12-21 1
- 2021-12-23 1
quoted_status 9 ✖
user 8 ✖
- swyx 37
- Brittney Postma 1
- ๐ m4dz ๐ฅ๐ฆ 1
- Paul Biggar 1
- React India ๐ฎ๐ณ 1
- Geoff Rich 1
- สษชแด ๐ 1
- Nina 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1262696057609187330 | swyx 33521530 | 2020-05-19T10:46:14+00:00 | i'm currently at ~2k visitors/day according to @Netlify Analytics. April data looks suspicious. People really like me in Germany! lol and TIL that Chris Coyier linked me in @Css!!!!!!!!! https://css-tricks.com/react-single-file-components-are-here/ *success kid โ* https://twitter.com/swyx/status/1262696057609187330/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 230] | 1220372896448700418 | 33521530 | swyx | 0 | 0 | 12 | 0 | 0 | 0 | en | |||||||
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 | ||||||||||
1420442392637939712 | Brittney Postma 36686876 | 2021-07-28T17:53:51+00:00 | So, I just had this idea today inspired by @swyx's Mixtapes. I'm thinking of starting a short, digestible solo podcast that I can get all my thoughts for the week out on. I blogged for awhile and put up http://TheConsoleLogs.com, but I just don't have time to write up anymore. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 0 | 12 | 0 | 0 | 0 | en | ||||||||||
1421938210876231680 | swyx 33521530 | 2021-08-01T20:57:42+00:00 | 1970's version of the intuition bell curve https://en.wikipedia.org/wiki/Four_stages_of_competence https://twitter.com/swyx/status/1421938210876231680/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 67] | 1393563260843028482 | 33521530 | swyx | 0 | 1 | 12 | 0 | 0 | 0 | en | |||||||
1422997035771256834 | swyx 33521530 | 2021-08-04T19:05:05+00:00 | @JemYoung oooh. care to expand on the qualities of good questions vs bad questions? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 83] | 1422987749196386305 | 959539956 | JemYoung | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1423313808525824000 | สษชแด ๐ 1338510819743719424 | 2021-08-05T16:03:50+00:00 | Life can be so much wider when you discover a simple fact: Everything around you that you call life was made by people who weren't smarter than you. https://dev.to/swyx/memento-vivere-5eak | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 173] | 0 | 3 | 12 | 0 | 1 | 0 | en | ||||||||||
1423365577091866626 | swyx 33521530 | 2021-08-05T19:29:33+00:00 | @maxlynch i know but i just love the shameless superiority complex of an early stage startup making ~$0 just shitting on stable, moneymaking incumbents while downplaying their own flaws | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 185] | 1423344700640145417 | 15103611 | maxlynch | 0 | 1 | 12 | 0 | 0 | en | ||||||||
1424503004074414081 | swyx 33521530 | 2021-08-08T22:49:16+00:00 | I also strongly, strongly recommend Sarah's take on the #1 objection to Tailwind: "bUT WE have inLIne StYleS?" https://twitter.com/frontstuff_io/status/1394274447612317697 | 1394274447612317697 1394274447612317697 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 135] | 1424502535411224581 | 33521530 | swyx | 1 | 0 | 12 | 0 | 0 | 0 | en | ||||||
1427798652018257923 | swyx 33521530 | 2021-08-18T01:05:00+00:00 | @chriscoyier the people who get this spend too much time online and should call their parents more often | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 104] | 1427798104422723591 | 793830 | chriscoyier | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1428580204088373252 | React India ๐ฎ๐ณ 4023142698 | 2021-08-20T04:50:37+00:00 | ๐จNominate Speakers ๐จ If you know someone who has something great to talk about, nominate them. Join @GantLaborde @swyx @mxstbr our very first confirmed speakers on the virtual stage. This Call for Presentationย closes soon Apply to our CFP today. https://bit.ly/cfp-reactindia2021 https://twitter.com/react_india/status/1428580204088373252/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 1428580201294876679 | 4023142698 | react_india | 0 | 3 | 12 | 0 | 1 | 0 | en | |||||||
1431715021868896259 | swyx 33521530 | 2021-08-28T20:27:15+00:00 | NEVER a bad look to acknowledge your weaknesses, flaws, and anti-goals. Better you say it upfront than have users drag it out of you (or worse, disbelieve your denials) It shows confidence that you solve an impt problem well enough you dont need to be all things to all people. https://twitter.com/kilianvalkhof/status/1431686864570826753 | 1431686864570826753 1431686864570826753 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1 | 0 | 12 | 0 | 0 | 0 | en | |||||||||
1432471431850299397 | swyx 33521530 | 2021-08-30T22:32:58+00:00 | ๐ quick post: 3 Reasons to Upgrade Git https://dev.to/swyx/3-reasons-to-upgrade-git-2bj3 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 63] | 0 | 3 | 12 | 0 | 0 | 0 | en | ||||||||||
1432510138741497860 | swyx 33521530 | 2021-08-31T01:06:46+00:00 | @jamonholmgren any workplace where company leaders regularly podcast with employees like normal human beings is automatic +30 in my book | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [15, 136] | 1432508680302325760 | 30273948 | jamonholmgren | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1432719949575905289 | Paul Biggar 86938585 | 2021-08-31T15:00:29+00:00 | Love this - "Self-provisioning runtime" Thanks for the shoutout @swyx https://www.swyx.io/self-provisioning-runtime/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 96] | 0 | 0 | 12 | 0 | 0 | 0 | en | ||||||||||
1432864040624091138 | swyx 33521530 | 2021-09-01T00:33:03+00:00 | To paraphrase: DX advances by extending the number of important problems our code handles without thinking of them. If we can isolate these chores, we can design them into the language, or build it into the platform. The holy grail: Language-AS-platform, Infra-FROM-code. https://twitter.com/swyx/status/1432864040624091138/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 274] | 1432864036241088513 | 33521530 | swyx | 0 | 1 | 12 | 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 | ||||||
1433919649075240962 | swyx 33521530 | 2021-09-03T22:27:39+00:00 | @seldo reading this in Werner Herzog voice | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 42] | 1433824330899607552 | 15453 | seldo | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1435253892523171843 | ๐ m4dz ๐ฅ๐ฆ 81091261 | 2021-09-07T14:49:28+00:00 | Deep dive in the #JavaScript's History, where it comes from, and where it goes for the next 10 years. I do love those kind of prospective talks ๐คฉ. Thanks @swyx ! #infobipshift https://twitter.com/m4d_z/status/1435253892523171843/photo/1 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 175] | 0 | 2 | 12 | 0 | 1 | 0 | en | ||||||||||
1439024297972932608 | swyx 33521530 | 2021-09-18T00:31:43+00:00 | @temporalio @golang "Yes, cool, but *HOW* do you checkpoint execution?!?" โ @EricVicenti Event sourcing. Temporal SDKs aren't mere API wrappers. They are runtimes that persist and replay the *complete event history* of your code execution, backed by Temporal Server. More: https://youtu.be/BJwFxqdSx4Y?t=600 https://twitter.com/swyx/status/1439024297972932608/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 299] | 1438969813225799682 | 33521530 | swyx | 0 | 2 | 12 | 0 | 0 | 0 | en | |||||||
1440205468761088004 | swyx 33521530 | 2021-09-21T06:45:16+00:00 | ๐ How I take Podcast Notes - and ship a mixtape almost every day Thanks to a question from @aravindballa https://youtu.be/wWV6KH6mGtM | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 131] | 0 | 4 | 12 | 0 | 0 | 0 | en | ||||||||||
1442204116151771136 | swyx 33521530 | 2021-09-26T19:07:10+00:00 | @rauchg @ConvertKit - theres a race condition that only infrequently lets you select text, paste url, and it converts into a link. when you miss the race you have to use the dialog box, where after pasting, you cant just hit enter to make it a link, you have to use the mouse to click! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 285] | 1442175055102767106 | 15540222 | rauchg | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1442310363681378312 | swyx 33521530 | 2021-09-27T02:09:22+00:00 | ๐ฅ Just pushed my new @Revue newsletter! โ[http://swyx.io] YouTube Podcasting - good idea, or bad idea?โ https://www.getrevue.co/profile/swyx/archive/317891 | Revue e01d36c55a12ec4cf389049ec42665dce335b54e | 0 | [0, 137] | 0 | 0 | 12 | 0 | 0 | 0 | en | ||||||||||
1443367814505525251 | swyx 33521530 | 2021-09-30T00:11:18+00:00 | "In 2021, @Awkwafina was in two Disney movies featuring blue water dragons that are the worldโs last line of defense against soul-entrapping Purple monsters." "Which isn't a lot, but it's weird that it happened twice." | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 219] | 0 | 0 | 12 | 0 | 0 | en | |||||||||||
1445466345194209290 | swyx 33521530 | 2021-10-05T19:10:06+00:00 | Done! Video is already here thanks to @ReactNewYork and related links are in the comments! Slides: https://docs.google.com/presentation/d/1sJSqNy-t-kVxzrWlqMTp_03nI7Zo8Znr7k0f0C6L9ig/edit?usp=sharing Video: https://www.youtube.com/watch?v=umsYzbDtj18 Thanks for having me! ๐ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 180] | 1445236122112561157 | 33521530 | swyx | 0 | 0 | 12 | 0 | 0 | 0 | en | |||||||
1445841314184982546 | swyx 33521530 | 2021-10-06T20:00:06+00:00 | @EmmaBostian @InfobipShift @renderATL haha i'm fine now but yeah it was the most depressed i've been all year bc also fell sick + did some screwups at work. fortunately my Mexico stay was brightened by very good podcast recordings with @threepointone and @mhevery accidentally starting off my "podcast career" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [38, 309] | 1445840848847970305 | 491821358 | EmmaBostian | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1447657846754054145 | swyx 33521530 | 2021-10-11T20:18:21+00:00 | @remix_run whoo congrats team! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 30] | 1447649474038222851 | 1250847387062419456 | remix_run | 0 | 1 | 12 | 0 | 0 | en | ||||||||
1448024107618947072 | swyx 33521530 | 2021-10-12T20:33:44+00:00 | Probably my biggest test of confidence was in March when @martin_casado and @davidu pushed back on the open source religion - if your monetization is SaaS, then open source is just marketing (there's nuance here, pls read his replies before reacting) https://twitter.com/swyx/status/1373425786351284228 | 1373425786351284228 1373425786351284228 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 1448024106633363456 | 33521530 | swyx | 1 | 2 | 12 | 0 | 0 | 0 | en | ||||||
1451410441012273155 | swyx 33521530 | 2021-10-22T04:49:49+00:00 | @sebastienlorber honestly miss getting excited about stuff like this. love that react continues to innovate. ๐ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 110] | 1451216514779172867 | 40663578 | sebastienlorber | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1452239851802275841 | swyx 33521530 | 2021-10-24T11:45:36+00:00 | @LeaVerou @Netlify it really is :) have you tried Netlify forms? another wow moment. https://twitter.com/netlify/status/1263517446465519619?s=21 | 1263517446465519619 1263517446465519619 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [19, 108] | 1451877841109401600 | 22199970 | LeaVerou | 1 | 0 | 12 | 0 | 0 | 0 | en | ||||||
1452821252951867394 | swyx 33521530 | 2021-10-26T02:15:53+00:00 | @techgirl1908 @anildash the "banking the unbanked" to Miami lambo party pipeline ๐ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 82] | 1452820534425706496 | 2932738834 | techgirl1908 | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1452849923494330373 | swyx 33521530 | 2021-10-26T04:09:49+00:00 | @threepointone been excited since @acdlite demoed it 2 pandemics ago... but eyes getting droopy | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 95] | 1452773175209697282 | 1593171 | threepointone | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1452857849508294660 | swyx 33521530 | 2021-10-26T04:41:18+00:00 | Remember when ISAs were the key to unlocking global human potential for a hot minute https://a16z.com/2019/12/18/solving-student-debt/ was literally one hot minute https://twitter.com/swyx/status/1452857849508294660/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 139] | 1452852967170658304 | 33521530 | swyx | 0 | 0 | 12 | 0 | 0 | 0 | en | |||||||
1454126293943918594 | swyx 33521530 | 2021-10-29T16:41:39+00:00 | @Rich_Harris @nytgraphics what a run, Rich. ๐ ๐ ๐ ๐ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [26, 51] | 1454088761852276749 | 19487837 | Rich_Harris | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1455430112967495685 | swyx 33521530 | 2021-11-02T07:02:34+00:00 | @GergelyOrosz one of mine that people seemed to like recently https://twitter.com/swyx/status/1451309430830612495 | 1451309430830612495 1451309430830612495 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [14, 61] | 1454444182068768769 | 30192824 | GergelyOrosz | 1 | 0 | 12 | 0 | 0 | 0 | en | ||||||
1455787019070701575 | swyx 33521530 | 2021-11-03T06:40:47+00:00 | @BenLesh hmm. want to jump on a @replit, mouth blog it with me and i handle the recording and posting? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 102] | 1455575154818527235 | 23795212 | BenLesh | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1460539625613631488 | swyx 33521530 | 2021-11-16T09:25:56+00:00 | @budibase @sveltejs this video is super potato quality, i'm going to redo this tomorrow morning, sorry for that. anyway just check out the proper video on producthunt: https://www.producthunt.com/posts/budibase | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 193] | 1460536626560438273 | 33521530 | swyx | 0 | 0 | 12 | 0 | 0 | 0 | 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 | |||||||
1466719647504343045 | swyx 33521530 | 2021-12-03T10:43:08+00:00 | @EmilyKager @farazamiruddin this was intensely triggering and i want to send it to every recruiter so we can skip all this | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 122] | 1466488709549674498 | 2347475803 | EmilyKager | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1469113401985011713 | swyx 33521530 | 2021-12-10T01:15:04+00:00 | @dabit3 @jaredpalmer @turborepo @vercel @rauchg forgot to share this footage of rauchg i had in my drafts https://twitter.com/swyx/status/1469113401985011713/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [48, 105] | 1469011087706238976 | 17189394 | dabit3 | 0 | 0 | 12 | 0 | 0 | 0 | en | |||||||
1470833048593698816 | swyx 33521530 | 2021-12-14T19:08:20+00:00 | @auchenberg @vercel MFW they didnโt hire me https://twitter.com/swyx/status/1459249053586255873?s=21 | 1459249053586255873 1459249053586255873 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 67] | 1470829496362094596 | 14810761 | auchenberg | 1 | 0 | 12 | 0 | 0 | 0 | en | ||||||
1473192929414070273 | Nina 1354787371494084612 | 2021-12-21T07:25:39+00:00 | Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "what we're really talking about here is turning fixed costs to variable costs which makes sense for a startup getting off the ground." https://twitter.com/briansowards/status/1472731566732414979 | 1472731566732414979 1472731566732414979 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 255] | 1 | 2 | 12 | 1 | 1 | 0 | en | |||||||||
1473995097205198851 | swyx 33521530 | 2021-12-23T12:33:11+00:00 | @levelsio @IndieHackers @csallen tell the behind the scenes of Rebase! also longtime followers know your post it note productivity system, i believe that can always use wider exposure as its a wake up call for people who habitually overcomplicate their lives | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [33, 259] | 1473993933277601799 | 1577241403 | levelsio | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1428100847712423938 | swyx 33521530 | 2021-08-18T21:05:49+00:00 | ๐๐๐๐๐๐๐๐๐๐ https://twitter.com/swyx/status/1428100847712423938/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 10] | 1428097711383871489 | 33521530 | swyx | 0 | 0 | 12 | 0 | 0 | 0 | und | |||||||
1444781745409179655 | swyx 33521530 | 2021-10-03T21:49:45+00:00 | @threepointone ๐๏ธโ๐๐๏ธ https://twitter.com/swyx/status/1417165280522821632 | 1417165280522821632 1417165280522821632 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 46] | 1444737710116196353 | 1593171 | threepointone | 1 | 0 | 12 | 0 | 0 | 0 | und |
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]);