Nursing Homes Including Rehab Services - State Inspection Cut Points

Health inspection star rating cut points by state — thresholds for 1-5 star ratings.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.NURSING_HOMES_STATE_INSPECTION_CUT_POINTS on Snowflake and Databricks — 88 snapshot releases spanning 2019–2026, 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.NURSING_HOMES_STATE_INSPECTION_CUT_POINTS
Databricks	cms_dwv.nursing_homes_state_inspection_cut_points
Cadence	Monthly
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2026-06-01
Loaded	2026-06-29
Columns	7 data + 6 lineage
File versions	88
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-06-01. Coverage runs through 2026-06-01. Next CMS release expected ~Jul 2026.

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.NURSING_HOMES_STATE_INSPECTION_CUT_POINTS
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

Health inspection star rating cut points by state — thresholds for 1-5 star ratings.

— Source: CMS feed metadata

Keywords: nursing homes, inspection, star ratings, cut points, state Theme: Medicare

Coverage timeline

2019–2026 🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

8 of 8 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2026-06-01	2026-06-01	2026-06-29	✓
Snapshot as of 2026-05-01	2026-05-01	2026-05-27
Snapshot as of 2026-04-01	2026-04-01	2026-04-29
Snapshot as of 2026-03-01	2026-03-01	2026-03-26
Snapshot as of 2026-03-01	2026-03-01	2026-03-25
Snapshot as of 2020-07-01	2020-07-01	2026-03-23
Snapshot as of 2020-06-01	2020-06-01	2026-03-23
Snapshot as of 2020-05-01	2020-05-01	2026-03-23
Snapshot as of 2020-04-01	2020-04-01	2026-03-23
Snapshot as of 2020-03-01	2020-03-01	2026-03-23

Show 78 earlier file versions

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2020-02-01	2020-02-01	2026-03-23
Snapshot as of 2020-01-01	2020-01-01	2026-03-23
Snapshot as of 2026-03-01	2026-03-01	2026-03-06
Snapshot as of 2026-02-01	2026-02-01	2026-03-06
Snapshot as of 2026-01-01	2026-01-01	2026-03-06
Snapshot as of 2025-12-01	2025-12-01	2026-03-06
Snapshot as of 2025-11-01	2025-11-01	2026-03-06
Snapshot as of 2025-09-01	2025-09-01	2026-03-06
Snapshot as of 2025-07-01	2025-07-01	2026-03-06
Snapshot as of 2025-06-01	2025-06-01	2026-03-06
Snapshot as of 2025-05-01	2025-05-01	2026-03-06
Snapshot as of 2025-04-01	2025-04-01	2026-03-06
Snapshot as of 2025-03-01	2025-03-01	2026-03-06
Snapshot as of 2025-02-01	2025-02-01	2026-03-06
Snapshot as of 2024-12-01	2024-12-01	2026-03-06
Snapshot as of 2024-11-01	2024-11-01	2026-03-06
Snapshot as of 2024-10-01	2024-10-01	2026-03-06
Snapshot as of 2024-09-01	2024-09-01	2026-03-06
Snapshot as of 2024-08-01	2024-08-01	2026-03-06
Snapshot as of 2024-07-01	2024-07-01	2026-03-06
Snapshot as of 2024-06-01	2024-06-01	2026-03-06
Snapshot as of 2024-05-01	2024-05-01	2026-03-06
Snapshot as of 2024-04-01	2024-04-01	2026-03-06
Snapshot as of 2024-03-01	2024-03-01	2026-03-06
Snapshot as of 2024-02-01	2024-02-01	2026-03-06
Snapshot as of 2024-01-01	2024-01-01	2026-03-06
Snapshot as of 2023-12-01	2023-12-01	2026-03-06
Snapshot as of 2023-11-01	2023-11-01	2026-03-06
Snapshot as of 2023-10-01	2023-10-01	2026-03-06
Snapshot as of 2023-09-01	2023-09-01	2026-03-06
Snapshot as of 2023-08-01	2023-08-01	2026-03-06
Snapshot as of 2023-07-01	2023-07-01	2026-03-06
Snapshot as of 2023-06-01	2023-06-01	2026-03-06
Snapshot as of 2023-05-01	2023-05-01	2026-03-06
Snapshot as of 2023-04-01	2023-04-01	2026-03-06
Snapshot as of 2023-03-01	2023-03-01	2026-03-06
Snapshot as of 2023-02-01	2023-02-01	2026-03-06
Snapshot as of 2023-01-01	2023-01-01	2026-03-06
Snapshot as of 2022-12-01	2022-12-01	2026-03-06
Snapshot as of 2022-11-01	2022-11-01	2026-03-06
Snapshot as of 2022-10-01	2022-10-01	2026-03-06
Snapshot as of 2022-09-01	2022-09-01	2026-03-06
Snapshot as of 2022-08-01	2022-08-01	2026-03-06
Snapshot as of 2022-07-01	2022-07-01	2026-03-06
Snapshot as of 2022-06-01	2022-06-01	2026-03-06
Snapshot as of 2022-05-01	2022-05-01	2026-03-06
Snapshot as of 2022-04-01	2022-04-01	2026-03-06
Snapshot as of 2022-03-01	2022-03-01	2026-03-06
Snapshot as of 2022-02-01	2022-02-01	2026-03-06
Snapshot as of 2022-01-01	2022-01-01	2026-03-06
Snapshot as of 2021-12-01	2021-12-01	2026-03-06
Snapshot as of 2021-11-01	2021-11-01	2026-03-06
Snapshot as of 2021-10-01	2021-10-01	2026-03-06
Snapshot as of 2021-09-01	2021-09-01	2026-03-06
Snapshot as of 2021-08-01	2021-08-01	2026-03-06
Snapshot as of 2021-07-01	2021-07-01	2026-03-06
Snapshot as of 2021-06-01	2021-06-01	2026-03-06
Snapshot as of 2021-05-01	2021-05-01	2026-03-06
Snapshot as of 2021-04-01	2021-04-01	2026-03-06
Snapshot as of 2021-03-01	2021-03-01	2026-03-06
Snapshot as of 2021-02-01	2021-02-01	2026-03-06
Snapshot as of 2021-01-01	2021-01-01	2026-03-06
Snapshot as of 2020-12-01	2020-12-01	2026-03-06
Snapshot as of 2020-11-01	2020-11-01	2026-03-06
Snapshot as of 2020-10-01	2020-10-01	2026-03-06
Snapshot as of 2020-09-01	2020-09-01	2026-03-06
Snapshot as of 2020-08-01	2020-08-01	2026-03-06
Snapshot as of 2019-12-01	2019-12-01	2026-03-06
Snapshot as of 2019-10-01	2019-10-01	2026-03-06
Snapshot as of 2019-09-01	2019-09-01	2026-03-06
Snapshot as of 2019-08-01	2019-08-01	2026-03-06
Snapshot as of 2019-07-01	2019-07-01	2026-03-06
Snapshot as of 2019-06-01	2019-06-01	2026-03-06
Snapshot as of 2019-05-01	2019-05-01	2026-03-06
Snapshot as of 2019-04-01	2019-04-01	2026-03-06
Snapshot as of 2019-03-01	2019-03-01	2026-03-06
Snapshot as of 2019-02-01	2019-02-01	2026-03-06
Snapshot as of 2019-01-01	2019-01-01	2026-03-06

Data dictionary

📋 7 data columns + 6 lineage columns

Data columns

Column	Type	Description
DATA_PERIOD	TEXT	The time frame for which the inspection data is applicable, represented as a date in YYYY-MM-DD format.
STATE	TEXT	The U.S. state in which the nursing home is located, represented by its official postal abbreviation.
FIVE_STARS	TEXT	The minimum inspection score threshold required for a nursing home to receive a five-star rating.
FOUR_STARS	TEXT	The minimum inspection score threshold required for a nursing home to receive a four-star rating.
THREE_STARS	TEXT	The minimum inspection score threshold required for a nursing home to receive a three-star rating.
TWO_STARS	TEXT	The minimum inspection score threshold required for a nursing home to receive a two-star rating.
ONE_STAR	TEXT	The minimum inspection score threshold required for a nursing home to receive a one-star rating.

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.STATE, d.FIVE_STARS,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.NURSING_HOMES_STATE_INSPECTION_CUT_POINTS 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

• Hicp 9999

Frequently asked questions

How often is Nursing Homes Including Rehab Services - State Inspection Cut Points updated?

Monthly. CMS last published this feed on 2026-06-01, and Dataplex loaded it to the warehouse on 2026-06-29. New releases are added automatically when CMS publishes them.

What years does Nursing Homes Including Rehab Services - State Inspection Cut Points cover?

2019 through 2026.

How many records are in Nursing Homes Including Rehab Services - State Inspection Cut Points?

Count the current snapshot yourself once the share is mounted:

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

How do I get Nursing Homes Including Rehab Services - State Inspection Cut Points 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.NURSING_HOMES_STATE_INSPECTION_CUT_POINTS directly — no pipeline setup required.

Related feeds

Nursing Homes Including Rehab Services - Survey SummarySkilled Nursing Facility Quality Reporting Program - Swing BedsNursing Homes Including Rehab Services - Inspection DatesNursing Homes Including Rehab Services - Medicare Claims Quality MeasuresNursing Homes Including Rehab Services - Penalties

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 →