tweets
38 rows where display_text_range = "[0, 280]", lang = "en", source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" and user = 33521530 sorted by lang
This data as json, CSV (advanced)
Suggested facets: is_quote_status, retweet_count, favorite_count, favorited
created_at (date) 33 ✖
- 2021-08-18 2
- 2021-08-31 2
- 2021-09-23 2
- 2021-10-05 2
- 2021-11-25 2
- 2020-07-11 1
- 2020-07-18 1
- 2021-07-27 1
- 2021-07-28 1
- 2021-08-02 1
- 2021-08-04 1
- 2021-08-07 1
- 2021-08-08 1
- 2021-08-20 1
- 2021-09-03 1
- 2021-09-04 1
- 2021-09-09 1
- 2021-09-11 1
- 2021-09-24 1
- 2021-10-03 1
- 2021-10-06 1
- 2021-10-20 1
- 2021-10-23 1
- 2021-10-31 1
- 2021-11-01 1
- 2021-11-03 1
- 2021-11-04 1
- 2021-11-10 1
- 2021-11-27 1
- 2021-11-28 1
- 2021-12-03 1
- 2021-12-14 1
- 2021-12-26 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1281896981049356288 | swyx 33521530 | 2020-07-11T10:23:51+00:00 | I admire the initiative behind https://tooling.report so much! - included maintainers of each tool - filed issues for every issue found - sensitive to nuances per tool - comparable across tools an instant classic piece of web advocacy I will be thinking about for years to come https://twitter.com/jaffathecake/status/1281290340746567680 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 4 | 32 | 0 | 0 | 0 | en | ||||||||||
1284597930398105600 | swyx 33521530 | 2020-07-18T21:16:27+00:00 | The primary beneficiary of you being #1 on Product Hunt is Product Hunt. The primary beneficiary of you being Employee of the Month is your Employer. The primary beneficiary of you going viral on Twitter is Twitter. Youre surprised *everything* around you is designed this way? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1284596781779767297 | 33521530 | swyx | 0 | 14 | 136 | 0 | 0 | en | ||||||||
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 | |||||||
1420477145969618946 | swyx 33521530 | 2021-07-28T20:11:57+00:00 | My opinion: you want standard comp (cash/stock) up to ~150k, THEN you want options. Why? TAXES. esp with 83b election. Give yourself a ~40% raise with this ONE WEIRD TRICK! You know how you should be critical of tech advice from online? Goes double for devs talking finance :) https://twitter.com/cassidoo/status/1420423346727051268 | 1420423346727051268 1420423346727051268 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 0 | 46 | 0 | 0 | 0 | en | |||||||||
1422041713187586048 | swyx 33521530 | 2021-08-02T03:48:59+00:00 | Open secret many content creators don't appreciate: Your content has a half life and the average varies by platform. My estimates: Twitter: 1-24 hours YouTube: Weeks-Months Blog: Years Your luck surface area grows as a factor of your still-relevant content. Create accordingly. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 7 | 168 | 0 | 0 | en | |||||||||||
1422998593158275073 | swyx 33521530 | 2021-08-04T19:11:17+00:00 | "Calling In will be, to the digital age human rights movement in the 21st century, what non-violence was to the civil rights movement in the 20th century." An incredible explanation of the way out of the "Calling Out" culture that so pervades our society. https://www.youtube.com/watch?v=xw_720iQDss | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 5 | 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 | |||||||||
1424180543009148932 | swyx 33521530 | 2021-08-08T01:27:56+00:00 | The problem with assessing advice in the form of "What worked for $bigname", or hiring pple who "ran $bigname from small to big": Absolutely NOBODY is incentivized to tell the full story. So little critical thinking (myself incl), it's like success is an off switch for the brain. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 27 | 0 | 0 | en | |||||||||||
1428048895850942471 | swyx 33521530 | 2021-08-18T17:39:23+00:00 | Advice for coworker new to @savvycal_: There's an unspoken etiquette to scheduling links. It can seem rude as it requires the other side to fit to your schedule Preempt it: “I’d be happy to book a meeting if you have a calendar link, or I can send you mine” and link if hypertext | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 19 | 0 | 0 | en | |||||||||||
1428067590920761349 | swyx 33521530 | 2021-08-18T18:53:40+00:00 | PSA: I'm noticing a rise in unsolicited emails from @Github email scraping recently. This was the most egregious one so far. looked like a GitHub link but was actually a phishing site. https://github.com/medusajs/medusa/issues/344 I should know better than clicking on links in emails but i'm a chump https://twitter.com/swyx/status/1428067590920761349/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 26 | 0 | 0 | 0 | en | ||||||||||
1428861510164520960 | swyx 33521530 | 2021-08-20T23:28:25+00:00 | I got Gigabit internet ("up to 1000 Mbps") and TIL how much antennae affect internet speeds as measured by fast.com: Plugged in Ethernet: 780mbps iPad on 5G: 200mbps iPhone on 5G: 120mbps iPad on 2G: 80mbps iPhone on 2G: 60mbps | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 47 | 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 | ||||||||||
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 | ||||||||||
1433716826660167680 | swyx 33521530 | 2021-09-03T09:01:43+00:00 | Aug 2021: 126k views, 28k uniques Exactly one hit post on Measuring DevRel: https://mobile.twitter.com/swyx/status/1427351638872772633 The world seems to want me to write more about DevRel, which I struggle with bc I'm not thaat much of an expert and I have mixed feelings about the career path. Tweets way down. https://twitter.com/swyx/status/1433716826660167680/photo/1 | 1427351638872772633 1427351638872772633 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1422264774327300097 | 33521530 | swyx | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
1434183926868635648 | swyx 33521530 | 2021-09-04T15:57:48+00:00 | Just got a preview of @IncredibleDevHQ from @jerriclynsjohn. If you want an integrated, collaborative platform for dev video content, hit him up for a demo! Related tools in dev/video space: @loom, @TellaHQ, @mmhmmapp, @replayio, @usebubbles, @GetShareX, @birdeatsbug, @iterspace https://twitter.com/swyx/status/1434183926868635648/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 6 | 26 | 0 | 0 | 0 | en | ||||||||||
1435793597870321674 | swyx 33521530 | 2021-09-09T02:34:04+00:00 | Today' clip: React Native's Near Death Experience, according to @Vjeux! https://share.transistor.fm/s/ee467824 I was surprised to learn on the @sourcegraph podcast that the initial impl of Facebook Photos with RN flopped! Sometimes entire industries pivot by the decisions of a few key people. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1435387866079694849 | 33521530 | swyx | 0 | 1 | 7 | 0 | 0 | 0 | en | |||||||
1436628297039982592 | swyx 33521530 | 2021-09-11T09:50:51+00:00 | Incredible discussion of platform economics and YouTube optimization by @veritasium: https://www.youtube.com/watch?v=S2xHZPH5Sng Non-obvious conflict: subscriptions (follows) vs recommendations (feed). Every ad supported platform wants to maximize time on site, which means the feed eventually wins. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 3 | 29 | 0 | 0 | 0 | en | ||||||||||
1441147744991596544 | swyx 33521530 | 2021-09-23T21:09:32+00:00 | Just saying I'm floored by the quality of connections that I've made here. Struggling to keep up with everyone getting in touch about the book/podcast/Temporal! I do pay it fwd too. If I can help you out w a quick answer or blogpost, my email is in bio. Will eventually respond!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 63 | 0 | 0 | en | |||||||||||
1441190031939420174 | swyx 33521530 | 2021-09-23T23:57:34+00:00 | Seeking opinions - when should a startup hire its first "data person"? (not data scientist; just someone who gets data fed into one place, proactively find insights, and make it easy for others to dig up their own) whats a good milestone? B round? # employees? # "data sources"? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 50 | 0 | 0 | en | |||||||||||
1441436065680609282 | swyx 33521530 | 2021-09-24T16:15:13+00:00 | accounts grow ofc - thats the power of SaaS - but i do feel like the market should *pull* you into a barbell than intentionally pursue it.. bc the cognitive dissonance on marketing, product, eng, docs, support etc is huge basically building two companies with one shared codebase | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1441436063923195905 | 33521530 | swyx | 0 | 0 | 15 | 0 | 0 | en | ||||||||
1444560899797176321 | swyx 33521530 | 2021-10-03T07:12:11+00:00 | Unsolicited compliment: I am enjoying watching along how @9ranty is building his Loom competitor in public. Lots of little gems and the video result looks great! Worth checking out http://tella.tv Am not a regular user yet but #BuildInPublic updates keep me interested. https://twitter.com/TellaHQ/status/1443129037854019589 | 1443129037854019589 1443129037854019589 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 0 | 14 | 0 | 0 | 0 | en | |||||||||
1445236122112561157 | swyx 33521530 | 2021-10-05T03:55:17+00:00 | In 2020 I thought I had given my last @reactjs talk, said all I had to say. Smash cut and here I am prepping for @ReactNewYork conf, framing @Temporalio as React for the backend! (not the actual tagline, just a talk title) Tickets are free: https://reactnewyork.com/ See you tmr! https://twitter.com/swyx/status/1445236122112561157/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 3 | 32 | 0 | 0 | 0 | en | ||||||||||
1445299225974095877 | swyx 33521530 | 2021-10-05T08:06:02+00:00 | Here's @Spolsky explaining how hard it was to write the Amazon One Click Buy button, because it turned a sync shopping cart experience into an async timer-based model: https://youtu.be/-QqIyICyXbU UX is often improved by async, but infra + complexity means people dont do it.. til now https://twitter.com/swyx/status/1445299225974095877/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1443024483170729989 | 33521530 | swyx | 0 | 11 | 70 | 0 | 0 | 0 | en | |||||||
1445566889598480394 | swyx 33521530 | 2021-10-06T01:49:38+00:00 | Today's mixtape is a little offbeat - the incredible story of how Howie Mandel said no to a last-choice opportunity three times, but listened to his wife and gave it a shot. Deal or No Deal got 100m viewers in its first week. From @theTigerBelly podcast: https://share.transistor.fm/s/564b46ba | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 2 | 0 | 0 | 0 | en | ||||||||||
1450650773805670405 | swyx 33521530 | 2021-10-20T02:31:10+00:00 | Working on my first @temporalio tutorial video.. I think I figured out how to: - start from an empty folder - cover every core feature: - Workflows - Workers - Retries - Durable Timers - Signals - in 30 mins Any @Nodejs devs want to preview for feedback? DM for link | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 58 | 0 | 0 | en | |||||||||||
1452024977499115520 | swyx 33521530 | 2021-10-23T21:31:46+00:00 | Loving this breakdown of terrible executives and why they happen from @Steve_Yegge: https://www.youtube.com/watch?v=jUtUAc_ew9Y&list=PLZfuUWMTtMcC1DZF6HxJhqsGrBXu8Jzi7&index=14 I was chatting with an exec years after some bad decisions in a previous company. The mistakes were obvious to employees, but nobody ever bothered to ask us. Still stings. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 8 | 0 | 0 | 0 | en | ||||||||||
1454710611539943424 | swyx 33521530 | 2021-10-31T07:23:31+00:00 | Before I attempt the last tutorial I'm checking out a few tips and tricks videos to see what I'm doing suboptimally and there's a LOT! man, tutorial was good but I was doing so much manually that they could've just told me outright... this is the best one https://www.youtube.com/watch?v=zS4YFApM8q4 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1454613301736837120 | 33521530 | swyx | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1455012914620813321 | swyx 33521530 | 2021-11-01T03:24:46+00:00 | for those brave enough: I needed to mass update "0.11.x" to "0.13.x" in https://github.com/temporalio/samples-typescript/pull/44#issuecomment-955878051 Where I gave up: find . -name "package.json" -not -path "*/node_modules/*" | xargs grep -lr -e "temporalio" | xargs -0 sed -i '' -e 's/"temporalio": "0.11.x"/"temporalio": "0.13.x"/g' | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1455007382577115142 | 33521530 | swyx | 0 | 0 | 13 | 0 | 0 | 0 | en | |||||||
1455798483517001734 | swyx 33521530 | 2021-11-03T07:26:20+00:00 | Recently I clipped @Steve_Yegge's podcast talking about the Xbox One disaster (https://swyx.transistor.fm/episodes/xbox-one-and-bad-execs-steve-yegge) and @jertype sent me this video underlining how off-tone execs were: https://www.youtube.com/watch?v=KbWgUO-Rqcw This comment was super insightful: be careful of who you poll vs who leads polls! https://twitter.com/swyx/status/1455798483517001734/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 4 | 0 | 0 | 0 | en | ||||||||||
1456392977819987968 | swyx 33521530 | 2021-11-04T22:48:39+00:00 | Just finalized my 7th angel investment of the year :) Funding environment is super frothy and I ain't rich yet but its so cool and flattering to be able to help founders get their thing off the ground. Running the devtools-angels community def made this a less solitary exercise. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 1 | 96 | 0 | 0 | en | |||||||||||
1458241442883653641 | swyx 33521530 | 2021-11-10T01:13:47+00:00 | Excellent read as usual by @Eugenewei: https://www.eugenewei.com/blog/2021/9/29/and-you-will-know-us-by-the-company-we-keep Elements of Offensive Graph Design - Social capital vs Entertainment vs Utility: Pick 2 - Social network to solve cold start - Interest network to solve churn - To build: pruners, filters, recommenders, collaboration https://twitter.com/swyx/status/1458241442883653641/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 17 | 0 | 0 | 0 | en | ||||||||||
1463987461978144769 | swyx 33521530 | 2021-11-25T21:46:25+00:00 | Just saved $1000 over 2 years. I'm trading in my old iPhone for new hotness and finally did the math. Carrier trade-ins always seemed appealing (on both environmental and cost angles) until I really looked into it. TL;DR: switch to MVNO's like @Mintmobile, trade in with Apple! https://twitter.com/swyx/status/1463987461978144769/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 11 | 0 | 0 | 0 | en | ||||||||||
1464009618460274739 | swyx 33521530 | 2021-11-25T23:14:27+00:00 | Sure, this is a reason to be thankful, but also just reminded me that if there is another huge solar flare from the Sun I am about 8.3 minutes from certain doom... https://dynomight.net/thanks/ how do we prep against solar flares? - water? - canned food? - backup generators? - books? https://twitter.com/swyx/status/1464009618460274739/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 21 | 0 | 0 | 0 | en | ||||||||||
1464691627423776768 | swyx 33521530 | 2021-11-27T20:24:31+00:00 | Making some moves to declutter my apartment. Been using @Clutter for the past ~6 years. Did some price checks for this round - its 30% *cheaper* than the self storage 2 blocks from me and does modular pickup/dropoff! $100 off with my referral code FKC7DH https://www.clutter.com/r/t/d?code=FKC7DH https://twitter.com/swyx/status/1464691627423776768/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 8 | 0 | 0 | 0 | en | ||||||||||
1464881717672493059 | swyx 33521530 | 2021-11-28T08:59:52+00:00 | Love these Hashicorp bulletpoints from @afc: - 100m OSS downloads, X00,000's users - 2.1k customers, 140k ACV, 124% NDR - revenue is 77% support, 16% licensing - 700 partners, 170 ISVs - margins great, rev growth is🚩 - Small custs & HCP is the future https://www.meritechcapital.com/blog/hashicorp-ipo-s-1-breakdown https://twitter.com/swyx/status/1464881717672493059/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1441436065680609282 | 33521530 | swyx | 0 | 1 | 13 | 0 | 0 | 0 | en | |||||||
1466641806007812098 | swyx 33521530 | 2021-12-03T05:33:50+00:00 | I think I have a memory leak on my machine. It slows down more and more every single day I let it "sleep" instead of shutting down. This is the first time it's been so obvious but I dont know the cause since its been slowly deteriorating. Any tips for identifying memory leaks? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 0 | 32 | 1 | 0 | en | |||||||||||
1470864435015151618 | swyx 33521530 | 2021-12-14T21:13:03+00:00 | Excited to chat with @beyang on the @Sourcegraph podcast! https://about.sourcegraph.com/podcast/swyx/ We covered: - Career change and #LearnInPublic - Helping Junior devs go Senior with @Coding_Career - @Reactjs and @Netlify - Developer community - Category creation - @Temporalio - API Economy! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 0 | 7 | 23 | 0 | 0 | 0 | en | ||||||||||
1475112373283598346 | swyx 33521530 | 2021-12-26T14:32:50+00:00 | For those who understand optionality, there's also an implicit life career strategy involved here: 1. go for high luck careers first to try your luck 2. try a few high talent careers to discover if you have it 3. fall back to high hard work careers as they're available to anyone | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1475105975518765063 | 33521530 | swyx | 0 | 2 | 49 | 0 | 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]);