Medicare Advantage, Part D, Medicaid

Hospital cost report — whole-hospital cost-to-charge (HCRIS 2552-10)

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

Rows

81,368

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The whole-hospital ACTUAL-COST lens: overall_ccr (cost-to-charge ratio = total_cost / total_charge from Worksheet C).
2Applied to a billed charge it estimates the real cost of care.
3This is the COST leg reference-based-pricing vendors (Imagine360/ELAP) price against; joined to our MRF negotiated rate + Medicare it completes the cost / rate / Medicare / fair-RBP-price picture that no one else holds.
4Use the DEPT table for service-specific cost, this for the hospital-wide ratio.

Grain

Key	Grain
N/A	1One row per (ccn, fiscal-year-end). 2CMS Medicare Hospital Cost Report (HCRIS, form 2552-10) Worksheet C. 381,368 report-years, 6,949 hospitals, FY2010-2024.

Columns (12)

Column	Type	Meaning
`ccn`	string
`fy_begin`	string
`fy_end`	string
`fy_year`	string
`rpt_status`	string
`rpt_rec_num`	string
`total_cost`	string
`total_charge`	string
`overall_ccr`	string
`charge_as_cost`	string
`plausible`	string
`source_file`	string

Query it

describe_data_source(source_fqn="medicare_silver.hospital_cost_report_overall")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.hospital_cost_report_overall 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_overall")`
Raw door	Athena (read-only via query_substrate): medicare_silver.hospital_cost_report_overall

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