34 ms·
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!
by ageitgey 4y ago
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!
- JackFr 4y agoIs that from the hospital side or the insurer side?
- withinboredom 4y agoIt’s my understanding these prices are negotiated to some degree, so it’s probably both sides at various times.
- ageitgey 4y agoWe have built databases for both and can compare between them.
- jamestimmins 4y agoIt'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.