tweets
12 rows where is_quote_status = 1 and retweet_count = 6 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, favorite_count, favorited, retweeted
created_at (date) 10 ✖
- 2021-07-27 2
- 2021-11-17 2
- 2021-08-25 1
- 2021-09-04 1
- 2021-09-27 1
- 2021-10-20 1
- 2021-11-16 1
- 2021-12-04 1
- 2021-12-07 1
- 2021-12-19 1
user 3 ✖
- swyx 10
- Cindy Sridharan 1
- Svelte Society 🧡 1
place 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1420135785987117060 | Cindy Sridharan 161667651 | 2021-07-27T21:35:30+00:00 | Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even if the second edition just had minor typo fixes, I’d buy it and read it all over again! https://twitter.com/JohnOusterhout/status/1420053240717086721 | 1420053240717086721 1420053240717086721 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 207] | 1 | 6 | 86 | 0 | 1 | 0 | en | |||||||||
| 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 | ||||||||||
| 1430388488923324417 | swyx 33521530 | 2021-08-25T04:36:05+00:00 | @mikeal i worked at AWS and supabase is outshipping teams 10x their size and funding. i dont know whats in the water there but @kiwicopple and team have got it. https://twitter.com/swyx/status/1424586713490358275?s=21 | 1424586713490358275 1424586713490358275 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 185] | 1430193529565839368 | 668423 | mikeal | 1 | 6 | 82 | 0 | 0 | 0 | en | ||||||
| 1434237502982815745 | swyx 33521530 | 2021-09-04T19:30:42+00:00 | Update: if you want to try self-provisioning runtimes, these are the top 3 so far: - http://Serverless.com/cloud contact @jeremy_daly and @dougmoscrop - http://CloudCompiler.run contact @AlaShiban - http://Lambdragon.com contact @aldonline All need serious design partners! https://twitter.com/swyx/status/1432864028842356736 | 1432864028842356736 1432864028842356736 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 1 | 6 | 25 | 0 | 0 | 0 | en | |||||||||
| 1442610193846603777 | swyx 33521530 | 2021-09-27T22:00:47+00:00 | "Let user group by business logic instead of force them to fit to your lifecycle method" is still the single most important lesson in API design I've ever learned. Used this exact diagram today in the design of @temporalio's JS SDK and so happy with the result. https://twitter.com/threepointone/status/1056594421079261185 | 1056594421079261185 1056594421079261185 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 262] | 1 | 6 | 77 | 0 | 0 | 0 | en | |||||||||
| 1450740609656901639 | swyx 33521530 | 2021-10-20T08:28:09+00:00 | Signal boost to the interesting work that Nicole and team are doing at Chrome with http://open-ui.org! imagine having alll these built in to the browser, its like Christmas morning https://twitter.com/stubbornella/status/1450702539347750917?s=21 https://twitter.com/swyx/status/1450740609656901639/photo/1 | 1450702539347750917 1450702539347750917 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 210] | 1450406508559101959 | 33521530 | swyx | 1 | 6 | 28 | 0 | 0 | 0 | en | ||||||
| 1460670147799044096 | swyx 33521530 | 2021-11-16T18:04:35+00:00 | Super excited to see @Budibase launch: https://www.producthunt.com/posts/budibase ✅ Low code ✅ SSO+RBAC ✅ Open Source ✅ Mobile friendly ✅ Built with @Sveltejs ✅ Connects with *everything* Why ever handwrite internal tooling again? Used by Amazon, Google, Microsoft, IBM, P&G #ProudInvestor https://twitter.com/budibase/status/1460519255573766147 https://twitter.com/swyx/status/1460670147799044096/video/1 | 1460519255573766147 1460519255573766147 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 302] | 1 | 6 | 27 | 0 | 0 | 0 | en | |||||||||
| 1460785448876331010 | Svelte Society 🧡 1176969867733479424 | 2021-11-17T01:42:45+00:00 | Svelte Summit viewing parties are springing up all over! Organize here or on Discord! NYC 🗽 @swyx Mainz 🇩🇪@einbuhrmi Zagreb 🇭🇷 @letourpowerscombine on Discord Barcelona 🇪🇸@stefanmaric on Discord Chicago 🍕@kennethkunz👇 https://twitter.com/kennethkunz/status/1460725443133415424 | 1460725443133415424 1460725443133415424 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 219] | 1 | 6 | 31 | 1 | 1 | 0 | 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 | ||||||||||
| 1467001291893194753 | swyx 33521530 | 2021-12-04T05:22:18+00:00 | Both @Cloudflare and @Supabase are pioneering a new playbook in launch week marketing — absolutely gobsmacking to watch. Turning followers into fans by creating buzz for devtools launches as intensely as appointment television. The moat: eng + product have to align! https://twitter.com/kiwicopple/status/1466801873373986819 | 1466801873373986819 1466801873373986819 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 268] | 1 | 6 | 99 | 0 | 0 | 0 | en | |||||||||
| 1468156417248923650 | swyx 33521530 | 2021-12-07T09:52:21+00:00 | Excellent answer from @yongfook on why too many people “building an audience first” w/o making anything of substance on @IndieHackers. Like most writers, I also don’t have a problem with the audience first approach. But it’s easy to overdo the “in public” and forget the “build”. https://twitter.com/jakobgreenfeld/status/1468143869426606081 https://twitter.com/swyx/status/1468156417248923650/photo/1 | 1468143869426606081 1468143869426606081 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 304] | 1 | 6 | 35 | 0 | 0 | 0 | en | |||||||||
| 1472495199322624003 | swyx 33521530 | 2021-12-19T09:13:07+00:00 | I am back in Singapore 🇸🇬 Never spending another winter in a cold country again. Come visit when it’s safe, it will change what you think a city can be. https://twitter.com/swyx/status/1137356384796794880 | 1137356384796794880 1137356384796794880 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 154] | 1 | 6 | 433 | 0 | 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]);