About this Dataset

National Hip Fracture Database Annual Report 2014

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.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-09-15T10:05:16Z

Tables

National Hip Fracture Database Annual Report 2014

@ukgov.national_hip_fracture_database_annual_report_2014.national_hip_fracture_database_annual_report_2014

179.9 kB
165 rows
143 columns

CREATE TABLE national_hip_fracture_database_annual_report_2014 (
  "site" VARCHAR,
  "chart_1_number_of_cases_included_in_chart" BIGINT,
  "chart_1_admitted_to_orthopaedic_ward_within_4_hours_n" VARCHAR  -- Chart 1:Admitted To Orthopaedic Ward Within 4 Hours (n),
  "chart_1_admitted_to_orthopaedic_ward_after_4_hours_n" BIGINT  -- Chart 1:Admitted To Orthopaedic Ward After 4 Hours (n),
  "chart_1_not_admitted_to_orthopaedic_ward_n" VARCHAR  -- Chart 1:Not Admitted To Orthopaedic Ward (n),
  "chart_1_unknown_n" VARCHAR  -- Chart 1:Unknown (n),
  "chart2_number_of_cases_included_in_chart" BIGINT,
  "chart2_routine_by_orthogeriatrician_n" VARCHAR  -- Chart2:Routine By Orthogeriatrician (n),
  "chart2_all_other_reviews_n" VARCHAR  -- Chart2:All Other Reviews (n),
  "chart2_no_assessment_n" VARCHAR  -- Chart2:No Assessment (n),
  "chart2_unknown_n" VARCHAR  -- Chart2:Unknown (n),
  "chart3_number_of_cases_included_in_chart" BIGINT,
  "chart3_ga_ga_nerve_block_n" VARCHAR  -- Chart3:GA, GA+nerve Block (n),
  "chart3_sa_sa_epidural_cse_sa_nerve_block_n" VARCHAR  -- Chart3:SA, SA+epidural(CSE), SA+nerve Block (n),
  "chart3_ga_sa_ga_epidural_n" VARCHAR  -- Chart3:GA+SA, GA+epidural (n),
  "chart3_unknown_and_other_n" VARCHAR  -- Chart3:Unknown And Other (n),
  "chart4_number_of_cases_included_in_chart" BIGINT,
  "chart4_surgery_on_day_of_or_day_after_admission_n" BIGINT  -- Chart4:Surgery On Day Of, Or Day After, Admission (n),
  "chart4_surgery_two_or_more_calendar_days_after_admission_n" BIGINT  -- Chart4:Surgery Two Or More Calendar Days After Admission (n),
  "chart4_no_surgery_performed_n" VARCHAR  -- Chart4:No Surgery Performed (n),
  "chart4_unknown_n" VARCHAR  -- Chart4:Unknown (n),
  "chart5_number_of_cases_included_in_chart" VARCHAR,
  "chart5_internal_fixation_n" VARCHAR  -- Chart5:Internal Fixation (n),
  "chart5_arthroplasty_n" VARCHAR  -- Chart5:Arthroplasty (n),
  "chart5_no_operation_n" VARCHAR  -- Chart5:No Operation (n),
  "chart5_unknown_and_other_n" VARCHAR  -- Chart5:Unknown And Other (n),
  "chart6_number_of_cases_included_in_chart" VARCHAR,
  "chart6_arthroplasty_n" VARCHAR  -- Chart6:Arthroplasty (n),
  "chart6_internal_fixation_n" VARCHAR  -- Chart6:Internal Fixation (n),
  "chart6_no_operation_n" VARCHAR  -- Chart6:No Operation (n),
  "chart6_unknown_and_other_n" VARCHAR  -- Chart6:Unknown And Other (n),
  "chart7_number_of_cases_included_in_chart" VARCHAR,
  "chart7_cemented_n" VARCHAR  -- Chart7:Cemented (n),
  "chart7_uncemented_n" VARCHAR  -- Chart7:Uncemented (n),
  "chart8_number_of_cases_included_in_chart" VARCHAR,
  "chart8_total_hip_replacement_n" VARCHAR  -- Chart8:Total Hip Replacement (n),
  "chart8_other_operation_or_unknown_n" VARCHAR  -- Chart8:Other Operation Or Unknown (n),
  "chart9_number_of_cases_included_in_chart" VARCHAR,
  "chart9_internal_fixation_shs_n" VARCHAR  -- Chart9:Internal Fixation SHS (n),
  "chart9_internal_fixation_not_shs_n" VARCHAR  -- Chart9:Internal Fixation – Not SHS (n),
  "chart9_arthroplasty_n" VARCHAR  -- Chart9:Arthroplasty (n),
  "chart9_no_operation_n" VARCHAR  -- Chart9:No Operation (n),
  "chart9_unknown_and_other_n" VARCHAR  -- Chart9:Unknown And Other (n),
  "chart10_number_of_cases_included_in_chart" VARCHAR,
  "chart10_internal_fixation_all_intramedullary_nail_n" VARCHAR  -- Chart10:Internal Fixation – All Intramedullary Nail (n),
  "chart10_internal_fixation_all_other_n" VARCHAR  -- Chart10:Internal Fixation –all Other (n),
  "chart10_arthroplasty_n" VARCHAR  -- Chart10:Arthroplasty (n),
  "chart10_no_operation_n" VARCHAR  -- Chart10:No Operation (n),
  "chart10_unknown_and_other_n" VARCHAR  -- Chart10:Unknown And Other (n),
  "chart11_number_of_cases_included_in_chart" VARCHAR,
  "chart11_surgery_n" VARCHAR  -- Chart11:Surgery (n),
  "chart11_no_surgery_n" VARCHAR  -- Chart11:No Surgery (n),
  "chart11_unknown_n" VARCHAR  -- Chart11:Unknown (n),
  "chart12_number_of_cases_included_in_chart" VARCHAR,
  "chart12_reoperation_within_30_days_n" VARCHAR  -- Chart12:Reoperation Within 30 Days (n),
  "chart12_no_reoperation_within_30_days_n" VARCHAR  -- Chart12:No Reoperation Within 30 Days (n),
  "chart12_unknown_n" VARCHAR  -- Chart12:Unknown (n),
  "chart13_number_of_cases_included_in_chart" BIGINT,
  "chart13_continued_from_pre_admission_n" VARCHAR  -- Chart13:Continued From Pre-admission (n),
  "chart13_started_on_this_admission_n" VARCHAR  -- Chart13:Started On This Admission (n),
  "chart13_awaits_dxa_scan_n" VARCHAR  -- Chart13:Awaits DXA Scan (n),
  "chart13_awaits_bone_clinic_assessment_n" VARCHAR  -- Chart13:Awaits Bone Clinic Assessment (n),
  "chart13_assessed_no_bone_protection_medication_needed__68b02729" VARCHAR  -- Chart13:Assessed – No Bone Protection Medication Needed/appropriate (n),
  "chart13_no_assessment_or_action_taken_n" VARCHAR  -- Chart13:No Assessment Or Action Taken (n),
  "chart13_unknown_n" VARCHAR  -- Chart13:Unknown (n),
  "chart14_number_of_cases_included_in_chart" BIGINT,
  "chart14_yes_n" BIGINT  -- Chart14:Yes (n),
  "chart14_no_or_unknown_n" VARCHAR  -- Chart14:No Or Unknown (n),
  "chart15_number_of_cases_included_in_chart" BIGINT,
  "chart15_pressure_ulcers_n" VARCHAR  -- Chart15:Pressure Ulcers (n),
  "chart15_no_pressure_ulcers_n" BIGINT  -- Chart15:No Pressure Ulcers (n),
  "chart15_unknown_n" VARCHAR  -- Chart15:Unknown (n),
  "chart16_number_of_cases_included_in_chart" BIGINT,
  "chart16_own_home_sheltered_housing_n" BIGINT  -- Chart16:Own Home/sheltered Housing (n),
  "chart16_rehabilitation_unit_n" VARCHAR  -- Chart16:Rehabilitation Unit (n),
  "chart16_acute_hospital_n" VARCHAR  -- Chart16:Acute Hospital (n),
  "chart16_residential_care_n" VARCHAR  -- Chart16:Residential Care (n),
  "chart16_nursing_care_n" VARCHAR  -- Chart16:Nursing Care (n),
  "chart16_dead_n" VARCHAR  -- Chart16:Dead (n),
  "chart16_other_n" VARCHAR  -- Chart16:Other (n),
  "chart16_unknown_n" VARCHAR  -- Chart16:Unknown (n),
  "chart17_number_of_cases_included_in_chart" BIGINT,
  "chart17_own_home_sheltered_housing_n" BIGINT  -- Chart17:Own Home/sheltered Housing (n),
  "chart17_residential_care_n" VARCHAR  -- Chart17:Residential Care (n),
  "chart17_nursing_care_n" VARCHAR  -- Chart17:Nursing Care (n),
  "chart17_rehabilitation_unit_n" VARCHAR  -- Chart17:Rehabilitation Unit (n),
  "chart17_acute_hospital_n" VARCHAR  -- Chart17:Acute Hospital (n),
  "chart17_already_in_hospital_n" VARCHAR  -- Chart17:Already In Hospital (n),
  "chart17_other_n" VARCHAR  -- Chart17:Other (n),
  "chart17_unknown_n" VARCHAR  -- Chart17:Unknown (n),
  "chart18_number_of_cases_included_in_chart" VARCHAR,
  "chart18_mean_length_of_acute_stay_days" VARCHAR  -- Chart18:Mean Length Of Acute Stay (days),
  "chart18_mean_length_of_post_acute_stay_days" VARCHAR  -- Chart18:Mean Length Of Post-acute Stay (days),
  "chart19_no_of_cases_eligible_for_mortality_analysis" BIGINT  -- Chart19:No. Of Cases Eligible For Mortality Analysis,
  "chart19_raw_mortality_rate_within_30_days" VARCHAR  -- Chart19:Raw Mortality Rate Within 30 Days (%),
  "chart19_adjusted_mortality_rate_with_30_days" VARCHAR  -- Chart19:Adjusted Mortality Rate With 30 Days (%),
  "chart20_no_of_cases_eligible_for_return_home_from_home_analysis" BIGINT  -- Chart20:No. Of Cases Eligible For Return Home From Home Analysis,
  "chart20_raw_return_home_rate_by_30_days" VARCHAR  -- Chart20:Raw Return Home Rate By 30 Days (%),
  "chart20_adjusted_return_home_rate_by_30_days" VARCHAR  -- Chart20:Adjusted Return Home Rate By 30 Days (%),
  "chart21_number_of_cases_included_in_chart" BIGINT
);