About this Dataset

National Hip Fracture Database Anaesthesia Sprint Audit Of Practice (ASAP) Report 2014

The outcome of hip fracture serves as a key marker of the quality of hospital care across the many disciplines and departments who collaborate before, during and after this operation. However, the immediate physiological stress experienced by these patients is the pain and blood loss associated with the fracture. High quality anaesthetic care is crucial to the effective management of both stresses. Clinicians interested in promoting better anaesthetic management of patients with hip fracture came together in 2007. The Hip Fracture Perioperative Network (HipPeN) grew from this, and produced a report in 2010 highlighting wide variations in anaesthetic practice. HipPeN has since completed several projects – leading to publication of the Association of Anaesthetists of Great Britain and Ireland (AAGB&I;) guidelines on the anaesthetic management of hip fracture in 2012. The National Hip Fracture Database (NHFD) is the largest hip fracture database in the world. The database includes surgical and mortality data on a third of a million patients. It captures 95% of all new cases of hip fracture, with data from all hospitals in England, Wales, Northern Ireland and the Channel Islands, and provides an ideal infrastructure for large audits. Public funding was provided through the Healthcare Quality Improvement Partnership (HQIP); the NHFD has now been incorporated into the Falls and Fragility Fracture Audit Programme (FFFAP) administered by the Royal College of Physicians (RCP). Collaboration between the AAGB&I; and the NHFD culminated in this 2014 report which profiles approaches to peri-operative care across England, Wales and Northern Ireland. ASAP set out to collect data on everyone over the age of 60 who had hip fracture surgery in hospitals across England, Wales and Northern Ireland between 1st May and 31st July 2013. The aim of ASAP was to profile individual hospitals’ compliance with the standards for peri-operative care defined by the National Institute of Health and Care Excellence (NICE) in 2011, and the Association of Anaesthetists of Great Britain and Ireland (AAGB&I;) in 2012. 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:29:36Z

Tables

National Hip Fracture Database Anaesthesia Sprint Audit Of Practice (ASAP) Report 2014

@ukgov.national_hip_fracture_database_anaesthesia_sprint_audi_00bc575a.national_hip_fracture_database_anaesthesia_sprint_audi_00bc575a

84.93 kB
180 rows
68 columns

CREATE TABLE national_hip_fracture_database_anaesthesia_sprint_audi_00bc575a (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "figure_3_seniority_of_surgeon_and_anaesthetist_number__99800b56" VARCHAR  -- Figure 3: Seniority Of Surgeon And Anaesthetist: Number Of Cases Included,
  "figure_3_seniority_of_surgeon_and_anaesthetist_consult_f2e73881" VARCHAR  -- Figure 3: Seniority Of Surgeon And Anaesthetist: Consultant Surgeon And Consultant Anaesthetist,
  "figure_3_seniority_of_surgeon_and_anaesthetist_consult_0ef915a3" VARCHAR  -- Figure 3: Seniority Of Surgeon And Anaesthetist: Consultant Surgeon And Junior Anaesthetist,
  "figure_3_seniority_of_surgeon_and_anaesthetist_junior__2127e419" VARCHAR  -- Figure 3: Seniority Of Surgeon And Anaesthetist: Junior Surgeon And Consultant Anaesthetist,
  "figure_3_seniority_of_surgeon_and_anaesthetist_junior__b647abf2" VARCHAR  -- Figure 3: Seniority Of Surgeon And Anaesthetist: Junior Surgeon And Junior Anaesthetist,
  "figure_3_seniority_of_surgeon_and_anaesthetist_not_rec_45b74f91" VARCHAR  -- Figure 3: Seniority Of Surgeon And Anaesthetist: Not Recorded Or Unknown,
  "figure_5_mode_of_anaesthesia_by_hospital_number_of_cas_df06decb" VARCHAR  -- Figure 5: Mode Of Anaesthesia By Hospital: Number Of Cases Included,
  "figure_5_mode_of_anaesthesia_by_hospital_general_anaes_a365cf45" VARCHAR  -- Figure 5: Mode Of Anaesthesia By Hospital: General Anaesthesia Only,
  "figure_5_mode_of_anaesthesia_by_hospital_general_anaes_d1f33680" VARCHAR  -- Figure 5: Mode Of Anaesthesia By Hospital: General Anaesthesia Plus Nerve Block,
  "figure_5_mode_of_anaesthesia_by_hospital_general_anaes_bf9e423b" VARCHAR  -- Figure 5: Mode Of Anaesthesia By Hospital: General Anaesthesia Plus Spinal Anaesthesia,
  "figure_5_mode_of_anaesthesia_by_hospital_spinal_anaest_0cb5f3d9" VARCHAR  -- Figure 5: Mode Of Anaesthesia By Hospital: Spinal Anaesthesia Only,
  "figure_5_mode_of_anaesthesia_by_hospital_spinal_anaest_775b0e2c" VARCHAR  -- Figure 5: Mode Of Anaesthesia By Hospital: Spinal Anaesthesia Plus Nerve Block,
  "figure_5_mode_of_anaesthesia_by_hospital_other_or_unknown" VARCHAR  -- Figure 5: Mode Of Anaesthesia By Hospital: Other Or Unknown,
  "figure_7_hyperbaric_bupivacaine_number_of_cases_included" VARCHAR  -- Figure 7: Hyperbaric Bupivacaine: Number Of Cases Included,
  "figure_7_hyperbaric_bupivacaine_lateral_position_2mls" VARCHAR  -- Figure 7: Hyperbaric Bupivacaine: Lateral Position <2mls,
  "figure_7_hyperbaric_bupivacaine_other_dose_or_position" VARCHAR  -- Figure 7: Hyperbaric Bupivacaine: Other Dose Or Position,
  "figure_8_subarachnoid_fentanyl_number_of_cases_included" VARCHAR  -- Figure 8: Subarachnoid Fentanyl: Number Of Cases Included,
  "figure_8_subarachnoid_fentanyl_other_preparation" VARCHAR  -- Figure 8: Subarachnoid Fentanyl: Other Preparation,
  "figure_8_subarachnoid_fentanyl_administered_subarachno_d668b5c4" VARCHAR  -- Figure 8: Subarachnoid Fentanyl: Administered Subarachnoid Fentanyl,
  "figure_9_sedation_number_of_cases_included" VARCHAR  -- Figure 9: Sedation: Number Of Cases Included,
  "figure_9_sedation_spinal_with_sedation" VARCHAR  -- Figure 9: Sedation: Spinal With Sedation,
  "figure_9_sedation_spinal_with_no_sedation" VARCHAR  -- Figure 9: Sedation: Spinal With No Sedation,
  "figure_10_spinal_sedation_with_suplemental_oxygen_numb_9b29ed15" VARCHAR  -- Figure 10: Spinal Sedation With Suplemental Oxygen: Number Of Cases Included,
  "figure_10_spinal_sedation_with_suplemental_oxygen_numb_56db7e1d" VARCHAR  -- Figure 10: Spinal Sedation With Suplemental Oxygen: Number Of Cases Receiving Supplemental Oxygen,
  "figure_10_spinal_sedation_with_suplemental_oxygen_numb_13778b3f" VARCHAR  -- Figure 10: Spinal Sedation With Suplemental Oxygen: Number Of Cases Not Receiving Supplemental Oxygen,
  "figure_11_ga_induction_number_of_cases_included" VARCHAR  -- Figure 11: GA Induction: Number Of Cases Included,
  "figure_11_ga_induction_intravenous_induction" VARCHAR  -- Figure 11: GA Induction: Intravenous Induction,
  "figure_11_ga_induction_inhalational_induction" VARCHAR  -- Figure 11: GA Induction: Inhalational Induction,
  "figure_11_ga_induction_inhalational_and_intravenous_induction" VARCHAR  -- Figure 11: GA Induction: Inhalational And Intravenous Induction,
  "figure_11_ga_induction_induction_not_recorded" VARCHAR  -- Figure 11: GA Induction:induction Not Recorded,
  "figure_12_general_anaesthesia_paralysed_and_ventilated_13a8e448" VARCHAR  -- Figure 12: General Anaesthesia, Paralysed And Ventilated: Number Of Cases Included,
  "figure_12_general_anaesthesia_paralysed_and_ventilated_e6083a91" VARCHAR  -- Figure 12: General Anaesthesia, Paralysed And Ventilated: Number Of Cases Paralysed And Ventilated,
  "figure_12_general_anaesthesia_paralysed_and_ventilated_0a35576c" VARCHAR  -- Figure 12: General Anaesthesia, Paralysed And Ventilated: Number Of Cases Ventilated Non Paralysed,
  "figure_12_general_anaesthesia_paralysed_and_ventilated_8486f3ad" VARCHAR  -- Figure 12: General Anaesthesia, Paralysed And Ventilated: Number Of Cases Self Ventilating,
  "figure_13_peripheral_nerve_blocks_number_of_cases_included" VARCHAR  -- Figure 13: Peripheral Nerve Blocks: Number Of Cases Included,
  "figure_13_peripheral_nerve_blocks_number_of_cases_havi_8a59314f" VARCHAR  -- Figure 13: Peripheral Nerve Blocks: Number Of Cases Having Peripheral Nerve Block,
  "figure_13_peripheral_nerve_blocks_number_of_cases_not__38d7b2e6" VARCHAR  -- Figure 13: Peripheral Nerve Blocks: Number Of Cases Not Having Peripheral Nerve Block,
  "figure_14_general_and_spinal_anaesthesia_combined_numb_efc3c9fb" VARCHAR  -- Figure 14: General And Spinal Anaesthesia Combined: Number Of Cases Included,
  "figure_14_general_and_spinal_anaesthesia_combined_numb_20788995" VARCHAR  -- Figure 14: General And Spinal Anaesthesia Combined: Number Of Cases With General And Spinal Anaesthesia Combined,
  "figure_14_general_and_spinal_anaesthesia_combined_numb_4779a266" VARCHAR  -- Figure 14: General And Spinal Anaesthesia Combined: Number Of Cases With Anaesthesia Other Than General And Spinal Anaesthesia Combined,
  "figure_15_relative_hypotension_number_of_cases_included" VARCHAR  -- Figure 15: Relative Hypotension: Number Of Cases Included,
  "figure_15_relative_hypotension_sbp_20" VARCHAR  -- Figure 15: Relative Hypotension: SBP>20%,
  "figure_15_relative_hypotension_no_sbp_20" VARCHAR  -- Figure 15: Relative Hypotension: No SBP>20%,
  "figure_16_absolute_hypotension_number_of_cases_included" VARCHAR  -- Figure 16: Absolute Hypotension: Number Of Cases Included,
  "figure_16_absolute_hypotension_lowsbp_100" VARCHAR  -- Figure 16: Absolute Hypotension: LowSBP <100,
  "figure_16_absolute_hypotension_low_sbp_100" VARCHAR  -- Figure 16: Absolute Hypotension: Low SBP >=100,
  "figure_17_bone_cement_inpmantation_syndrome_number_of__1b8a84dc" VARCHAR  -- Figure 17: Bone Cement Inpmantation Syndrome: Number Of Cases Included,
  "figure_17_bone_cement_inpmantation_syndrome_bcis" VARCHAR  -- Figure 17: Bone Cement Inpmantation Syndrome: BCIS,
  "figure_17_bone_cement_inpmantation_syndrome_not_recorded" VARCHAR  -- Figure 17: Bone Cement Inpmantation Syndrome: Not Recorded,
  "figure_17_bone_cement_inpmantation_syndrome_no_bcis" VARCHAR  -- Figure 17: Bone Cement Inpmantation Syndrome: No BCIS,
  "summary_table_asap_cases_submitted" DOUBLE  -- Summary Table: ASAP Cases Submitted,
  "summary_table_ascertainment" DOUBLE  -- Summary Table : % Ascertainment,
  "summary_table_asap_standard_1" DOUBLE  -- Summary Table : ASAP Standard 1,
  "summary_table_asap_standard_2" DOUBLE  -- Summary Table : ASAP Standard 2,
  "summary_table_asap_standard_3" DOUBLE  -- Summary Table : ASAP Standard 3,
  "summary_table_asap_standard_4" DOUBLE  -- Summary Table : ASAP Standard 4,
  "summary_table_asap_standard_5" DOUBLE  -- Summary Table : ASAP Standard 5,
  "summary_table_asap_standard_6" DOUBLE  -- Summary Table : ASAP Standard 6,
  "summary_table_asap_standard_7" DOUBLE  -- Summary Table : ASAP Standard 7,
  "summary_table_asap_standard_8" DOUBLE  -- Summary Table : ASAP Standard 8,
  "summary_table_asap_standard_9" DOUBLE  -- Summary Table : ASAP Standard 9,
  "summary_table_asap_standard_10" DOUBLE  -- Summary Table : ASAP Standard 10,
  "summary_table_asap_standard_11a" DOUBLE  -- Summary Table : ASAP Standard 11a,
  "summary_table_asap_standard_11b" DOUBLE  -- Summary Table : ASAP Standard 11b,
  "summary_table_asap_standard_12" DOUBLE  -- Summary Table : ASAP Standard 12,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67
);