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:
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!
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.
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
Login to Gigasheet. Don't have an account yet? Sign up!
Click the button below to view the data in your account.
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
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!
Institutional Rates ($304k average) are on average $65k higher for this plan than Professional Rates ($239k). How do I qualify for the Professional ones?
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.
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.