tweets
6 rows where "created_at" is on date 2021-09-27 and possibly_sensitive = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, created_at, source, is_quote_status, retweet_count, retweeted
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1442310363681378312 | swyx 33521530 | 2021-09-27T02:09:22+00:00 | 🔥 Just pushed my new @Revue newsletter! “[http://swyx.io] YouTube Podcasting - good idea, or bad idea?” https://www.getrevue.co/profile/swyx/archive/317891 | Revue e01d36c55a12ec4cf389049ec42665dce335b54e | 0 | [0, 137] | 0 | 0 | 12 | 0 | 0 | 0 | en | ||||||||||
1442490764341039111 | Josh W. Comeau 2308474213 | 2021-09-27T14:06:13+00:00 | ✨🥳🎉✨ WE’RE LIVE! After more than a year of full-time work, CSS for JavaScript Developers is completed, and ready to go. 😄 Learn more: 👉 https://css-for-js.dev/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 162] | 0 | 453 | 2190 | 0 | 1 | 0 | en | ||||||||||
1442528022385479682 | swyx 33521530 | 2021-09-27T16:34:16+00:00 | God bless people who leave this kind of @GitHub comment, you know who you are https://twitter.com/swyx/status/1442528022385479682/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 77] | 0 | 17 | 477 | 0 | 0 | 0 | en | ||||||||||
1442537833495990278 | Gergely Orosz 30192824 | 2021-09-27T17:13:15+00:00 | A month into a paid newsletter for eng managers/engineers, it's taking off faster than I ever hoped: ~ 500 paid subscribers (thank you!) ~ 15,000 free subscribers ~ $62K ARR - A top 10 @SubstackInc technology newsletter Here's what I learned and advice on writing/newsletters 👇 https://twitter.com/GergelyOrosz/status/1442537833495990278/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 0 | 33 | 582 | 0 | 1 | 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 | |||||||||
1442610195339776004 | swyx 33521530 | 2021-09-27T22:00:47+00:00 | If the only thing you learned from React is React, look harder: https://twitter.com/swyx/status/1383516418205835264?lang=en | 1383516418205835264 1383516418205835264 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 88] | 1442610193846603777 | 33521530 | swyx | 1 | 0 | 16 | 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]);