sl-dolt

https://www.dolthub.com/repositories/dolthub/hospital-prices...

A limitation of our dataset is it excludes percentage-based contracts. So those won't show up.

Anyways, if you have the hospital NPI you want, you can look up all of its dollar-amount negotiated rates in this table. You can link that to the `hospital` table, geocode however you want, and make a map of the different rates. Note, however, that the insurance data published here is kind of a mess and, I think, contains many many mistakes (originating in the source data.)

BTW, I'm not sure if this insurance-derived hospital data exists anywhere else. I believe it doesn't.

Along the same lines we're crowdsourcing a database of hospital prices, starting this week. I'm reviewing our first pull request as we speak. You can follow our progress live. The data is here: https://www.dolthub.com/repositories/dolthub/standard-charge...

We talked a little about the problems we're encountering here: https://docs.google.com/document/d/1uMx1sUYwP_uE7ebd3PtGvF0t... and here https://docs.google.com/document/d/1NifwgKHBCeF35ZRZsfpgg4bE...

Please take a look at the CMS Price Transparency Guide https://github.com/CMSgov/price-transparency-guide and familiarize yourself with the schema. You can also take a look at the federal ruling: https://www.ecfr.gov/current/title-45/subtitle-A/subchapter-...

The metadata you're talking about is specified in the files themselves. I've limited my search to fee-for-service (non-capitated, non-derived, non-bundled) institutional claims.

You can write to me if you have more questions. [email protected]

Take an example like this https://github.com/CMSgov/price-transparency-guide/discussio...

I don't know how closely you've worked with this data -- you clearly have some kind of expertise -- but how do you explain this?

The insurance companies had 18 months to talk to the CMS and ask for a better data model. If they're not able to explain how much things cost with 5 different negotiated types -- negotiated, percentage, derived, fee schedule, and capitation -- then they should have asked for another one.

The hospital and insurance rates are both fee-for-service base rates for items billed individually. If there's some nuance in interpreting how "fee for service" "dollar amount negotiated" goes, definitely write to me and let me know. I talked with experts in healthcare pricing before I published this.

You can write to me at [email protected] if you wanna hit me with more questions.

> No one can produce the corrected/missing rates but the insurance companies themselves. All we can do is point out when we’ve found rates/patterns that don’t make sense. E.g. https://github.com/CMSgov/price-transparency-guide/discussio...