Live data from Hacker News

Health insurers just published close to a trillion hospital prices

dolthub.com

11–20 of 549 posts

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

#11
post #7

Anyone else get the feeling this is malicious compliance on behalf of the insurance companies? "Oh, they're going to force us to publish our prices are they? Well we'll publish so much data it'll take a herculean effort to make it readable to anyone that doesn't work in data engineering"

The article mentioned CSV files, it seems more like a reflection of what a huge bureaucracy the US healthcare system is. I liked their suggestion that the government should have created the database as part of the law, done the processing on the raw data, and made it more accessible.

meh, I'd prefer the raw data. We can always create DBs out of the raw data, we can always link data. Handling this after the fact would be impossible.

Linking a few trillion records doesn't seem that difficult. It should be doable with a good data warehouse and a reasonable entity linking model. I suspect that we'll find more than a few instances of fraudulent behavior once the data is linked.

My father was nearly pushed into ~2 Million dollars worth of brain surgery that was unnecessary. Not only was the procedure unnecessary, the price for it was >5X what a top-3 hospital would have charged. I only became privy to this once I pushed him to come to Mass General Hospital (MGH) for a second opinion. The surgeon we saw at MGH also believed the suggested procedure to be dangerous.

I wonder if it's possible to cross-reference mortality/complication rates with prices...

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

#12
post #10

Seems like every week there's a new massive scale DB project or company getting announced on HN. If they're looking for projects that create public value and demonstrate the power of their products at scale, digitizing this and making it searchable may be a good marketing project that's appealing to certain kinds of customers.

Figuring out the size of this data was part of the research phase for doing just that: building out that database. I'm curious to know if other people are already working on it (maybe Turquoise Health?)

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!

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

#13

Anyone else get the feeling this is malicious compliance on behalf of the insurance companies? "Oh, they're going to force us to publish our prices are they? Well we'll publish so much data it'll take a herculean effort to make it readable to anyone that doesn't work in data engineering"

Oh totally. It also probably is the formats they already had -- so they just dumped them into a file -- versus making something more orthogonal and ergonomic.

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

#16
post #10

Earlier quoted context omitted.

Figuring out the size of this data was part of the research phase for doing just that: building out that database. I'm curious to know if other people are already working on it (maybe Turquoise Health?)

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!

Is that from the hospital side or the insurer side?

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

#17

Anyone else get the feeling this is malicious compliance on behalf of the insurance companies? "Oh, they're going to force us to publish our prices are they? Well we'll publish so much data it'll take a herculean effort to make it readable to anyone that doesn't work in data engineering"

Oh totally. It also probably is the formats they already had -- so they just dumped them into a file -- versus making something more orthogonal and ergonomic.

I'm not sure what format they store their records in, but I have a hunch it's a lot more structured than what we see in the CSV files. The data dumps have to comply with some CMS guidelines set out here: https://github.com/CMSgov/price-transparency-guide

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

#19

Say someone ingests this data and clean it up make it usable, who's the customer for that service? What would they want to know from it?

I want to be able to visit a website, select my hospital, the procedure, and my insurance, and see what it will cost. Next to the result, please show me how much the same procedure would cost with the same insurance at other hospitals near my location.

You will literally save American lives.

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

#20
post #16

Earlier quoted context omitted.

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!

Is that from the hospital side or the insurer side?

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