Exploring the Transparency in Coverage final rule – a petabyte of data a month

For anyone interested in exploring the data yourself, here are a few tools

https://dadroit.com/: desktop tool for processing large JSON files.There’s a free version so you can get pretty far with it if you’re patient

https://www.dolthub.com/repositories/dolthub/quest: they’re running a bounty program for some healthcare providers to process the machine readable files, and have some useful code snippets in case you’re a little bit technical

ChatGPT (https://chat.openai.com/): I know it sounds weird, but this helped adapt some simple python scripts when I got stuck

https://cascadehealth.ai/: if you’re doing this at scale, they can help you

https://www.healthplanexplorer.com/: I built this with some collaborators over the last couple of weeks to help process the files more quickly into formats useful for me. Costs a bit to pay for the box. If you have feedback, I’d love to hear it.