tweets

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

40 rows where favorite_count = 0, is_quote_status = 1 and retweeted = 1 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, favorited, created_at (date)

retweet_count 22 ✖

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
1420136685472342016 swyx 33521530 2021-07-27T21:39:05+00:00 RT @copyconstruct: Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even… 1420135785987117060 1420135785987117060     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             1 6 0 0 1   en  
1421277387413606403 swyx 33521530 2021-07-31T01:11:49+00:00 RT @jhooks: a couple of years ago @swyx asked us what our big hairy audacious goal was... this is still my answer I am super motivated to… 1421273039648399364 1421273039648399364     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1426606285269602308 swyx 33521530 2021-08-14T18:06:58+00:00 RT @mipsytipsy: Ever wondered what columnar databases are, or peered skeptically at my claim that you basically can't have observability wi… 1426405785832095749 1426405785832095749     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 43 0 0 1   en  
1427393308997783602 swyx 33521530 2021-08-16T22:14:19+00:00 RT @andyhattemer: Lots of great info in this post! @swyx categorizes devrel programs into "Community", "Content" and "Product". For me, he… 1427370301495652354 1427370301495652354     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 1 0 0 1   en  
1428402450839457800 swyx 33521530 2021-08-19T17:04:17+00:00 RT @beyang: Super happy that a lot of these efforts are now well under way. Especially excited about indexing the entire world of open sour… 1428402268550754304 1428402268550754304     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 4 0 0 1   en  
1434242885893844992 swyx 33521530 2021-09-04T19:52:05+00:00 RT @SvelteSociety: Svelte Summit Fall 2021 is happening on November 20th! CFPs are open as well! 1434106223721426945 1434106223721426945     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 96]             1 11 0 0 1   en  
1434287058596597762 swyx 33521530 2021-09-04T22:47:37+00:00 RT @pullara: Let me get this straight... @jhuber had the GENIUS idea to buy @YouTube, debated internally for a bit, got pushback... ...… 1433880742682112001 1433880742682112001     TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 140]             1 12 0 0 1   en  
1434928945774972931 swyx 33521530 2021-09-06T17:18:15+00:00 RT @ryanatkn: as @sveltejs passes 50k GitHub stars, here's the https://is.gd/artmachine AI interpreting "sveltejs space elevator", a 🚀 metap… 1434918776462585856 1434918776462585856     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 4 0 0 1 0 en  
1436214579705569283 swyx 33521530 2021-09-10T06:26:54+00:00 RT @kiwicopple: Less than 2 years ago I met @AntWilson in a coffee shop to brainstorm an open source company that could delight developers.… 1436145598772625462 1436145598772625462     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 25 0 0 1   en  
1438094706555097089 swyx 33521530 2021-09-15T10:57:51+00:00 RT @cyberdees: Q: Engineers — you've always wanted to time travel, right? A: Now you can. When debugging w/ @ReplayIO. Crafted by @jason… 1438052380227117076 1438052380227117076     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 9 0 0 1   en  
1439026846549495812 swyx 33521530 2021-09-18T00:41:50+00:00 RT @swyx: How @Temporalio Works: 1. Write async code with SDK 2. Temporal Server handles queues, timers, retries, timeouts, heartbeats. Ch… 1438939235801653249 1438939235801653249     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 12 0 0 1   en  
1439976474623234050 swyx 33521530 2021-09-20T15:35:19+00:00 RT @tannerlinsley: "GraphQL helps solve the overfetching problem. In practice, I think the importance of this is overhyped unless you are F… 1439976152995545090 1439976152995545090     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 29 0 0 1   en  
1441072853168840705 swyx 33521530 2021-09-23T16:11:56+00:00 RT @brianleroux: This in no way assuaged my overall skepticism but super appreciate the hype-free honesty of the current state of "web3". M… 1441062360811143175 1441062360811143175     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 0 1   en  
1441519278235082753 swyx 33521530 2021-09-24T21:45:52+00:00 RT @simonw: This right here is why I've invested so much of my career learning (and building) tools that enable really rapid prototyping I… 1441502655021387790 1441502655021387790     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 15 0 0 1   en  
1445537727131176967 swyx 33521530 2021-10-05T23:53:45+00:00 RT @ritakozlov_: A+ write up from @swyx. the great thing about “from the outside in” metaphor is that it works figuratively and literally —… 1445533835945414662 1445533835945414662     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1445565723502264331 swyx 33521530 2021-10-06T01:45:00+00:00 RT @kristoferbaxter: Some of the best writing in our industry comes from @swyx. This is yet another great read. 1445564661965807617 1445564661965807617     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 111]             1 1 0 0 1   en  
1447731092144869376 swyx 33521530 2021-10-12T01:09:24+00:00 RT @patio11: Understanding difference between O(N^2) vs. O(n) is indistinguishable from magic at least some of the time, like all good tech… 1447414882081521665 1447414882081521665     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 145 0 0 1   en  
1449105641797128192 swyx 33521530 2021-10-15T20:11:22+00:00 RT @ChibuzorObilom: I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 2… 1449103297839763459 1449103297839763459     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   en  
1449117060265492481 swyx 33521530 2021-10-15T20:56:45+00:00 RT @threepointone: Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you liter… 1449112317917110276 1449112317917110276     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 0 1   en  
1450203732956758016 swyx 33521530 2021-10-18T20:54:48+00:00 RT @GatsbyJS: "The following is my conversation with @AbhiAiyer and @wardpeet, two lead engineers behind Gatsby Cloud and the recently anno… 1450202214664921088 1450202214664921088     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 5 0 0 1   en  
1450404185153757189 swyx 33521530 2021-10-19T10:11:19+00:00 RT @ascorbic: This is a really interesting discussion on Gatsby and the state of the Jamstack ecosystem and I agree with most of it. Worth… 1450403609078898694 1450403609078898694     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 139]             1 7 0 0 1   en  
1451392641598255110 swyx 33521530 2021-10-22T03:39:05+00:00 RT @dan_abramov: Wouldn’t it be cool if React Docs were written with Hooks first, had interactive examples and challenges, API diagrams, an… 1451349199082213378 1451349199082213378     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 152 0 1 1   en  
1452683398254714880 swyx 33521530 2021-10-25T17:08:06+00:00 RT @kentcdodds: This is similar to my attitude toward content creation. I choose the topics I choose primarily because I want to. This is… 1452479329686876163 1452479329686876163     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 139]             1 1 0 1 1   en  
1453538330176413704 swyx 33521530 2021-10-28T01:45:18+00:00 RT @seldo: I don't think enough has been made of the discovery that Google's funding of AMP was an explicitly anti-competitive move designe… 1453377986791575552 1453377986791575552     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 353 0 1 1   en  
1455263219027628034 swyx 33521530 2021-11-01T19:59:23+00:00 RT @hillelogram: Other examples are preemptive pluralization (https://twitter.com/swyx/status/1370513317379280897) and preemptive pagination. Not always the right choi… 1455261914297249798 1455261914297249798     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 3 0 1 1 0 en  
1457037645570199555 swyx 33521530 2021-11-06T17:30:19+00:00 RT @swyx: I had a wonderful time talking through this blogpost with @adamstac and @jerodsanto on The Changelog! Life achievement unlocked ✅… 1456712851104559105 1456712851104559105     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 5 0 1 1   en  
1460327694801850368 swyx 33521530 2021-11-15T19:23:48+00:00 RT @Rich_Harris: for the @brooklyn_js family, this is taking place at the event space right next to 61 local. this saturday, 12-4pm it's s… 1460291937412521997 1460291937412521997     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 11 0 1 1   en  
1460785490282483718 swyx 33521530 2021-11-17T01:42:55+00:00 RT @SvelteSociety: Svelte Summit viewing parties are springing up all over! Organize here or on Discord! NYC 🗽 @swyx Mainz 🇩🇪@einbuhrmi Z… 1460785448876331010 1460785448876331010     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 6 0 1 1   en  
1462854647891197954 swyx 33521530 2021-11-22T18:45:01+00:00 RT @ronvoluted: "Productivity through Product Focus" by Reddit's @volanStudio is about to begin! Tune in: https://youtube.com/watch?v=0g0BQex8fyo and joi… 1462840959427772418 1462840959427772418     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 1 1 0 en  
1463618402841284609 swyx 33521530 2021-11-24T21:19:54+00:00 RT @Rich_Harris: adding facebook to the "who uses svelte" list :) 1463612706867630097 1463612706867630097     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 65]             1 72 0 1 1   en  
1463692023278358534 swyx 33521530 2021-11-25T02:12:27+00:00 RT @swyx: TIL you can use object destructuring on an *array* to get at its properties... and immediately use them in an index with `[ ]` no… 1172604337366941697 1172604337366941697     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 336 0 0 1   en  
1464320734533017600 swyx 33521530 2021-11-26T19:50:43+00:00 RT @adamwathan: Execute Program is way too under the radar for how good it is. If they have a course on something, it is the best way to le… 1464316615453986818 1464316615453986818     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 8 0 1 1   en  
1465823027497607171 swyx 33521530 2021-11-30T23:20:18+00:00 RT @thomaspaulmann: Today is a big day for @raycastapp! We're thrilled to announce our $15m Series A and release our Extensions Store and A… 1465601156449804290 1465601156449804290     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 8 0 1 1   en  
1466847530872762370 swyx 33521530 2021-12-03T19:11:18+00:00 RT @corecursive: A great list to be a part of! 🏆 1466846573078487043 1466846573078487043     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 48]             1 3 0 1 1   en  
1467343666473623557 swyx 33521530 2021-12-05T04:02:46+00:00 RT @swyx: 🎙️ My latest podcast is with @argyleink! *Complexity Cliffs, DX, and the Disruption of Web Design* https://www.youtube.com/watch?v=xEyJ6LY7DKI - U… 1467304180003917824 1467304180003917824     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 14 0 1 1 0 en  
1467347814686416898 swyx 33521530 2021-12-05T04:19:15+00:00 RT @acemarke: I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thor… 1467343720936792071 1467343720936792071     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 5 0 1 1   en  
1469801943019110401 swyx 33521530 2021-12-11T22:51:05+00:00 RT @JoshWComeau: I had a bill recently go from $20/month to $660/month because I exceeded a magic threshold. My actual usage increased mayb… 1469313115598860293 1469313115598860293     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 4 0 1 1   en  
1470900644055711747 swyx 33521530 2021-12-14T23:36:56+00:00 RT @beyang: The amazing thing about @swyx is he got into programming not too long ago after making a big career pivot from finance. It's aw… 1470874194283884545 1470874194283884545     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             1 1 0 1 1   en  
1471290912856690691 swyx 33521530 2021-12-16T01:27:43+00:00 RT @stubbornella: Utility classes: I'm not in a mood to be erased today. I was experimenting with utility classes in large production sites… 1471213109767405568 1471213109767405568     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 135 0 1 1   en  
1473206717403959297 swyx 33521530 2021-12-21T08:20:26+00:00 RT @Nina_Ledid: Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "wh… 1473192929414070273 1473192929414070273     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 2 0 1 1   en  

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