About this Dataset

National Audit Of Inpatient Falls 2024 Annual Report

National Audit of Inpatient Falls Data from clinical audit data from 1 January to 31 December 2023, published October 2024. Falls are the most frequently reported incident affecting hospital inpatients. The data collected by NAIF and presented below provide opportunity to identify areas in which to enhance the quality of care for people who sustain an inpatient hip fracture.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-12-15T22:06:26Z

Tables

Phase 6 – NAIF 20233 Annual Report – Clinical Data

@ukgov.national_audit_of_inpatient_falls_2024_annual_report.phase_6_naif_20233_annual_report_clinical_data

364.8 KB
164 rows
411 columns


CREATE TABLE phase_6_naif_20233_annual_report_clinical_data (
  "trustcode2" VARCHAR,
  "trust_name" VARCHAR,
  "q101n_falls_by_categoryyes" VARCHAR,
  "q101total_fallsyes" VARCHAR,
  "q101p_falls_by_categoryyes" VARCHAR,
  "q201total_falls" VARCHAR,
  "q201invalid_now_missing_date" VARCHAR,
  "q201median_los_ptf_days" DOUBLE,
  "q201lower_iqr_los_ptf_days" DOUBLE,
  "q201upper_iqr_los_ptf_days" DOUBLE,
  "q201median_los_ptf_hours" DOUBLE,
  "q201lower_iqr_los_ptf_hours" DOUBLE,
  "q201upper_iqr_los_ptf_hours" DOUBLE,
  "n_falls_acuteemergencyd" VARCHAR,
  "p_falls_acuteemergencyd" VARCHAR,
  "n_falls_acutemedicaladm" VARCHAR,
  "p_falls_acutemedicaladm" VARCHAR,
  "n_falls_acutemedicalgen" VARCHAR,
  "p_falls_acutemedicalgen" VARCHAR,
  "n_falls_acutemissing" VARCHAR,
  "p_falls_acutemissing" VARCHAR,
  "n_falls_acuteolderperso" VARCHAR,
  "p_falls_acuteolderperso" VARCHAR,
  "n_falls_acuteother" VARCHAR,
  "p_falls_acuteother" VARCHAR,
  "n_falls_acutesurgicalad" VARCHAR,
  "p_falls_acutesurgicalad" VARCHAR,
  "n_falls_acutesurgicalge" VARCHAR,
  "p_falls_acutesurgicalge" VARCHAR,
  "n_falls_acutetraumaorth" VARCHAR,
  "p_falls_acutetraumaorth" VARCHAR,
  "n_falls_commcontinuing" VARCHAR,
  "p_falls_commcontinuing" VARCHAR,
  "n_falls_commgeneral" VARCHAR,
  "p_falls_commgeneral" VARCHAR,
  "n_falls_integadultmenta" VARCHAR,
  "p_falls_integadultmenta" VARCHAR,
  "n_falls_integcontinuing" VARCHAR,
  "p_falls_integcontinuing" VARCHAR,
  "n_falls_integemergencyd" VARCHAR,
  "p_falls_integemergencyd" VARCHAR,
  "n_falls_integgeneralcom" VARCHAR,
  "p_falls_integgeneralcom" VARCHAR,
  "n_falls_integmedicaladm" VARCHAR,
  "p_falls_integmedicaladm" VARCHAR,
  "n_falls_integmedicalgen" VARCHAR,
  "p_falls_integmedicalgen" VARCHAR,
  "n_falls_integmissing" VARCHAR,
  "p_falls_integmissing" VARCHAR,
  "n_falls_integolderadult" VARCHAR,
  "p_falls_integolderadult" VARCHAR,
  "n_falls_integolderperso" VARCHAR,
  "p_falls_integolderperso" VARCHAR,
  "n_falls_integotheracute" VARCHAR,
  "p_falls_integotheracute" VARCHAR,
  "n_falls_integothercommu" VARCHAR,
  "p_falls_integothercommu" VARCHAR,
  "n_falls_integsurgicalad" VARCHAR,
  "p_falls_integsurgicalad" VARCHAR,
  "n_falls_integsurgicalge" VARCHAR,
  "p_falls_integsurgicalge" VARCHAR,
  "n_falls_integtraumaorth" VARCHAR,
  "p_falls_integtraumaorth" VARCHAR,
  "n_falls_mhgeneraladu" VARCHAR,
  "p_falls_mhgeneraladu" VARCHAR,
  "n_falls_mholderpeopl" VARCHAR,
  "p_falls_mholderpeopl" VARCHAR,
  "q301n_falls_by_mfra0" VARCHAR,
  "q301p_falls_by_mfra0" VARCHAR,
  "q301n_falls_by_mfra1" VARCHAR,
  "q301p_falls_by_mfra1" VARCHAR,
  "q301n_falls_by_mfram" VARCHAR,
  "q301p_falls_by_mfram" VARCHAR,
  "q301atotal_falls" VARCHAR,
  "q301amedian_mfra_days" VARCHAR,
  "q301alower_iqr_mfra_days" VARCHAR,
  "q301aupper_iqr_mfra_days" VARCHAR,
  "q302n_falls_other0" VARCHAR,
  "q302p_falls_other0" VARCHAR,
  "q302n_falls_other1" VARCHAR,
  "q302p_falls_other1" VARCHAR,
  "q303n_falls_other_mfra0" VARCHAR,
  "q303p_falls_other_mfra0" VARCHAR,
  "q303n_falls_other_mfra1" VARCHAR,
  "q303p_falls_other_mfra1" VARCHAR,
  "q304n_falls_visionnotdocumen" VARCHAR,
  "q304p_falls_visionnotdocumen" VARCHAR,
  "q304n_falls_visionyesnovisua" VARCHAR,
  "q304p_falls_visionyesnovisua" VARCHAR,
  "q304n_falls_visionyesvisuali" VARCHAR,
  "q304p_falls_visionyesvisuali" VARCHAR,
  "q304_1n_falls_vision0" VARCHAR,
  "q304_1p_falls_vision0" VARCHAR,
  "q304_1n_falls_vision1" VARCHAR,
  "q304_1p_falls_vision1" VARCHAR,
  "q304_2n_falls_vision0" VARCHAR,
  "q304_2p_falls_vision0" VARCHAR,
  "q304_2n_falls_vision1" VARCHAR,
  "q304_2p_falls_vision1" VARCHAR,
  "q305n_falls_bp_catnotdocumen" VARCHAR
);