horizontal lines

Health Insurance Prices

Transparency in Coverage Data

About This Data

The file comes from Aetna's Machine Readable Transparency in Coverage website.


We downloaded the first Life Insurance file:

Plan Name: Aetna CVS Bronze: Low-Cost MinuteClinic Visits- Telehealth- Roanoke- Ped Dental

File Name: 2022-07-01_f42d21fd-3576-4569-b0c7-20253bccc7fe_Aetna-Life-insurance-Company.json.gz

File Type: In Network Rates

Plan ID: 38234VA0180009

Things to try in the data set:

Group Data

Roll data up into groups of values within a column to look for trends. Place groups inside of groups to drill down another level, then group again!

Filter Data

Use the filters to narrow down the file to the values that interest you most. Only show values that include, exclude, contain, or are greater than a value (to name a few). Then add another level of filtering with AND / OR logic to dive deeper.

Search Data

Not sure where to start? Use search to find values in the file and then go back and filter or group the entire data set down to just that value.

Top 10 Most Expensive Procedures

Institutional vs Professional Average Rate

Count of Billing Codes by Negotiated Type / Billing Code Type

Data Highlights

  1. Login to Gigasheet. Don't have an account yet? Sign up!
     

  2. Click the button below to view the data in your account.
     

  3. Feel free to explore the data via sharing mode or save a copy to your own account by clicking the View Copy button at the top of the page.

Explore This Data

3

The Combined Anterior/Posterior procedure is the most expensive item on the list at a whopping $180k average. We don't know what that means, but #2 and #3 are spine related so we will go with that. Any doctors out  there, please let us know!

2

Institutional Rates ($304k average) are on average $65k higher for this plan than Professional Rates ($239k). How do I qualify for the Professional ones?

1

There are an insane amount of rows: 5,446,583 ROWS for just one Insurance plan. And there are plenty of other plans to download.

Key Insights

Overview

Begining July 1, 2022 US healh insurance issuers are required to disclose prices for healthcare services (read more about the specifics here). This federal requirment is exposing troves heathcare cost data that has historically been kept secret. The data is typically posted as huge machine-readable JSON files in contorted formats not easily accessible to consumers. At Gigasheet we're working to change that!


You can find rates posted in huge files, such as this one from Aetna. But what good is a machine-readable file? These multi-gigabye files are nearly impossible for the average person to open because 1) they are HUGE and contain millions of records and 2) they are JSON, which can't be easily opened in something like Google Sheets or Microsoft Excel.


With Gigasheet JSON files become human-readable, and the average spreadsheet user can group, filter, and analyze price data. Check out this relatively small ~5 million row sample file. Gigasheet Enterprise supports files with 1 billion+ rows! If you're interested to analyze health insurce price transparency data, contact us about Gigasheet Enterprise.