About this Dataset

National Asthma And COPD Audit Programme (NACAP) - Adult Asthma And COPD Organisational Audit 2019

This report contains the main messages and key recommendations derived from an analysis of data collected for the adult asthma and chronic obstructive pulmonary disease (COPD) organisational audit component of the National Asthma and COPD Audit Programme (NACAP). Data collection for the organisational audit took place between 1 April and 1 July 2019 across England, Scotland and Wales. The audit collected information on the resourcing and organisation of services relevant to the care of adult patients with asthma and COPD that are admitted to hospital.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2022-07-01T04:03:23Z

Tables

Table 1

@ukgov.national_asthma_and_copd_audit_programme_nacap_adult_a_bdae75f8.table_1

248.34 KB
189 rows
293 columns


CREATE TABLE table_1 (
  "hosp_name" VARCHAR,
  "trust_healthboard" VARCHAR,
  "country" VARCHAR,
  "copd" BIGINT,
  "asthma" BIGINT,
  "allmed_adms" BIGINT,
  "resp_adms" DOUBLE,
  "copd_adms" BIGINT,
  "asthma_adms" BIGINT,
  "admsperbed" DOUBLE,
  "respadmsperrespbed" DOUBLE,
  "copdadmsper1000adms" DOUBLE,
  "asthmaadmsper1000adms" DOUBLE,
  "q1_1copdadmins" DOUBLE,
  "q1_1copdadminsno" VARCHAR,
  "propcopdadmsdisdie" DOUBLE,
  "q1_2aaadmins" DOUBLE,
  "q1_2aaadminsno" VARCHAR,
  "propasthmaadmsdisdie" DOUBLE,
  "q1_3medbeds" DOUBLE,
  "q1_4respwardbeds" DOUBLE,
  "q1_4respwardbedsno" VARCHAR,
  "q1_4arespwardbedsl2" DOUBLE,
  "l2bedsper1000respadms" DOUBLE,
  "q1_5hdus" VARCHAR,
  "q1_5ahdubeds" DOUBLE,
  "hdubedsper10000adms" DOUBLE,
  "q1_6icu" VARCHAR,
  "q1_6aicubeds" DOUBLE,
  "icubedsper10000adms" DOUBLE,
  "q2_1physifwte" VARCHAR,
  "q2_1physifwte_cat" VARCHAR,
  "q2_1physifwtep1kr" DOUBLE,
  "q2_1physifwtep1kc" DOUBLE,
  "q2_1physifwtep1ka" DOUBLE,
  "q2_1physiuwte" VARCHAR,
  "q2_1physiuwte_cat" VARCHAR,
  "q2_1ct1_2fwte" VARCHAR,
  "q2_1ct1_2fwte_cat" VARCHAR,
  "q2_1ct1_2fwtep1kr" DOUBLE,
  "q2_1ct1_2fwtep1kc" DOUBLE,
  "q2_1ct1_2fwtep1ka" DOUBLE,
  "q2_1ct1_2uwte" VARCHAR,
  "q2_1ct1_2uwte_cat" VARCHAR,
  "q2_1st3wte" VARCHAR,
  "q2_1st3wte_cat" VARCHAR,
  "q2_1st3wtep1kr" DOUBLE,
  "q2_1st3wtep1kc" DOUBLE,
  "q2_1st3wtep1ka" DOUBLE,
  "q2_1st3uwte" VARCHAR,
  "q2_1st3uwte_cat" VARCHAR,
  "q2_1respconswte" VARCHAR,
  "q2_1respconswte_cat" VARCHAR,
  "q2_1respconswtep1kr" DOUBLE,
  "q2_1respconswtep1kc" DOUBLE,
  "q2_1respconswtep1ka" DOUBLE,
  "q2_1respconsuwte" VARCHAR,
  "q2_1respconsuwte_cat" VARCHAR,
  "q2_1assspecwte" VARCHAR,
  "q2_1assspecwte_cat" VARCHAR,
  "q2_1assspecwtep1kr" DOUBLE,
  "q2_1assspecwtep1kc" DOUBLE,
  "q2_1assspecwtep1ka" DOUBLE,
  "q2_1assspecuwte" VARCHAR,
  "q2_1assspecuwte_cat" VARCHAR,
  "q2_1staffgradewte" VARCHAR,
  "q2_1staffgradewte_cat" VARCHAR,
  "q2_1staffgradewtep1kr" DOUBLE,
  "q2_1staffgradewtep1kc" DOUBLE,
  "q2_1staffgradewtep1ka" DOUBLE,
  "q2_1staffgradeuwte" VARCHAR,
  "q2_1staffgradeuwte_cat" VARCHAR,
  "q2_1genrespnurspecfwte" DOUBLE,
  "q2_1genrespnurspecfwte_cat" VARCHAR,
  "q2_1genrespnurspecfwtep1kr" DOUBLE,
  "q2_1genrespnurspecfwtep1kc" DOUBLE,
  "q2_1genrespnurspecfwtep1ka" DOUBLE,
  "q2_1genrespnurspecuwte" VARCHAR,
  "q2_1genrespnurspecuwte_cat" VARCHAR,
  "q2_1copdnurwte" VARCHAR,
  "q2_1copdnurwte_cat" VARCHAR,
  "q2_1copdnurwtep1kr" DOUBLE,
  "q2_1copdnurwtep1kc" DOUBLE,
  "q2_1copdnurwtep1ka" DOUBLE,
  "q2_1copdnuruwte" VARCHAR,
  "q2_1copdnuruwte_cat" VARCHAR,
  "q2_1asthmanurwte" VARCHAR,
  "q2_1asthmanurwte_cat" VARCHAR,
  "q2_1asthmanurwtep1kr" DOUBLE,
  "q2_1asthmanurwtep1kc" DOUBLE,
  "q2_1asthmanurwtep1ka" DOUBLE,
  "q2_1asthmanuruwte" VARCHAR,
  "q2_1asthmanuruwte_cat" VARCHAR,
  "q2_1nurseconswte" VARCHAR,
  "q2_1nurseconswte_cat" VARCHAR,
  "q2_1nurseconswtep1kr" DOUBLE,
  "q2_1nurseconswtep1kc" DOUBLE,
  "q2_1nurseconswtep1ka" DOUBLE,
  "q2_1nurseconsuwte" VARCHAR,
  "q2_1nurseconsuwte_cat" VARCHAR
);

Table 2

@ukgov.national_asthma_and_copd_audit_programme_nacap_adult_a_bdae75f8.table_2

251.15 KB
4 rows
293 columns


CREATE TABLE table_2 (
  "column_a" VARCHAR,
  "column_b" VARCHAR,
  "column_c" VARCHAR,
  "column_d" VARCHAR,
  "column_e" VARCHAR,
  "column_f" VARCHAR,
  "column_g" VARCHAR,
  "column_h" VARCHAR,
  "column_i" VARCHAR,
  "column_j" VARCHAR,
  "column_k" VARCHAR,
  "column_l" VARCHAR,
  "column_m" VARCHAR,
  "column_n" VARCHAR,
  "column_o" VARCHAR,
  "column_p" VARCHAR,
  "column_q" VARCHAR,
  "column_r" VARCHAR,
  "column_s" VARCHAR,
  "column_t" VARCHAR,
  "column_u" VARCHAR,
  "column_v" VARCHAR,
  "column_w" VARCHAR,
  "column_x" VARCHAR,
  "column_y" VARCHAR,
  "column_z" VARCHAR,
  "column_aa" VARCHAR,
  "column_ab" VARCHAR,
  "column_ac" VARCHAR,
  "column_ad" VARCHAR,
  "column_ae" VARCHAR,
  "column_af" VARCHAR,
  "column_ag" VARCHAR,
  "column_ah" VARCHAR,
  "column_ai" VARCHAR,
  "column_aj" VARCHAR,
  "column_ak" VARCHAR,
  "column_al" VARCHAR,
  "column_am" VARCHAR,
  "column_an" VARCHAR,
  "column_ao" VARCHAR,
  "column_ap" VARCHAR,
  "column_aq" VARCHAR,
  "column_ar" VARCHAR,
  "column_as" VARCHAR,
  "column_at" VARCHAR,
  "column_au" VARCHAR,
  "column_av" VARCHAR,
  "column_aw" VARCHAR,
  "column_ax" VARCHAR,
  "column_ay" VARCHAR,
  "column_az" VARCHAR,
  "column_ba" VARCHAR,
  "column_bb" VARCHAR,
  "column_bc" VARCHAR,
  "column_bd" VARCHAR,
  "column_be" VARCHAR,
  "column_bf" VARCHAR,
  "column_bg" VARCHAR,
  "column_bh" VARCHAR,
  "column_bi" VARCHAR,
  "column_bj" VARCHAR,
  "column_bk" VARCHAR,
  "column_bl" VARCHAR,
  "column_bm" VARCHAR,
  "column_bn" VARCHAR,
  "column_bo" VARCHAR,
  "column_bp" VARCHAR,
  "column_bq" VARCHAR,
  "column_br" VARCHAR,
  "column_bs" VARCHAR,
  "column_bt" VARCHAR,
  "column_bu" VARCHAR,
  "column_bv" VARCHAR,
  "column_bw" VARCHAR,
  "column_bx" VARCHAR,
  "column_by" VARCHAR,
  "column_bz" VARCHAR,
  "column_ca" VARCHAR,
  "column_cb" VARCHAR,
  "column_cc" VARCHAR,
  "column_cd" VARCHAR,
  "column_ce" VARCHAR,
  "column_cf" VARCHAR,
  "column_cg" VARCHAR,
  "column_ch" VARCHAR,
  "column_ci" VARCHAR,
  "column_cj" VARCHAR,
  "column_ck" VARCHAR,
  "column_cl" VARCHAR,
  "column_cm" VARCHAR,
  "column_cn" VARCHAR,
  "column_co" VARCHAR,
  "column_cp" VARCHAR,
  "column_cq" VARCHAR,
  "column_cr" VARCHAR,
  "column_cs" VARCHAR,
  "column_ct" VARCHAR,
  "column_cu" VARCHAR,
  "column_cv" VARCHAR
);