News for hackers. Stuff that matters.
Re:Mapping Hospital Accessibility with OpenStreetMap by wcedmisten on Wednesday April 05, 2023 @09:27AM (#35453779)
Thanks! You're doing awesome work, I read the blog post about the insurance data mess you're working through.

I'll see if I can incorporate that into my project!

I'd love to see what this map looks like filtered for specific services.

Re:Mapping Hospital Accessibility with OpenStreetMap by sl-dolt on Wednesday April 05, 2023 @09:34AM (#35453887)
> I'd love to see what this map looks like filtered for specific services.

Sure. I did something like that with our insurance data. Did a quick folium visualization. You can start from here:

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.