About this Dataset

Nursing Home Affiliated Entity Performance Measures

The Nursing Home Affiliated Entity Performance Measures dataset provides select quality and performance measures from Care Compare for groups of nursing homes that share common individual or organizational owners, officers, or entities with operational/managerial control. The data include measures such as average health and staffing star ratings, staffing measures, average quality star ratings, select enforcement remedies, claims-based and Minimum Data Set (MDS) measures, average Skilled Nursing Facility Quality Reporting Program (SNF QRP) metrics, and COVID-19 vaccination rates.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-08-14T20:58:28.869416
Tags: hospitals-facilities, medicare, skilled-nursing

Tables

Nursing Home Chain Performance Measures : 2023-06-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2023_06_01

126.98 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2023-07-21

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2023_07_21

126.69 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2023-08-29

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2023_08_29

124.47 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2023-09-21

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2023_09_21

123.99 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2023-10-18

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2023_10_18

124.26 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2023-11-30

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2023_11_30

123.28 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-01-25

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_01_25

123.84 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-02-22

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_02_22

124.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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-03-22

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_03_22

124.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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-04-25

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_04_25

125.22 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-05-30

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_05_30

125.35 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-06-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_06_01

125.22 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-07-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_07_01

124.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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-08-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_08_01

124.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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-09-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_09_01

124.65 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-10-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_10_01

124.49 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2024-11-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2024_11_01

124.9 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_made_im_ed149071" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "average_percentage_of_long_stay_high_risk_residents_wi_bfda3856" DOUBLE,
  "average_percentage_of_long_stay_residents_with_a_urina_5b48e0fe" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_low_risk_residents_who_41cef78e" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2025-01-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2025_01_01

124.45 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_are_at__1e954b3c" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "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_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2025-02-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2025_02_01

124.16 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_are_at__1e954b3c" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "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_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2025-03-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2025_03_01

124.28 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_are_at__1e954b3c" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "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_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2025-04-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2025_04_01

124.61 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_are_at__1e954b3c" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "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_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2025-05-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2025_05_01

124.5 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_are_at__1e954b3c" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "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_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2025-06-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2025_06_01

124.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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_are_at__1e954b3c" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "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_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE,
  "average_percentage_of_current_residents_up_to_date_wit_fae9aa93" DOUBLE,
  "average_percentage_of_healthcare_personnel_up_to_date__fb550adb" DOUBLE
);

Nursing Home Chain Performance Measures : 2025-07-01

@usgov.hhs_gov_nursing_home_affiliated_entity_performance_measures.nursing_home_chain_performance_measures_2025_07_01

118.73 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_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_have_ha_4732db74" DOUBLE,
  "average_percentage_of_short_stay_residents_who_newly_r_88ac237c" DOUBLE,
  "average_percentage_of_short_stay_residents_with_pressu_9e102672" DOUBLE,
  "average_percentage_of_short_stay_residents_who_are_at__1e954b3c" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_484d76e6" DOUBLE,
  "average_percentage_of_short_stay_residents_who_were_as_bbb334c9" DOUBLE,
  "average_number_of_hospitalizations_per_1_000_long_stay_26c50fe2" DOUBLE,
  "average_number_of_outpatient_emergency_department_visi_a8acd588" DOUBLE,
  "average_percentage_of_long_stay_residents_who_received_7d0bc4ec" DOUBLE,
  "average_percentage_of_long_stay_residents_experiencing_1e2317d0" DOUBLE,
  "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_who_have_or__2fca1ccb" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_abilit_3d5c7303" DOUBLE,
  "average_percentage_of_long_stay_residents_whose_need_f_044980d2" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_dbbff680" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_ass_c37e7063" DOUBLE,
  "average_percentage_of_long_stay_residents_who_were_phy_4da49d3e" DOUBLE,
  "average_percentage_of_long_stay_residents_with_new_or__981419c4" DOUBLE,
  "average_percentage_of_long_stay_residents_who_lose_too_44e40fda" DOUBLE,
  "average_percentage_of_long_stay_residents_who_have_sym_b61cdc84" DOUBLE,
  "average_percentage_of_long_stay_residents_who_used_ant_397dc454" DOUBLE,
  "average_rate_of_potentially_preventable_hospital_readm_d665e07f" DOUBLE
);