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.