Health insurers just published close to a trillion hospital prices

NDJSON? Sqlite?

My understanding (not an expert by any means) is that we basically have two tiers of negotiation - the fed. govt. has way more leverage but also some amount of corruption that goes into pricing, then afterwards individual hospitals and "networks" of providers will negotiate with the insurer - sometimes after the procedure has already happened - to figure out the final price.

The end result is that you might end up with an individual doctor having to work with the insurance company for pricing, so the same procedure can cost vastly different amounts at hospitals down the road from each other providing the same level of care. To make it worse we also have laws preventing healthcare providers from providing prices upfront, out of a fear that people will forego necessary care they can't afford.

Edit: seems like this changed 01-01-2021, now we do have some price transparency laws - https://www.cms.gov/hospital-price-transparency

> The US pays about twice per nurse or doctor in the system, and part of that is because the US pays nearly twice for most skilled work.

which is in turn because in the US an average GP comes out of medical school with $200k-300k of student debt that has to have interest serviced and paid off within some 10-20 year timespan. That cost ultimately ends up being borne by the patient and their insurance.

unfortunately the US is very resistant to the idea of education reform in general, very very resistant to student debt relief, and very very very resistant to student debt relief for "high earners" like doctors and lawyers, even when a huge chunk of that earn is going to debt service. But there is a shortage of doctors and we're doing everything in our power to make the path unattractive for new students. And this time the problem isn't even the AMA - the AMA agrees there is a problem and is onboard with expanding the pipeline... it's just not all that attractive a profession anymore when you can make equal/higher compensation (after considering the debt) in software or other fields.

doctors are still extremely well-paid professionals in other countries, but if we tackle the cost of education we can get our numbers down much closer to theirs. conversely if you push salaries too low then servicing $200-300k of student debt won't be realistic and the path becomes even less attractive.

medical care is probably the single most complex political problem in the US because it's basically at the nexus of every single social and political problem we have. doctors are too expensive... because they're trucking around a quarter million of student loan debt from our shitty education system. we spend way too much on end-of-life care and not enough on earlier care... because seniors vote. we have way too much overhead due to the multi-payer insurance system and the market-driven pricing system's overheads... and all those insurance companies are huge lobbyists too. Drug and device costs are out of control... because the US doesn't allow conditioning of regulatory approval on price negotiations, or reimportation from other countries, etc. It's just every single political problem in the US in a single field all at once and every hand is dipping into the till as much as they can get away with, and it's politically infeasible to slap the hands that are necessary to slap to actually get costs reduced.

Sounds like an application for ML, to determine which codes frequently coincide per-patient at each provider and then assign those groupings to cross-provider "Treatment XYZ" buckets to enable apples-to-apples comparisons.

My current assumption is that private healthcare/insurance is to blame, because countries without that or with less generally have better outcomes at less cost. Looking for evidence to the contrary