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