tweets

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

10 rows where favorited = 0, is_quote_status = 0, retweet_count = 11 and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, created_at (date)

retweeted 1 ✖

retweet_count 1 ✖

is_quote_status 1 ✖

quoted_status 0 ✖

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
1010677126897504256 swyx 33521530 2018-06-24T00:12:59+00:00 Ever wondered what the @gatsbyjs bootstrap output means every time you type `gatsby develop`? I went code spelunking today and wrote them up in this gist: 👉🏼 https://gist.github.com/sw-yx/09306ec03df7b4cd8e7469bb74c078fb 👈🏼 there's a lifecycle chart to be made somewhere here but this is the primary sequence. https://twitter.com/swyx/status/1010677126897504256/photo/1       Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 0 [0, 273]             0 11 72 0 0 0 en  
1346652236378566657 Beyang Liu 16520821 2021-01-06T02:58:07+00:00 Sourcegraph raised a lot of money in 2020 and in 2021, we're putting that to work by investing in features for open-source authors, maintainers, and users. I'd love to hear from folks who have thoughts on how we can better serve open source through our product. Current ideas👇       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276]             0 11 36 0 0   en  
1431061845947805706 swyx 33521530 2021-08-27T01:11:46+00:00 Underrated form of wealth: the Bad Idea Budget. You can afford to make bad decisions if: - you admit them fast - you use this information to improve future decisions - you’ve invested in making them cheaply reversible Small & cheap mistakes > Research & high stakes       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             0 11 105 0 0   en  
1442926717635477504 Hassan El Mghari 3246815913 2021-09-28T18:58:32+00:00 Incredibly excited to announce I've joined @vercel as a Developer Advocate! 🎉 I've been so impressed with Vercel as a company and their focus on great developer experience. Can't wait to contribute and help grow the Next.js and Vercel communities!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 250]             0 11 489 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  
1445373456162381827 swyx 33521530 2021-10-05T13:01:00+00:00 Live footage of what REALLY happened yesterday (h/t @threehourcoffee) https://twitter.com/swyx/status/1445373456162381827/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 70]             0 11 148 0 0 0 en  
1448024106633363456 swyx 33521530 2021-10-12T20:33:44+00:00 This year I've done a total 180 on open source strategy. Remember Elastic making a fuss with "Amazon: NOT OK"? I was quite persuaded. If MongoDB, Redis, Cockroach, Confluent relicensed and do fine, maybe SSPL just becomes acceptable "open source". Now I think MIT is just fine.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 279]             0 11 99 0 0   en  
1457730231301705730 Katie Sylor-Miller 23232640 2021-11-08T15:22:25+00:00 Another great Frontend-focused @Etsy @codeascraft blog post for y'all about how we migrated to Typescript by the amazing @technoheads - this was a massive undertaking to roll out and provide training timelines for engineers. https://codeascraft.com/2021/11/08/etsys-journey-to-typescript/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 248]             0 11 47 0 0 0 en  
1462323377553694722 swyx 33521530 2021-11-21T07:33:56+00:00 ✅ #SvelteSummit🏔️ is a wrap! Huge thank you to @Rich_Harris, @kevmodrome, @antony, @coderinheels, @BrittneyPostma, @rauchg, @rts_rob, our speakers, and thousands of developers who joined us today, both online and in person. What a way to celebrate @Sveltejs' fifth birthday! 🎂 https://twitter.com/swyx/status/1462323377553694722/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 278]             0 11 138 0 0 0 en  
1465635073319849985 swyx 33521530 2021-11-30T10:53:26+00:00 @johnspurlock @eastdakota @QuinnyPig just caught up with this now. audibly LOLed at the idea that the cheapest way to get data out of AWS is to sue them and then get it through discovery 😹       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [37, 188] 1462473358944186370 12961272 johnspurlock       0 11 42 0 0   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]);