# Hospital cost report — department cost-to-charge (HCRIS 2552-10 Worksheet C)

`medicare_silver.hospital_cost_report_dept` · Medicare Advantage, Part D, Medicaid · status live · 1,474,951 rows

The SERVICE-SPECIFIC actual-cost lens, and the load-bearing one: dept_ccr (cost-to-charge ratio for one Worksheet C cost center). CCR spreads ~17x across departments (CT ~0.04 vs Clinic ~0.64), so a per-code cost estimate MUST use the service's own cost center via the HCPCS->cost-center crosswalk, never the hospital overall ratio. cost_center_label names the standard 2552-10 lines (Operating Room=50, CT=57, MRI=58, Cardiac Cath=59, Laboratory=60, Clinic=90, Emergency=91).

**Grain.** One row per (ccn, fiscal-year-end, cost_center_line). 1,474,951 rows, 6,887 hospitals, FY2011-2024, 553 distinct cost centers.

| column | type | meaning |
|---|---|---|
| ccn | string |  |
| fy_year | string |  |
| cost_center_line | string |  |
| cost_center_label | string |  |
| dept_cost | string |  |
| dept_charge | string |  |
| dept_ccr | string |  |
| charge_as_cost | string |  |
| rpt_rec_num | string |  |

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