CMS Program Statistics - Medicare SNF Utilization by Geography

Medicare SNF utilization, program payments, and cost sharing by area of residence — US total plus each state/DC and US territories.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.MDCR_SNF_UTILIZATION_BY_GEOGRAPHY on Snowflake and Databricks — 12 snapshot releases spanning 2013–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.MDCR_SNF_UTILIZATION_BY_GEOGRAPHY
Databricks	cms_dwv.mdcr_snf_utilization_by_geography
Cadence	Annual
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2023-12-01
Loaded	2026-04-21
Columns	23 data + 6 lineage
File versions	12
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.

Last CMS publication 2023-12-01 — awaiting the next release. New files load automatically when CMS publishes.

Full-refresh feed — each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.

Sample queries

Snowflake

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.MDCR_SNF_UTILIZATION_BY_GEOGRAPHY
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

Medicare SNF utilization, program payments, and cost sharing by area of residence — US total plus each state/DC and US territories. One row per area per annual release.

— Source: CMS feed metadata

Keywords: Medicare, SNF, program statistics, geography, state, territory, area of residence Theme: Medicare

Coverage timeline

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

11 of 11 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2023-12-01	2023-12-01	2026-04-21	✓
Snapshot as of 2023-12-01	2023-12-01	2026-04-16
Snapshot as of 2022-12-01	2022-12-01	2026-04-16
Snapshot as of 2021-12-01	2021-12-01	2026-04-16
Snapshot as of 2020-12-01	2020-12-01	2026-04-16
Snapshot as of 2019-12-01	2019-12-01	2026-04-16
Snapshot as of 2018-12-01	2018-12-01	2026-04-16
Snapshot as of 2017-12-01	2017-12-01	2026-04-16
Snapshot as of 2016-12-01	2016-12-01	2026-04-16
Snapshot as of 2015-12-01	2015-12-01	2026-04-16

Show 2 earlier file versions

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2014-12-01	2014-12-01	2026-04-16
Snapshot as of 2013-12-01	2013-12-01	2026-04-16

Data dictionary

📋 23 data columns + 6 lineage columns

Data columns

Column	Type	Description
DATA_PERIOD	TEXT	The time frame for the data, represented as a year (YYYY).
AREA_GROUPING	TEXT	Categorization of geographic areas, which may include states, territories, or other defined regions.
AREA_OF_RESIDENCE	TEXT	The specific geographic location where the Medicare beneficiaries reside.
TOTAL_ORIGINAL_MEDICARE_PART_A_ENROLLEES	NUMBER	The total number of individuals enrolled in Original Medicare Part A during the specified period.
TOTAL_PERSONS_WITH_UTILIZATION	NUMBER	The total count of individuals who utilized skilled nursing facility (SNF) services.
TOTAL_COVERED_ADMISSIONS	NUMBER	The total number of admissions to skilled nursing facilities that are covered by Medicare.
COVERED_ADMISSIONS_PER_PERSON_WITH_UTILIZATION	NUMBER	The average number of covered admissions per individual who utilized SNF services.
COVERED_ADMISSIONS_PER_1000_ORIGINAL_MEDICARE_PART_A_ENROLLEES	NUMBER	The rate of covered admissions per 1,000 enrollees in Original Medicare Part A.
TOTAL_COVERED_DAYS_OF_CARE	NUMBER	The total number of days of care provided in skilled nursing facilities that are covered by Medicare.
COVERED_DAYS_OF_CARE_PER_COVERED_ADMISSION	NUMBER	The average number of covered days of care per covered admission to a skilled nursing facility.
COVERED_DAYS_OF_CARE_PER_PERSON_WITH_UTILIZATION	NUMBER	The average number of covered days of care per individual who utilized SNF services.
COVERED_DAYS_OF_CARE_PER_1000_ORIGINAL_MEDICARE_PART_A_ENROLLEES	NUMBER	The rate of covered days of care per 1,000 enrollees in Original Medicare Part A.
TOTAL_PROGRAM_PAYMENTS	NUMBER	The total amount of Medicare program payments made for skilled nursing facility services.
PROGRAM_PAYMENTS_PER_COVERED_ADMISSION	NUMBER	The average Medicare program payment made per covered admission to a skilled nursing facility.
PROGRAM_PAYMENTS_PER_COVERED_DAY	NUMBER	The average Medicare program payment made per covered day of care in skilled nursing facilities.
PROGRAM_PAYMENTS_PER_PERSON_WITH_UTILIZATION	NUMBER	The average Medicare program payment made per individual who utilized SNF services.
PROGRAM_PAYMENTS_PER_ORIGINAL_MEDICARE_PART_A_ENROLLEE	NUMBER	The average Medicare program payment made per enrollee in Original Medicare Part A.
TOTAL_PERSONS_WITH_COINSURANCE	NUMBER	The total number of individuals who incurred coinsurance payments for skilled nursing facility services.
TOTAL_COINSURANCE_DAYS	NUMBER	The total number of days for which coinsurance payments were incurred by beneficiaries.
COINSURANCE_DAYS_PER_PERSON_WITH_COINSURANCE	NUMBER	The average number of coinsurance days per individual who incurred coinsurance payments.
TOTAL_COINSURANCE_PAYMENTS	NUMBER	The total amount of coinsurance payments made by beneficiaries for skilled nursing facility services.
COINSURANCE_PAYMENTS_PER_PERSON_WITH_COINSURANCE	NUMBER	The average coinsurance payment made per individual who incurred such payments.
DISCHARGED_DEAD	NUMBER	The total number of patients discharged from skilled nursing facilities who died during the reporting period.

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.DATA_PERIOD, d.AREA_GROUPING, d.AREA_OF_RESIDENCE,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.MDCR_SNF_UTILIZATION_BY_GEOGRAPHY 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

• CMS Program Statistics Medicare Skilled Nursing Facility

Frequently asked questions

How often is CMS Program Statistics - Medicare SNF Utilization by Geography updated?

Annually. CMS last published this feed on 2023-12-01, and Dataplex loaded it to the warehouse on 2026-04-21. New releases are added automatically when CMS publishes them.

What years does CMS Program Statistics - Medicare SNF Utilization by Geography cover?

2013 through 2023.

How many records are in CMS Program Statistics - Medicare SNF Utilization by Geography?

Count the current snapshot yourself once the share is mounted:

SELECT COUNT(*)
FROM DWV.MDCR_SNF_UTILIZATION_BY_GEOGRAPHY d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;

How do I get CMS Program Statistics - Medicare SNF Utilization by Geography 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.MDCR_SNF_UTILIZATION_BY_GEOGRAPHY directly — no pipeline setup required.

Related feeds

CMS Program Statistics - Medicare SNF Utilization by Demographics and Dual-Eligible StatusCMS Program Statistics - Medicare SNF Utilization by Facility Type and BedsizeCMS Program Statistics - Medicare SNF Utilization by Covered Days of CareCMS Program Statistics - Medicare SNF Utilization by Type of EntitlementHospital All Owners

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 →