tweets
13 rows where favorited = 1, retweet_count = 2 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952"
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, favorite_count, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1453508738241814533 | swyx 33521530 | 2021-10-27T23:47:42+00:00 | For Developer Experience peeps: I met @Silassao at KubeCon recently and he was thinking thru a lot of the same problems at @DataStax. We had a recorded conversation today about how we're using feature mapping to harmonize the DX for @Temporalio! https://youtu.be/ddKDPikKbNk | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 272] | 0 | 2 | 11 | 1 | 0 | 0 | en | ||||||||||
| 1456915351241990145 | Lou ☁️ 👨💻🏋️♂️🎸🚴🏻♂️🏍 1290693397 | 2021-11-06T09:24:22+00:00 | In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tech it feels natural to write "beginner content" or sometimes meta-content (content about content—wait, that's *this thread* 😱 😆) https://www.swyx.io/meta-creator-ceiling/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 1456915349639680008 | 1290693397 | loujaybee | 0 | 2 | 6 | 1 | 1 | 0 | en | |||||||
| 1457466032365445120 | Zev Averbach 38199764 | 2021-11-07T21:52:35+00:00 | gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, but the value he crams into these 10-minute episodes is 🔥 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 183] | 0 | 2 | 13 | 1 | 1 | 0 | en | ||||||||||
| 1457471762258546691 | swyx 33521530 | 2021-11-07T22:15:21+00:00 | RT @zevav: gratitude to @swyx for his excellent, usually bite-sized podcast: https://swyx.transistor.fm/ always amazed by his prolificity, bu… | 1457466032365445120 1457466032365445120 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | 0 | en | |||||||||
| 1457803089230974983 | Changelog 90286855 | 2021-11-08T20:11:55+00:00 | 📢 We had @swyx on The Changelog! 1️⃣ Why learn in public 2️⃣ The dark side of the #API economy 3️⃣ @Cloudflare's Go game vs @awscloud's Chess 4️⃣ The #frontend pay ceiling & his move to the back 5️⃣ What @temporalio is about This is a good one! http://changelog.fm/467 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 274] | 0 | 2 | 7 | 1 | 1 | 0 | en | ||||||||||
| 1457804131762991104 | swyx 33521530 | 2021-11-08T20:16:04+00:00 | RT @changelog: 📢 We had @swyx on The Changelog! 1️⃣ Why learn in public 2️⃣ The dark side of the #API economy 3️⃣ @Cloudflare's Go game vs… | 1457803089230974983 1457803089230974983 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
| 1459667585272713218 | swyx 33521530 | 2021-11-13T23:40:46+00:00 | 🗽 Just booked a giant AirBnB for next week's NYC Svelte Summit (https://lu.ma/sveltenyc)! If any out of towners are considering flying in for #SvelteSummit, we have 1-2 beds left in the SvelteShack. DM to join! If you're local and interested in the future of the Web, join us: | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 0 | 2 | 33 | 1 | 0 | 0 | en | ||||||||||
| 1461748429764239361 | Andrew Culver 11467732 | 2021-11-19T17:29:18+00:00 | Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @swyx's recent post which I think is one of the most important things written in software development in the last ten years. https://twitter.com/andrewculver/status/1461748429764239361/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 242] | 1461746021306830852 | 11467732 | andrewculver | 0 | 2 | 10 | 1 | 1 | 0 | en | |||||||
| 1461750746072899586 | swyx 33521530 | 2021-11-19T17:38:30+00:00 | RT @andrewculver: Ooh, I had already forgotten: One of my favorite parts of this article is that it gave me an opportunity to highlight @sw… | 1461748429764239361 1461748429764239361 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
| 1462110266536124425 | Pier 1360839410 | 2021-11-20T17:27:06+00:00 | @sveltejs @vercel @Rich_Harris @rauchg @steph_dietz from Vercel just said publicly: "Svelte is the future of web development" 🔥🔥🔥🔥🔥🔥🔥 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [39, 135] | 1462108361621745664 | 1360839410 | PierB | 0 | 2 | 16 | 1 | 1 | en | ||||||||
| 1462128820325077003 | swyx 33521530 | 2021-11-20T18:40:50+00:00 | RT @maiertech: Dream team @Rich_Harris and @rauchg at #SvelteSummit NYC. https://twitter.com/maiertech/status/1462123489914245121/photo/1 | 1462123489914245121 1462123489914245121 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 96] | 0 | 2 | 0 | 1 | 1 | 0 | en | |||||||||
| 1462128832266313736 | swyx 33521530 | 2021-11-20T18:40:53+00:00 | RT @PierB: @sveltejs @vercel @Rich_Harris @rauchg @steph_dietz from Vercel just said publicly: "Svelte is the future of web development"… | 1462110266536124425 1462110266536124425 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 138] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
| 1470487534132154378 | Jason Laster 312750384 | 2021-12-13T20:15:23+00:00 | This week is bug report week at http://Replay.io. DM or reply directly if you’re part of the support loop. It doesn't matter if you're technically support, success, product, qa, leadership, or dev, if you care about quality, we want to talk to you! 🐛👋 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 260] | 0 | 2 | 4 | 1 | 1 | 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]);