Nursing Homes Including Rehab Services - Provider Information
General info, 1-5 star ratings, staffing hours, beds, deficiencies, and penalties summary for ~14,710 CMS-certified nursing homes.
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.NURSING_HOMES_PROVIDER_INFORMATION on Snowflake and Databricks — 82 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_PROVIDER_INFORMATION
Databricks
cms_dwv.nursing_homes_provider_information
Cadence
Monthly
Update pattern
Full-refresh — each file replaces the prior snapshot
CMS published
2026-06-01
Loaded
2026-06-29
Columns
99 data + 6 lineage
Identifiers
CCN · ZIP codes
File versions
82
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
About this feed
General info, 1-5 star ratings, staffing hours, beds, deficiencies, and penalties summary for ~14,710 CMS-certified nursing homes.
— Source: CMS feed metadata
Keywords: nursing homes, ratings, staffing, beds, quality, deficiencies Theme: Medicare
Coverage timeline
2019–2026 🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
8 of 8 years with snapshot releases — no gaps.
Release history
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-02-01
2026-02-01
2026-03-25
Snapshot as of 2023-05-01
2023-05-01
2026-03-24
Snapshot as of 2023-04-01
2023-04-01
2026-03-24
Snapshot as of 2023-03-01
2023-03-01
2026-03-24
Snapshot as of 2023-02-01
2023-02-01
2026-03-24
Snapshot as of 2023-01-01
2023-01-01
2026-03-24
Show 72 earlier file versions
Snapshot as of 2022-11-01
2022-11-01
2026-03-24
Snapshot as of 2022-10-01
2022-10-01
2026-03-24
Snapshot as of 2022-09-01
2022-09-01
2026-03-24
Snapshot as of 2022-08-01
2022-08-01
2026-03-24
Snapshot as of 2022-07-01
2022-07-01
2026-03-24
Snapshot as of 2022-06-01
2022-06-01
2026-03-24
Snapshot as of 2022-05-01
2022-05-01
2026-03-24
Snapshot as of 2022-04-01
2022-04-01
2026-03-24
Snapshot as of 2022-03-01
2022-03-01
2026-03-24
Snapshot as of 2022-02-01
2022-02-01
2026-03-24
Snapshot as of 2022-01-01
2022-01-01
2026-03-24
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
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 2025-12-01
2025-12-01
2026-02-28
Snapshot as of 2025-11-01
2025-11-01
2026-02-28
Snapshot as of 2025-10-01
2025-10-01
2026-02-28
Snapshot as of 2025-09-01
2025-09-01
2026-02-28
Snapshot as of 2025-07-01
2025-07-01
2026-02-28
Snapshot as of 2025-06-01
2025-06-01
2026-02-28
Snapshot as of 2025-05-01
2025-05-01
2026-02-28
Snapshot as of 2025-04-01
2025-04-01
2026-02-28
Snapshot as of 2025-03-01
2025-03-01
2026-02-28
Snapshot as of 2025-02-01
2025-02-01
2026-02-28
Snapshot as of 2024-11-01
2024-11-01
2026-02-28
Snapshot as of 2024-10-01
2024-10-01
2026-02-28
Snapshot as of 2024-09-01
2024-09-01
2026-02-28
Snapshot as of 2024-08-01
2024-08-01
2026-02-28
Snapshot as of 2024-07-01
2024-07-01
2026-02-28
Snapshot as of 2024-06-01
2024-06-01
2026-02-28
Snapshot as of 2024-05-01
2024-05-01
2026-02-28
Snapshot as of 2024-04-01
2024-04-01
2026-02-28
Snapshot as of 2024-03-01
2024-03-01
2026-02-28
Snapshot as of 2024-02-01
2024-02-01
2026-02-28
Snapshot as of 2024-01-01
2024-01-01
2026-02-28
Snapshot as of 2023-11-01
2023-11-01
2026-02-28
Snapshot as of 2023-10-01
2023-10-01
2026-02-28
Snapshot as of 2023-09-01
2023-09-01
2026-02-28
Snapshot as of 2023-08-01
2023-08-01
2026-02-28
Snapshot as of 2023-07-01
2023-07-01
2026-02-28
Snapshot as of 2023-06-01
2023-06-01
2026-02-28
Snapshot as of 2021-11-01
2021-11-01
2026-02-28
Snapshot as of 2021-10-01
2021-10-01
2026-02-28
Snapshot as of 2021-09-01
2021-09-01
2026-02-28
Snapshot as of 2021-08-01
2021-08-01
2026-02-28
Snapshot as of 2021-07-01
2021-07-01
2026-02-28
Snapshot as of 2021-06-01
2021-06-01
2026-02-28
Snapshot as of 2021-05-01
2021-05-01
2026-02-28
Snapshot as of 2021-04-01
2021-04-01
2026-02-28
Snapshot as of 2021-03-01
2021-03-01
2026-02-28
Snapshot as of 2021-02-01
2021-02-01
2026-02-28
Snapshot as of 2021-01-01
2021-01-01
2026-02-28
Snapshot as of 2020-11-01
2020-11-01
2026-02-28
Snapshot as of 2020-10-01
2020-10-01
2026-02-28
Snapshot as of 2020-09-01
2020-09-01
2026-02-28
Snapshot as of 2020-08-01
2020-08-01
2026-02-28
Snapshot as of 2019-12-01
2019-12-01
2026-02-28
Snapshot as of 2019-10-01
2019-10-01
2026-02-28
Snapshot as of 2019-09-01
2019-09-01
2026-02-28
Snapshot as of 2019-08-01
2019-08-01
2026-02-28
Snapshot as of 2019-07-01
2019-07-01
2026-02-28
Snapshot as of 2019-06-01
2019-06-01
2026-02-28
Snapshot as of 2019-05-01
2019-05-01
2026-02-28
Snapshot as of 2019-04-01
2019-04-01
2026-02-28
Snapshot as of 2019-03-01
2019-03-01
2026-02-28
Snapshot as of 2019-02-01
2019-02-01
2026-02-28
Snapshot as of 2019-01-01
2019-01-01
2026-02-28
Snapshot as of 2026-02-01
2026-02-01
2026-02-27
Data dictionary
📋 99 data columns + 6 lineage columns
Data columns
CMS_CERTIFICATION_NUMBER_CCN
TEXT
CMS Certification Number — unique 6-character identifier assigned to each Medicare/Medicaid-certified nursing home
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
State where the provider is located.
ZIP_CODE
TEXT
5-digit ZIP code of the facility
TELEPHONE_NUMBER
TEXT
Facility telephone number
PROVIDER_SSA_COUNTY_CODE
TEXT
Social Security Administration county code for the provider location
COUNTY_PARISH
TEXT
County or parish name
URBAN
TEXT
Whether the provider is in an urban area.
OWNERSHIP_TYPE
TEXT
Type of ownership (e.g., For profit - Corporation, Government - State, Non profit - Other)
NUMBER_OF_CERTIFIED_BEDS
NUMBER
Total number of Medicare/Medicaid certified beds in the facility
AVERAGE_NUMBER_OF_RESIDENTS_PER_DAY
NUMBER
Average daily census — the average number of residents in the facility on any given day
AVERAGE_NUMBER_OF_RESIDENTS_PER_DAY_FOOTNOTE
TEXT
Footnote explaining data availability for resident count
PROVIDER_TYPE
TEXT
Medicare/Medicaid participation type (e.g., Medicare, Medicaid, Medicare and Medicaid)
PROVIDER_RESIDES_IN_HOSPITAL
TEXT
Whether the nursing home is located within a hospital (Y/N)
LEGAL_BUSINESS_NAME
TEXT
Legal business entity name that operates the facility
DATE_FIRST_APPROVED
DATE
Date the facility was first approved to participate in Medicare and Medicaid
CHAIN_NAME
TEXT
Name of the corporate chain, if the facility is part of one
CHAIN_ID
TEXT
CMS identifier for the chain organization
NUMBER_OF_FACILITIES_IN_CHAIN
NUMBER
Total number of facilities in the same chain
CHAIN_AVERAGE_OVERALL_5_STAR_RATING
NUMBER
Average overall Five-Star rating across all facilities in the chain
CHAIN_AVERAGE_HEALTH_INSPECTION_RATING
NUMBER
Average health inspection rating across all facilities in the chain
CHAIN_AVERAGE_STAFFING_RATING
NUMBER
Average staffing rating across all facilities in the chain
CHAIN_AVERAGE_QM_RATING
NUMBER
Average quality measure rating across all facilities in the chain
CONTINUING_CARE_RETIREMENT_COMMUNITY
TEXT
Whether the facility is part of a Continuing Care Retirement Community (Y/N)
SPECIAL_FOCUS_STATUS
TEXT
Special Focus Facility (SFF) status — facilities with a history of serious quality issues that CMS monitors more closely. Values include SFF, SFF Candidate, or blank.
ABUSE_ICON
TEXT
Flag indicating the facility has been cited for abuse (Y/N)
MOST_RECENT_HEALTH_INSPECTION_MORE_THAN_2_YEARS_AGO
TEXT
Whether the most recent standard health inspection was more than 2 years ago (Y/N)
PROVIDER_CHANGED_OWNERSHIP_IN_LAST_12_MONTHS
TEXT
Whether the facility changed ownership in the past 12 months (Y/N)
WITH_A_RESIDENT_AND_FAMILY_COUNCIL
TEXT
Whether the facility has resident and/or family councils (Resident, Family, Both, or None)
AUTOMATIC_SPRINKLER_SYSTEMS_IN_ALL_REQUIRED_AREAS
TEXT
Whether automatic sprinkler systems are installed in all required areas (Yes/Partial/No)
OVERALL_RATING
NUMBER
1-5 star overall quality rating from CMS. 5 = much above average, 1 = much below average. Combines health inspection, staffing, and quality measure ratings.
OVERALL_RATING_FOOTNOTE
TEXT
Footnote explaining any data limitations for the overall rating
HEALTH_INSPECTION_RATING
NUMBER
1-5 star rating based on health inspection results over the last 3 survey cycles. 5 = much above average.
HEALTH_INSPECTION_RATING_FOOTNOTE
TEXT
Footnote for health inspection rating
QM_RATING
NUMBER
1-5 star rating based on quality measures (both MDS-derived and claims-based). 5 = much above average.
QM_RATING_FOOTNOTE
TEXT
Footnote for quality measure rating
LONG_STAY_QM_RATING
NUMBER
1-5 star rating based on quality measures for long-stay residents (those in the facility 100+ days)
LONG_STAY_QM_RATING_FOOTNOTE
TEXT
Footnote for long-stay quality measure rating
SHORT_STAY_QM_RATING
NUMBER
1-5 star rating based on quality measures for short-stay residents (those in the facility less than 100 days)
SHORT_STAY_QM_RATING_FOOTNOTE
TEXT
Footnote for short-stay quality measure rating
STAFFING_RATING
NUMBER
1-5 star rating based on staffing levels adjusted for resident case mix. 5 = much above average.
STAFFING_RATING_FOOTNOTE
TEXT
Footnote for staffing rating
REPORTED_STAFFING_FOOTNOTE
TEXT
Footnote for reported staffing data
PHYSICAL_THERAPIST_STAFFING_FOOTNOTE
TEXT
Footnote for physical therapist staffing data
REPORTED_NURSE_AIDE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Nurse aide (CNA) hours per resident per day as reported by the facility on its CMS cost reports. Higher values indicate more direct-care time per resident.
REPORTED_LPN_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Licensed Practical Nurse (LPN) hours per resident per day as reported by the facility
REPORTED_RN_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Registered Nurse (RN) hours per resident per day as reported by the facility
REPORTED_LICENSED_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Total licensed nursing staff (RN + LPN) hours per resident per day
REPORTED_TOTAL_NURSE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Total nursing staff (RN + LPN + CNA) hours per resident per day
TOTAL_NURSE_STAFF_HOURS_PER_RESIDENT_PER_DAY_WEEKEND
NUMBER
Total nursing staff hours per resident per day on weekends — often lower than weekday staffing
RN_HOURS_PER_RESIDENT_PER_DAY_WEEKEND
NUMBER
Registered Nurse hours per resident per day on weekends
REPORTED_PT_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Physical therapist hours per resident per day as reported by the facility
TOTAL_NURSING_STAFF_TURNOVER
NUMBER
Annual turnover rate for all nursing staff as a percentage. Higher turnover is generally associated with lower quality of care.
TOTAL_NURSING_STAFF_TURNOVER_FOOTNOTE
TEXT
Footnote for nursing staff turnover data
REGISTERED_NURSE_TURNOVER
NUMBER
Annual turnover rate for RNs specifically, as a percentage
REGISTERED_NURSE_TURNOVER_FOOTNOTE
TEXT
Footnote for RN turnover data
NUMBER_OF_ADMINISTRATORS_WHO_HAVE_LEFT
NUMBER
Number of nursing home administrators who have left the facility in the past 12 months
ADMINISTRATOR_TURNOVER_FOOTNOTE
TEXT
Footnote for administrator turnover data
NURSING_CASE_MIX_INDEX
NUMBER
Nursing case-mix index reflecting the average acuity of residents. Higher values indicate more complex care needs.
NURSING_CASE_MIX_INDEX_RATIO
NUMBER
Ratio of this facility's case-mix index to the national average. Values >1 indicate higher-than-average acuity.
CASE_MIX_NURSE_AIDE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
CNA hours per resident per day adjusted for resident case mix — enables fair comparison across facilities with different acuity levels
CASE_MIX_LPN_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
LPN hours per resident per day adjusted for case mix
CASE_MIX_RN_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
RN hours per resident per day adjusted for case mix
CASE_MIX_TOTAL_NURSE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Total nursing hours per resident per day adjusted for case mix
CASE_MIX_WEEKEND_TOTAL_NURSE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Weekend total nursing hours per resident per day adjusted for case mix
ADJUSTED_NURSE_AIDE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
CNA hours per resident per day adjusted for both case mix and geographic wage differences
ADJUSTED_LPN_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
LPN hours per resident per day adjusted for case mix and geographic wages
ADJUSTED_RN_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
RN hours per resident per day adjusted for case mix and geographic wages
ADJUSTED_TOTAL_NURSE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Total nursing hours per resident per day adjusted for case mix and geographic wages
ADJUSTED_WEEKEND_TOTAL_NURSE_STAFFING_HOURS_PER_RESIDENT_PER_DAY
NUMBER
Weekend total nursing hours per resident per day adjusted for case mix and geographic wages
RATING_CYCLE_1_STANDARD_SURVEY_HEALTH_DATE
DATE
Date of the most recent (Cycle 1) standard health inspection survey
RATING_CYCLE_1_TOTAL_NUMBER_OF_HEALTH_DEFICIENCIES
NUMBER
Total health deficiencies found in Cycle 1 (most recent inspection)
RATING_CYCLE_1_NUMBER_OF_STANDARD_HEALTH_DEFICIENCIES
NUMBER
Standard (non-complaint) deficiencies found in Cycle 1
RATING_CYCLE_1_NUMBER_OF_COMPLAINT_HEALTH_DEFICIENCIES
NUMBER
Complaint-related deficiencies found in Cycle 1
RATING_CYCLE_1_HEALTH_DEFICIENCY_SCORE
NUMBER
Weighted deficiency score for Cycle 1 — accounts for scope and severity of each deficiency
RATING_CYCLE_1_NUMBER_OF_HEALTH_REVISITS
NUMBER
Number of revisit inspections in Cycle 1
RATING_CYCLE_1_HEALTH_REVISIT_SCORE
NUMBER
Score based on Cycle 1 revisit outcomes
RATING_CYCLE_1_TOTAL_HEALTH_SCORE
NUMBER
Combined deficiency + revisit score for Cycle 1
RATING_CYCLE_2_STANDARD_HEALTH_SURVEY_DATE
DATE
Date of the second most recent (Cycle 2) standard health inspection
RATING_CYCLE_2_3_TOTAL_NUMBER_OF_HEALTH_DEFICIENCIES
NUMBER
Total health deficiencies found across Cycles 2 and 3
RATING_CYCLE_2_NUMBER_OF_STANDARD_HEALTH_DEFICIENCIES
NUMBER
Standard deficiencies found in Cycle 2
RATING_CYCLE_2_3_NUMBER_OF_COMPLAINT_HEALTH_DEFICIENCIES
NUMBER
Complaint-related deficiencies found across Cycles 2 and 3
RATING_CYCLE_2_3_HEALTH_DEFICIENCY_SCORE
NUMBER
Weighted deficiency score for Cycles 2 and 3
RATING_CYCLE_2_3_NUMBER_OF_HEALTH_REVISITS
NUMBER
Number of revisit inspections across Cycles 2 and 3
RATING_CYCLE_2_3_HEALTH_REVISIT_SCORE
NUMBER
Score based on Cycles 2-3 revisit outcomes
RATING_CYCLE_2_3_TOTAL_HEALTH_SCORE
NUMBER
Combined deficiency + revisit score for Cycles 2 and 3
TOTAL_WEIGHTED_HEALTH_SURVEY_SCORE
NUMBER
Weighted composite score across all inspection cycles — the primary input to the health inspection star rating
NUMBER_OF_CITATIONS_FROM_INFECTION_CONTROL_INSPECTIONS
NUMBER
Number of deficiency citations from infection control inspections
NUMBER_OF_FINES
NUMBER
Total number of federal fines imposed on the facility in the last 3 years
TOTAL_AMOUNT_OF_FINES_IN_DOLLARS
NUMBER
Total dollar amount of fines imposed in the last 3 years
NUMBER_OF_PAYMENT_DENIALS
NUMBER
Number of Medicare payment denials imposed in the last 3 years
TOTAL_NUMBER_OF_PENALTIES
NUMBER
Total penalties (fines + payment denials) in the last 3 years
LOCATION
TEXT
Geographic location of the facility.
LATITUDE
NUMBER
Latitude coordinate of the facility.
LONGITUDE
NUMBER
Longitude coordinate of the facility.
GEOCODING_FOOTNOTE
TEXT
Footnote about geocoding accuracy or data availability
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 - Provider Information 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 - Provider Information cover?
2019 through 2026.
How many records are in Nursing Homes Including Rehab Services - Provider Information?
Count the current snapshot yourself once the share is mounted:
How do I get Nursing Homes Including Rehab Services - Provider Information 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_PROVIDER_INFORMATION directly — no pipeline setup required.
Related feeds
Nursing Homes Including Rehab Services - Fire Safety DeficienciesNursing Homes Including Rehab Services - Survey SummaryNursing Homes Including Rehab Services - Medicare Claims Quality MeasuresNursing Homes Including Rehab Services - State Inspection Cut PointsNursing Homes Including Rehab Services - Citation Code LookupGet 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