Skilled Nursing Facility Cost Report

The Skilled Nursing Facility (SNF) Cost Report dataset is a public use file that provides select measures from the skilled nursing facility annual cost report.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.SKILLED_NURSING_FACILITY_COST_REPORT on Snowflake and Databricks — 16 annual reporting periods (2011–2023) aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.SKILLED_NURSING_FACILITY_COST_REPORT
Databricks	cms_dwv.skilled_nursing_facility_cost_report
Coverage	Jan 2011 – Dec 2023 (13 of 13 annual reporting periods)
Rows	238,211 (total across all reporting periods)
Cadence	Annual
Update pattern	Time-partitioned — each file adds one reporting year
CMS published	2025-12-19
Loaded	2025-12-19
Columns	122 data + 6 lineage
Identifiers	CCN · ZIP codes
File versions	16
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2025-12-19. Coverage is complete through the 2023 reporting year. Next CMS release expected ~Dec 2026.

Time-partitioned feed — each file version covers one reporting year, so history is additive. Query the full table for all years; filter on the reporting period columns for a single period. Do not filter to the latest file only — that would return just the 2023 reporting year.

Sample queries

Snowflake

-- Each file version covers one reporting period — history is additive
SELECT *
FROM DWV.SKILLED_NURSING_FACILITY_COST_REPORT
LIMIT 100;

Databricks

About this feed

The Skilled Nursing Facility (SNF) Cost Report dataset is a public use file that provides select measures from the skilled nursing facility annual cost report. This data includes provider information such as facility characteristics, utilization data, cost and charges by cost center (in total and for Medicare), Medicare settlement data, and financial statement data organized by CMS Certification Number.

— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Hospitals & Facilities, Skilled Nursing, Health Care Use & Payments, Value-Based Care, Financials Theme: Medicare

Coverage timeline

2011–2023 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

13 of 13 annual reporting periods present — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2023-01-01 – 2023-12-31	2025-12-19	2025-12-19	✓
2023-01-01 – 2023-12-31	2025-11-19	2025-11-19
2022-01-01 – 2022-12-31	2025-11-19	2025-11-19
2022-01-01 – 2022-12-31	2024-11-25	2025-10-18
2022-01-01 – 2022-12-31	2024-10-23	2024-10-23
2021-01-01 – 2021-12-31	2023-12-14	2023-12-14
2020-01-01 – 2020-12-31	2023-12-14	2023-12-14
2019-01-01 – 2019-12-31	2022-09-30	2023-08-29
2018-01-01 – 2018-12-31	2022-01-19	2023-08-29
2017-01-01 – 2017-12-31	2021-10-29	2023-08-29

Show 6 earlier file versions

Reporting period	CMS published	Loaded	Latest file
2016-01-01 – 2016-12-31	2021-10-29	2023-08-29
2015-01-01 – 2015-12-31	2021-10-29	2023-08-29
2014-01-01 – 2014-12-31	2021-10-29	2023-08-29
2013-01-01 – 2013-12-31	2022-09-30	2023-08-29
2012-01-01 – 2012-12-31	2022-09-30	2023-08-29
2011-01-01 – 2011-12-31	2022-09-30	2023-08-29

Data dictionary

📋 122 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Skilled Nursing Facility Cost Report data dictionary.

Data columns

Column	Type
RPT_REC_NUM	NUMBER
PROVIDER_CCN	NUMBER
FACILITY_NAME	TEXT
STREET_ADDRESS	TEXT
CITY	TEXT
STATE_CODE	TEXT
ZIP_CODE	TEXT
COUNTY	TEXT
MEDICARE_CBSA_NUMBER	TEXT
RURAL_VERSUS_URBAN	TEXT
FISCAL_YEAR_BEGIN_DATE	DATE
FISCAL_YEAR_END_DATE	DATE
TYPE_OF_CONTROL	NUMBER
TOTAL_DAYS_TITLE_V	TEXT
TOTAL_DAYS_TITLE_XVIII	NUMBER
TOTAL_DAYS_TITLE_XIX	NUMBER
TOTAL_DAYS_OTHER	NUMBER
TOTAL_DAYS_TOTAL	NUMBER
NUMBER_OF_BEDS	NUMBER
TOTAL_BED_DAYS_AVAILABLE	NUMBER
TOTAL_DISCHARGES_TITLE_V	TEXT
TOTAL_DISCHARGES_TITLE_XVIII	NUMBER
TOTAL_DISCHARGES_TITLE_XIX	NUMBER
TOTAL_DISCHARGES_TITLE_OTHER	NUMBER
TOTAL_DISCHARGES_TOTAL	NUMBER
SNF_AVERAGE_LENGTH_OF_STAY_TITLE_V	TEXT
SNF_AVERAGE_LENGTH_OF_STAY_TITLE_XVIII	NUMBER
SNF_AVERAGE_LENGTH_OF_STAY_TITLE_XIX	NUMBER
SNF_AVERAGE_LENGTH_OF_STAY_TOTAL	NUMBER
SNF_ADMISSIONS_TITLE_V	TEXT
SNF_ADMISSIONS_TITLE_XVIII	NUMBER
SNF_ADMISSIONS_TITLE_XIX	NUMBER
SNF_ADMISSIONS_OTHER	NUMBER
SNF_ADMISSIONS_TOTAL	NUMBER
SNF_DAYS_TITLE_V	TEXT
SNF_DAYS_TITLE_XVIII	NUMBER
SNF_DAYS_TITLE_XIX	NUMBER
SNF_DAYS_OTHER	NUMBER
SNF_DAYS_TOTAL	NUMBER
SNF_NUMBER_OF_BEDS	NUMBER
SNF_BED_DAYS_AVAILABLE	NUMBER
SNF_DISCHARGES_TITLE_V	TEXT
SNF_DISCHARGES_TITLE_XVIII	NUMBER
SNF_DISCHARGES_TITLE_XIX	NUMBER
SNF_DISCHARGES_TITLE_OTHER	NUMBER
SNF_DISCHARGES_TOTAL	NUMBER
NF_NUMBER_OF_BEDS	NUMBER
NF_BED_DAYS_AVAILABLE	NUMBER
NF_DAYS_TITLE_V	TEXT
NF_DAYS_TITLE_XIX	NUMBER
NF_DAYS_OTHER	NUMBER
NF_DAYS_TOTAL	NUMBER
NF_DISCHARGES_TITLE_V	TEXT
NF_DISCHARGES_TITLE_XIX	NUMBER
NF_DISCHARGES_TITLE_OTHER	NUMBER
NF_DISCHARGES_TOTAL	NUMBER
NF_AVERAGE_LENGTH_OF_STAY_TITLE_V	TEXT
NF_AVERAGE_LENGTH_OF_STAY_TITLE_XIX	NUMBER
NF_AVERAGE_LENGTH_OF_STAY_TOTAL	NUMBER
NF_ADMISSIONS_TITLE_V	TEXT
NF_ADMISSIONS_TITLE_XIX	NUMBER
NF_ADMISSIONS_OTHER	NUMBER
NF_ADMISSIONS_TOTAL	NUMBER
TOTAL_RUG_DAYS	TEXT
TOTAL_SALARIES_FROM_WORKSHEET_A	NUMBER
OVERHEAD_NON_SALARY_COSTS	NUMBER
TOTAL_CHARGES	NUMBER
TOTAL_COSTS	NUMBER
WAGE_RELATED_COSTS_CORE_	NUMBER
TOTAL_SALARIES_ADJUSTED_	NUMBER
CONTRACT_LABOR	NUMBER
CASH_ON_HAND_AND_IN_BANKS	NUMBER
TEMPORARY_INVESTMENTS	NUMBER
NOTES_RECEIVABLE	NUMBER
ACCOUNTS_RECEIVABLE	NUMBER
LESS_ALLOWANCES_FOR_UNCOLLECTIBLE_NOTES_AND_ACCOUNTS_RECEIVABLE	NUMBER
INVENTORY	NUMBER
PREPAID_EXPENSES	NUMBER
OTHER_CURRENT_ASSETS	NUMBER
TOTAL_CURRENT_ASSETS	NUMBER
LAND	NUMBER
LAND_IMPROVEMENTS	NUMBER
BUILDINGS	NUMBER
LEASEHOLD_IMPROVEMENTS	NUMBER
FIXED_EQUIPMENT	NUMBER
MAJOR_MOVABLE_EQUIPMENT	NUMBER
MINOR_EQUIPMENT_DEPRECIABLE	TEXT
TOTAL_FIXED_ASSETS	NUMBER
INVESTMENTS	NUMBER
OTHER_ASSETS	NUMBER
TOTAL_OTHER_ASSETS	NUMBER
TOTAL_ASSETS	NUMBER
ACCOUNTS_PAYABLE	NUMBER
SALARIES_WAGES_AND_FEES_PAYABLE	NUMBER
PAYROLL_TAXES_PAYABLE	NUMBER
NOTES_AND_LOANS_PAYABLE_SHORT_TERM_	NUMBER
DEFERRED_INCOME	NUMBER
OTHER_CURRENT_LIABILITIES	NUMBER
TOTAL_CURRENT_LIABILITIES	NUMBER
MORTGAGE_PAYABLE	NUMBER
NOTES_PAYABLE	NUMBER
UNSECURED_LOANS	TEXT
OTHER_LONG_TERM_LIABILITIES	NUMBER
TOTAL_LONG_TERM_LIABILITIES	NUMBER
TOTAL_LIABILITIES	NUMBER
GENERAL_FUND_BALANCE	NUMBER
TOTAL_FUND_BALANCES	NUMBER
TOTAL_LIABILITIES_AND_FUND_BALANCES	NUMBER
TOTAL_GENERAL_INPATIENT_CARE_SERVICES_REVENUE	NUMBER
INPATIENT_REVENUE	NUMBER
OUTPATIENT_REVENUE	NUMBER
GROSS_REVENUE	NUMBER
LESS_CONTRACTUAL_ALLOWANCE_AND_DISCOUNTS_ON_PATIENTS_ACCOUNTS	NUMBER
NET_PATIENT_REVENUE	NUMBER
LESS_TOTAL_OPERATING_EXPENSE	NUMBER
NET_INCOME_FROM_SERVICE_TO_PATIENTS	NUMBER
TOTAL_OTHER_INCOME	NUMBER
TOTAL_INCOME	NUMBER
NET_INCOME	NUMBER
INPATIENT_PPS_AMOUNT	NUMBER
NURSING_AND_ALLIED_HEALTH_EDUCATION_ACTIVITIES	TEXT
ALLOWABLE_BAD_DEBTS	NUMBER

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file — joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed — joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

SELECT d.RPT_REC_NUM, d.PROVIDER_CCN, d.FACILITY_NAME,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.SKILLED_NURSING_FACILITY_COST_REPORT d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

• Official CMS documentation

• Skilled Nursing Facility Cost Report Methodology

Frequently asked questions

How often is Skilled Nursing Facility Cost Report updated?

Annually. CMS last published this feed on 2025-12-19, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Skilled Nursing Facility Cost Report cover?

2011 through 2023 — 13 annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.

How many records are in Skilled Nursing Facility Cost Report?

238,211 rows across all 16 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.

How do I get Skilled Nursing Facility Cost Report data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.SKILLED_NURSING_FACILITY_COST_REPORT directly — no pipeline setup required.

Related feeds

Hospital Provider Cost ReportMedicare Post-Acute Care Utilization - Skilled Nursing Facility by Geography and ProviderPayroll Based Journal Employee Detail Nursing Home StaffingMedicare Post-Acute Care Utilization - Skilled Nursing Facility by Geography, Provider and ServiceMedicare Post-Acute Care Utilization - Skilled Nursing Facility

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share — the database and DWV schema appear in your account immediately

3. Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →