About this Dataset

National Hip Fracture Database Annual Report 2024

Hip fracture is a serious and costly injury affecting mainly older people. 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 almost 1 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: 2024-09-20T04:00:01Z

Tables

NHFD 2024 Annual Report Small Number Supressed

@ukgov.national_hip_fracture_database_annual_report_2024.nhfd_2024_annual_report_small_number_supressed

143.38 kB
162 rows
98 columns

CREATE TABLE nhfd_2024_annual_report_small_number_supressed (
  "year" BIGINT,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "nation" VARCHAR,
  "number_of_cases" BIGINT,
  "surgery_on_day_of_or_day_after_admission_n" VARCHAR  -- Surgery On Day Of, Or Day After, Admission (n),
  "surgery_on_day_of_or_day_after_admission_d" BIGINT  -- Surgery On Day Of, Or Day After, Admission (d),
  "surgery_on_day_of_or_day_after_admission" VARCHAR  -- Surgery On Day Of, Or Day After, Admission (%),
  "surgery_supervised_by_consultant_surgeon_and_anaesthetist_n" VARCHAR  -- Surgery Supervised By Consultant Surgeon And Anaesthetist (n),
  "surgery_supervised_by_consultant_surgeon_and_anaesthetist_d" BIGINT  -- Surgery Supervised By Consultant Surgeon And Anaesthetist (d),
  "surgery_supervised_by_consultant_surgeon_and_anaesthetist" VARCHAR  -- Surgery Supervised By Consultant Surgeon And Anaesthetist (%),
  "general_anaesthetic_n" VARCHAR  -- General Anaesthetic (n),
  "general_anaesthetic_d" BIGINT  -- General Anaesthetic (d),
  "general_anaesthetic" VARCHAR  -- General Anaesthetic (%),
  "general_anaesthetic_and_nerve_block_of_all_ga_n" VARCHAR  -- General Anaesthetic And Nerve Block (of All GA)(n),
  "general_anaesthetic_and_nerve_block_of_all_ga_d" VARCHAR  -- General Anaesthetic And Nerve Block (of All GA) (d),
  "general_anaesthetic_and_nerve_block_of_all_ga" VARCHAR  -- General Anaesthetic And Nerve Block (of All GA) (%),
  "spinal_anaesthetic_n" VARCHAR  -- Spinal Anaesthetic (n),
  "spinal_anaesthetic_d" BIGINT  -- Spinal Anaesthetic (d),
  "spinal_anaesthetic" VARCHAR  -- Spinal Anaesthetic (%),
  "spinal_anaesthetic_and_nerve_block_of_all_sa_n" VARCHAR  -- Spinal Anaesthetic And Nerve Block (of All SA) (n),
  "spinal_anaesthetic_and_nerve_block_of_all_sa_d" BIGINT  -- Spinal Anaesthetic And Nerve Block (of All SA) (d),
  "spinal_anaesthetic_and_nerve_block_of_all_sa" VARCHAR  -- Spinal Anaesthetic And Nerve Block (of All SA) (%),
  "proportion_of_arthroplasties_which_are_cemented_n" VARCHAR  -- Proportion Of Arthroplasties Which Are Cemented (n),
  "proportion_of_arthroplasties_which_are_cemented_d" BIGINT  -- Proportion Of Arthroplasties Which Are Cemented (d),
  "proportion_of_arthroplasties_which_are_cemented" VARCHAR  -- Proportion Of Arthroplasties Which Are Cemented (%),
  "eligible_displaced_intracapsular_fractures_treated_with_thr_n" VARCHAR  -- Eligible Displaced Intracapsular Fractures Treated With THR (n),
  "eligible_displaced_intracapsular_fractures_treated_with_thr_d" VARCHAR  -- Eligible Displaced Intracapsular Fractures Treated With THR (d),
  "eligible_displaced_intracapsular_fractures_treated_with_thr" VARCHAR  -- Eligible Displaced Intracapsular Fractures Treated With THR (%),
  "intertrochanteric_fractures_excl_reverse_oblique_treat_c1f2cfd4" VARCHAR  -- Intertrochanteric Fractures (excl. Reverse Oblique) Treated With SHS (n),
  "intertrochanteric_fractures_excl_reverse_oblique_treat_b9ff1c07" VARCHAR  -- Intertrochanteric Fractures (excl. Reverse Oblique) Treated With SHS (d),
  "intertrochanteric_fractures_excl_reverse_oblique_treat_82e0be17" VARCHAR  -- Intertrochanteric Fractures (excl. Reverse Oblique) Treated With SHS (%),
  "subtrochanteric_fractures_treated_with_an_im_nail_n" VARCHAR  -- Subtrochanteric Fractures Treated With An IM Nail (n),
  "subtrochanteric_fractures_treated_with_an_im_nail_d" VARCHAR  -- Subtrochanteric Fractures Treated With An IM Nail (d),
  "subtrochanteric_fractures_treated_with_an_im_nail" VARCHAR  -- Subtrochanteric Fractures Treated With An IM Nail (%),
  "nice_compliant_surgery_n" VARCHAR  -- NICE Compliant Surgery (n),
  "nice_compliant_surgery_d" BIGINT  -- NICE Compliant Surgery (d),
  "nice_compliant_surgery" VARCHAR  -- NICE Compliant Surgery (%),
  "admitted_to_orthopaedic_ward_within_4_hours_n" VARCHAR  -- Admitted To Orthopaedic Ward Within 4 Hours (n),
  "admitted_to_orthopaedic_ward_within_4_hours_d" VARCHAR  -- Admitted To Orthopaedic Ward Within 4 Hours (d),
  "admitted_to_orthopaedic_ward_within_4_hours" VARCHAR  -- Admitted To Orthopaedic Ward Within 4 Hours (%),
  "mental_test_score_recorded_on_admission_n" VARCHAR  -- Mental Test Score Recorded On Admission (n),
  "mental_test_score_recorded_on_admission_d" BIGINT  -- Mental Test Score Recorded On Admission (d),
  "mental_test_score_recorded_on_admission" VARCHAR  -- Mental Test Score Recorded On Admission (%),
  "perioperative_medical_assessment_n" VARCHAR  -- Perioperative Medical Assessment (n),
  "perioperative_medical_assessment_d" BIGINT  -- Perioperative Medical Assessment (d),
  "perioperative_medical_assessment" VARCHAR  -- Perioperative Medical Assessment (%),
  "physiotherapy_assessment_by_the_day_after_surgery_n" VARCHAR  -- Physiotherapy Assessment By The Day After Surgery (n),
  "physiotherapy_assessment_by_the_day_after_surgery_d" BIGINT  -- Physiotherapy Assessment By The Day After Surgery (d),
  "physiotherapy_assessment_by_the_day_after_surgery" VARCHAR  -- Physiotherapy Assessment By The Day After Surgery (%),
  "mobilised_out_of_bed_by_the_day_after_surgery_n" VARCHAR  -- Mobilised Out Of Bed By The Day After Surgery (n),
  "mobilised_out_of_bed_by_the_day_after_surgery_d" BIGINT  -- Mobilised Out Of Bed By The Day After Surgery (d),
  "mobilised_out_of_bed_by_the_day_after_surgery" VARCHAR  -- Mobilised Out Of Bed By The Day After Surgery (%),
  "nutritional_risk_assessment_n" BIGINT  -- Nutritional Risk Assessment (n),
  "nutritional_risk_assessment_d" BIGINT  -- Nutritional Risk Assessment (d),
  "nutritional_risk_assessment" BIGINT  -- Nutritional Risk Assessment (%),
  "delirium_assessment_n" VARCHAR  -- Delirium Assessment (n),
  "delirium_assessment_d" BIGINT  -- Delirium Assessment (d),
  "delirium_assessment" VARCHAR  -- Delirium Assessment (%),
  "not_delirious_when_tested_post_op_n" VARCHAR  -- Not Delirious When Tested Post-op. (n),
  "not_delirious_when_tested_post_op_d" BIGINT  -- Not Delirious When Tested Post-op. (d),
  "not_delirious_when_tested_post_op" VARCHAR  -- Not Delirious When Tested Post-op. (%),
  "received_falls_assessment_n" VARCHAR  -- Received Falls Assessment (n),
  "received_falls_assessment_d" BIGINT  -- Received Falls Assessment (d),
  "received_falls_assessment" VARCHAR  -- Received Falls Assessment (%),
  "received_bone_health_assessment_n" BIGINT  -- Received Bone Health Assessment (n),
  "received_bone_health_assessment_d" BIGINT  -- Received Bone Health Assessment (d),
  "received_bone_health_assessment" BIGINT  -- Received Bone Health Assessment (%),
  "met_best_practice_criteria_n" VARCHAR  -- Met Best Practice Criteria (n),
  "met_best_practice_criteria_d" BIGINT  -- Met Best Practice Criteria (d),
  "met_best_practice_criteria" VARCHAR  -- Met Best Practice Criteria (%),
  "case_ascertainment_total_cases_compared_to_last_year_n" BIGINT  -- Case Ascertainment: Total Cases Compared To Last Year (n),
  "case_ascertainment_total_cases_compared_to_last_year_d" BIGINT  -- Case Ascertainment: Total Cases Compared To Last Year (d),
  "case_ascertainment_total_cases_compared_to_last_year" BIGINT  -- Case Ascertainment: Total Cases Compared To Last Year (%),
  "acute_length_of_stay_days" BIGINT  -- Acute Length Of Stay (days),
  "overall_hospital_length_of_stay_days" BIGINT  -- Overall Hospital Length Of Stay (days),
  "documented_final_discharge_destination_n" VARCHAR  -- Documented Final Discharge Destination (n),
  "documented_final_discharge_destination_d" BIGINT  -- Documented Final Discharge Destination (d),
  "documented_final_discharge_destination" VARCHAR  -- Documented Final Discharge Destination (%),
  "discharge_to_original_residence_within_120_days_n" VARCHAR  -- Discharge To Original Residence Within 120 Days (n),
  "discharge_to_original_residence_within_120_days_d" BIGINT  -- Discharge To Original Residence Within 120 Days (d),
  "discharge_to_original_residence_within_120_days" VARCHAR  -- Discharge To Original Residence Within 120 Days (%),
  "hip_fractures_which_were_sustained_as_an_inpatient_n" VARCHAR  -- Hip Fractures Which Were Sustained As An Inpatient (n),
  "hip_fractures_which_were_sustained_as_an_inpatient_d" BIGINT  -- Hip Fractures Which Were Sustained As An Inpatient (d),
  "hip_fractures_which_were_sustained_as_an_inpatient" VARCHAR  -- Hip Fractures Which Were Sustained As An Inpatient (%),
  "documented_not_to_have_developed_a_pressure_ulcer_n" VARCHAR  -- Documented Not To Have Developed A Pressure Ulcer (n),
  "documented_not_to_have_developed_a_pressure_ulcer_d" BIGINT  -- Documented Not To Have Developed A Pressure Ulcer (d),
  "documented_not_to_have_developed_a_pressure_ulcer" VARCHAR  -- Documented Not To Have Developed A Pressure Ulcer (%),
  "documented_not_to_have_had_a_reoperation_within_120_days_n" VARCHAR  -- Documented Not To Have Had A Reoperation Within 120 Days (n),
  "documented_not_to_have_had_a_reoperation_within_120_days_d" BIGINT  -- Documented Not To Have Had A Reoperation Within 120 Days (d),
  "documented_not_to_have_had_a_reoperation_within_120_days" VARCHAR  -- Documented Not To Have Had A Reoperation Within 120 Days (%),
  "n_120_day_follow_up_n" VARCHAR  -- 120 Day Follow Up (n),
  "n_120_day_follow_up_d" VARCHAR  -- 120 Day Follow Up (d),
  "n_120_day_follow_up" VARCHAR  -- 120 Day Follow Up (%),
  "crude_30_day_mortality_rate_n" VARCHAR  -- Crude 30 Day Mortality Rate (n),
  "crude_30_day_mortality_rate_d" BIGINT  -- Crude 30 Day Mortality Rate (d),
  "crude_30_day_mortality_rate" VARCHAR  -- Crude 30 Day Mortality Rate (%),
  "adjusted_30_day_mortality_rate" VARCHAR  -- Adjusted 30 Day Mortality Rate (%)
);