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  -- When Patients Present To Your ED With A New Hip Fracture, What Type Of Ward Would They Normally Be Placed On Until They Go To Theatre For Their Hip Operation?,
  "other" VARCHAR,
  "if_patients_with_hip_fracture_have_been_started_on_ora_50293181" VARCHAR  -- If Patients With Hip Fracture Have Been Started On Oral Osteoporosis Treatment During Their Admission, How Do You Support Them, So That You Know They Are Able To Continue This After Discharge?,
  "are_you_aware_of_the_requirement_to_peri_prosthetic_fe_de312b46" VARCHAR  -- Are You Aware Of The Requirement To Record Peri-Prosthetic Femoral Fracture (PPFF) In The Mandatory National Audit (NHFD)?,
  "do_you_routinely_input_details_of_patients_sustaining__b7a16ec0" VARCHAR  -- Do You Routinely Input Details Of Patients Sustaining PPFF Into The NHFD?,
  "if_no_why_not" VARCHAR  -- If No, Why Not?,
  "in_your_hospital_will_a_senior_st3_orthogeriatrician_r_7fe71d99" VARCHAR  -- In Your Hospital, Will A Senior (ST3+) Orthogeriatrician Routinely Try To Review All Patients Admitted With A PPFF?,
  "how_many_consultant_orthopaedic_surgeons_or_sas_grade__0a69d980" DOUBLE  -- How Many Consultant Orthopaedic Surgeons Or SAS Grade Surgeons Are There Within In Your Hospital Who Operate On Trauma Patients When Required?,
  "around_a_thr_how_many_consultant_orthopaedic_surgeons__eb63b6b6" DOUBLE  -- Around A THR: How Many Consultant Orthopaedic Surgeons Or SAS Grade Surgeons Within Your Hospital Would Feel Comfortable Performing/supervising Both A Revision And Fixation Of A PPFF?,
  "around_a_tkr_how_many_consultant_orthopaedic_surgeons__b4d1cba5" DOUBLE  -- Around A TKR: How Many Consultant Orthopaedic Surgeons Or SAS Grade Surgeons Within Your Hospital Would Feel Comfortable Performing/supervising Both A Revision And Fixation Of A PPFF?,
  "around_a_thr_do_you_have_a_formal_process_whereby_a_sp_392e32fe" VARCHAR  -- Around A THR: Do You Have A Formal Process Whereby A Specialist Hip And/or Knee Surgeon Is Available To Operate On/supervise A PPFF At Least Every Other Weekday (Monday To Friday) Such As A PPFF Rota?,
  "around_a_tkr_do_you_have_a_formal_process_whereby_a_sp_baad58d3" VARCHAR  -- Around A TKR: Do You Have A Formal Process Whereby A Specialist Hip And/or Knee Surgeon Is Available To Operate On/supervise A PPFF At Least Every Other Weekday (Monday To Friday) Such As A PPFF Rota?,
  "around_a_thr_do_you_have_at_least_one_nominated_dedica_2f0c01b1" VARCHAR  -- Around A THR: Do You Have At Least One Nominated, Dedicated Theatre List For Urgent Primary, Urgent Revision Or Periprosthetic Fractures Each Week?,
  "around_a_tkr_do_you_have_at_least_one_nominated_dedica_b0713ca8" VARCHAR  -- Around A TKR: Do You Have At Least One Nominated, Dedicated Theatre List For Urgent Primary, Urgent Revision Or Periprosthetic Fractures Each Week?,
  "ppff_around_a_thr_do_you_transfer_patients_from_your_d_fb13f7c8" VARCHAR  -- PPFF Around A THR: Do You Transfer Patients From Your Department To Another T&O Department At Another Site/hospital/Trust For Definitive Surgery?,
  "ppff_around_a_thr_how_frequently_are_patients_transferred" VARCHAR  -- PPFF Around A THR: How Frequently Are Patients Transferred?,
  "ppff_around_a_thr_why_are_patients_transferred" VARCHAR  -- PPFF Around A THR: Why Are Patients Transferred?,
  "ppff_around_a_thr_are_patients_transferred_directly_fr_be1376a1" VARCHAR  -- PPFF Around A THR: Are Patients Transferred Directly From Your Emergency Department?,
  "ppff_around_a_thr_which_hospital_do_you_transfer_these_afcf6d6e" VARCHAR  -- PPFF Around A THR: Which Hospital Do You Transfer These Patients To?,
  "ppff_around_a_tkr_do_you_transfer_patients_from_your_d_daa46b20" VARCHAR  -- PPFF Around A TKR: Do You Transfer Patients From Your Department To Another T&O Department At Another Site/hospital/Trust For Definitive Surgery?,
  "ppff_around_a_tkr_how_frequently_are_patients_transferred" VARCHAR  -- PPFF Around A TKR: How Frequently Are Patients Transferred?,
  "ppff_around_a_tkr_why_are_patients_transferred" VARCHAR  -- PPFF Around A TKR: Why Are Patients Transferred?,
  "ppff_around_a_tkr_are_patients_transferred_directly_fr_c022bce6" VARCHAR  -- PPFF Around A TKR: Are Patients Transferred Directly From Your Emergency Department?,
  "ppff_around_a_tkr_which_hospital_do_you_transfer_these_00f3bc3e" VARCHAR  -- PPFF Around A TKR: Which Hospital Do You Transfer These Patients To?,
  "patients_with_hip_fracture_not_ppff_do_you_transfer_pa_6a41c97a" VARCHAR  -- Patients With Hip Fracture (not PPFF): Do You Transfer Patients From Your Department To Another T&O Department At Another Site/hospital/Trust For Definitive Surgery?,
  "patients_with_hip_fracture_not_ppff_how_frequently_are_8614bef9" VARCHAR  -- Patients With Hip Fracture (not PPFF): How Frequently Are Patients Transferred?,
  "patients_with_hip_fracture_not_ppff_why_are_patients_t_d5f3d56d" VARCHAR  -- Patients With Hip Fracture (not PPFF): Why Are Patients Transferred?,
  "patients_with_hip_fracture_not_ppff_are_patients_trans_c5d8a8f2" VARCHAR  -- Patients With Hip Fracture (not PPFF): Are Patients Transferred Directly From Your Emergency Department?,
  "patients_with_hip_fracture_not_ppff_which_hospital_do__5b769fad" VARCHAR  -- Patients With Hip Fracture (not PPFF): Which Hospital Do You Transfer These Patients To?,
  "patients_with_a_ppff_around_a_thr_do_you_receive_trans_eb9b4418" VARCHAR  -- Patients With A PPFF Around A THR: Do You Receive Transfers From A T&O Department At Another Site/hospital/Trust For Definitive Surgery?,
  "patients_with_a_ppff_around_a_thr_does_this_follow_a_f_fe300b75" VARCHAR  -- Patients With A PPFF Around A THR: Does This Follow A Formalised Process/policy Or On An Ad Hoc Basis?,
  "patients_with_a_ppff_around_a_thr_where_do_you_receive_2d138d6d" VARCHAR  -- Patients With A PPFF Around A THR: Where Do You Receive Patients From?,
  "patients_with_a_ppff_around_a_tkr_do_you_receive_trans_ec8f011a" VARCHAR  -- Patients With A PPFF Around A TKR: Do You Receive Transfers From A T&O Department At Another Site/hospital/Trust For Definitive Surgery?,
  "patients_with_a_ppff_around_a_tkr_does_this_follow_a_f_a3660b23" VARCHAR  -- Patients With A PPFF Around A TKR: Does This Follow A Formalised Process/policy Or On An Ad Hoc Basis?,
  "patients_with_a_ppff_around_a_tkr_where_do_you_receive_77813796" VARCHAR  -- Patients With A PPFF Around A TKR: Where Do You Receive Patients From?,
  "patients_with_hip_fracture_not_ppff_do_you_receive_tra_add66218" VARCHAR  -- Patients With Hip Fracture (not PPFF): Do You Receive Transfers From A T&O Department At Another Site/hospital/Trust For Definitive Surgery?,
  "patients_with_hip_fracture_not_ppff_does_this_follow_a_6c01fbc8" VARCHAR  -- Patients With Hip Fracture (not PPFF): Does This Follow A Formalised Process/policy Or On An Ad Hoc Basis?,
  "patients_with_hip_fracture_not_ppff_where_do_you_recei_4ee28c6f" VARCHAR  -- Patients With Hip Fracture (not PPFF): Where Do You Receive Them From?,
  "for_thr_do_you_have_a_local_revision_mdt_within_hospit_e3cbac0d" VARCHAR  -- For THR: Do You Have A Local Revision MDT (within Hospital) For Revision Arthroplasty (all Revisions And Not Just PPFF)?,
  "for_tkr_do_you_have_a_local_revision_mdt_within_hospit_b6610dee" VARCHAR  -- For TKR: Do You Have A Local Revision MDT (within Hospital) For Revision Arthroplasty (all Revisions And Not Just PPFF)?,
  "for_thr_do_you_participate_in_a_regional_revision_mdt__7987f774" VARCHAR  -- For THR: Do You Participate In A Regional Revision MDT (outside Your Hospital) For Revision Arthroplasty (all Revisions And Not Just PPFF)?,
  "for_tkr_do_you_participate_in_a_regional_revision_mdt__ed657e1e" VARCHAR  -- For TKR: Do You Participate In A Regional Revision MDT (outside Your Hospital) For Revision Arthroplasty (all Revisions And Not Just PPFF),
  "for_hips_do_you_routinely_discuss_all_ppff_with_other__6d8530f9" VARCHAR  -- For Hips: Do You Routinely Discuss All PPFF With Other Sub-specialty Surgeons In Your Hospital Either In Your Local MDT Or By Other Means (formally Or Informally)?,
  "for_knees_do_you_routinely_discuss_all_ppff_with_other_5e048a1f" VARCHAR  -- For Knees: Do You Routinely Discuss All PPFF With Other Sub-specialty Surgeons In Your Hospital Either In Your Local MDT Or By Other Means (formally Or Informally)?,
  "for_hips_do_you_routinely_discuss_all_ppff_in_your_reg_90143dbb" VARCHAR  -- For Hips: Do You Routinely Discuss All PPFF In Your Regional Revision MDT (if You Have One)?,
  "for_knees_do_you_routinely_discuss_all_ppff_in_your_re_a75e418b" VARCHAR  -- For Knees: Do You Routinely Discuss All PPFF In Your Regional Revision MDT (if You Have One)?,
  "n__in_the_nhfd_2020_annual_report_suggest_that_theatre_46677cf1" VARCHAR  -- Data In The NHFD 2020 Annual Report Suggest That Theatre Within 36 Hours Was Not Achieved For Most PPFF. In Your Hospital, How Would You Rank The Following Contributing Factors As Reasons For Delay (1-4 Or NA; 1 Being The Most Frequent Cause For Delay): Surgeon Availability,
  "n__in_the_nhfd_2020_annual_report_suggest_that_theatre_8be747bb" VARCHAR  -- Data In The NHFD 2020 Annual Report Suggest That Theatre Within 36 Hours Was Not Achieved For Most PPFF. In Your Hospital, How Would You Rank The Following Contributing Factors As Reasons For Delay (1-4 Or NA; 1 Being The Most Frequent Cause For Delay): Theatre Availability,
  "n__in_the_nhfd_2020_annual_report_suggest_that_theatre_46ac8108" VARCHAR  -- Data In The NHFD 2020 Annual Report Suggest That Theatre Within 36 Hours Was Not Achieved For Most PPFF. In Your Hospital, How Would You Rank The Following Contributing Factors As Reasons For Delay (1-4 Or NA; 1 Being The Most Frequent Cause For Delay): Kit Availability,
  "n__in_the_nhfd_2020_annual_report_suggest_that_theatre_f87864f1" VARCHAR  -- Data In The NHFD 2020 Annual Report Suggest That Theatre Within 36 Hours Was Not Achieved For Most PPFF. In Your Hospital, How Would You Rank The Following Contributing Factors As Reasons For Delay (1-4 Or NA; 1 Being The Most Frequent Cause For Delay): Patient Optimisation,
  "case_scenario_how_would_you_manage_this_patient" VARCHAR  -- Case Scenario: How Would You Manage This Patient?,
  "case_scenario_if_you_selected_revision_surgery_or_a_co_3dea3ede" VARCHAR  -- Case Scenario: If You Selected Revision Surgery, (or A Combination) What Type Of Implant Would You Use? (Please Select One),
  "case_scenario_do_you_have_the_system_selected_above_on_4a2c1e0c" VARCHAR  -- Case Scenario: Do You Have The System Selected Above “on The Shelf” Or Would You Require Loan Kit?,
  "case_scenario_if_you_selected_open_reduction_and_inter_ed6f2efc" VARCHAR  -- Case Scenario: If You Selected Open Reduction And Internal Fixation (or A Combination), What Type Of Plate Would You Use (brand And Name)?,
  "case_scenario_do_you_have_the_system_selected_above_on_27b1bd75" VARCHAR  -- Case Scenario: Do You Have The System Selected Above “on The Shelf” Or Would You Require Loan Kit?.1,
  "case_scenario_would_you_permit_the_patient_to_weight_b_2bef26c1" VARCHAR  -- Case Scenario: Would You Permit The Patient To Weight Bear The Day After Surgery? (Please Select One),
  "case_scenario_would_the_operation_be_performed_in_your_072b9e75" VARCHAR  -- Case Scenario: Would The Operation Be Performed In Your Own Hospital?,
  "case_scenario_who_would_this_operation_be_performed_by_ba22a9d8" VARCHAR  -- Case Scenario: Who Would This Operation Be Performed By? (Select One),
  "case_scenario_would_you_routinely_aspirate_prior_to_re_a2d23a43" VARCHAR  -- Case Scenario: Would You Routinely Aspirate Prior To Revision Or Fixation?
);