tweets

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

25 rows where "created_at" is on date 2021-08-17 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count

favorite_count 9 ✖

retweeted 2 ✖

  • 0 23
  • 1 2

source 1 ✖

  • Twitter for iPhone · 25 ✖

created_at (date) 1 ✖

  • 2021-08-17 · 25 ✖
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
1427432110860554241 swyx 33521530 2021-08-17T00:48:30+00:00 @emilywithcurls wtf, @reddit has now removed the ability to view single posts on mobile web without downloading their app. transition to full evil complete. https://twitter.com/swyx/status/1427432110860554241/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 156] 1427394837318447113 402502573 emilywithcurls       0 0 3 0 0 0 en  
1427442268064030730 swyx 33521530 2021-08-17T01:28:51+00:00 The @Official_GDC breakdowns of how they made the game are a must watch btw. So, so much work went into the traversal algorithm, simulation, and polish of making Spider-man swing across New York, trading off physics with user intent. https://youtu.be/OEaGEaCUq3g       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 258] 1422416105226657792 33521530 swyx       0 0 3 0 0 0 en  
1427457113463300106 swyx 33521530 2021-08-17T02:27:51+00:00 Are we stuck with 5 star rating systems forever? A single irate customer can total someone’s livelihood with a 1 and there’s no meaningful difference between a 4.6 and a 4.7. Is anyone working on a viable alternative to the tyranny of Black Mirror style rating systems?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 270]             0 6 130 0 0   en  
1427458108637421615 swyx 33521530 2021-08-17T02:31:48+00:00 @virtualkirill mockup for elaboration?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 38] 1427457921449824258 212923731 virtualkirill       0 0 0 0 0   en  
1427460022284419073 Marcelo Alves 🐙 13451662 2021-08-17T02:39:24+00:00 @swyx I’m just waiting for sites to implement the 5/7 perfect score https://www.dictionary.com/e/memes/5-7/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 91] 1427457113463300106 33521530 swyx       0 0 2 0 0 0 en  
1427461696734449666 swyx 33521530 2021-08-17T02:46:04+00:00 @MathCrln right, some people really treat 3 as “normal” and others wont give anything less than a 5, need to give guidelines to norm everyone. then again theyd probably ignore it unless you make it in-your-face       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 212] 1427459133419229189 369219338 MathCrln       0 0 4 0 0   en  
1427461947327324160 swyx 33521530 2021-08-17T02:47:03+00:00 @Daniel0x6019 problem is its not normally distributed, its usually bimodal heavily skewed to 5 because people try to be nice       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 124] 1427460340879695873 1048895989095063552 Daniel0x6019       0 0 2 0 0   en  
1427463880695975941 swyx 33521530 2021-08-17T02:54:44+00:00 @mike_hasarms @Daniel0x6019 drivers is one thing but there are thousands of restaurants with truly very widely varying quality and mere dozens of reviews. ditto amazon sellers and airbnb hosts       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 192] 1427462671503298568 123131219 mike_hasarms       0 0 1 0 0   en  
1427465816300163077 swyx 33521530 2021-08-17T03:02:26+00:00 @preetster this is a great chart :) nice way to sum it all up. didnt model bicameral voting where your vote can count 3-4x more based on what state you live in 😉 also can frame capitalism as the least worst form of economic organization because it is in effect univariate score voting https://twitter.com/swyx/status/1427465816300163077/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 286] 1427463168201089030 16343912 preetster       0 0 3 0 0 0 en  
1427466290923409410 swyx 33521530 2021-08-17T03:04:19+00:00 @mike_hasarms @Daniel0x6019 whats in my mind https://twitter.com/swyx/status/1427466290923409410/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 44] 1427465581293309953 123131219 mike_hasarms       0 0 4 0 0 0 en  
1427484616772833292 swyx 33521530 2021-08-17T04:17:08+00:00 @jeanqasaur @mhkeller oh wow this is overwhelmingly awesome @mhkeller!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 70] 1427470272035057667 271516623 jeanqasaur       0 0 2 0 0   en  
1427547007745335300 swyx 33521530 2021-08-17T08:25:03+00:00 @leeerob congrats! long time coming. question: is this a de facto new standard and can other ecosystem projects like storybook, docusaurus, gastby etc opt in to this via some sort of webpack config?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 198] 1427344453367443459 81712767 leeerob       0 0 1 0 0   en  
1427547450735165440 swyx 33521530 2021-08-17T08:26:49+00:00 @Nutlope i fear not the man who has read 1000 books. i fear the man who has read 1 book 1000 times.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 99] 1427470046343925760 3246815913 Nutlope       0 0 10 0 0   en  
1427636024881074195 swyx 33521530 2021-08-17T14:18:47+00:00 RT @RabbiGreenberg: This post by @swyx should be mandatory reading for anyone trying to think through how to measure effectively the bit am… 1427618325232771076 1427618325232771076     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 5 0 0 1   en  
1427636302325981188 swyx 33521530 2021-08-17T14:19:53+00:00 RT @jim_ej: Brilliant talk brought to me by @swyx: https://swyx.transistor.fm/episodes/weekend-drop-what-we-know-we-dont-know-hillel-wayne. What we know about coding based on evidence. TDD is no better t… 1427577933074505728 1427577933074505728     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 2 0 0 1 0 en  
1427640108950466570 swyx 33521530 2021-08-17T14:35:00+00:00 @peggyrayzis woww huge! congrats to you and your team!!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 56] 1427625528031387652 711729626482081792 peggyrayzis       0 0 1 0 0   en  
1427640343034482704 swyx 33521530 2021-08-17T14:35:56+00:00 @fortelabs i thought this might have been a Succession parody       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 61] 1427357032609304587 1909232666 fortelabs       0 0 7 0 0   en  
1427644236472766468 swyx 33521530 2021-08-17T14:51:24+00:00 Apollo becomes the first GraphQL devtool unicorn, 10 years after graduating from YC as Meteor. Huge validation step for those who bet on Apollo, but curiously no mention of commercial offerings in this blogpost. How does @apollographql make money and any estimates how much? 👀 https://twitter.com/apollographql/status/1427616423824797698   1427616423824797698 1427616423824797698   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 278]             1 18 185 0 0 0 en  
1427736439316307969 swyx 33521530 2021-08-17T20:57:47+00:00 @juzbo @apollographql in a way its just trivia, though it’d make for an inspiring story of perservering through challenges       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 122] 1427680891548098564 13256302 juzbo       0 0 1 0 0   en  
1427737083339186177 swyx 33521530 2021-08-17T21:00:21+00:00 @rstacruz @marckohlbrugge i could’ve sworn this used to be fully built out! did you change it somehow?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 102] 1427594190515367938 9513832 rstacruz       0 0 0 0 0   en  
1427766366191316997 swyx 33521530 2021-08-17T22:56:42+00:00 @StartuptoLast sorry to see you end but it was great while it lasted! thank you and enjoy the new job!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 102] 1427757070397411331 1154528612554399745 StartuptoLast       0 0 2 0 0   en  
1427770886912761856 swyx 33521530 2021-08-17T23:14:40+00:00 @texastoland @alanmynah @sindreaars @scrimba the first language of the web is html. imba is clearly a great solution for scrimba but to go for mass adoption it will face the same challenges Elm did. (fuly aware i may eat my words here so what do i know)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [45, 254] 1427768524794056704 1003839292773367810 texastoland       0 0 2 0 0   en  
1427773012577701889 swyx 33521530 2021-08-17T23:23:07+00:00 @0xca0a where do i look up info on their proposal or info? this is unfamiliar syntax to me       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 90] 1427732215732051973 835209520200699909 0xca0a       0 0 2 0 0   en  
1427775806223257600 swyx 33521530 2021-08-17T23:34:13+00:00 @clemmihai and doing it so well 👏 you make it look easy even tho i know it couldnt be easy. come so far from your @fullstack days!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 130] 1427732369876807687 4796832195 clemmihai       0 0 4 0 0   en  
1427776791762984967 swyx 33521530 2021-08-17T23:38:08+00:00 @EugeneNg_VCap ambition and vision is good and all but i really wish he had talked about serving customers or community instead of being so fixated on valuation. down that path lies a lot of corpses of companies ruined by giant egos putting money over people.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 259] 1427734201017589763 915576521129041920 EugeneNg_VCap       0 0 4 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]);