Public sample Data files

Price Transparency Data Sample - 800K+ Negotiated Rates

Explore 800,000+ negotiated rates from five major Minnesota payers, cleaned and enriched for immediate analysis.

Payers included:

  • UnitedHealthcare Midwest
  • Medica
  • Blue Cross Blue Shield of Minnesota
  • HealthPartners
  • Allina Health Aetna

What's in This Dataset

This sample contains a random slice of in-network negotiated rates filtered to Minnesota providers. Unlike raw MRF files that require weeks of processing and terabytes of storage, this data is ready to analyze in seconds.

Data quality features:

  • NPI-filtered to Minnesota providers only
  • Zombie rates removed for individual NPIs (rates that appear in MRF files but are never actually paid)
  • Enriched with NPI details including provider name, specialty, and address
  • Clean EIN names mapped to recognizable organization names
  • CMS non-facility rates included for instant Medicare benchmarking

Why This Data Matters

Price transparency regulations require payers to publish their negotiated rates, but the raw files are nearly impossible to use. A single payer's MRF can exceed 1 terabyte. The data comes in deeply nested JSON formats. Provider identifiers require extensive crosswalking. And the files contain millions of "zombie rates" that inflate the data without providing actionable intelligence.

This sample demonstrates what becomes possible when price transparency data is properly processed: clean, queryable rate intelligence that providers, payers, and employers can actually use for contract negotiations, network analysis, and market benchmarking.

View in Gigasheet

Unlock Market Intelligence from Big Data with Gigasheet

Price Transparency Data: Healthcare organizations are turning massive machine-readable price transparency data into competitive advantage with Gigasheet. Our platform helps providers and payers easily analyze newly published pricing files – no coding required. With Gigasheet’s no-code big data platform for healthcare, users can transform Transparency in Coverage (MRFs) files into interactive reports and compare negotiated rates across payers and providers to spot opportunities. Learn how our healthcare price transparency tools drive smarter contracts and cost savings by exploring Gigasheet’s price transparency data solution for actionable analytics.

More Sample Data Files

Previous Spreadsheet

No previous post!
Back to all sample data

Next Spreadsheet

No next post!
Back to all sample data

100,000+ people use Gigasheet.

Self-service analytics for huge files, databases, warehouses and more.
No Code
No Training
No Install
Request a Demo

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.