tweets
22 rows where "created_at" is on date 2021-09-08, retweet_count = 0 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, lang
quoted_status 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1435470169774698497 | swyx 33521530 | 2021-09-08T05:08:52+00:00 | @amasad more like RepsOfIt amirite | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 34] | 1435425996853813252 | 166138615 | amasad | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435471481266388993 | swyx 33521530 | 2021-09-08T05:14:05+00:00 | Brian makes good points here about where we want provisioning to be implicit vs explicit: we definitely dont want typos to drop db’s but ironically i do raise Begin Data as a form of implicit provisioning of DB https://twitter.com/brianleroux/status/1435324306238619649 | 1435324306238619649 1435324306238619649 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 211] | 1433939106459885570 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1435473821490950144 | swyx 33521530 | 2021-09-08T05:23:23+00:00 | @ritakozlov_ oh amazing! always wondered how people do this. idk if this is feedback or not but calling it “vanity domains” trivialized a fairly important feature for me. if i ran a hosting platform, id want every user of mine to run on their own domain, own their own destiny. not vanity. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 290] | 1435228859897679878 | 232076816 | ritakozlov_ | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1435479820964614146 | swyx 33521530 | 2021-09-08T05:47:13+00:00 | @anthonynsimon wheew. congrats! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 31] | 1435338483791507458 | 3356542414 | anthonynsimon | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435486802152939521 | swyx 33521530 | 2021-09-08T06:14:58+00:00 | @aninferiorcoder @QwikDev webdev is an infinite rabbit hole 😂 but dont feel FOMO, you dont need to know everything to be successful | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 131] | 1435251911200935937 | 1407203188877402120 | aninferiorcoder | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1435533758648696839 | swyx 33521530 | 2021-09-08T09:21:33+00:00 | @DPritchett @Swizec @hillelogram Dunning Kruger strikes again! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [33, 62] | 1435355969052155905 | 14163251 | DPritchett | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435534540081074177 | swyx 33521530 | 2021-09-08T09:24:39+00:00 | @kwuchu not to shill or anything but… haaaaaave you met http://temporal.io? https://twitter.com/mitchellh/status/1316510643030114304?s=21 | 1316510643030114304 1316510643030114304 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 104] | 1435270987298246663 | 291911739 | kwuchu | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1435591576949035016 | swyx 33521530 | 2021-09-08T13:11:18+00:00 | @loujaybee - OKRs and what metrics work - % time allocation between blog and youtube and conferences and what else? - the single most effective decision you made in the entire 2 years | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 183] | 1435569066886979586 | 1290693397 | loujaybee | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1435609189284450314 | swyx 33521530 | 2021-09-08T14:21:17+00:00 | @JackMiddlebrook @worrydream thanks Jack! hey i miss our @Coding_Career hangouts, hope Singapore/Shopee life is good! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 117] | 1435557288765394944 | 247418281 | JackMiddlebrook | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1435611112846790659 | swyx 33521530 | 2021-09-08T14:28:56+00:00 | @wongmjane where edit button tho | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 32] | 1435325281212907521 | 337119125 | wongmjane | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1435611250323599368 | swyx 33521530 | 2021-09-08T14:29:29+00:00 | @mjwhansen what beast, i just see rug | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 37] | 1435591831471988740 | 21612095 | mjwhansen | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1435729110232403971 | swyx 33521530 | 2021-09-08T22:17:49+00:00 | @getupnext @readwiseio nice work 👏! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 35] | 1435697205235445761 | 1306704425654915073 | getupnext | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435746322506780682 | swyx 33521530 | 2021-09-08T23:26:12+00:00 | @timdorr @DotProto can somebody um… lock this down? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 51] | 1435602941621243907 | 4145801 | timdorr | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1435748951014223874 | swyx 33521530 | 2021-09-08T23:36:39+00:00 | @DotProto @timdorr there are two vulnerable constituencies here: users (security), and authors (spam) and one aggressor: extension buyers the extreme asymmetry here suggests we can do something that minorly inconveniences buyers but improves protections for the other two | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 273] | 1435747545926365184 | 380741910 | dotproto | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435749807025541123 | swyx 33521530 | 2021-09-08T23:40:03+00:00 | @DotProto @timdorr example: extensions require formal notice to users on transferral of ownership? if you like, limit security features to extensions >1m users for implementation purposes | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 192] | 1435748951014223874 | 33521530 | swyx | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435750019093651460 | swyx 33521530 | 2021-09-08T23:40:54+00:00 | @DotProto @timdorr whatever the policy, playing this out a few turns you're basically having to choose between doing this now proactively or being forced to do it from social pressure reactively after a high profile pwning. i'm hopeful that smart folks at Google can figure this one out! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 288] | 1435749807025541123 | 33521530 | swyx | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1435751222644981760 | swyx 33521530 | 2021-09-08T23:45:41+00:00 | @DotProto @timdorr build automatic notification into chrome itself? "ownership has changed", please review here btw i know this is a sensitive issue that your team needs to think through, perhaps discuss with other major app store teams, but i just hope y'all are brainstorming all the ideas. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 293] | 1435750262207959042 | 380741910 | dotproto | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1435751957386387462 | swyx 33521530 | 2021-09-08T23:48:36+00:00 | @DotProto @timdorr yes the path for small personal projects could be smoothed out more, but perhaps ALSO the rules change over some user limit. no reason same process should apply regardless of user size. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 204] | 1435750724357410816 | 380741910 | dotproto | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435752162911563781 | swyx 33521530 | 2021-09-08T23:49:25+00:00 | @DotProto @timdorr as for how much pain is acceptable: pretend you just woke up and the @NYtimes H1 headline is "1.3 million developers hacked via Chrome extension" and you are being called before Congress. what do? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 217] | 1435751957386387462 | 33521530 | swyx | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1435753681098616832 | swyx 33521530 | 2021-09-08T23:55:27+00:00 | @DotProto @timdorr @nytimes i know man and sympathies for that. dont wanna put you on the spot any more than i already have. but this sort of thing does keep me up at night and i hope theres constant brainstorming and innovating to match the scale of this responsibility that no other app store on earth has. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 308] | 1435752789720793089 | 380741910 | dotproto | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1435469480780607492 | swyx 33521530 | 2021-09-08T05:06:08+00:00 | @shanselman https://twitter.com/swyx/status/1435469480780607492/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 11] | 1435446014631047168 | 5676102 | shanselman | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1435475005358358534 | swyx 33521530 | 2021-09-08T05:28:05+00:00 | @Sawtaytoes @mhevery @QwikDev @InfobipShift https://twitter.com/swyx/status/1435223333398843397 | 1435223333398843397 1435223333398843397 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [44, 67] | 1435425890075385858 | 3168000442 | Sawtaytoes | 1 | 0 | 1 | 0 | 0 | 0 | und |
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]);