tweets
12 rows where "created_at" is on date 2021-09-27 and is_quote_status = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, 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 |
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]);