Nursing Homes Including Rehab Services - Survey Summary
Deficiency counts by category per facility per inspection cycle — health, fire safety, and specific regulatory categories.
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.NURSING_HOMES_SURVEY_SUMMARY on Snowflake and Databricks — 64 snapshot releases spanning 2020–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_SURVEY_SUMMARY
Databricks
cms_dwv.nursing_homes_survey_summary
Cadence
Monthly
Update pattern
Full-refresh — each file replaces the prior snapshot
CMS published
2026-06-01
Loaded
2026-07-15
Columns
42 data + 6 lineage
Identifiers
CCN · ZIP codes
File versions
64
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 2026-06-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
About this feed
Deficiency counts by category per facility per inspection cycle — health, fire safety, and specific regulatory categories.
— Source: CMS feed metadata
Keywords: nursing homes, survey, deficiencies, inspection Theme: Medicare
Coverage timeline
2020–2026 🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
7 of 7 years with snapshot releases — no gaps.
Release history
Snapshot as of 2026-06-01
2026-06-01
2026-07-15
Snapshot as of 2026-06-01
2026-06-01
2026-06-29
✓
Snapshot as of 2026-05-01
2026-05-01
2026-05-28
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-02-01
2026-02-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-10-01
2025-10-01
2026-03-06
Snapshot as of 2025-09-01
2025-09-01
2026-03-06
Show 54 earlier file versions
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-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-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-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-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-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
Data dictionary
📋 42 data columns + 6 lineage columns
Data columns
DATA_PERIOD
TEXT
Data snapshot period from BATCH_LOG (e.g., '2026-02')
CMS_CERTIFICATION_NUMBER_CCN
TEXT
CMS Certification Number — unique 6-character facility identifier
PROVIDER_NAME
TEXT
Official name of the nursing home facility
PROVIDER_ADDRESS
TEXT
Street address of the facility
CITY_TOWN
TEXT
City or town where the facility is located
STATE
TEXT
Two-letter state abbreviation
ZIP_CODE
TEXT
5-digit ZIP code
INSPECTION_CYCLE
TEXT
Inspection cycle number (1 = most recent, 2 = previous, 3 = oldest)
HEALTH_SURVEY_DATE
DATE
Date of the health survey for this inspection cycle
FIRE_SAFETY_SURVEY_DATE
DATE
Date of the fire safety survey for this inspection cycle
TOTAL_NUMBER_OF_HEALTH_DEFICIENCIES
NUMBER
Total health deficiency count for this inspection cycle
TOTAL_NUMBER_OF_FIRE_SAFETY_DEFICIENCIES
NUMBER
Total fire safety deficiency count for this inspection cycle
COUNT_OF_FREEDOM_FROM_ABUSE_AND_NEGLECT_AND_EXPLOITATION_DEFICIENCIES
NUMBER
Deficiency count: freedom from abuse, neglect, and exploitation
COUNT_OF_QUALITY_OF_LIFE_AND_CARE_DEFICIENCIES
NUMBER
Deficiency count: quality of life and care
COUNT_OF_RESIDENT_ASSESSMENT_AND_CARE_PLANNING_DEFICIENCIES
NUMBER
Deficiency count: resident assessment and care planning
COUNT_OF_NURSING_AND_PHYSICIAN_SERVICES_DEFICIENCIES
NUMBER
Deficiency count: nursing and physician services
COUNT_OF_RESIDENT_RIGHTS_DEFICIENCIES
NUMBER
Deficiency count: resident rights
COUNT_OF_NUTRITION_AND_DIETARY_DEFICIENCIES
NUMBER
Deficiency count: nutrition and dietary
COUNT_OF_PHARMACY_SERVICE_DEFICIENCIES
NUMBER
Deficiency count: pharmacy services
COUNT_OF_ENVIRONMENTAL_DEFICIENCIES
NUMBER
Deficiency count: environmental
COUNT_OF_ADMINISTRATION_DEFICIENCIES
NUMBER
Deficiency count: administration
COUNT_OF_INFECTION_CONTROL_DEFICIENCIES
NUMBER
Deficiency count: infection control
COUNT_OF_EMERGENCY_PREPAREDNESS_DEFICIENCIES
NUMBER
Deficiency count: emergency preparedness
COUNT_OF_AUTOMATIC_SPRINKLER_SYSTEMS_DEFICIENCIES
NUMBER
Fire safety deficiency count: automatic sprinkler systems
COUNT_OF_CONSTRUCTION_DEFICIENCIES
NUMBER
Fire safety deficiency count: construction
COUNT_OF_SERVICES_DEFICIENCIES
NUMBER
Fire safety deficiency count: services
COUNT_OF_CORRIDOR_WALLS_AND_DOORS_DEFICIENCIES
NUMBER
Fire safety deficiency count: corridor walls and doors
COUNT_OF_EGRESS_DEFICIENCIES
NUMBER
Fire safety deficiency count: egress
COUNT_OF_ELECTRICAL_DEFICIENCIES
NUMBER
Fire safety deficiency count: electrical
COUNT_OF_EMERGENCY_PLANS_AND_FIRE_DRILLS_DEFICIENCIES
NUMBER
Fire safety deficiency count: emergency plans and fire drills
COUNT_OF_FIRE_ALARM_SYSTEMS_DEFICIENCIES
NUMBER
Fire safety deficiency count: fire alarm systems
COUNT_OF_SMOKE_DEFICIENCIES
NUMBER
Fire safety deficiency count: smoke detection
COUNT_OF_INTERIOR_DEFICIENCIES
NUMBER
Fire safety deficiency count: interior
COUNT_OF_GAS_AND_VACUUM_AND_ELECTRICAL_SYSTEMS_DEFICIENCIES
NUMBER
Fire safety deficiency count: gas, vacuum, and electrical systems
COUNT_OF_HAZARDOUS_AREA_DEFICIENCIES
NUMBER
Fire safety deficiency count: hazardous areas
COUNT_OF_ILLUMINATION_AND_EMERGENCY_POWER_DEFICIENCIES
NUMBER
Fire safety deficiency count: illumination and emergency power
COUNT_OF_LABORATORIES_DEFICIENCIES
NUMBER
Fire safety deficiency count: laboratories
COUNT_OF_MEDICAL_GASES_AND_ANAESTHETIZING_AREAS_DEFICIENCIES
NUMBER
Fire safety deficiency count: medical gases and anaesthetizing areas
COUNT_OF_SMOKING_REGULATIONS_DEFICIENCIES
NUMBER
Fire safety deficiency count: smoking regulations
COUNT_OF_MISCELLANEOUS_DEFICIENCIES
NUMBER
Fire safety deficiency count: miscellaneous
LOCATION
TEXT
Geocoded location string from CMS
PROCESSING_DATE
DATE
Date CMS processed/released this data snapshot
Lineage columns (present on every feed table)
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:
Source & provenance
Published by the Centers for Medicare & Medicaid Services (bureau 009:38).
Frequently asked questions
How often is Nursing Homes Including Rehab Services - Survey Summary updated?
Monthly. CMS last published this feed on 2026-06-01, and Dataplex loaded it to the warehouse on 2026-07-15. New releases are added automatically when CMS publishes them.
What years does Nursing Homes Including Rehab Services - Survey Summary cover?
2020 through 2026.
How many records are in Nursing Homes Including Rehab Services - Survey Summary?
Count the current snapshot yourself once the share is mounted:
How do I get Nursing Homes Including Rehab Services - Survey Summary 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_SURVEY_SUMMARY directly — no pipeline setup required.
Related feeds
Nursing Homes Including Rehab Services - Provider InformationNursing Homes Including Rehab Services - State Inspection Cut PointsNursing Homes Including Rehab Services - Fire Safety DeficienciesNursing Homes Including Rehab Services - OwnershipNursing Homes Including Rehab Services - Inspection DatesGet this feed
Start a free trial on Snowflake Marketplace or purchase via Databricks
Mount the share — the database and
DWVschema appear in your account immediatelyRun the sample query above — no ETL, no pipeline maintenance
Questions about this feed? Contact us at notifications@dataplex-consulting.com.
Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →
Last updated