tweets
46 rows where "created_at" is on date 2021-08-31 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, display_text_range, in_reply_to_user_id, is_quote_status, retweet_count, favorite_count, retweeted, lang
in_reply_to_screen_name 23 ✖
- swyx 5
- bcomnes 2
- buildsghost 2
- lilyraynyc 2
- zkwentz 2
- AdamRackis 1
- CntrvaslDev 1
- KennethCassel 1
- Prateek_theDev 1
- acemarke 1
- ajcwebdev 1
- jamonholmgren 1
- jdrumgoole 1
- jrhunt 1
- kamalhm 1
- mjwhansen 1
- paulbiggar 1
- phil_renaud 1
- shreyas 1
- simonholdorf 1
- tannerlinsley 1
- tlakomy 1
- xdg 1
user 6 ✖
- swyx 41
- Paul Biggar 1
- Florin Pop 👨🏻💻 1
- David K. 🎹 1
- Jai Bhagat 1
- Magic 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432501072300593162 | Jai Bhagat 896059763129298953 | 2021-08-31T00:30:44+00:00 | Today, I was selected to speak at one of the most important conferences for Ember. I just learned Ember 3 months ago. And I still need someone to pair program with me regularly to get unblocked. @swyx taught me 3 tips for submitting a CFP in @Coding_Career. #ship30for30 https://twitter.com/imShahrukhDon/status/1432501072300593162/photo/1 | Typeshare ad5adbf4b257d939c1b6993f34e2b8463adbbc6c | 0 | [0, 273] | 0 | 3 | 34 | 0 | 1 | 0 | en | ||||||||||
1432502043332120579 | swyx 33521530 | 2021-08-31T00:34:36+00:00 | RT @imShahrukhDon: Today, I was selected to speak at one of the most important conferences for Ember. I just learned Ember 3 months ago. A… | 1432501072300593162 1432501072300593162 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 3 | 0 | 0 | 1 | en | ||||||||||
1432504165440184321 | swyx 33521530 | 2021-08-31T00:43:02+00:00 | @shreyas “Good Enough” is better than “Best”: https://twitter.com/swyx/status/1221129594146840577?s=21 | 1221129594146840577 1221129594146840577 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 70] | 1432501769989357568 | 2048741 | shreyas | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
1432508202050994177 | swyx 33521530 | 2021-08-31T00:59:04+00:00 | Heard some ugly workplace stories today. Lots of things that people can't say out loud, but there's no stronger signal than employees voting with their feet. Departure of any one person isn't concerning, it's the trendline - and whether or not management takes it seriously. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 1 | 51 | 0 | 0 | en | |||||||||||
1432508563398610944 | swyx 33521530 | 2021-08-31T01:00:30+00:00 | @tannerlinsley semi seriously, have you considered building a metaframework again? either competitor to or ontop of nextjs? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 123] | 1432507628559552513 | 50136899 | tannerlinsley | 0 | 0 | 13 | 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 | ||||||||
1432511756962701312 | swyx 33521530 | 2021-08-31T01:13:12+00:00 | @ajcwebdev @tannerlinsley yeah man you have great taste and amazing docs and i think React Query is the wedge into a truly delightful client server paradigm. only thing id warn about is decide on monetisation model early (React Training or Blitz) before going too far but theres real money here | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [26, 294] | 1432510305834201088 | 30723962 | ajcwebdev | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1432533812500578304 | swyx 33521530 | 2021-08-31T02:40:50+00:00 | I confess I wasn't pumped about the @ShangChi movie initially. First Asian Marvel hero and his power is... kung fu? Really thats the best we could do? This trailer singlehandedly changed my mind. @SimuLiu wielding those 10 rings like a #NextLevel badass. https://www.youtube.com/watch?v=EU9q6lb4eKI | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 9 | 0 | 0 | 0 | en | ||||||||||
1432533906360729603 | swyx 33521530 | 2021-08-31T02:41:13+00:00 | @bcomnes YES HAI https://twitter.com/swyx/status/1361712610593316866?s=20 | 1361712610593316866 1361712610593316866 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 40] | 1432533753121935360 | 2149850018 | bcomnes | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
1432536380706410501 | swyx 33521530 | 2021-08-31T02:51:03+00:00 | @shangchi @SimuLiu Marvel was SO SMART to turn these into arm rings. These are the original comic book rings worn by the Mandarin. Cool, but too similar to the Infinity Glove. Turn them into LEVITATING ARM RINGS THO and all sorts of CGI badassery unlocked!!!! WHOSE IDEA WAS THIS https://twitter.com/swyx/status/1432536380706410501/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 282] | 1432533812500578304 | 33521530 | swyx | 0 | 0 | 8 | 0 | 0 | 0 | en | |||||||
1432537201405878273 | swyx 33521530 | 2021-08-31T02:54:18+00:00 | @bcomnes oh man why you make me choose 😹 i read these books literally 2 years apart, i cant compare them! i guess go with 50 lessons cos its newer and plus the book is genuinely a work of art. they both cover approx similar expertise range so cant really go wrong, its more about style | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 286] | 1432534764028940296 | 2149850018 | bcomnes | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432569213688823810 | swyx 33521530 | 2021-08-31T05:01:31+00:00 | Today's clip: @MarkLovesTech's journey to MongoDB, on the excellent StackOverflow podcast https://share.transistor.fm/s/11c1a958 Mark stands out for 2 reasons: He's a relational databases guy that has embraced NoSQL, and he's the rare CTO that's still in LOVE with technology (per his handle)! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 2 | 15 | 0 | 0 | 0 | en | ||||||||||
1432583994441297924 | swyx 33521530 | 2021-08-31T06:00:15+00:00 | Added a new question to my @savvycal_ - Can I record our conversation? Stealing a page from @sytses, I want to share as many of my conversations as possible and it's awkward to ask "can I record this" at the start of the convo. This way, open-minded people can opt in. https://twitter.com/swyx/status/1432583994441297924/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 1 | 19 | 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 | ||||||
1432602694758273025 | swyx 33521530 | 2021-08-31T07:14:33+00:00 | I have the best readers. just got a super thoughtful, 750 word email response to my 1500 word blogpost. and that is one of 3-4 deeply engaged responses that emerged in just the first day. I know I'm on the right track because I'm feeling uncomfortable, yet people are agreeing. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 0 | 67 | 0 | 0 | en | |||||||||||
1432636294555791362 | swyx 33521530 | 2021-08-31T09:28:04+00:00 | @tlakomy actually understanding charts like these and how much youre not doing! https://twitter.com/swyx/status/1423025792783568899 | 1423025792783568899 1423025792783568899 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [9, 79] | 1432420643853713411 | 1903060381 | tlakomy | 1 | 0 | 5 | 0 | 0 | 0 | en | ||||||
1432659604618551296 | David K. 🎹 992126114 | 2021-08-31T11:00:41+00:00 | 🚀 The new @statelyai visualizer is now live on @ProductHunt! You can now visualize, simulate, and inspect your XState machines in one place, and so many more features coming soon. 🔗 http://stately.ai/viz 🐱 https://www.producthunt.com/posts/stately-viz https://twitter.com/DavidKPiano/status/1432659604618551296/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 234] | 0 | 102 | 513 | 0 | 1 | 0 | en | ||||||||||
1432682080912084998 | swyx 33521530 | 2021-08-31T12:30:00+00:00 | So excited to be presenting my latest talk, the Third Age of JavaScript at the @InfobipShift Conference! It will be Europe’s largest Developer conference in 2021 - hope to see you there! Learn more at https://shift.infobip.com/#devconf https://twitter.com/swyx/status/1263123032328925186 https://twitter.com/swyx/status/1432682080912084998/photo/1 | 1263123032328925186 1263123032328925186 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 249] | 1 | 3 | 28 | 0 | 0 | 0 | en | |||||||||
1432689385271664641 | Florin Pop 👨🏻💻 861320851 | 2021-08-31T12:59:02+00:00 | Learning @supabase By Building a Project with @kiwicopple! 🔥 https://youtu.be/_U0c4G5TCWQ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 84] | 0 | 4 | 33 | 0 | 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 | ||||||||||
1432731282706894855 | swyx 33521530 | 2021-08-31T15:45:31+00:00 | @phil_renaud @savvycal_ @sytses good enough for me to tweet about it! haha free month here if u wanna try https://savvycal.com/?r=swyx | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 130] | 1432715653161553922 | 14338766 | phil_renaud | 0 | 0 | 0 | 0 | 0 | 0 | en | |||||||
1432732200273793027 | swyx 33521530 | 2021-08-31T15:49:10+00:00 | @KennethCassel break a leg! also get a fatigue mat, costs like $10 and much better for your feet/standing | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 105] | 1432711585982734337 | 1319269656264409088 | KennethCassel | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432739257978818567 | swyx 33521530 | 2021-08-31T16:17:12+00:00 | @kamalhm @KennethCassel yoga mat works ok, its just not designed to support standing human weight for a long time. i had a folded yoga mat before i had a fatigue mat | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 165] | 1432737995329720320 | 574349200 | kamalhm | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432741932082479111 | swyx 33521530 | 2021-08-31T16:27:50+00:00 | @AdamRackis @buildsghost idk, which flavor of decorator should win? just feels like unnecessary syntax compared to dropping the function into the impl | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 150] | 1432719206269734928 | 68567860 | AdamRackis | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432744748289183749 | swyx 33521530 | 2021-08-31T16:39:01+00:00 | @Prateek_theDev oh yay! that is the goal! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 41] | 1432742651422552064 | 1135710292392972289 | Prateek_theDev | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432760330883514369 | Magic 1221344704811241472 | 2021-08-31T17:40:56+00:00 | 🍿 Awesome ppl to follow to learn about @sveltejs: 🔸 @lihautan, Svelte maintainer & youtuber. 🔸 @swyx, speaks & write about Svelte. 🔸 @steph_dietz_, new Svelte fan & youtuber. 🔸 @spences10, writes about Svelte. 🔸 @Wattenberger, uses Svelte for data visualization. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 13 | 42 | 0 | 1 | en | |||||||||||
1432771300330668036 | swyx 33521530 | 2021-08-31T18:24:32+00:00 | RT @magic_labs: 🍿 Awesome ppl to follow to learn about @sveltejs: 🔸 @lihautan, Svelte maintainer & youtuber. 🔸 @swyx, speaks & write about… | 1432760330883514369 1432760330883514369 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 148] | 0 | 13 | 0 | 0 | 1 | en | ||||||||||
1432785586817953795 | swyx 33521530 | 2021-08-31T19:21:18+00:00 | Tale of two startups: Orchestration engine that distils centuries of distributed systems experience at AWS/Microsoft/Uber • 1,877 Followers over 2 years App that only says "good morning" • 6,000 Followers over 4 days | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 218] | 0 | 16 | 214 | 0 | 0 | en | |||||||||||
1432787641892700161 | swyx 33521530 | 2021-08-31T19:29:28+00:00 | @buildsghost just curious why did you pick the 🍤 emoji? wondering if its a joke im not getting | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 94] | 1432786307969814532 | 1175464650395111424 | buildsghost | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1432787752257409027 | swyx 33521530 | 2021-08-31T19:29:54+00:00 | @simonholdorf 💯 % growth in product roadmap!!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 46] | 1432786356946837513 | 1172079654850744320 | simonholdorf | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1432788499523014658 | swyx 33521530 | 2021-08-31T19:32:52+00:00 | @buildsghost i swear to god if 🍤 shows up in my node_modules i will… be highly entertained | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 90] | 1432787824630063114 | 1175464650395111424 | buildsghost | 0 | 0 | 13 | 0 | 0 | en | ||||||||
1432794852920418304 | swyx 33521530 | 2021-08-31T19:58:07+00:00 | RT @DavidKPiano: 🚀 The new @statelyai visualizer is now live on @ProductHunt! You can now visualize, simulate, and inspect your XState mac… | 1432659604618551296 1432659604618551296 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 102 | 0 | 0 | 1 | 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 | |||||||
1432801885375721472 | swyx 33521530 | 2021-08-31T20:26:04+00:00 | @xdg @jdrumgoole happy to! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 26] | 1432801098658684929 | 20618252 | xdg | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432834280703414273 | swyx 33521530 | 2021-08-31T22:34:47+00:00 | @zkwentz or can you 👀 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 21] | 1432823023304945675 | 378393952 | zkwentz | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432839668794486785 | swyx 33521530 | 2021-08-31T22:56:12+00:00 | @jdrumgoole @xdg @mlynn TIL you have a podcast! yes happy to join too. can schedule in DMs or on email swyx @ temporal . io | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 123] | 1432838808484073475 | 66613 | jdrumgoole | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432842590827671554 | swyx 33521530 | 2021-08-31T23:07:49+00:00 | @lilyraynyc what do we know so far about this update? is there a summary post that i can catch up on? first i am hearing about this 😅 (non SEO here) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 148] | 1432841869646512131 | 29074075 | lilyraynyc | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432843471958593537 | swyx 33521530 | 2021-08-31T23:11:19+00:00 | @lilyraynyc thank you!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 23] | 1432842803088969728 | 29074075 | lilyraynyc | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432848155129704449 | swyx 33521530 | 2021-08-31T23:29:55+00:00 | @zkwentz aye. distribution vs product isnt an either or, good enough distribution has just so many biz models (ads, consulting, courses, workshops) that you can do while you develop a product (that in fact gives you an unfair advantage and unique insights) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 256] | 1432847359722000385 | 378393952 | zkwentz | 0 | 0 | 1 | 0 | 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 | |||||||
1432848799353819138 | swyx 33521530 | 2021-08-31T23:32:29+00:00 | @jrhunt “full stack” https://twitter.com/swyx/status/1432848799353819138/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 20] | 1432821139978403845 | 14157064 | jrhunt | 0 | 1 | 85 | 0 | 0 | 0 | en | |||||||
1432848974902284289 | swyx 33521530 | 2021-08-31T23:33:11+00:00 | @jrhunt “full stack #jamstack” https://twitter.com/swyx/status/1432848974902284289/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 30] | 1432848799353819138 | 33521530 | swyx | 0 | 1 | 24 | 0 | 0 | 0 | en | |||||||
1432853966979670016 | swyx 33521530 | 2021-08-31T23:53:01+00:00 | @paulbiggar thank you for the shoutout! @darklang was a big aha moment in terms of provisioning - if its on the canvas, it's there! You can code against it and everything! instantly made me feel like all the setup and glue code I had used was so clunky. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 253] | 1432719949575905289 | 86938585 | paulbiggar | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432504895735681031 | swyx 33521530 | 2021-08-31T00:45:56+00:00 | @mjwhansen https://twitter.com/swyx/status/1432504895735681031/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 10] | 1432343494614523908 | 21612095 | mjwhansen | 0 | 0 | 21 | 0 | 0 | 0 | und | |||||||
1432796518281453570 | swyx 33521530 | 2021-08-31T20:04:44+00:00 | @CntrvaslDev it's @temporalio ! https://twitter.com/swyx/status/1417165270641045505 | 1417165270641045505 1417165270641045505 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 56] | 1432791593396936704 | 930727203876364289 | CntrvaslDev | 1 | 0 | 0 | 0 | 0 | 0 | und | ||||||
1432801930175156226 | swyx 33521530 | 2021-08-31T20:26:14+00:00 | @acemarke bro | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 13] | 1432801733802070025 | 727704217012604928 | acemarke | 0 | 0 | 1 | 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]);