# Hospital department cost ratio history from Medicare cost reports (FY2011-2024)

`vlada_curated.mart_hospital_dept_ccr_history` · Hospital price transparency · status live · 1,359,025 rows

The same normalized department ratios as mart_hospital_dept_ccr for every recoverable fiscal year, for trends (a department's cost ratio over time) and for matching a price to the cost report of its own year.

**Grain.** One row per (hospital_ccn, cost_center_line, fy_year), with cost_center_label; the whole-hospital ratio under '__OVERALL__'. 1,359,025 rows, 6,909 hospitals, 14 fiscal years, 533 cost centers (measured 2026-09-27, qid 582e78d9).

| column | type | meaning |
|---|---|---|
| hospital_ccn | string |  |
| cost_center_line | string |  |
| cost_center_label | string |  |
| ccr_basis | string |  |
| dept_ccr | double |  |
| fy_year | string |  |
| ccr_vintage | string |  |

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.mart_hospital_dept_ccr_history WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.mart_hospital_dept_ccr_history")` first.