# Hospital department cost ratios from Medicare cost reports (latest fiscal year per department)

`vlada_curated.mart_hospital_dept_ccr` · Hospital price transparency · status live · 138,458 rows

The normalized cost lens over the raw HCRIS Worksheet C table (medicare_silver.hospital_cost_report_dept): typed dept_ccr (double), the charge_as_cost 1.0 sentinel excluded, ratios at or above 10 excluded as parse or units defects, one row per hospital and department. Estimated cost of a service = its gross charge x the dept_ccr of the service's own cost center, found through medicare_silver.hcpcs_cost_center_crosswalk (hcpcs -> cost_center_line). An inpatient MS-DRG spans departments and uses the __OVERALL__ row, labelled by ccr_basis.

**Grain.** One row per (hospital_ccn, cost_center_line), the latest usable fiscal year of that pair, plus one whole-hospital row per CCN under cost_center_line '__OVERALL__' (ccr_basis 'overall'). 138,458 rows, 6,909 hospitals (6,708 with the overall row), FY2011-2024 (measured 2026-09-27, qid 2d22e8a5).

| column | type | meaning |
|---|---|---|
| hospital_ccn | string |  |
| cost_center_line | 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 WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.mart_hospital_dept_ccr")` first.