Price-transparency negotiated rates
The rate each insurer has agreed to pay each hospital for common procedures, taken from the hospital's own published price file, snapshot by month.
Hospital price-transparency negotiated-rate facts, extracted from hospitals' federally-mandated machine-readable files (MRFs) under CMS-1717-F2 (effective Jan 1, 2021). Every US hospital must publish a machine-readable file of standard charges — gross charges, payer-specific negotiated rates, discounted cash prices, and de-identified min/max rates — for every item and service. There is no central federal registry; hospitals host their own files in inconsistent formats (JSON/CSV/TXT, v1.1 legacy or v2.0 current schema). This product is built by crawling each hospital's own MRF and extracting rows only for a curated list of ~500 high-volume/CMS-shoppable CPT/HCPCS/MS-DRG codes (raw MRFs are never persisted — extraction-only, which is what keeps this tractable instead of multi-terabyte). One row per (hospital × billing code × payer × plan × setting × rate type). As of 2026-07-28 the target list is 708 codes: the original acute CPT/MS-DRG set plus 475 IRF case-mix groups and 24 revenue codes, added so inpatient rehabilitation and behavioural hospitals — which bill under neither CPT nor MS-DRG — are extractable at all.
The count is *lower* than the 10,752,221 shipped on 2026-08-29 despite a wider crawl, because that export was overstated. See Hospital identity below: 40% of the rows carried a crawl placeholder in ccn instead of a CCN, and a large share of those were second copies of a file already extracted under the hospital's real CCN. Reconciling them collapsed 1,611,971 duplicate facts and dropped 1,475,152 rows that still cannot be tied to a hospital from the product. Every row that ships now joins on ccn; on 2026-08-29 four in ten did not.
Since July 2024 every hospital must publish cms-hpt.txt at the root of the site hosting its MRF (45 CFR 180.50(b)(8)). Multi-location systems — Ascension, HCA, Atrium, Fairview, Trinity — satisfy that with ONE file listing a location-name and mrf-url per facility. The file names the locations; it does not carry their CCNs.
Contract repricing between snapshots. Payer-versus-operator rate spreads. Joins to cost reports on CCN.
- 708 target codes; 613 observed with rates. Not every hospital publishes every code.
- Coverage depends on each hospital's file quality. 2,421 hospitals had extractable rates at the last export.
- Rows
- 7,954,124 (2026-09-11 export) — the largest product in this catalog. The extracted code list was expanded from 209 to 708 codes on 2026-07-28 (inpatient rehabilitation case-mix groups and behavioural revenue codes added).
- Product cadence
- Monthly snapshots
- Lag
- Current
- Lookback shipped
- Snapshots from 2026-05-22
- Backfill available
- None. Raw files are not retained and no earlier snapshots exist
- Vintage
- 2026-09-11 (max snapshot_date observed at export time: 2026-09-02).
- Tables
- 1
- Licence
- $999 per month per firm, or inside the suite
Where every row comes from.
| Source | Source cadence | History |
|---|---|---|
| Hospital machine-readable files, crawled from each hospital's own domain | Rolling re-crawl; hospitals update about monthly | Snapshots retained from 2026-05-22 |
Dictionary source line: Hospital-published MRFs, crawled directly from each hospital's own domain (no central government feed).
1 table, three meta columns each.
Every table carries _dataset, _vintage and _exported_at in addition to the columns in the dictionary.
| Table | Snowflake path | Columns | Rows |
|---|---|---|---|
| hpt_negotiated_rates | HEALTHPARSE_DATA.HPT_NEGOTIATED_RATES.HPT_NEGOTIATED_RATES | 15 | 7,954,124 |
Price Transparency Rates
Three real rows pulled from the production tables on 2026-09-10. The query is recorded next to the rows in the site source.
| Hospital | Code | Payer | Negotiated rate |
|---|---|---|---|
| Marshall Medical Centers South (AL) | CPT 70450 | Aetna | $1,329 |
| Marshall Medical Centers South (AL) | CPT 70450 | UnitedHealthcare | $852 |
| Marshall Medical Centers South (AL) | CPT 70450 | Blue Cross Blue Shield | $666 |
Evaluate Price-transparency negotiated rates
Free California sample on the marketplaces. 30-day full-table evaluation on request.