13 ms·

That's really cool. I'll probably end up trying to reproduce this by following your work step-by-step. I'm not too familiar with OSM, besides having used Nomina

That's really cool. I'll probably end up trying to reproduce this by following your work step-by-step. I'm not too familiar with OSM, besides having used Nominatim. 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-files/data/main 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_uE7ebd3PtGvF0tZgWUhqgPd7lofxYzO3I/edit#heading=h.y2u8vk12zbd7 https://docs.google.com/document/d/1uMx1sUYwP_uE7ebd3PtGvF0t... and here https://docs.google.com/document/d/1NifwgKHBCeF35ZRZsfpgg4bErvlgsPnJBzPLvztwXLU/edit# https://docs.google.com/document/d/1NifwgKHBCeF35ZRZsfpgg4bE...

wcedmisten 3y ago
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.
- sl-dolt 3y ago
  > 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-allpayers/doc/main 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.

wcedmisten 3y ago

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.

sl-dolt 3y ago
> 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-allpayers/doc/main 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.