How the numbers are built

Every price on this site comes from a public file a hospital or CMS published. This page shows the path from those files to a number on a page, and what we do (and don't do) along the way.

Coverage right now
54facilities with prices in Arizona
82procedure / DRG codes tracked
3207facility × code price rows
8insurers with facility-level negotiated rates
September 2026last refresh (rebuilt weekly)
Data flow
Data flow from public sources to pages Hospital price files and CMS fee schedules are fetched weekly, parsed, filtered to the tracked codes, aggregated per facility into a columnar dataset, benchmarked against Medicare, and rendered as compare, payer-rate, and site-of-care pages. PUBLIC SOURCES PIPELINE · WEEKLY APP · PER REQUEST Hospital price files CMS machine-readable files one per hospital · CSV or JSON 45 CFR 180 · updated by hospitals Medicare fee schedules OPPS Addendum B (hospital OPD) PFS RVUs × conversion factor CLFS (labs) · IPPS DRG weights ASC Addendum AA/BB cms.gov · yearly / quarterly CMS quality data Care Compare star ratings hip/knee complication rate data.cms.gov · by CCN 1 · Fetch every file re-downloaded streamed, never kept on disk 2 · Parse tall CSV · wide CSV · JSON one row per code × payer 3 · Keep tracked codes 82 shoppable codes everything else dropped 4 · Aggregate per facility × code: cash, negotiated min / median / max 5 · Payer rates plan names → 8 insurers median per facility × insurer 6 · Columnar dataset Parquet, partitioned by state and code · atomic swap Reference tables (loaded at start) Medicare benchmarks by code and source · quality by facility · metros · ASCs with published prices Benchmark & statistics ×Medicare · IQR band · outliers typical price · ask target percentile of your rate Compare pages every facility, cheapest first Payer rates facility × insurer matrix, CSV Site of care hospital OPD vs ASC Bill analysis & letter paste a bill, get the numbers

Sources

WhatWhere it comes fromVintage
Facility prices (cash, negotiated)Each hospital's CMS machine-readable file, linked from its cms-hpt.txt or price-transparency pageWhatever the hospital last published; re-fetched weekly
Hospital outpatient benchmarkMedicare OPPS Addendum B, national unadjusted payment rateCY2025
Physician / office benchmarkMedicare PFS: non-facility total RVU × conversion factor ($32.3465)CY2025
Lab benchmarkMedicare Clinical Laboratory Fee ScheduleCY2025
Inpatient (MS-DRG) benchmarkIPPS: DRG relative weight × (operating + capital national base rate), wage index 1.0FY2026 Final Rule Tables 5 and 1A/1D
ASC benchmarkMedicare ASC Addendum AA/BB national payment rate; packaged codes shown as not separately payableJanuary 2026 update
QualityCare Compare overall star rating; hip/knee replacement complication rate (COMP_HIP_KNEE), matched to facilities by CCN or nameLatest Care Compare release

What we compute, exactly

Which rows are kept

Only rows whose code is on the tracked list (82 codes). A hospital file typically has hundreds of thousands of rows; a few thousand survive. Rows without a usable code, and files that contain only chargemaster items with no CPT/HCPCS/DRG codes, are dropped and logged.

The per-facility price

For each facility and code: cash is the published discounted cash price; negotiated min / median / max summarize every payer row for that code. The facility list shows cash where published, otherwise the negotiated median.

Payer rates

Raw plan names are collapsed to 8 insurers (all Aetna plans → Aetna, Blue Cross / Blue Shield / Anthem → BCBS, and so on). The rate shown for a facility and insurer is the median across that insurer's plans. Plans that don't map to a major insurer are excluded from the payer view but still count in the negotiated range.

Typical price and the band

Across the facilities in the selected area, the typical price is the median with implausible values excluded: anything under 25% of the Medicare rate (a mis-keyed file), and anything outside the Tukey fences (1.5× the interquartile range). The band shown is the 25th to 75th percentile; flagged outliers stay visible in the table, marked.

Medicare multiples and the ask

Every price is expressed as a multiple of the Medicare benchmark for its setting (OPPS for hospital outpatient, IPPS for inpatient DRGs, PFS for office). The suggested ask is the lower of 2× Medicare or the local cash price, a figure most facilities accept for self-pay.

Site of care

Medicare's own hospital-outpatient (OPPS) and ASC rates for the same code give the reference differential. The per-case shift figure is the hospital typical price minus the median of published non-hospital prices for that code, using only sites that publish a price.

Percentiles

"Your rate is at the Nth percentile" means N% of facilities in the selected column have a lower published rate. It is computed over the facilities shown, not a national sample.

What this is not

Freshness and reproducibility

The whole dataset is rebuilt from scratch every week: every file is downloaded again, parsed, filtered, and swapped in atomically, so the site never serves a half-built dataset. Hospital files change on their own schedules; the vintage shown on each page is our last rebuild (September 2026). Every source above is public and linkable, so any number here can be traced back to a row in a hospital's own file.

← Back to the site