NHFD Annual Report 2022 Data
Healthcare Quality Improvement Partnership
@ukgov.nhfd_annual_report_2022_data
Healthcare Quality Improvement Partnership
@ukgov.nhfd_annual_report_2022_data
CREATE TABLE nhfd_2022_facilities_audit_transparency_data (
"hospital_nhfd_code" VARCHAR,
"hospital_name" VARCHAR,
"when_patients_present_to_your_ed_with_a_new_hip_fractu_d0a086f8" VARCHAR,
"other" VARCHAR,
"if_patients_with_hip_fracture_have_been_started_on_ora_50293181" VARCHAR,
"are_you_aware_of_the_requirement_to_peri_prosthetic_fe_de312b46" VARCHAR,
"do_you_routinely_input_details_of_patients_sustaining__b7a16ec0" VARCHAR,
"if_no_why_not" VARCHAR,
"in_your_hospital_will_a_senior_st3_orthogeriatrician_r_7fe71d99" VARCHAR,
"how_many_consultant_orthopaedic_surgeons_or_sas_grade__0a69d980" DOUBLE,
"around_a_thr_how_many_consultant_orthopaedic_surgeons__eb63b6b6" DOUBLE,
"around_a_tkr_how_many_consultant_orthopaedic_surgeons__b4d1cba5" DOUBLE,
"around_a_thr_do_you_have_a_formal_process_whereby_a_sp_392e32fe" VARCHAR,
"around_a_tkr_do_you_have_a_formal_process_whereby_a_sp_baad58d3" VARCHAR,
"around_a_thr_do_you_have_at_least_one_nominated_dedica_2f0c01b1" VARCHAR,
"around_a_tkr_do_you_have_at_least_one_nominated_dedica_b0713ca8" VARCHAR,
"ppff_around_a_thr_do_you_transfer_patients_from_your_d_fb13f7c8" VARCHAR,
"ppff_around_a_thr_how_frequently_are_patients_transferred" VARCHAR,
"ppff_around_a_thr_why_are_patients_transferred" VARCHAR,
"ppff_around_a_thr_are_patients_transferred_directly_fr_be1376a1" VARCHAR,
"ppff_around_a_thr_which_hospital_do_you_transfer_these_afcf6d6e" VARCHAR,
"ppff_around_a_tkr_do_you_transfer_patients_from_your_d_daa46b20" VARCHAR,
"ppff_around_a_tkr_how_frequently_are_patients_transferred" VARCHAR,
"ppff_around_a_tkr_why_are_patients_transferred" VARCHAR,
"ppff_around_a_tkr_are_patients_transferred_directly_fr_c022bce6" VARCHAR,
"ppff_around_a_tkr_which_hospital_do_you_transfer_these_00f3bc3e" VARCHAR,
"patients_with_hip_fracture_not_ppff_do_you_transfer_pa_6a41c97a" VARCHAR,
"patients_with_hip_fracture_not_ppff_how_frequently_are_8614bef9" VARCHAR,
"patients_with_hip_fracture_not_ppff_why_are_patients_t_d5f3d56d" VARCHAR,
"patients_with_hip_fracture_not_ppff_are_patients_trans_c5d8a8f2" VARCHAR,
"patients_with_hip_fracture_not_ppff_which_hospital_do__5b769fad" VARCHAR,
"patients_with_a_ppff_around_a_thr_do_you_receive_trans_eb9b4418" VARCHAR,
"patients_with_a_ppff_around_a_thr_does_this_follow_a_f_fe300b75" VARCHAR,
"patients_with_a_ppff_around_a_thr_where_do_you_receive_2d138d6d" VARCHAR,
"patients_with_a_ppff_around_a_tkr_do_you_receive_trans_ec8f011a" VARCHAR,
"patients_with_a_ppff_around_a_tkr_does_this_follow_a_f_a3660b23" VARCHAR,
"patients_with_a_ppff_around_a_tkr_where_do_you_receive_77813796" VARCHAR,
"patients_with_hip_fracture_not_ppff_do_you_receive_tra_add66218" VARCHAR,
"patients_with_hip_fracture_not_ppff_does_this_follow_a_6c01fbc8" VARCHAR,
"patients_with_hip_fracture_not_ppff_where_do_you_recei_4ee28c6f" VARCHAR,
"for_thr_do_you_have_a_local_revision_mdt_within_hospit_e3cbac0d" VARCHAR,
"for_tkr_do_you_have_a_local_revision_mdt_within_hospit_b6610dee" VARCHAR,
"for_thr_do_you_participate_in_a_regional_revision_mdt__7987f774" VARCHAR,
"for_tkr_do_you_participate_in_a_regional_revision_mdt__ed657e1e" VARCHAR,
"for_hips_do_you_routinely_discuss_all_ppff_with_other__6d8530f9" VARCHAR,
"for_knees_do_you_routinely_discuss_all_ppff_with_other_5e048a1f" VARCHAR,
"for_hips_do_you_routinely_discuss_all_ppff_in_your_reg_90143dbb" VARCHAR,
"for_knees_do_you_routinely_discuss_all_ppff_in_your_re_a75e418b" VARCHAR,
"n__in_the_nhfd_2020_annual_report_suggest_that_theatre_46677cf1" VARCHAR,
"n__in_the_nhfd_2020_annual_report_suggest_that_theatre_8be747bb" VARCHAR,
"n__in_the_nhfd_2020_annual_report_suggest_that_theatre_46ac8108" VARCHAR,
"n__in_the_nhfd_2020_annual_report_suggest_that_theatre_f87864f1" VARCHAR,
"case_scenario_how_would_you_manage_this_patient" VARCHAR,
"case_scenario_if_you_selected_revision_surgery_or_a_co_3dea3ede" VARCHAR,
"case_scenario_do_you_have_the_system_selected_above_on_4a2c1e0c" VARCHAR,
"case_scenario_if_you_selected_open_reduction_and_inter_ed6f2efc" VARCHAR,
"case_scenario_do_you_have_the_system_selected_above_on_27b1bd75" VARCHAR,
"case_scenario_would_you_permit_the_patient_to_weight_b_2bef26c1" VARCHAR,
"case_scenario_would_the_operation_be_performed_in_your_072b9e75" VARCHAR,
"case_scenario_who_would_this_operation_be_performed_by_ba22a9d8" VARCHAR,
"case_scenario_would_you_routinely_aspirate_prior_to_re_a2d23a43" VARCHAR
);
Anyone who has the link will be able to view this.