PriceTransparency Rate Changes
Hospital price-transparency rate changes — the same hospital, code and payer seen in two crawls, and what the price did
The same hospital, code and payer, seen in two monthly snapshots, and what the price did. Every US hospital publishes a machine-readable file (MRF) of its standard charges; each of those files is a *level* — a price as of the day it was posted. Nobody publishes the *difference*. This product is that difference: one row per negotiated-rate fact that our crawl has observed in two or more snapshots of the hospital's MRF, carrying the first and last rate, the change in dollars and percent, the second-to-last observation (so the most recent move is separable from the cumulative one), and which way it went.
It is derived entirely from PriceTransparency Negotiated Rates — no new source. A buyer who already ingests the raw MRFs has every input to this table and still has to build it, because building it requires a *retained* history of prior snapshots; the hospital's own file only ever shows today.
A second file rolls the diff up to the listed operator, so the series can be read as a repricing signal per ticker rather than per CCN.
- Rows
- See dictionary
- Product cadence
- recomputed on every marketplace export, from whatever snapshots the rolling re-crawl has accumulated. The panel deepens with each refresh — a fact only enters this table on its *second* observation.
- Lag
- See dictionary
- Lookback shipped
- See dictionary
- Backfill available
- On request
- Vintage
- 2026-08-29 (max snapshot_date in the underlying fact table).
- Tables
- 2
- Licence
- Inside the suite
2 tables, 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_rate_changes | HEALTHPARSE_DATA.HPT_RATE_CHANGES.HPT_RATE_CHANGES | 20 | |
| hpt_rate_changes_by_operator | HEALTHPARSE_DATA.HPT_RATE_CHANGES.HPT_RATE_CHANGES_BY_OPERATOR | 14 |
Evaluate PriceTransparency Rate Changes
Free California sample on the marketplaces. 30-day full-table evaluation on request.