3 ms·

For anyone looking to download the data, here are a few links: Empire Blue (Anthem): https://www.empireblue.com/machine-readable-file/search/ https://www.empir

For anyone looking to download the data, here are a few links: Empire Blue (Anthem): https://www.empireblue.com/machine-readable-file/search/ https://www.empireblue.com/machine-readable-file/search/ United Healthcare: https://transparency-in-coverage.uhc.com/ https://transparency-in-coverage.uhc.com/ Aetna (Seems like the right page, but I don't see any download links — possibly because they haven't been posted yet): https://health1.aetna.com/app/public/#/one/insurerCode=AETNACVS_I&brandCode=ALICSI/machine-readable-transparency-in-coverage?searchTerm=279439&lock=true https://health1.aetna.com/app/public/#/one/insurerCode=AETNA... Search keywords: https://www.google.com/search?q=machine+readable+files+transparency+in+coverage https://www.google.com/search?q=machine+readable+files+trans...

nope96 4y ago
Blue Cross https://www.bcbsil.com/member/policy-forms/machine-readable-file https://www.bcbsil.com/member/policy-forms/machine-readable-... So are there programs I can use to parse this? It looks like a json file with links to more gziped json files...
- throwaway743 4y ago
  ...it is unfortunately. If you know a language you could run through it. Otherwise ypu might be able to find something like a json to csv converter online
- loxias 4y ago
  > It looks like a json file with links to more gziped json files Yup! Should be pretty easy to whip up a parser, it's just JSON and HTTP, you could do it in shell if you cared to. The challenge is what are you parsing it _to_. That is to say, what's your data model. I'd choose that first, then worry about parsing.
loxias 4y ago
Thank you thank you thank you! Here's Cigna: https://www.cigna.com/legal/compliance/machine-readable-files https://www.cigna.com/legal/compliance/machine-readable-file... UCLA Health keeps theirs: https://uclahealth.s3-us-west-1.amazonaws.com/price-transparency/rr-sm-machine-readable-2022.json https://uclahealth.s3-us-west-1.amazonaws.com/price-transpar... But sadly, still can't find my insurance company's download links. I can't wait to lose a weekend doing something with this data, it's a dream dataset and a perfect example of a very narrow type of project I love doing. Is there a canonical list of the major insurance companies?
- vayun 4y ago
  Cigna posted a single 570GB gzipped JSON that barely qualifies as machine-readable
PovilasID 4y ago
Hey has anybody created and open API or just downloaded it all to a single source?

nope96 4y ago

Blue Cross https://www.bcbsil.com/member/policy-forms/machine-readable-file https://www.bcbsil.com/member/policy-forms/machine-readable-... So are there programs I can use to parse this? It looks like a json file with links to more gziped json files...

throwaway743 4y ago
...it is unfortunately. If you know a language you could run through it. Otherwise ypu might be able to find something like a json to csv converter online
loxias 4y ago
> It looks like a json file with links to more gziped json files Yup! Should be pretty easy to whip up a parser, it's just JSON and HTTP, you could do it in shell if you cared to. The challenge is what are you parsing it _to_. That is to say, what's your data model. I'd choose that first, then worry about parsing.

loxias 4y ago

Thank you thank you thank you! Here's Cigna: https://www.cigna.com/legal/compliance/machine-readable-files https://www.cigna.com/legal/compliance/machine-readable-file... UCLA Health keeps theirs: https://uclahealth.s3-us-west-1.amazonaws.com/price-transparency/rr-sm-machine-readable-2022.json https://uclahealth.s3-us-west-1.amazonaws.com/price-transpar... But sadly, still can't find my insurance company's download links. I can't wait to lose a weekend doing something with this data, it's a dream dataset and a perfect example of a very narrow type of project I love doing. Is there a canonical list of the major insurance companies?

vayun 4y ago
Cigna posted a single 570GB gzipped JSON that barely qualifies as machine-readable

PovilasID 4y ago

Hey has anybody created and open API or just downloaded it all to a single source?