About this Dataset

Nursing Home Chain Performance Measures

The Nursing Home Chain 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, and average Skilled Nursing Facility Quality Reporting Program (SNF QRP) metrics.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:20:55.980780
Tags: hospitals-facilities, medicare, skilled-nursing

Tables

Nursing Home Chain Performance Measures : 2023-06-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2023_06_01

130.03 kB
614 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2023_06_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "avarge_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2023-07-21

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2023_07_21

129.73 kB
611 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2023_07_21 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "avarge_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2023-08-29

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2023_08_29

127.45 kB
592 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2023_08_29 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2023-09-21

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2023_09_21

126.97 kB
587 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2023_09_21 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2023-10-18

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2023_10_18

127.24 kB
585 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2023_10_18 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2023-11-30

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2023_11_30

126.23 kB
581 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2023_11_30 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-01-25

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_01_25

126.82 kB
585 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_01_25 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-02-22

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_02_22

127.68 kB
594 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_02_22 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-03-22

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_03_22

127.98 kB
598 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_03_22 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-04-25

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_04_25

128.23 kB
601 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_04_25 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-05-30

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_05_30

128.36 kB
601 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_05_30 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-06-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_06_01

128.23 kB
601 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_06_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-07-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_07_01

127.96 kB
601 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_07_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-08-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_08_01

127.73 kB
600 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_08_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-09-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_09_01

127.64 kB
600 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_09_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-10-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_10_01

127.48 kB
601 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_10_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2024-11-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2024_11_01

127.89 kB
602 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2024_11_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- Average Percentage Of Short-stay Residents With Pressure Ulcers Or Pressure Injuries That Are New Or Worsened,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE  -- Average Percentage Of Short-stay Residents Who Made Improvements In Function,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE  -- Average Percentage Of Long-stay High-risk Residents With Pressure Ulcers,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE  -- Average Percentage Of Long-stay Low-risk Residents Who Lose Control Of Their Bowels Or Bladder,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2025-01-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2025_01_01

127.44 kB
602 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2025_01_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- 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__1e954b3c" DOUBLE  -- 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_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_residents_with_pressure_ulcers" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE  -- Average Percentage Of Long-stay Residents With New Or Worsened Bowel Or Bladder Incontinence,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2025-02-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2025_02_01

127.14 kB
600 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2025_02_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- 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__1e954b3c" DOUBLE  -- 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_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_residents_with_pressure_ulcers" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE  -- Average Percentage Of Long-stay Residents With New Or Worsened Bowel Or Bladder Incontinence,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2025-03-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2025_03_01

127.26 kB
602 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2025_03_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- 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__1e954b3c" DOUBLE  -- 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_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_residents_with_pressure_ulcers" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE  -- Average Percentage Of Long-stay Residents With New Or Worsened Bowel Or Bladder Incontinence,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2025-04-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2025_04_01

127.6 kB
603 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2025_04_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- 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__1e954b3c" DOUBLE  -- 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_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_residents_with_pressure_ulcers" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE  -- Average Percentage Of Long-stay Residents With New Or Worsened Bowel Or Bladder Incontinence,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2025-05-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2025_05_01

127.49 kB
604 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2025_05_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- 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__1e954b3c" DOUBLE  -- 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_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_residents_with_pressure_ulcers" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE  -- Average Percentage Of Long-stay Residents With New Or Worsened Bowel Or Bladder Incontinence,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2025-06-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2025_06_01

127.69 kB
607 rows
53 columns

CREATE TABLE nursing_home_chain_performance_measures_2025_06_01 (
  "affiliated_entity" VARCHAR,
  "affiliated_entity_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- 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__1e954b3c" DOUBLE  -- 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_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_residents_with_pressure_ulcers" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE  -- Average Percentage Of Long-stay Residents With New Or Worsened Bowel Or Bladder Incontinence,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE  -- Average Percentage Of Current Residents Up To Date With COVID-19 Vaccines,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE  -- Average Percentage Of Healthcare Personnel Up To Date With COVID-19 Vaccines
);

Nursing Home Chain Performance Measures : 2025-07-01

@usgov.hhs_gov_nursing_home_chain_performance_measures.nursing_home_chain_performance_measures_2025_07_01

121.58 kB
605 rows
51 columns

CREATE TABLE nursing_home_chain_performance_measures_2025_07_01 (
  "chain" VARCHAR,
  "chain_id" DOUBLE,
  "number_of_facilities" BIGINT,
  "number_of_states_and_territories_with_operations" BIGINT,
  "number_of_special_focus_facilities_sff" BIGINT  -- Number Of Special Focus Facilities (SFF),
  "number_of_sff_candidates" BIGINT,
  "number_of_facilities_with_an_abuse_icon" BIGINT,
  "percentage_of_facilities_with_an_abuse_icon" DOUBLE,
  "percent_of_facilities_classified_as_for_profit" DOUBLE,
  "percent_of_facilities_classified_as_non_profit" DOUBLE,
  "percent_of_facilities_classified_as_government_owned" DOUBLE,
  "average_overall_5_star_rating" DOUBLE,
  "average_health_inspection_rating" DOUBLE,
  "average_staffing_rating" DOUBLE,
  "average_quality_rating" DOUBLE,
  "average_total_nurse_hours_per_resident_day" DOUBLE,
  "average_total_weekend_nurse_hours_per_resident_day" DOUBLE,
  "average_total_registered_nurse_hours_per_resident_day" DOUBLE,
  "average_total_nursing_staff_turnover_percentage" DOUBLE,
  "average_registered_nurse_turnover_percentage" DOUBLE,
  "average_number_of_administrators_who_have_left_the_nursing_home" DOUBLE,
  "total_number_of_fines" BIGINT,
  "average_number_of_fines" DOUBLE,
  "total_amount_of_fines_in_dollars" DOUBLE,
  "average_amount_of_fines_in_dollars" DOUBLE,
  "total_number_of_payment_denials" BIGINT,
  "average_number_of_payment_denials" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_re_a5b73da8" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Re-hospitalized After A Nursing Home Admission,
  "average_percentage_of_short_stay_residents_who_have_ha_4732db74" DOUBLE  -- Average Percentage Of Short-stay Residents Who Have Had An Outpatient Emergency Department Visit,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE  -- Average Percentage Of Short-stay Residents Who Newly Received An Antipsychotic Medication,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE  -- 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__1e954b3c" DOUBLE  -- 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_as_484d76e6" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE  -- Average Percentage Of Short-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE  -- Average Number Of Hospitalizations Per 1,000 Long-stay Resident Days,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE  -- Average Number Of Outpatient Emergency Department Visits Per 1,000 Long-stay Resident Days,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE  -- Average Percentage Of Long-stay Residents Who Received An Antipsychotic Medication,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE  -- Average Percentage Of Long-stay Residents Experiencing One Or More Falls With Major Injury,
  "average_percentage_of_long_stay_residents_with_pressure_ulcers" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE  -- Average Percentage Of Long-stay Residents With A Urinary Tract Infection,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE  -- 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_abilit_3d5c7303" DOUBLE  -- Average Percentage Of Long-stay Residents Whose Ability To Move Independently Worsened,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE  -- 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_ass_dbbff680" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Seasonal Influenza Vaccine,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Assessed And Appropriately Given The Pneumococcal Vaccine,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE  -- Average Percentage Of Long-stay Residents Who Were Physically Restrained,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE  -- Average Percentage Of Long-stay Residents With New Or Worsened Bowel Or Bladder Incontinence,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE  -- Average Percentage Of Long-stay Residents Who Lose Too Much Weight,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE  -- Average Percentage Of Long-stay Residents Who Have Symptoms Of Depression,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE  -- Average Percentage Of Long-stay Residents Who Used Antianxiety Or Hypnotic Medication,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE  -- Average Rate Of Potentially Preventable Hospital Readmissions 30 Days After Discharge From A SNF
);