About this Dataset

National Hip Fracture Database Annual Report 2022

Hip fracture is a serious and costly injury affecting mainly older people, and is more common in women. It usually results from the combination of weak bone structure (osteoporosis) and a fall. Around 76,000 hip fractures occur each year in the UK as a whole. Although there is good evidence on best practice in surgical, medical and rehabilitation care following hip fracture, such care and its outcomes – in terms of return home and also of mortality – continues to vary.

The National Hip Fracture Database (NHFD), which was launched in 2007, aims to deliver improvements in the care of hip fracture patients. It documents case-mix, care and outcomes of hip fracture patients in England, Wales and Northern Ireland and is now, with over1 million cases on record – by far the largest hip fracture audit in the world.

It has demonstrated broad improvements at local and national level in patient care, and in England has supported the Department of Health’s highly successful Best Practice Tariff for hip fracture care. The work of the NHFD is now being replicated in Ireland, with the recent launch of Irish Hip Fracture Database, and similar developments are in hand in Australia and New Zealand, Canada and Hong Kong.

The National Hip Fracture Database was founded as a collaboration between the British Orthopaedic Association and the British Geriatrics Society. It was developed between 2004 and 2007, and since 2009 it has received central funding as a national clinical audit via the Healthcare Quality Improvement Partnership (HQIP). Since April 2012 the NHFD has continued as part of the Falls and Fragility Fracture Audit Programme (FFFAP), managed on behalf of HQIP by the Royal College of Physicians (RCP).

The audit covers England, Wales, Northern Ireland, Guernsey and the Isle of Man; however data files only refer to data for England and Wales
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2025-06-12T04:00:31Z

Tables

NHFD 2022 Annual Report Facilities Survey Results

@ukgov.national_hip_fracture_database_annual_report_2022.nhfd_2022_annual_report_facilities_survey_results

87.8 kB
163 rows
61 columns

CREATE TABLE nhfd_2022_annual_report_facilities_survey_results (
  "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?
);