tweets
4 rows where favorite_count = 51 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, retweet_count
created_at (date) 4 ✖
- 2021-01-09 1
- 2021-08-31 1
- 2021-10-26 1
- 2021-11-26 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1348027297912082433 | swyx 33521530 | 2021-01-09T22:02:07+00:00 | 🆕 Blog: What Drives Optimal Overhead? https://www.swyx.io/optimal-overhead/ We're often advised to "Slow down to speed up". But *how much* slowdown is too much? 5%? 50%? How does it differ between human and machine systems? An exploration of optimal and tolerable overhead. https://twitter.com/swyx/status/1348027297912082433/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 265] | 0 | 9 | 51 | 0 | 0 | 0 | en | ||||||||||
1432508202050994177 | swyx 33521530 | 2021-08-31T00:59:04+00:00 | Heard some ugly workplace stories today. Lots of things that people can't say out loud, but there's no stronger signal than employees voting with their feet. Departure of any one person isn't concerning, it's the trendline - and whether or not management takes it seriously. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 1 | 51 | 0 | 0 | en | |||||||||||
1452822595649212416 | swyx 33521530 | 2021-10-26T02:21:13+00:00 | @techgirl1908 I'm not opposed to web3, but I think that greed has seduced many to worship Digital Scarcity like it is the second coming. They forget that Digital Abundance - the open source, positive sum nature of web2 (yes, with serious flaws) - embodies the best of human generosity. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 287] | 1452811729470201858 | 2932738834 | techgirl1908 | 0 | 1 | 51 | 0 | 0 | en | ||||||||
1464293076948635655 | Execute Program 1192893578214641664 | 2021-11-26T18:00:49+00:00 | Execute Program is on sale through Nov 30! 40% off the first year for individual subscriptions (including the new yearly billing option). Eight highly interactive programming language courses, including the most comprehensive TypeScript courses available. https://www.executeprogram.com | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 279] | 0 | 15 | 51 | 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]);