Live data from Hacker News

Health insurers just published close to a trillion hospital prices

dolthub.com

361–370 of 549 posts

Re: Health insurers just published close to a trillion hospital prices

#361
post #333
post #324

To save anyone else similarly curious the trouble, here's a sample record from the Humana data set: {'REPORTING_ENTITY_NAME': 'Humana Inc', 'REPORTING_ENTITY_TYPE': 'Health Insurance Issuer', 'LAST_UPDATED_ON': '2022-08-24', 'VERSION': '1.0.0', 'NPI': '1629053517,1659354272', 'TIN': '593279318', 'TYPE': 'ein', 'NEGOTIATION_ARRANGEMENT': 'ffs', 'NAME': 'Nasal Prosthesis Replacement See Also Code 21087', 'BILLING_CODE_…

For comparison, here's the first bit of an Anthem file (which contains some of the data that's just another row in the Humana record), along with the first record "reporting_entity_name": "Excellus BlueCross BlueShield", "reporting_entity_type": "Health Insurance Issuer", "last_updated_on": "2022-06-14", "version": "1.0.0", "provider_references": [ { "provider_group_id": 302.1518360704, "location": "https://mrf.healt…

> "negotiation_arrangement": "ffs"

Negotiation arrangement: for fuck’s sake

Re: Health insurers just published close to a trillion hospital prices

#362

Earlier quoted context omitted.

> Singapore which has exceptionally low healthcare spending yea because they have healthy population, its not because of some smart govt policy( if only it was that easy). singapore obesity rate = 10% usa obesity rate = 42 % usa obesity healthcare spend = 90%

My state has a "stupid motorist" law that requires people who negligently put their vehicles in danger and then use state resources to get bailed out, to pay for the rescue themselves. Perhaps we could create a "stupid eater law" for medicare/medicaid, forcing obese people etc to pay for their own private health insurance or healthcare which would free up money for others to buy more healthcare privately (via lower t…

> Perhaps we could create a "stupid eater law" for medicare/medicaid, forcing obese people etc to pay for their own private health insurance

That might be a good idea after we make sure that every single person has equal access to healthy foods and equal ability to afford healthier options. Maybe we could also ban companies from adding HFCS to everything, ban advertising of any unhealthy foods, fine people for not wearing masks or vaccinating their babies, and police what people are allowed to have in their refrigerators so we can punish anyone who has too many unhealthy foods in their home!

Or... maybe we can let doctors and scientists figure out what the best ways to combat the obesity problem are and try to find ways to help people instead of punishing them while in the meantime making sure everyone has access to the care that they need. If we had universal healthcare the costs for your family would the same as everyone else no matter if you or the next person drinks, or smokes, or likes rock climbing, or plays sports, or drives more than x number of miles in a year, or has more than x number of sexual partners, or doesn't exercise at least x number of hours a day and nobody would have to go around spying on everybody to make sure they aren't doing anything that might raise someone else's costs "or else".

Re: Health insurers just published close to a trillion hospital prices

#363

India is considered a "cheap and poor" country in many ways. It's GDP is 1/10th that of United States. Even then, India has free health care, and in many states (out of the 30+ states), Govt run healthcare is the best. Woman give birth to babies and walk out paying almost nothing, men break their bones and walk out paying nothing after a month of staying in hospitals and such. Insurance is never heard of or forced to…

Huh. 8 or 9 years ago I visited somebody in a hospital in rural India (maybe 100km from Hubli), and this was definitely not the case. A man was being ejected (after intake!) from the hospital with acute appendicitis because he and his family was unable to pay. There were probably 3 nurses in the hospital and 40 patients over several floors. The degraded ductwork and disgusting window mount aircon looked like legionnaires disease would kill anybody who could afford to stay.

Has a lot changed in the last decade? Is the “good” healthcare just in wealthier areas? Was this just an extreme outlier?

Obviously, this is just one (anec)datapoint.

Re: Health insurers just published close to a trillion hospital prices

#364
post #350

Earlier quoted context omitted.

This is a peculiar perspective to see on HN. Isn't the entire business model of startups and YC based on ruthlessly "disrupting" industries using efficiency gains achieved through technology, causing the same sort of unemployment? Why should healthcare billing and administration be any different?

Actual founders are maybe 0.1% of the HN reader base. Most everyone else are tech workers not looking to disrupt anything.

I'm mostly interested why the USA suddenly becomes pro-worker when it comes to this expensive and inefficient healthcare system they have. I swear you could be talking to the most hardline GOP guy who wouldn't spit on a trade unionist if they were on fire ... but if you mention, say, single-payer healthcare they'll start weeping for the all the workers in hospitals' billing departments and in health insurance companies who will lose their jobs.

I mean I don't want anyone suffering either (one would hope you'd have adequate social safety net to take care of these people until they find another job) but it's such a bizarre exemption to carve out

Re: Health insurers just published close to a trillion hospital prices

#365
post #233

Earlier quoted context omitted.

Do you consider the amount that the US spends per capita on healthcare relative to other countries for the same standard of care a "failure" of the healthcare industry? Or is there some other reason healthcare "just costs more" here? Also wondering what you think a solution is - single-payer for better and simpler price negotiations, or some other approach? My main concern is if we're spending 20% of GDP on something…

There's many things wrong with US healthcare. But somehow the USA comes up with the the first vaccines for the coronavirus and if you want any sort of complex procedure you travel to the US to get it. So maybe thats where the extra cost goes? To drive research, and support the infrastructure that creates good to better health outcomes on average vs the rest of the world. Saying something is a failure just because it…

On average healthcare outcomes in the US aren’t particularly great compared to other developed countries though (https://www.commonwealthfund.org/publications/issue-briefs/2...).

In particular life expectancy is very low by developed world standards and deaths from preventable causes are very high.

I don’t doubt that the US has world leading hospitals but the population level outcomes delivered are poor by developed world standards.

The US is a net exporter of healthcare services but mostly to developing countries and the numbers involved are tiny (https://www.usitc.gov/publications/332/executive_briefings/c...)

The idea that people who want any sort of complex procedure travel to the US is pure fantasy.

As for the COVID-19 vaccines. The first approved vaccine was the “Pfizer” vaccine developed by BioNTech in Germany (https://en.m.wikipedia.org/wiki/Pfizer–BioNTech_COVID-19_vac...).

Re: Health insurers just published close to a trillion hospital prices

#366

I wonder what percentage of work in the US healthcare system is completely unnecessary from a general perspective but made necessary deliberately to justify the unethical system that allows millions to die unnecessarily.

It's pretty bad probably. It's basically a system that is incentivizing companies to make lots of money where a lot of the checks and balances are misaligned (in some cases intentionally so) which further enables this. So, you have pharmaceutical companies charging extortion rates for products that they sell for next to nothing elsewhere. Insurers that squeeze their patients hard. And hospitals that blindly prescribe medication because the patient demands it because they pay so much money for their insurance. Hospitals don't care because it's not their money and they get to bill the insurer for all sorts of bullshit. Insurers simply raise the prices for their customers. And they can actually cut loose patients over all sorts of technicalities so patients don't complain about this.

Aligning the incentives is pretty hard but not impossible. The Dutch system was facing rising cost a few decades ago. It was split in a private insurance and public insurance system. Privately insured people enjoyed all sorts of perks (like private hospital rooms, less waiting time, etc.). The same system still exists in Germany (I live there currently).

To improve financial efficiency the Dutch government decided to get rid of public insurance and empower people to switch insurance. Everybody has to have insurance, all the insurers are private, and they have to compete to keep people as they can choose to jump to another insurer and they don't get to reject people. They all have to offer the same base package of care to everyone but can choose to diversify on top of that. This results in people shopping around and being treated like customers by insurers.

The second thing they then did was empower insurance companies to make deals with care providers. After all, they are paying the bills and if some hospital is being inefficient, they have to pay for it. They can't reject patients. But they can make deals with certain care providers or refuse to do business with others. This incentives care providers to align with insurers.

Likewise, pharmacies that supply medication are incentivized to look for cheaper alternatives. So, pharmaceuticals end up competing with each other for some things and pharmacies will pick what's cost effective rather than what doctors prescribe (in case of compatible alternatives).

It's not a perfect system but it has resulted in hospitals and insurers improving their game and getting rid of inefficiencies or bad service. Bad insurers lose their customers, inefficient hospitals result in insurers taking their business elsewhere and they suffer financially. Smart hospitals and insurers align what they are doing and avoid needless treatment. Patients and employers shop around for the best insurers based on the needs and means and to get the best rate and care or access to their preferred care providers.

I actually live in Germany which has a system that resembles what things used to look like in the Netherlands. It's a bloated, inefficient system. There's stupid bureaucracy left right and center, endless referrals and waiting lists, and you are treated like cattle. I have private insurance so I get to jump the queue but I also get to deal with doctors that are a bit too trigger happy with treatments and needless appointments that they can squeeze the insurer for. The insurance is super expensive for me. And I can't easily switch insurer so they can squeeze me hard and up their rates. The hospitals are pretty bad and miserable compared to Dutch hospitals.

Re: Health insurers just published close to a trillion hospital prices

#367
post #272

USA Healthcare is 19.5% of GDP. Canada + Australia + UK + (a few similar countries) average 10.5% of GDP. The USA healthcare price gouges via run away prices. Healthcare corporations corrupting congress is the fuel that forces this on people (and breaks a free market).

I’m a Canadian, and I would never want to give up our single payer system. That being said, Canada has a huge health care problem right now. Frequently they need to close emergency services in major (& minor) cities at night due to staff shortages. The wait times for basic diagnostics is on the order of months (not days or weeks). For example, a relative of mine has lost 90 pounds since the start of the year, complai…

Well, I'm here in a major metro area of the US and it's 6 months or more for every doctor I try to see. Very difficult to get in to see anyone for anything.

Re: Health insurers just published close to a trillion hospital prices

#368

Earlier quoted context omitted.

Yes I think that makes sense, to an extent. Maybe not specifically those because they are too hard to measure. But it would be a great way to have people put skin in the game. As a taxpayer paying for others’ healthcare I’d love if they were incentivized to live healthier lives to reduce costs

There are people genetically predisposed to gain weight or have heart disease. Cancer can be Russian roulette, as is your immune system picking up random autoimmune disorders. Accidents happen. There are too many stakeholders with too many backgrounds and conditions for anything like your proposed system to work. Everyone would be angry.

> There are people genetically predisposed to gain weight

And this genetic mutation somehow happened in the last 50-100 years or so? Obese people have always existed. Obese poor people are fairly new. The root cause is diet, not genetics.

Re: Health insurers just published close to a trillion hospital prices

#369
post #3
post #2

Where is the raw 50-100TB of compressed data available for download? Is it fully public or does it require registration to access?

It's all fully public. Here are some tools that will get you the negotiated rates links along with the sizes of all the files: https://github.com/alecstein/transparency-in-coverage-filesi... This won't get you all of the insurers, but it'll get you a a few of the major ones. If you want links to the files of more insurers, here's a project from one of my friends at Postman: https://github.com/postman-open-technologie…

So - veteran data wrangler here. I skimmed some of Humana's files. There's lots of repetition that can easily be removed when converting from a raw input to an analytical dataset - basically the huge blocks of text in "BILL_TYPE_CODE: 130,139,..." in the ADDITIONAL_INFO field can be normalized away by building a quasi-Huffman-encoded lookup table.

Noteworthy(?): there seems to be a limit of ~100~ 140 sets of prices, as seen in the filenames:

2022-08-25_NNN_in-network-rates_0000000XXXXX.csv.gz

~Did I miss something? ... or is this some kind of technical limitation for Humana?~ Edit: I missed the alphabetical ordering. Still, only about 140 price sets.

Also, each plan member's JSON file has a small chunk of useful information, then a useless list of all 15k gz parts of a relevant NN_in-network-rates file (you only need the first filename to figure out which NN to reference).

For these files, you can use Range requests to download only the first, say, 50KB, and pipe it to gunzip and jq. (https://github.com/stedolan/jq/issues/31#issuecomment-900184...)

I would also be interested in helping throw such an analytical dataset into BigQuery. It'll be great for sharing an open dataset. No doubt this will still be a gigantic headache, but it is tractable.

Re: Health insurers just published close to a trillion hospital prices

#370

Earlier quoted context omitted.

What do you think about how Kaiser has handled the whole thing? The insurance company employing the doctors and just paying them a standard salary seems to create all the right incentives.

My experience in talking to people with chronic conditions that aren’t easily treatable is that Kaiser’s model works great until anything that’s slightly out of the ordinary happens, and then it falls apart. If you’re a zebra (as in “when you hear hooves, think horses, not zebras”), their model is pretty horrible.

Sounds like they have intelligently optimized for the common case.
Post reply on HN