Hacker News new | past | comments | ask | show | jobs | submit login

Yep, we have built this database at Turquoise Health. I agree, the data is massive - and don't forget that it is all refreshed monthly!



It's cool seeing that Turqoise Health exists. One of my first programming projects back in the day (when I was trying to get a jr role in 2014) involved building a simple version based on data.gov medicare data. The inputs were terrible and tiny (e.g. chest pain at hospital X costs ~$60k on average across 5 patients), so I was always curious what a real world version might look like.

edit: As I reflect, I'm amused to recall that this was early enough in my path that I didn't know about DB indexes, so I was very proud that I figured out how to basically roll my own indexes by pre-sorting the columns by lat and lon. I don't remember whether my solution actually prevented a full-table scan, but it felt like a major breakthrough at the time.


Is that from the hospital side or the insurer side?


We have built databases for both and can compare between them.


It’s my understanding these prices are negotiated to some degree, so it’s probably both sides at various times.




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: