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

167.44 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_d" BIGINT,
  "surgery_on_day_of_or_day_after_admission" DOUBLE,
  "surgery_supervised_by_consultant_surgeon_and_anaesthetist_n" BIGINT,
  "surgery_supervised_by_consultant_surgeon_and_anaesthetist_d" BIGINT,
  "surgery_supervised_by_consultant_surgeon_and_anaesthetist" DOUBLE,
  "general_anaesthetic_n" BIGINT,
  "general_anaesthetic_d" BIGINT,
  "general_anaesthetic" DOUBLE,
  "general_anaesthetic_and_nerve_block_of_all_ga_n" BIGINT,
  "general_anaesthetic_and_nerve_block_of_all_ga_d" BIGINT,
  "general_anaesthetic_and_nerve_block_of_all_ga" DOUBLE,
  "spinal_anaesthetic_n" VARCHAR,
  "spinal_anaesthetic_d" VARCHAR,
  "spinal_anaesthetic" DOUBLE,
  "spinal_anaesthetic_and_nerve_block_of_all_sa_n" VARCHAR,
  "spinal_anaesthetic_and_nerve_block_of_all_sa_d" VARCHAR,
  "spinal_anaesthetic_and_nerve_block_of_all_sa" DOUBLE,
  "proportion_of_arthroplasties_which_are_cemented_n" VARCHAR,
  "proportion_of_arthroplasties_which_are_cemented_d" VARCHAR,
  "proportion_of_arthroplasties_which_are_cemented" DOUBLE,
  "eligible_displaced_intracapsular_fractures_treated_with_thr_n" VARCHAR,
  "eligible_displaced_intracapsular_fractures_treated_with_thr_d" VARCHAR,
  "eligible_displaced_intracapsular_fractures_treated_with_thr" DOUBLE,
  "intertrochanteric_fractures_excl_reverse_oblique_treat_c1f2cfd4" VARCHAR,
  "intertrochanteric_fractures_excl_reverse_oblique_treat_b9ff1c07" VARCHAR,
  "intertrochanteric_fractures_excl_reverse_oblique_treat_82e0be17" DOUBLE,
  "subtrochanteric_fractures_treated_with_an_im_nail_n" VARCHAR,
  "subtrochanteric_fractures_treated_with_an_im_nail_d" VARCHAR,
  "subtrochanteric_fractures_treated_with_an_im_nail" DOUBLE,
  "admitted_to_orthopaedic_ward_within_4_hours_n" VARCHAR,
  "admitted_to_orthopaedic_ward_within_4_hours_d" VARCHAR,
  "admitted_to_orthopaedic_ward_within_4_hours" DOUBLE,
  "mental_test_score_recorded_on_admission_n" BIGINT,
  "mental_test_score_recorded_on_admission_d" BIGINT,
  "mental_test_score_recorded_on_admission" DOUBLE,
  "perioperative_medical_assessment_n" BIGINT,
  "perioperative_medical_assessment_d" BIGINT,
  "perioperative_medical_assessment" DOUBLE,
  "physiotherapy_assessment_by_the_day_after_surgery_n" BIGINT,
  "physiotherapy_assessment_by_the_day_after_surgery_d" BIGINT,
  "physiotherapy_assessment_by_the_day_after_surgery" DOUBLE,
  "mobilised_out_of_bed_by_the_day_after_surgery_n" BIGINT,
  "mobilised_out_of_bed_by_the_day_after_surgery_d" BIGINT,
  "mobilised_out_of_bed_by_the_day_after_surgery" DOUBLE,
  "nutritional_risk_assessment_n" VARCHAR,
  "nutritional_risk_assessment_d" VARCHAR,
  "nutritional_risk_assessment" DOUBLE,
  "delirium_assessment_n" VARCHAR,
  "delirium_assessment_d" VARCHAR,
  "delirium_assessment" DOUBLE,
  "received_falls_assessment_n" VARCHAR,
  "received_falls_assessment_d" VARCHAR,
  "received_falls_assessment" DOUBLE,
  "received_bone_health_assessment_n" BIGINT,
  "received_bone_health_assessment_d" BIGINT,
  "received_bone_health_assessment" DOUBLE,
  "met_best_practice_criteria_n" VARCHAR,
  "met_best_practice_criteria_d" VARCHAR,
  "met_best_practice_criteria" DOUBLE,
  "case_ascertainment_n" BIGINT,
  "case_ascertainment_n_1" BIGINT,
  "case_ascertainment" DOUBLE,
  "acute_length_of_stay_days" DOUBLE,
  "overall_hospital_length_of_stay_days" DOUBLE,
  "documented_final_discharge_destination_n" BIGINT,
  "documented_final_discharge_destination_d" BIGINT,
  "documented_final_discharge_destination" DOUBLE,
  "discharge_to_original_residence_within_120_days_n" BIGINT,
  "discharge_to_original_residence_within_120_days_d" BIGINT,
  "discharge_to_original_residence_within_120_days" DOUBLE,
  "hip_fractures_which_were_sustained_as_an_inpatient_n" VARCHAR,
  "hip_fractures_which_were_sustained_as_an_inpatient_d" VARCHAR,
  "hip_fractures_which_were_sustained_as_an_inpatient" DOUBLE,
  "documented_not_to_have_developed_a_pressure_ulcer_n" BIGINT,
  "documented_not_to_have_developed_a_pressure_ulcer_d" BIGINT,
  "documented_not_to_have_developed_a_pressure_ulcer" DOUBLE,
  "documented_not_to_have_had_a_reoperation_within_120_days_n" VARCHAR,
  "documented_not_to_have_had_a_reoperation_within_120_days_d" VARCHAR,
  "documented_not_to_have_had_a_reoperation_within_120_days" DOUBLE,
  "n_120_day_follow_up_n" VARCHAR,
  "n_120_day_follow_up_d" VARCHAR,
  "n_120_day_follow_up" DOUBLE,
  "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
);