tweets
24 rows where "created_at" is on date 2021-08-17, is_quote_status = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, retweet_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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
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]);