# SNF cost reports, by department

`medicare_silver.snf_cost_report_dept` · Medicare Advantage, Part D, Medicaid · status live · 101,717 rows

Skilled nursing facility cost reports (HCRIS 2540-10) by department: cost, charges and the cost-to-charge ratio per cost center line.

**Grain.** One row per (ccn, fy_year, cost_center_line, rpt_rec_num): the department's cost, charges and ratio.

| column | type | meaning |
|---|---|---|
| ccn | string |  |
| fy_year | string |  |
| cost_center_line | 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.snf_cost_report_dept WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.snf_cost_report_dept")` first.