Medicare Advantage, Part D, Medicaid

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

medicare_silver.hospital_cost_report_dept·live·silver·Hospital Cost Reports (HCRIS)

Rows

1,474,951

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The SERVICE-SPECIFIC actual-cost lens, and the load-bearing one: dept_ccr (cost-to-charge ratio for one Worksheet C cost center).
2CCR 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

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

Columns (9)

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

describe_data_source(source_fqn="medicare_silver.hospital_cost_report_dept")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.hospital_cost_report_dept WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ccn`
Join	`how_to_join(source_fqn="medicare_silver.hospital_cost_report_dept")`
Raw door	Athena (read-only via query_substrate): medicare_silver.hospital_cost_report_dept

This page as markdown: /docs-md/data/medicare_silver_hospital_cost_report_dept.md · every page in one file: /llms-full.txt