tweets
14 rows where "created_at" is on date 2021-09-27 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, created_at, source, is_quote_status, retweet_count, favorite_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 | ||||||||||
| 1442509441643941899 | swyx 33521530 | 2021-09-27T15:20:26+00:00 | RT @JoshWComeau: ✨🥳🎉✨ WE’RE LIVE! After more than a year of full-time work, CSS for JavaScript Developers is completed, and ready to go. 😄… | 1442490764341039111 1442490764341039111 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 453 | 0 | 0 | 1 | en | ||||||||||
| 1442511237036720132 | swyx 33521530 | 2021-09-27T15:27:34+00:00 | @PKodmad @github yay congrats!!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 32] | 1442396149860618242 | 1245747631 | PKodmad | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1442513417248460806 | swyx 33521530 | 2021-09-27T15:36:13+00:00 | @andrewkrisyudha hey! yeah i need to figure out the magic incantations to put into Route53 with @ryan. thanks for the push.. it has been like this for a while because life got busy but i really should tackle this better | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 219] | 1442507319057604612 | 1422210868666769409 | andrewkrisyudha | 0 | 0 | 1 | 0 | 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 | ||||||||||
| 1442580647759912960 | swyx 33521530 | 2021-09-27T20:03:22+00:00 | @derrickreimer only a bad idea if i'm not in it! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 48] | 1442577237241327617 | 28679508 | derrickreimer | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1442580918326026240 | swyx 33521530 | 2021-09-27T20:04:27+00:00 | Dear lazy Twitter, anyone have a good "Take this Slack chat and open an issue in GitHub" workflow/plugin/app to recommend? need to try new ways of tracking bc am dropping stuff | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 178] | 0 | 1 | 25 | 0 | 0 | en | |||||||||||
| 1442581670796804097 | swyx 33521530 | 2021-09-27T20:07:26+00:00 | @ellenchisa @marissamary well that was perfect + fast! ty and proposing internally 🙏 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 84] | 1442581180742881282 | 14620776 | ellenchisa | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1442584581476020231 | swyx 33521530 | 2021-09-27T20:19:00+00:00 | @marissamary @ellenchisa yes ty! i dont want to get your hopes up, someone just suggested this in an internal meeting so am doing due diligence | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 143] | 1442582236860084231 | 34507197 | marissamary | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1442589511142166533 | swyx 33521530 | 2021-09-27T20:38:36+00:00 | @preritayadav welcome and excited to chat with you over the next 4 weeks!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 74] | 1442587377709379584 | 159511130 | preritayadav | 0 | 0 | 1 | 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 | |||||||||
| 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]);