tweets

This is data scraped from swyx's timeline! See blog post

24 rows where "created_at" is on date 2021-09-08

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, created_at (date)

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
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  
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  
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  
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  
1435528913560682499 swyx 33521530 2021-09-08T09:02:18+00:00 Still the best tech talk I've ever seen. “The most dangerous thought that you can have as a creative person is to think that you know what you’re doing." — @worrydream https://www.youtube.com/watch?v=8pTEmbeENF4 https://twitter.com/swyx/status/1435528913560682499/video/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 195]             0 95 507 0 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  
1435602941621243907 Tim 🚪 4145801 2021-09-08T13:56:28+00:00 I think $130m sounds about right for selling out the privacy and security of 1.3m Redux DevTools users? https://twitter.com/timdorr/status/1435602941621243907/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 103]             0 3 150 0 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  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);