About

Does getting healthcare in the US feel like a labyrinth? Perhaps…

• You’re a patient, and you get a letter from some mysterious “ACO” thingamajig, and now you’re not sure who they are and what they have to do with your doctor.
• You’re a retiring practitioner and you were approached by Bartholomew Banks with an offer. You’re enticed, but worried what selling your practice might mean for patients and peers.
• Mom’s nursing home got acquired last week, and you’re wary of what it might mean.
• The insurer negotiated price of your medication is way higher than if you buy it without them involved...

While data on clinical professionals are heavily scrutinized, it’s harder to learn about the web of legal entities and business strategies operating behind the scenes.

At @onefact, we’re big believers that:

1. Incentives drive outcomes
2. Health policy is hard, and it’s not always clear which incentives are the best in any situation
3. In any case, you need transparency to find out

Tools

This repository is meant to host tools for understanding the labyrinth. These will come in various forms, including:

• Open source graph databases which merge public CMS data with additional sources (Open Corporates, Price Transparency data, Payer / Provider websites, etc.)
• Websites and chat-based query interfaces that make the graph databases accessible to the general public.
• Research and experimental methods for surfacing relationships between entities involved in healthcare delivery which are not documented via structured data (sometimes purposefully obfuscated).

Products

PECOS Plus

Overview

Our first product is PECOS Plus, not to be confused with PECOS 2.0. PECOS Plus is an open source database which takes CMS PECOS enrollment and ownership data sources and maps them into a graph database. From there, we plan to...

• Create an interactive visual interface whereby people can explore relationships and propose opaque, or undocumented affiliate relationships.
• Integrate additional sources (Open Corporates, CMS Price Transparency data, etc.)
• Publish subgraphs curated by industry veterans that map the 800 lb gorillas, i.e. the largest payvidor entities (United Healthcare Group, CVS Health, Humana Inc.)
• Create a framework for experimenting with new methodologies to infer affiliate relationships. Similar to CMS’ approach but with open source contributions.

If you have healthcare industry experience, sleuthing skills, or programming chops and want to help make this happen, please email us at [email protected].

Getting Started

To set up the Pecos Plus database, follow these steps:

1. Create a Conda Environment:

   • Begin by setting up a Conda environment to manage dependencies. Use the appropriate environment configuration file if available, or create a new environment using conda create.

2. Load CMS Data into SQLite:

   • Execute the script load_cms_data_api_to_sqlite.py to download and load CMS data into a SQLite database. This script handles the data retrieval and populates the SQLite database with the necessary information.

3. Transfer Data from SQLite to Kuzu:

   • Finally, run the load_sqlite_to_kuzu.py script to transfer the data from the SQLite database to the Kuzu database. This step migrates the data into the Kuzu database format, completing the setup process.

Conventions for collaboration

Please tackle any open issue and submit a pull request - we are working out conventions for collaboration in this manner.

Feel free to submit an issue if you have a request for a feature, request for a visualization, or have any ideas on ways this data can be made more useful for health care use cases.

Financing

This mapping exercise is now supported by https://www.patientrightsadvocate.org/ through their grant of $100,000 to our organization, after our initial seed funding from @columbia and @SU-SWS.