Medicare Advantage, Part D, Medicaid

SNF cost reports, overall

medicare_silver.snf_cost_report_overall·live·silver

Rows

14,698

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Skilled nursing facility cost reports (HCRIS 2540-10), the whole-facility view: total cost, total charges, overall cost-to-charge ratio, with a plausibility flag.

Grain

Key	Grain
N/A	1One row per (ccn, fy_year, rpt_rec_num): the facility's total cost, total charge and overall cost-to-charge ratio.

Columns (12)

Column	Type	Meaning
`ccn`	string
`fy_begin`	string
`fy_end`	string
`fy_year`	string
`status`	string
`rpt_rec_num`	string
`total_cost`	string
`total_charge`	string
`overall_ccr`	string
`charge_as_cost`	string
`plausible`	string
`source`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ccn,fy_year,rpt_rec_num`
Join	`how_to_join(source_fqn="medicare_silver.snf_cost_report_overall")`
Raw door	Athena (read-only via query_substrate): medicare_silver.snf_cost_report_overall
Note	Product lane 2026-09-28: 14698 rows, measured on Athena. Register source cms_hcris_non_hospital_forms (w5).

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