About this Dataset

National Hip Fracture Database Annual Report 2012-13

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, the Isle of Man and the Channel Islands, however data files only refer to data for England.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-09-15T08:28:54Z

Tables

National Hip Fracture Database Annual Report 2012-13

@ukgov.national_hip_fracture_database_annual_report_2012_13.national_hip_fracture_database_annual_report_2012_13

274.51 kB
164 rows
208 columns

CREATE TABLE national_hip_fracture_database_annual_report_2012_13 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "chart_1_data_complete" DOUBLE  -- Chart 1:% Data Complete,
  "chart_1_data_incomplete" VARCHAR  -- Chart 1:% Data Incomplete,
  "chart_2_number_of_cases_included_in_chart" VARCHAR,
  "chart_2_admitted_from_other" VARCHAR,
  "chart_2_admitted_from_own_home_sheltered_housing" VARCHAR,
  "chart_2_admitted_from_residential_care" VARCHAR,
  "chart_2_admitted_from_nursing_care" VARCHAR,
  "chart_2_admitted_from_rehabilitation_unit" VARCHAR,
  "chart_2_admitted_from_acute_hospital" VARCHAR,
  "chart_2_admitted_from_already_in_hospital" VARCHAR,
  "chart_3a_number_of_cases_included_in_chart" BIGINT,
  "chart_3a_pre_op_amts_0_6" VARCHAR  -- Chart 3a:Pre -op AMTS 0-6,
  "chart_3a_pre_op_amts_7_10" BIGINT,
  "chart_3a_pre_op_amts_unknown" VARCHAR,
  "chart_3b_number_of_cases_included_in_chart" BIGINT,
  "chart_3b_post_op_amts_0_6" VARCHAR,
  "chart_3b_post_op_amts_7_10" VARCHAR,
  "chart_3b_post_op_amts_unknown" VARCHAR,
  "chart_4_number_of_cases_included_in_chart" BIGINT,
  "chart_4_orth_ward_admission_within_4_hours" VARCHAR,
  "chart4_orth_ward_admission_after_4_hours" BIGINT,
  "chart_4_not_admitted_to_orth_ward" VARCHAR,
  "chart_4_time_to_ortho_ward_unknown" VARCHAR,
  "chart_5_number_of_cases_included_in_chart" BIGINT,
  "chart_5_ga_only_n" VARCHAR  -- Chart 5:GA Only (n),
  "chart_5_ga_nerve_block_n" VARCHAR  -- Chart 5:GA + Nerve Block (n),
  "chart_5_ga_epidural_anaesthesia_n" VARCHAR  -- Chart 5:GA + Epidural Anaesthesia (n),
  "chart_5_ga_spinal_anaesthesia_n" VARCHAR  -- Chart 5:GA + Spinal Anaesthesia (n),
  "chart_5_spinal_anaesthesia_only_n" VARCHAR  -- Chart 5:Spinal Anaesthesia Only (n),
  "chart_5_sa_epidural_cse_n" VARCHAR  -- Chart 5:SA + Epidural (CSE) (n),
  "chart_5_sa_nerve_block_n" VARCHAR  -- Chart 5:SA + Nerve Block (n),
  "chart_5_anaesthetic_other_n" VARCHAR  -- Chart 5:Anaesthetic Other (n),
  "chart_5_anaesthetic_unknown_n" VARCHAR  -- Chart 5:Anaesthetic Unknown (n),
  "chart_6_number_of_cases_included_in_chart" BIGINT,
  "chart_6_surgery_within_36_hours_n" BIGINT  -- Chart 6:Surgery Within 36 Hours (n),
  "chart_6_surgery_after_36_hours_n" BIGINT  -- Chart 6:Surgery After 36 Hours (n),
  "chart_6_no_operation_performed_n" VARCHAR  -- Chart 6:No Operation Performed (n),
  "chart_6_unknown_time_to_surgery_36_hours_n" VARCHAR  -- Chart 6:Unknown Time To Surgery (36 Hours) (n),
  "chart_7_number_of_cases_included_in_chart" BIGINT,
  "chart_7_surgery_on_day_of_or_day_after_admission_n" BIGINT  -- Chart 7:Surgery On Day Of; Or Day After; Admission (n),
  "chart_7_surgery_two_or_more_calendar_days_after_admission_n" BIGINT  -- Chart 7:Surgery Two Or More Calendar Days After Admission (n),
  "chart_7_unknown_time_to_surgery_day_or_next_day_n" VARCHAR  -- Chart 7:Unknown Time To Surgery (day Or Next Day) (n),
  "chart_8_number_of_cases_included_in_chart" BIGINT,
  "chart_8_surgery_within_48_hours_during_working_hours_n" BIGINT  -- Chart 8:Surgery Within 48 Hours & During Working Hours (n),
  "chart_8_surgery_within_48_hours_but_not_during_working_hours_n" VARCHAR  -- Chart 8:Surgery Within 48 Hours But Not During Working Hours (n),
  "chart_8_surgery_not_within_48_hours_n" VARCHAR  -- Chart 8:Surgery Not Within 48 Hours (n),
  "chart_8_unknown_time_to_surgery_48_hours_n" VARCHAR  -- Chart 8:Unknown Time To Surgery (48 Hours)(n),
  "chart_9_number_of_cases_included_in_chart" BIGINT  -- Chart 9: Number Of Cases Included In Chart,
  "chart_9_medically_unfit_awaiting_medical_review_invest_a993e580" VARCHAR  -- Chart 9:Medically Unfit - Awaiting Medical Review Investigation Or Stabilisation (n),
  "chart_9_medically_unfit_awaiting_orthopaedic_diagnosis_915c4064" VARCHAR  -- Chart 9:Medically Unfit - Awaiting Orthopaedic Diagnosis Or Investigation (n),
  "chart_9_admin_logistic_awaiting_space_on_theatre_list_n" VARCHAR  -- Chart 9:Admin/logistic - Awaiting Space On Theatre List (n),
  "chart_9_admin_logistic_cancelled_due_to_list_over_run_n" VARCHAR  -- Chart 9:Admin/logistic - Cancelled Due To List Over-run (n),
  "chart_9_admin_logistic_problem_with_theatre_surgical_a_820f09b3" VARCHAR  -- Chart 9:Admin/logistic - Problem With Theatre/surgical/anaesthetic Staff Cover (n),
  "chart_9_admin_logistic_problem_with_theatre_equipment_n" VARCHAR  -- Chart 9:Admin/logistic - Problem With Theatre/equipment (n),
  "chart_9_admin_logistic_awaiting_inpatient_or_high_depe_80884090" VARCHAR  -- Chart 9:Admin/logistic - Awaiting Inpatient Or High Dependency Bed (n),
  "chart_9_other_delay_to_surgery_n" VARCHAR  -- Chart 9:Other Delay To Surgery (n),
  "chart_9_unknowndelay_to_surgery_n" VARCHAR  -- Chart 9:Unknowndelay To Surgery (n),
  "chart_11_number_of_cases_included_in_chart" BIGINT,
  "chart_11_patients_undergoing_surgery_n" BIGINT  -- Chart 11:Patients Undergoing Surgery (n),
  "chart_11_no_surgery_n" VARCHAR  -- Chart 11:No Surgery (n),
  "chart_11_unknown_surgery_n" VARCHAR  -- Chart 11:Unknown Surgery (n),
  "chart_12_number_of_cases_included_in_chart" VARCHAR,
  "chart_12_undisplaced_intracapsular_arthroplasty_unipol_1a262b20" VARCHAR  -- Chart 12:Undisplaced Intracapsular Arthroplasty Unipolar Hemi (cemented) (n),
  "chart_12_undisplaced_intracapsular_arthroplasty_unipol_703a4a78" VARCHAR  -- Chart 12:Undisplaced Intracapsular Arthroplasty Unipolar Hemi (uncemented) (n),
  "chart_12_undisplaced_intracapsular_arthroplasty_bipola_b1c10a1c" VARCHAR  -- Chart 12:Undisplaced Intracapsular Arthroplasty Bipolar Hemi (cemented) (n),
  "chart_12_undisplaced_intracapsular_arthroplasty_other_n" VARCHAR  -- Chart 12:Undisplaced Intracapsular Arthroplasty Other (n),
  "chart_12_undisplaced_intracapsular_internal_fixation_shs_n" VARCHAR  -- Chart 12:Undisplaced Intracapsular Internal Fixation SHS (n),
  "chart_12_undisplaced_intracapsular_internal_fixation_screws_n" VARCHAR  -- Chart 12:Undisplaced Intracapsular Internal Fixation Screws (n),
  "chart_12_undisplaced_intracapsular_other_n" VARCHAR  -- Chart 12:Undisplaced Intracapsular Other (n),
  "chart_12_undisplaced_intracapsular_no_operation_performed_n" VARCHAR  -- Chart 12:Undisplaced Intracapsular No Operation Performed (n),
  "chart_12_undisplaced_intracapsular_unknown_n" VARCHAR  -- Chart 12:Undisplaced Intracapsular Unknown (n),
  "chart_13_number_of_cases_included_in_chart" VARCHAR,
  "chart_13_displaced_intracapsular_arthroplasty_unipolar_400f27f7" VARCHAR  -- Chart 13:Displaced Intracapsular Arthroplasty Unipolar Hemi (cemented) (n),
  "chart_13_displaced_intracapsular_arthroplasty_unipolar_f5774689" VARCHAR  -- Chart 13:Displaced Intracapsular Arthroplasty Unipolar Hemi (uncemented) (n),
  "chart_13_displaced_intracapsular_arthroplasty_bipolar__8332817f" VARCHAR  -- Chart 13:Displaced Intracapsular Arthroplasty Bipolar Hemi (cemented) (n),
  "chart_13_displaced_intracapsular_arthroplasty_other_n" VARCHAR  -- Chart 13:Displaced Intracapsular Arthroplasty Other (n),
  "chart_13_displaced_intracapsular_internal_fixation_shs_n" VARCHAR  -- Chart 13:Displaced Intracapsular Internal Fixation SHS (n),
  "chart_13_displaced_intracapsular_internal_fixation_screws_n" VARCHAR  -- Chart 13:Displaced Intracapsular Internal Fixation Screws (n),
  "chart_13_displaced_intracapsular_other_n" VARCHAR  -- Chart 13:Displaced Intracapsular Other (n),
  "chart_13_displaced_intracapsular_no_operation_performed_n" VARCHAR  -- Chart 13:Displaced Intracapsular No Operation Performed (n),
  "chart_13_displaced_intracapsular_unknown_n" VARCHAR  -- Chart 13:Displaced Intracapsular Unknown (n),
  "chart_14_number_of_cases_included_in_chart" BIGINT,
  "chart_14_arthroplasties_cemented_n" VARCHAR  -- Chart 14:Arthroplasties Cemented (n),
  "chart_14_arthroplasties_uncemented_n" VARCHAR  -- Chart 14:Arthroplasties Uncemented (n),
  "chart_15_number_of_cases_included_in_chart" VARCHAR,
  "chart_15_total_hip_replacement_displaced_intracapsular_n" VARCHAR  -- Chart 15:Total Hip Replacement Displaced Intracapsular(n),
  "chart_15_other_operation_displaced_intracapsular_n" VARCHAR  -- Chart 15:Other Operation Displaced Intracapsular (n),
  "chart_16_number_of_cases_included_in_chart" BIGINT,
  "chart_16_intertrochanteric_internal_fixation_shs_n" BIGINT  -- Chart 16:Intertrochanteric Internal Fixation SHS (n),
  "chart_16_intertrochanteric_internal_fixation_im_nail_long_n" VARCHAR  -- Chart 16:Intertrochanteric Internal Fixation IM Nail (long) (n),
  "chart_16_intertrochanteric_internal_fixation_im_nail_short_n" VARCHAR  -- Chart 16:Intertrochanteric Internal Fixation IM Nail (short) (n),
  "chart_16_intertrochanteric_internal_fixation_screws_n" VARCHAR  -- Chart 16:Intertrochanteric Internal Fixation Screws (n),
  "chart_16_intertrochanteric_arthroplasty_n" VARCHAR  -- Chart 16:Intertrochanteric Arthroplasty (n),
  "chart_16_intertrochanteric_other_n" VARCHAR  -- Chart 16:Intertrochanteric Other (n),
  "chart_16_intertrochanteric_no_operation_performed_n" VARCHAR  -- Chart 16:Intertrochanteric No Operation Performed (n),
  "chart_16_intertrochanteric_unknown_n" VARCHAR  -- Chart 16:Intertrochanteric Unknown (n),
  "chart_17_number_of_cases_included_in_chart" VARCHAR,
  "chart_17_subtrochanteric_internal_fixation_shs_n" VARCHAR  -- Chart 17:Subtrochanteric Internal Fixation SHS (n),
  "chart_17_subtrochanteric_internal_fixation_im_nail_long_n" VARCHAR  -- Chart 17:Subtrochanteric Internal Fixation IM Nail (long) (n)
);