About this Dataset

National Hip Fracture Database Annual Report 2017

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 more than 250,000 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, managed on behalf of HQIP by the Royal College of Physicians (London). The audit covers England, Wales, Northern Ireland and the Isle of Man and, however data files only refer to data for England and Wales
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-09-15T01:24:30Z

Tables

National Hip Fracture Database Annual Report 2017

@ukgov.national_hip_fracture_database_annual_report_2017.national_hip_fracture_database_annual_report_2017

171.46 kB
172 rows
92 columns

CREATE TABLE national_hip_fracture_database_annual_report_2017 (
  "year" BIGINT,
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "nation" VARCHAR,
  "number_of_cases" BIGINT,
  "surgery_on_day_of_or_day_after_admission_n" BIGINT  -- 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" DOUBLE  -- Surgery On Day Of, Or Day After, Admission (%),
  "surgery_supervised_by_consultant_surgeon_and_anaesthetist_n" BIGINT  -- 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" DOUBLE  -- Surgery Supervised By Consultant Surgeon And Anaesthetist (%),
  "general_anaesthetic_n" BIGINT  -- General Anaesthetic (n),
  "general_anaesthetic_d" BIGINT  -- General Anaesthetic (d),
  "general_anaesthetic" DOUBLE  -- General Anaesthetic (%),
  "general_anaesthetic_and_nerve_block_of_all_ga_n" BIGINT  -- General Anaesthetic And Nerve Block (of All GA)(n),
  "general_anaesthetic_and_nerve_block_of_all_ga_d" BIGINT  -- General Anaesthetic And Nerve Block (of All GA) (d),
  "general_anaesthetic_and_nerve_block_of_all_ga" DOUBLE  -- General Anaesthetic And Nerve Block (of All GA) (%),
  "spinal_anaesthetic_n" VARCHAR  -- Spinal Anaesthetic (n),
  "spinal_anaesthetic_d" VARCHAR  -- Spinal Anaesthetic (d),
  "spinal_anaesthetic" DOUBLE  -- 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" VARCHAR  -- Spinal Anaesthetic And Nerve Block (of All SA) (d),
  "spinal_anaesthetic_and_nerve_block_of_all_sa" DOUBLE  -- 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" VARCHAR  -- Proportion Of Arthroplasties Which Are Cemented (d),
  "proportion_of_arthroplasties_which_are_cemented" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- 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" DOUBLE  -- Subtrochanteric Fractures Treated With An IM Nail (%),
  "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" DOUBLE  -- Admitted To Orthopaedic Ward Within 4 Hours (%),
  "mental_test_score_recorded_on_admission_n" BIGINT  -- 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" DOUBLE  -- Mental Test Score Recorded On Admission (%),
  "perioperative_medical_assessment_n" BIGINT  -- Perioperative Medical Assessment (n),
  "perioperative_medical_assessment_d" BIGINT  -- Perioperative Medical Assessment (d),
  "perioperative_medical_assessment" DOUBLE  -- Perioperative Medical Assessment (%),
  "physiotherapy_assessment_by_the_day_after_surgery_n" BIGINT  -- 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" DOUBLE  -- Physiotherapy Assessment By The Day After Surgery (%),
  "mobilised_out_of_bed_by_the_day_after_surgery_n" BIGINT  -- 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" DOUBLE  -- Mobilised Out Of Bed By The Day After Surgery (%),
  "nutritional_risk_assessment_n" VARCHAR  -- Nutritional Risk Assessment (n),
  "nutritional_risk_assessment_d" VARCHAR  -- Nutritional Risk Assessment (d),
  "nutritional_risk_assessment" DOUBLE  -- Nutritional Risk Assessment (%),
  "delirium_assessment_n" VARCHAR  -- Delirium Assessment (n),
  "delirium_assessment_d" VARCHAR  -- Delirium Assessment (d),
  "delirium_assessment" DOUBLE  -- Delirium Assessment (%),
  "received_falls_assessment_n" VARCHAR  -- Received Falls Assessment (n),
  "received_falls_assessment_d" VARCHAR  -- Received Falls Assessment (d),
  "received_falls_assessment" DOUBLE  -- 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" DOUBLE  -- Received Bone Health Assessment (%),
  "met_best_practice_criteria_n" VARCHAR  -- Met Best Practice Criteria (n),
  "met_best_practice_criteria_d" VARCHAR  -- Met Best Practice Criteria (d),
  "met_best_practice_criteria" DOUBLE  -- Met Best Practice Criteria (%),
  "case_ascertainment_n" BIGINT  -- Case Ascertainment (n),
  "case_ascertainment_n_1" BIGINT  -- Case Ascertainment (n).1,
  "case_ascertainment" DOUBLE  -- Case Ascertainment (%),
  "acute_length_of_stay_days" DOUBLE  -- Acute Length Of Stay (days),
  "overall_hospital_length_of_stay_days" DOUBLE  -- Overall Hospital Length Of Stay (days),
  "documented_final_discharge_destination_n" BIGINT  -- Documented Final Discharge Destination (n),
  "documented_final_discharge_destination_d" BIGINT  -- Documented Final Discharge Destination (d),
  "documented_final_discharge_destination" DOUBLE  -- Documented Final Discharge Destination (%),
  "discharge_to_original_residence_within_120_days_n" BIGINT  -- 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" DOUBLE  -- 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" VARCHAR  -- Hip Fractures Which Were Sustained As An Inpatient (d),
  "hip_fractures_which_were_sustained_as_an_inpatient" DOUBLE  -- Hip Fractures Which Were Sustained As An Inpatient (%),
  "documented_not_to_have_developed_a_pressure_ulcer_n" BIGINT  -- 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" DOUBLE  -- 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" VARCHAR  -- Documented Not To Have Had A Reoperation Within 120 Days (d),
  "documented_not_to_have_had_a_reoperation_within_120_days" DOUBLE  -- 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" DOUBLE  -- 120 Day Follow Up (%),
  "crude_30_day_mortality_rate" VARCHAR,
  "crude_30_day_mortality_rate_1" VARCHAR,
  "crude_30_day_mortality_rate_2" DOUBLE,
  "adjusted_30_day_mortality_rate" DOUBLE
);