Price transparency is an essential part of a healthy market. Or so says the theory. I hope they release it. I wonder what I can do to help? I’m capable in db design, sql, etc being a data engineer by day perhaps I can help this effort.
Health insurers just published close to a trillion hospital prices
31–40 of 549 posts
Re: Health insurers just published close to a trillion hospital prices
#32I'm the author. A question I have is: how did so many prices ever get negotiated in the first place? What kind of systems are in place to do this kind of micro-negotiation?
Re: Health insurers just published close to a trillion hospital prices
#33This seems very much like the episode of Veep'Boxes of lies' where they try to hide their nefarious deeds alongside the real day to day inter-workings of the vice presidents office but inundating the public with data.
Re: Health insurers just published close to a trillion hospital prices
#34This data is already available cleaned here. https://turquoise.health/
I know it's not in the business interest of Turquoise Health, but I'd like to see that data be downloadable. There's a lot of insight sitting in the data.
This blog was a feasibility analysis to see what kind of work it would take to get that data. If we do get it, we plan on making it free to download.
Re: Health insurers just published close to a trillion hospital prices
#35I'm the author. A question I have is: how did so many prices ever get negotiated in the first place? What kind of systems are in place to do this kind of micro-negotiation?
Super curious about this, too.
Also! What did they do before they could store 100TB of pricing data? How has pricing (and care quality) changed as a result of being able to do this type of thing?
Re: Health insurers just published close to a trillion hospital prices
#36I'm the author. A question I have is: how did so many prices ever get negotiated in the first place? What kind of systems are in place to do this kind of micro-negotiation?
Any time you can convert a problem from an `N x K` problem to an `N + K` problem, there's some asshole administrator trying to turn an `N + K` problem into an `N x K` problem. It wouldn't surprise me if there's huge amounts of redundant information in there.
Re: Health insurers just published close to a trillion hospital prices
#37I'm the author. A question I have is: how did so many prices ever get negotiated in the first place? What kind of systems are in place to do this kind of micro-negotiation?
The next question would be 'how long did the average negotiation take' followed by 'how much were the average people on each side of the negotiation paid?" (or are most of these negotiations the result of computers talking to each other? Either way with a few assumptions one could make an estimate of the smallest amount these different prices cost the system. Might be huge
Re: Health insurers just published close to a trillion hospital prices
#38I'm the author. A question I have is: how did so many prices ever get negotiated in the first place? What kind of systems are in place to do this kind of micro-negotiation?
Super curious about this, too. Also! What did they do before they could store 100TB of pricing data? How has pricing (and care quality) changed as a result of being able to do this type of thing?
Possibly the original data is logically compressed. E.g. payer A pays 110% of our standard rates, payer B pays 85% of our standard rates. Those two rows could translate into thousands of CSV lines depending on the number of procedures.
Maybe you have a couple one off negotiations for high volume procedures, but even still the source data could be several orders of magnitude smaller than the dumps.
Re: Health insurers just published close to a trillion hospital prices
#39I 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.
> to justify the unethical system that allows millions to die unnecessarily
Which people are those millions?
The system saves millions of lives that would have died in generations past. How do you factor that into your claim?
Re: Health insurers just published close to a trillion hospital prices
#40Unrelated: “dolt” vs “doIt” is one of my standard font competence tests