tweets
11 rows where favorited = 0, retweet_count = 11 and retweeted = 0
This data as json, CSV (advanced)
Suggested facets: user, source, is_quote_status, created_at (date)
| 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 | ||||||||||
| 1134311153960534016 | Lee Byron 14904098 | 2019-05-31T04:10:28+00:00 | Super curious to see how this works out. Historically I’ve been very skeptical of schema federation and the costs it incurs on an org, so I’m hoping to learn from the community on what works and doesn’t work from this new attempt. https://twitter.com/apollographql/status/1134086759489384449 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 230] | 1 | 11 | 82 | 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
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]);