> For the complete documentation index, see [llms.txt](https://docs.dataplex-consulting.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-provider-information.md). # Nursing Homes Including Rehab Services - Provider Information Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md) › 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](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset). {% hint style="info" %} **Last CMS publication 2026-06-01** — awaiting the next release. New files load automatically when CMS publishes. {% endhint %} {% hint style="info" %} **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. {% endhint %} ## Sample queries {% tabs %} {% tab title="Snowflake" %} ```sql -- Latest snapshot only (avoids double-counting across file versions) SELECT * FROM DWV.NURSING_HOMES_PROVIDER_INFORMATION WHERE FILE_ID IN ( SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1 ) LIMIT 100; ``` {% endtab %} {% tab title="Databricks" %} ```sql -- Latest snapshot only (avoids double-counting across file versions) SELECT * FROM cms_dwv.nursing_homes_provider_information WHERE file_id IN ( SELECT id FROM cms_dwv.feeds_files WHERE is_latest = 1 ) LIMIT 100; ``` {% endtab %} {% endtabs %} ## 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 | 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-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 | Reporting period | CMS published | Loaded | Latest file | | ------------------------- | ------------- | ---------- | ----------- | | 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** | Column | Type | Description | | ------------------------------------------------------------------ | ------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `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) | 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: ```mermaid erDiagram FEEDS ||--o{ FEEDS_FILES : "ID = FEED_ID" FEEDS ||--o{ NURSING_HOMES_PROVIDER_INFORMATION : "ID = FILE_FEED_ID" FEEDS_FILES ||--o{ NURSING_HOMES_PROVIDER_INFORMATION : "ID = FILE_ID" FEEDS { text ID PK text TITLE text VIEW_NAME text ACCURAL_PERIODICITY } FEEDS_FILES { text ID PK text FEED_ID FK date TEMPORAL_START date TEMPORAL_END date CMS_FEED_MODIFIED number IS_LATEST } NURSING_HOMES_PROVIDER_INFORMATION { text ROW_ID PK text FILE_ID FK text FILE_FEED_ID FK text CMS_CERTIFICATION_NUMBER_CCN text PROVIDER_NAME text PROVIDER_ADDRESS text CITY_TOWN number remaining_95_data_columns } ``` Trace any row back to its source file and reporting period: ```sql SELECT d.CMS_CERTIFICATION_NUMBER_CCN, d.PROVIDER_NAME, d.PROVIDER_ADDRESS, ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED FROM DWV.NURSING_HOMES_PROVIDER_INFORMATION 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](https://data.cms.gov/provider-data/topics/nursing-homes) * [4pq5 N9py](https://data.cms.gov/provider-data/dataset/4pq5-n9py) ## 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: ```sql SELECT COUNT(*) FROM DWV.NURSING_HOMES_PROVIDER_INFORMATION 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 - Provider Information data? It's included in the CMS Data Feeds Dataset on the [Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) (free trial available) and via [Databricks Delta Sharing](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00). Once mounted, query `DWV.NURSING_HOMES_PROVIDER_INFORMATION` directly — no pipeline setup required. ## Related feeds {% content-ref url="/pages/qrQRl0TWSS9bhdKMnLKz" %} [Nursing Homes Including Rehab Services - Fire Safety Deficiencies](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-fire-safety-deficiencies.md) {% endcontent-ref %} {% content-ref url="/pages/mxKIAZ9J1gojFDd2uVrF" %} [Nursing Homes Including Rehab Services - Survey Summary](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-survey-summary.md) {% endcontent-ref %} {% content-ref url="/pages/tHA84Kp2BFdlvJZLVuP9" %} [Nursing Homes Including Rehab Services - Medicare Claims Quality Measures](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-medicare-claims-quality-measures.md) {% endcontent-ref %} {% content-ref url="/pages/JItZoZ6tHConsksTeIRZ" %} [Nursing Homes Including Rehab Services - State Inspection Cut Points](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-state-inspection-cut-points.md) {% endcontent-ref %} {% content-ref url="/pages/eYYbhekCPekvwpbv9J8F" %} [Nursing Homes Including Rehab Services - Citation Code Lookup](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-citation-code-lookup.md) {% endcontent-ref %} ## Get this feed 1. [Start a free trial on Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) or purchase via [Databricks](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00) 2. Mount the share — the database and `DWV` schema appear in your account immediately 3. Run the [sample query](#sample-queries) above — no ETL, no pipeline maintenance Questions about this feed? Contact us at . *** Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset.md) — 280+ feeds · 245B+ records · updated daily. [Back to the full catalog →](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md#nursing-homes-including-rehab-services-provider-information) --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/nursing-homes-including-rehab-services-provider-information.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.