Nursing Home Affiliated Entity Performance Measures
The Nursing Home Affiliated Entity Performance Measures dataset provides select quality and performance measures from Care Compare for groups of nursing homes…
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.NURSING_HOME_AFFILIATED_ENTITY_PERFORMANCE_MEASURES on Snowflake and Databricks — coverage from 2023 to 2025 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.NURSING_HOME_AFFILIATED_ENTITY_PERFORMANCE_MEASURES
Databricks
cms_dwv.nursing_home_affiliated_entity_performance_measures
Coverage
Jun 2023 – Jun 2025
Rows
13,772 (total across all reporting periods)
Cadence
Monthly
Update pattern
Time-partitioned — each file adds one reporting period
CMS published
2025-07-09
Loaded
2025-07-09
Columns
58 data + 6 lineage
File versions
23
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 2025-07-09 — awaiting the next release. New files load automatically when CMS publishes.
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 2025 reporting period.
Sample queries
About this feed
The Nursing Home Affiliated Entity Performance Measures dataset provides select quality and performance measures from Care Compare for groups of nursing homes that share common individual or organizational owners, officers, or entities with operational/managerial control. The data include measures such as average health and staffing star ratings, staffing measures, average quality star ratings, select enforcement remedies, claims-based and Minimum Data Set (MDS) measures, average Skilled Nursing Facility Quality Reporting Program (SNF QRP) metrics, and COVID-19 vaccination rates.
— Source: CMS feed metadata
Keywords: Medicare, Hospitals & Facilities, Skilled Nursing Theme: Medicare
Coverage timeline
2023 🟩 · 2024 🟩 · 2025 🟩
3 of 3 years covered — no gaps.
Release history
2025-06-01 – 2025-06-30
2025-07-09
2025-07-09
✓
2025-05-01 – 2025-05-31
2025-06-11
2025-06-11
2025-04-01 – 2025-04-30
2025-05-14
2025-05-14
2025-03-01 – 2025-03-31
2025-04-02
2025-04-02
2025-02-01 – 2025-02-28
2025-04-02
2025-04-02
2025-01-01 – 2025-01-31
2025-04-02
2025-04-02
2024-11-01 – 2024-11-30
2024-12-11
2024-12-11
2024-10-01 – 2024-10-31
2024-11-13
2024-11-13
2024-09-01 – 2024-09-30
2024-10-09
2024-10-09
2024-08-01 – 2024-08-31
2024-09-04
2024-09-04
Show 13 earlier file versions
2024-07-01 – 2024-07-31
2024-08-07
2024-08-07
2024-06-01 – 2024-06-30
2024-07-10
2024-07-10
2024-05-01 – 2024-05-31
2024-06-12
2024-06-12
2024-04-01 – 2024-04-30
2024-05-08
2024-05-08
2024-03-01 – 2024-03-31
2024-04-03
2024-04-03
2024-02-01 – 2024-02-29
2024-03-06
2024-03-06
2024-01-01 – 2024-01-31
2024-02-07
2024-02-07
2023-11-01 – 2023-11-30
2023-12-13
2023-12-13
2023-10-01 – 2023-10-31
2023-11-17
2023-11-17
2023-09-01 – 2023-09-30
2023-10-04
2023-10-04
2023-08-01 – 2023-08-31
2023-09-21
2023-09-21
2023-07-01 – 2023-07-31
2023-07-26
2023-08-29
2023-06-01 – 2023-06-30
2023-06-28
2023-08-29
Data dictionary
📋 58 data columns + 6 lineage columns
Data columns
AFFILIATED_ENTITY
TEXT
AFFILIATED_ENTITY_ID
NUMBER
NUMBER_OF_FACILITIES
NUMBER
NUMBER_OF_STATES_AND_TERRITORIES_WITH_OPERATIONS
NUMBER
NUMBER_OF_SPECIAL_FOCUS_FACILITIES_SFF_
NUMBER
NUMBER OF SPECIAL FOCUS FACILITIES (SFF)
NUMBER_OF_SFF_CANDIDATES
NUMBER
NUMBER_OF_FACILITIES_WITH_AN_ABUSE_ICON
NUMBER
PERCENTAGE_OF_FACILITIES_WITH_AN_ABUSE_ICON
NUMBER
PERCENT_OF_FACILITIES_CLASSIFIED_AS_FOR_PROFIT
NUMBER
PERCENT OF FACILITIES CLASSIFIED AS FOR-PROFIT
PERCENT_OF_FACILITIES_CLASSIFIED_AS_NON_PROFIT
NUMBER
PERCENT OF FACILITIES CLASSIFIED AS NON-PROFIT
PERCENT_OF_FACILITIES_CLASSIFIED_AS_GOVERNMENT_OWNED
NUMBER
PERCENT OF FACILITIES CLASSIFIED AS GOVERNMENT-OWNED
AVERAGE_OVERALL_5_STAR_RATING
NUMBER
AVERAGE OVERALL 5-STAR RATING
AVERAGE_HEALTH_INSPECTION_RATING
NUMBER
AVERAGE_STAFFING_RATING
NUMBER
AVERAGE_QUALITY_RATING
NUMBER
AVERAGE_TOTAL_NURSE_HOURS_PER_RESIDENT_DAY
NUMBER
AVERAGE_TOTAL_WEEKEND_NURSE_HOURS_PER_RESIDENT_DAY
NUMBER
AVERAGE_TOTAL_REGISTERED_NURSE_HOURS_PER_RESIDENT_DAY
NUMBER
AVERAGE_TOTAL_NURSING_STAFF_TURNOVER_PERCENTAGE
NUMBER
AVERAGE_REGISTERED_NURSE_TURNOVER_PERCENTAGE
NUMBER
AVERAGE_NUMBER_OF_ADMINISTRATORS_WHO_HAVE_LEFT_THE_NURSING_HOME
NUMBER
TOTAL_NUMBER_OF_FINES
NUMBER
AVERAGE_NUMBER_OF_FINES
NUMBER
TOTAL_AMOUNT_OF_FINES_IN_DOLLARS
NUMBER
AVERAGE_AMOUNT_OF_FINES_IN_DOLLARS
NUMBER
TOTAL_NUMBER_OF_PAYMENT_DENIALS
NUMBER
AVERAGE_NUMBER_OF_PAYMENT_DENIALS
NUMBER
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WHO_WERE_RE_HOSPITALIZED_AFTER_A_NURSING_HOME_ADMISSION
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WHO WERE RE-HOSPITALIZED AFTER A NURSING HOME ADMISSION
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WHO_HAVE_HAD_AN_OUTPATIENT_EMERGENCY_DEPARTMENT_VISIT
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WHO HAVE HAD AN OUTPATIENT EMERGENCY DEPARTMENT VISIT
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WHO_NEWLY_RECEIVED_AN_ANTIPSYCHOTIC_MEDICATION
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WHO NEWLY RECEIVED AN ANTIPSYCHOTIC MEDICATION
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WITH_PRESSURE_ULCERS_OR_PRESSURE_INJURIES_THAT_ARE_NEW_OR_WORSENED
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WITH PRESSURE ULCERS OR PRESSURE INJURIES THAT ARE NEW OR WORSENED
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WHO_ARE_AT_OR_ABOVE_AN_EXPECTED_ABILITY_TO_CARE_FOR_THEMSELVES_AND_MOVE_AROUND_AT_DISCHARGE
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WHO ARE AT OR ABOVE AN EXPECTED ABILITY TO CARE FOR THEMSELVES AND MOVE AROUND AT DISCHARGE
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WHO_WERE_ASSESSED_AND_APPROPRIATELY_GIVEN_THE_SEASONAL_INFLUENZA_VACCINE
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WHO WERE ASSESSED AND APPROPRIATELY GIVEN THE SEASONAL INFLUENZA VACCINE
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WHO_WERE_ASSESSED_AND_APPROPRIATELY_GIVEN_THE_PNEUMOCOCCAL_VACCINE
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WHO WERE ASSESSED AND APPROPRIATELY GIVEN THE PNEUMOCOCCAL VACCINE
AVERAGE_NUMBER_OF_HOSPITALIZATIONS_PER_1_000_LONG_STAY_RESIDENT_DAYS
NUMBER
AVERAGE NUMBER OF HOSPITALIZATIONS PER 1,000 LONG-STAY RESIDENT DAYS
AVERAGE_NUMBER_OF_OUTPATIENT_EMERGENCY_DEPARTMENT_VISITS_PER_1_000_LONG_STAY_RESIDENT_DAYS
NUMBER
AVERAGE NUMBER OF OUTPATIENT EMERGENCY DEPARTMENT VISITS PER 1,000 LONG-STAY RESIDENT DAYS
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_RECEIVED_AN_ANTIPSYCHOTIC_MEDICATION
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO RECEIVED AN ANTIPSYCHOTIC MEDICATION
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_EXPERIENCING_ONE_OR_MORE_FALLS_WITH_MAJOR_INJURY
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS EXPERIENCING ONE OR MORE FALLS WITH MAJOR INJURY
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WITH_PRESSURE_ULCERS
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WITH PRESSURE ULCERS
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WITH_A_URINARY_TRACT_INFECTION
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WITH A URINARY TRACT INFECTION
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_HAVE_OR_HAD_A_CATHETER_INSERTED_AND_LEFT_IN_THEIR_BLADDER
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO HAVE OR HAD A CATHETER INSERTED AND LEFT IN THEIR BLADDER
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHOSE_ABILITY_TO_MOVE_INDEPENDENTLY_WORSENED
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHOSE ABILITY TO MOVE INDEPENDENTLY WORSENED
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHOSE_NEED_FOR_HELP_WITH_ACTIVITIES_OF_DAILY_LIVING_HAS_INCREASED
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHOSE NEED FOR HELP WITH ACTIVITIES OF DAILY LIVING HAS INCREASED
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_WERE_ASSESSED_AND_APPROPRIATELY_GIVEN_THE_SEASONAL_INFLUENZA_VACCINE
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO WERE ASSESSED AND APPROPRIATELY GIVEN THE SEASONAL INFLUENZA VACCINE
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_WERE_ASSESSED_AND_APPROPRIATELY_GIVEN_THE_PNEUMOCOCCAL_VACCINE
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO WERE ASSESSED AND APPROPRIATELY GIVEN THE PNEUMOCOCCAL VACCINE
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_WERE_PHYSICALLY_RESTRAINED
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO WERE PHYSICALLY RESTRAINED
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WITH_NEW_OR_WORSENED_BOWEL_OR_BLADDER_INCONTINENCE
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WITH NEW OR WORSENED BOWEL OR BLADDER INCONTINENCE
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_LOSE_TOO_MUCH_WEIGHT
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO LOSE TOO MUCH WEIGHT
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_HAVE_SYMPTOMS_OF_DEPRESSION
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO HAVE SYMPTOMS OF DEPRESSION
AVERAGE_PERCENTAGE_OF_LONG_STAY_RESIDENTS_WHO_USED_ANTIANXIETY_OR_HYPNOTIC_MEDICATION
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY RESIDENTS WHO USED ANTIANXIETY OR HYPNOTIC MEDICATION
AVERAGE_RATE_OF_POTENTIALLY_PREVENTABLE_HOSPITAL_READMISSIONS_30_DAYS_AFTER_DISCHARGE_FROM_A_SNF
NUMBER
AVERAGE_PERCENTAGE_OF_CURRENT_RESIDENTS_UP_TO_DATE_WITH_COVID_19_VACCINES
NUMBER
AVERAGE PERCENTAGE OF CURRENT RESIDENTS UP TO DATE WITH COVID-19 VACCINES
AVERAGE_PERCENTAGE_OF_HEALTHCARE_PERSONNEL_UP_TO_DATE_WITH_COVID_19_VACCINES
NUMBER
AVERAGE PERCENTAGE OF HEALTHCARE PERSONNEL UP TO DATE WITH COVID-19 VACCINES
__AFFILIATED_ENTITY
TEXT
AVARGE_TOTAL_REGISTERED_NURSE_HOURS_PER_RESIDENT_DAY
NUMBER
AVERAGE_PERCENTAGE_OF_SHORT_STAY_RESIDENTS_WHO_MADE_IMPROVEMENTS_IN_FUNCTION
NUMBER
AVERAGE PERCENTAGE OF SHORT-STAY RESIDENTS WHO MADE IMPROVEMENTS IN FUNCTION
AVERAGE_PERCENTAGE_OF_LONG_STAY_HIGH_RISK_RESIDENTS_WITH_PRESSURE_ULCERS
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY HIGH-RISK RESIDENTS WITH PRESSURE ULCERS
AVERAGE_PERCENTAGE_OF_LONG_STAY_LOW_RISK_RESIDENTS_WHO_LOSE_CONTROL_OF_THEIR_BOWELS_OR_BLADDER
NUMBER
AVERAGE PERCENTAGE OF LONG-STAY LOW-RISK RESIDENTS WHO LOSE CONTROL OF THEIR BOWELS OR BLADDER
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 Home Affiliated Entity Performance Measures updated?
Monthly. CMS last published this feed on 2025-07-09, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.
What years does Nursing Home Affiliated Entity Performance Measures cover?
2023 through 2025.
How many records are in Nursing Home Affiliated Entity Performance Measures?
13,772 rows across all 23 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.
How do I get Nursing Home Affiliated Entity Performance Measures 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_HOME_AFFILIATED_ENTITY_PERFORMANCE_MEASURES directly — no pipeline setup required.
Related feeds
Medicare Advantage Geographic Variation - National & StateMedicare Post-Acute Care Utilization - Skilled Nursing FacilityPayroll Based Journal Employee Detail Nursing Home StaffingFacility-Level Minimum Data Set FrequencySkilled Nursing Facility Cost ReportGet 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