tweets
9 rows where favorite_count = 10 and is_quote_status = 1 sorted by truncated
This data as json, CSV (advanced)
Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, retweet_count
created_at (date) 9 ✖
- 2021-08-03 1
- 2021-08-08 1
- 2021-08-13 1
- 2021-08-18 1
- 2021-09-07 1
- 2021-09-15 1
- 2021-10-12 1
- 2021-11-28 1
- 2021-12-16 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1422642885162242048 | swyx 33521530 | 2021-08-03T19:37:49+00:00 | Holy shit. @Sveltejs rocketed to the top of the @StackOverflow survey this year (and I wasnt even aware of the survey so I didnt vote/promote it) https://twitter.com/SvelteSociety/status/1422372693827985409 | 1422372693827985409 1422372693827985409 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 145] | 1414617653386178563 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1424199362024931328 | swyx 33521530 | 2021-08-08T02:42:42+00:00 | i really like the “Name Evaluation” and “Happy Idiot” sections of this guide. https://twitter.com/swyx/status/1424198548720029698 https://twitter.com/swyx/status/1424199362024931328/photo/1 | 1424198548720029698 1424198548720029698 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 101] | 1383881255264034820 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1426327484316884992 | swyx 33521530 | 2021-08-13T23:39:06+00:00 | @chantastic 🙌🏽 my writeup ICYMI https://twitter.com/swyx/status/1221586490674696193?s=20 | 1221586490674696193 1221586490674696193 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 56] | 1426318522242588675 | 12745092 | chantastic | 1 | 1 | 10 | 0 | 0 | 0 | en | ||||||
1428094708899745793 | swyx 33521530 | 2021-08-18T20:41:25+00:00 | 2 years on... nice explanation and discussion of JWTs here, and I pretty much am exactly where Emelia is at https://twitter.com/ThisIsMissEm/status/1427988073292476418?s=20 | 1427988073292476418 1427988073292476418 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 132] | 1133780714988736512 | 33521530 | swyx | 1 | 1 | 10 | 0 | 0 | 0 | en | ||||||
1435223333398843397 | swyx 33521530 | 2021-09-07T12:48:02+00:00 | sorry for my shitty photos - lighting not great and my phone is pretty old. read his @QwikDev intro blogpost series if you are interested in his take - it really is sufficiently different than existing paradigms that it is worth a look. https://twitter.com/mhevery/status/1415436174685089793?s=20 | 1415436174685089793 1415436174685089793 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 263] | 1435218549946073092 | 33521530 | swyx | 1 | 1 | 10 | 0 | 0 | 0 | en | ||||||
1438226292566937602 | swyx 33521530 | 2021-09-15T19:40:43+00:00 | In the two years since this first post, I've written a couple other pieces for those curious in following the thread: Why I Enjoy Svelte: https://twitter.com/swyx/status/1221586490674696193?lang=en Svelte for Sites, React for Apps: https://twitter.com/swyx/status/1317635707838496768?lang=en | 1317635707838496768 1317635707838496768 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 221] | 1172926476045492230 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1448040791629185025 | swyx 33521530 | 2021-10-12T21:40:02+00:00 | Now the hard question: Could Amazon host Temporal as a service? Yes. Just like Hashicorp does (https://twitter.com/mitchellh/status/1316510643030114304?s=20), or Stripe (come learn more at our Nov meetup http://temporal.io/meetup), or {REDACTED_BIGCORP}, in a long tradition that goes back to our origins at Uber. | 1316510643030114304 1316510643030114304 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 274] | 1448027264289959938 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1465098064411037699 | swyx 33521530 | 2021-11-28T23:19:33+00:00 | @lennysan for the skeptics, i spent some time looking into drivers of “optimal overhead” https://twitter.com/swyx/status/1348027297912082433?s=21 | 1348027297912082433 1348027297912082433 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 112] | 1465019740905107456 | 7958322 | lennysan | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
1471580713946214402 | swyx 33521530 | 2021-12-16T20:39:17+00:00 | an unqualified, low effort “it depends” isn’t wisdom. it’s lazy and nihilistic. here’s how to give a great “it depends”: https://twitter.com/swyx/status/1100275989622505472 | 1100275989622505472 1100275989622505472 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 121] | 1202207460292988929 | 33521530 | swyx | 1 | 2 | 10 | 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]);