Facility-Level Minimum Data Set Frequency

The Facility-Level Minimum Data Set (MDS) Frequency dataset provides information for active nursing home residents on topics, such as race/ethnicity, age, or…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.FACILITYLEVEL_MINIMUM_DATA_SET_FREQUENCY on Snowflake and Databricks — coverage from 2023 to 2026 in a single aligned 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.FACILITYLEVEL_MINIMUM_DATA_SET_FREQUENCY
Databricks	cms_dwv.facilitylevel_minimum_data_set_frequency
Coverage	Oct 2023 – Mar 2026
Rows	344,877,379 (total across all reporting periods)
Cadence	Quarterly
Update pattern	Time-partitioned — each file adds one reporting period
CMS published	2026-04-29
Loaded	2026-04-29
Columns	16 data + 6 lineage
Identifiers	CCN · FIPS codes · ZIP codes
File versions	11
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 2026-04-29. Coverage runs through 2026-03-31. Next CMS release expected ~Jul 2026.

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

Sample queries

Snowflake

-- Each file version covers one reporting period (2023, 2024, 2025, 2026) — history is additive
SELECT *
FROM DWV.FACILITYLEVEL_MINIMUM_DATA_SET_FREQUENCY
LIMIT 100;

Databricks

About this feed

The Facility-Level Minimum Data Set (MDS) Frequency dataset provides information for active nursing home residents on topics, such as race/ethnicity, age, or marital status; discharge dispositions; hearing, speech, and vision; cognitive patterns; mood; functional abilities and goals; bladder and bowel; active diagnoses; health conditions; swallowing/nutritional status; oral/dental status; skin conditions; medications; special treatments, procedures, and programs; restraints and alarms; and participation in assessment and goal setting.

— Source: CMS feed metadata

Keywords: Medicare, Hospitals & Facilities, Skilled Nursing Theme: Medicare

Coverage timeline

2023 🟩 · 2024 🟩 · 2025 🟩 · 2026 🟩

4 of 4 years covered — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2026-01-01 – 2026-03-31	2026-04-29	2026-04-29	✓
2025-10-01 – 2025-12-31	2026-01-28	2026-01-28
2025-07-01 – 2025-09-30	2025-12-05	2025-12-05
2025-04-01 – 2025-06-30	2025-09-12	2025-10-18
2025-04-01 – 2025-06-30	2025-07-30	2025-07-30
2025-01-01 – 2025-03-31	2025-05-07	2025-05-07
2024-10-01 – 2024-12-31	2025-04-02	2025-04-02
2024-07-01 – 2024-09-30	2024-11-04	2024-11-04
2024-04-01 – 2024-06-30	2024-11-04	2024-11-04
2024-01-01 – 2024-03-31	2024-07-31	2024-07-31

Show 1 earlier file version

Reporting period	CMS published	Loaded	Latest file
2023-10-01 – 2023-12-31	2024-07-31	2024-07-31

Data dictionary

📋 16 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Facility-Level Minimum Data Set Frequency data dictionary.

Data columns

Column	Type
CCN	NUMBER
PROVIDER_NAME	TEXT
CITY	TEXT
STATE	TEXT
ZIP_CODE	TEXT
FIPS_COUNTY_CODE	NUMBER
COUNTY_NAME	TEXT
REPORT_DATE	TEXT
MDS_ITEM_QUESTION_DESCRIPTION	TEXT
MDS_ITEM_RESPONSE	TEXT
OVERALL_PERCENT	TEXT
TOTAL_RESIDENTS	TEXT
SHORT_STAY_PERCENT	TEXT
SHORT_STAY_RESIDENTS	TEXT
LONG_STAY_PERCENT	TEXT
LONG_STAY_RESIDENTS	TEXT

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.CCN, d.PROVIDER_NAME, d.CITY,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.FACILITYLEVEL_MINIMUM_DATA_SET_FREQUENCY 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 data dictionary

• Facility Level Minimum Data Set Frequency Methodology

Frequently asked questions

How often is Facility-Level Minimum Data Set Frequency updated?

Quarterly. CMS last published this feed on 2026-04-29, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Facility-Level Minimum Data Set Frequency cover?

2023 through 2026.

How many records are in Facility-Level Minimum Data Set Frequency?

344,877,379 rows across all 11 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.

How do I get Facility-Level Minimum Data Set Frequency 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.FACILITYLEVEL_MINIMUM_DATA_SET_FREQUENCY directly — no pipeline setup required.

Related feeds

Medicare Post-Acute Care Utilization - Skilled Nursing Facility by Geography and ProviderPayroll Based Journal Daily Nurse StaffingLong-Term Care Facility CharacteristicsSkilled Nursing Facility EnrollmentsPayroll Based Journal Daily Non-Nurse Staffing

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 →