Baselight
Sign In

National Asthma And COPD Audit Programme (NACAP) Adult Asthma Audit 2019/20

Healthcare Quality Improvement Partnership

@ukgov.national_asthma_and_copd_audit_programme_nacap_adult_a_ffb8272e

Loading...
Loading...

About this Dataset

National Asthma And COPD Audit Programme (NACAP) Adult Asthma Audit 2019/20

This report contains the main messages and key recommendations derived from an analysis of data collected for the adult asthma clinical audit component of the National Asthma and COPD Audit Programme (NACAP). The report contains data collected form adult asthma patients discharged from hospital between 1 April 2019 and 31 March 2020 across England, Scotland and Wales.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-09-14T12:06:01Z

Tables

Adult Asthma Secondary Care Clinical Audit 2019-2020 Data Description File

@ukgov.national_asthma_and_copd_audit_programme_nacap_adult_a_ffb8272e.adult_asthma_secondary_care_clinical_audit_2019_2020_d_4c5e9a9b
  • 595.98 KB
  • 3 rows
  • 595 columns
Loading... 

CREATE TABLE adult_asthma_secondary_care_clinical_audit_2019_2020_d_4c5e9a9b (
  "hosp_code" VARCHAR,
  "hosp_name" VARCHAR,
  "trust_code" VARCHAR,
  "trust_name" VARCHAR,
  "record_n" VARCHAR,
  "country1" VARCHAR,
  "age_n" VARCHAR,
  "age_median" VARCHAR,
  "age_lo_quart" VARCHAR,
  "age_hi_quart" VARCHAR,
  "gender_n" VARCHAR,
  "gender_male_n" VARCHAR,
  "gender_male_perc" VARCHAR,
  "gender_female_n" VARCHAR,
  "gender_female_perc" VARCHAR,
  "gender_transgender_n" VARCHAR,
  "gender_transgender_perc" VARCHAR,
  "gender_other_n" VARCHAR,
  "gender_other_perc" VARCHAR,
  "gender_not_recorded_n" VARCHAR,
  "gender_not_recorded_perc" VARCHAR,
  "imd_quintile_eng_n" VARCHAR,
  "imd_quintile_eng_1_n" VARCHAR,
  "imd_quintile_eng_1_perc" VARCHAR,
  "imd_quintile_eng_2_n" VARCHAR,
  "imd_quintile_eng_2_perc" VARCHAR,
  "imd_quintile_eng_3_n" VARCHAR,
  "imd_quintile_eng_3_perc" VARCHAR,
  "imd_quintile_eng_4_n" VARCHAR,
  "imd_quintile_eng_4_perc" VARCHAR,
  "imd_quintile_eng_5_n" VARCHAR,
  "imd_quintile_eng_5_perc" VARCHAR,
  "imd_quintile_scot_n" VARCHAR,
  "imd_quintile_scot_1_n" VARCHAR,
  "imd_quintile_scot_1_perc" VARCHAR,
  "imd_quintile_scot_2_n" VARCHAR,
  "imd_quintile_scot_2_perc" VARCHAR,
  "imd_quintile_scot_3_n" VARCHAR,
  "imd_quintile_scot_3_perc" VARCHAR,
  "imd_quintile_scot_4_n" VARCHAR,
  "imd_quintile_scot_4_perc" VARCHAR,
  "imd_quintile_scot_5_n" VARCHAR,
  "imd_quintile_scot_5_perc" VARCHAR,
  "imd_quintile_wal_n" VARCHAR,
  "imd_quintile_wal_1_n" VARCHAR,
  "imd_quintile_wal_1_perc" VARCHAR,
  "imd_quintile_wal_2_n" VARCHAR,
  "imd_quintile_wal_2_perc" VARCHAR,
  "imd_quintile_wal_3_n" VARCHAR,
  "imd_quintile_wal_3_perc" VARCHAR,
  "imd_quintile_wal_4_n" VARCHAR,
  "imd_quintile_wal_4_perc" VARCHAR,
  "imd_quintile_wal_5_n" VARCHAR,
  "imd_quintile_wal_5_perc" VARCHAR,
  "anyimd_n" VARCHAR,
  "anyimd_imd_present_n" VARCHAR,
  "anyimd_imd_present_perc" VARCHAR,
  "anyimd_no_imd_n" VARCHAR,
  "anyimd_no_imd_perc" VARCHAR,
  "monday_0_00to1_59_admiss_n" VARCHAR,
  "monday_2_00to3_59_admiss_n" VARCHAR,
  "monday_4_00to5_59_admiss_n" VARCHAR,
  "monday_6_00to7_59_admiss_n" VARCHAR,
  "monday_8_00to9_59_admiss_n" VARCHAR,
  "monday_10_00to11_59_admiss_n" VARCHAR,
  "monday_12_00to13_59_admiss_n" VARCHAR,
  "monday_14_00to15_59_admiss_n" VARCHAR,
  "monday_16_00to17_59_admiss_n" VARCHAR,
  "monday_18_00to19_59_admiss_n" VARCHAR,
  "monday_20_00to21_59_admiss_n" VARCHAR,
  "monday_22_00to23_59_admiss_n" VARCHAR,
  "tuesday_0_00to1_59_admiss_n" VARCHAR,
  "tuesday_2_00to3_59_admiss_n" VARCHAR,
  "tuesday_4_00to5_59_admiss_n" VARCHAR,
  "tuesday_6_00to7_59_admiss_n" VARCHAR,
  "tuesday_8_00to9_59_admiss_n" VARCHAR,
  "tuesday_10_00to11_59_admiss_n" VARCHAR,
  "tuesday_12_00to13_59_admiss_n" VARCHAR,
  "tuesday_14_00to15_59_admiss_n" VARCHAR,
  "tuesday_16_00to17_59_admiss_n" VARCHAR,
  "tuesday_18_00to19_59_admiss_n" VARCHAR,
  "tuesday_20_00to21_59_admiss_n" VARCHAR,
  "tuesday_22_00to23_59_admiss_n" VARCHAR,
  "wednesday_0_00to1_59_admiss_n" VARCHAR,
  "wednesday_2_00to3_59_admiss_n" VARCHAR,
  "wednesday_4_00to5_59_admiss_n" VARCHAR,
  "wednesday_6_00to7_59_admiss_n" VARCHAR,
  "wednesday_8_00to9_59_admiss_n" VARCHAR,
  "wednesday_10_00to11_59_admiss_n" VARCHAR,
  "wednesday_12_00to13_59_admiss_n" VARCHAR,
  "wednesday_14_00to15_59_admiss_n" VARCHAR,
  "wednesday_16_00to17_59_admiss_n" VARCHAR,
  "wednesday_18_00to19_59_admiss_n" VARCHAR,
  "wednesday_20_00to21_59_admiss_n" VARCHAR,
  "wednesday_22_00to23_59_admiss_n" VARCHAR,
  "thursday_0_00to1_59_admiss_n" VARCHAR,
  "thursday_2_00to3_59_admiss_n" VARCHAR,
  "thursday_4_00to5_59_admiss_n" VARCHAR,
  "thursday_6_00to7_59_admiss_n" VARCHAR,
  "thursday_8_00to9_59_admiss_n" VARCHAR
);

Table 2

@ukgov.national_asthma_and_copd_audit_programme_nacap_adult_a_ffb8272e.table_2
  • 658.06 KB
  • 178 rows
  • 595 columns
Loading... 

CREATE TABLE table_2 (
  "hosp_code" VARCHAR,
  "hosp_name" VARCHAR,
  "trust_code" VARCHAR,
  "trust_name" VARCHAR,
  "record_n" VARCHAR,
  "country1" VARCHAR,
  "age_n" VARCHAR,
  "age_median" DOUBLE,
  "age_lo_quart" DOUBLE,
  "age_hi_quart" DOUBLE,
  "gender_n" VARCHAR,
  "gender_male_n" VARCHAR,
  "gender_male_perc" VARCHAR,
  "gender_female_n" VARCHAR,
  "gender_female_perc" VARCHAR,
  "gender_transgender_n" VARCHAR,
  "gender_transgender_perc" VARCHAR,
  "gender_other_n" DOUBLE,
  "gender_other_perc" DOUBLE,
  "gender_not_recorded_n" DOUBLE,
  "gender_not_recorded_perc" DOUBLE,
  "imd_quintile_eng_n" VARCHAR,
  "imd_quintile_eng_1_n" VARCHAR,
  "imd_quintile_eng_1_perc" VARCHAR,
  "imd_quintile_eng_2_n" VARCHAR,
  "imd_quintile_eng_2_perc" VARCHAR,
  "imd_quintile_eng_3_n" VARCHAR,
  "imd_quintile_eng_3_perc" VARCHAR,
  "imd_quintile_eng_4_n" VARCHAR,
  "imd_quintile_eng_4_perc" VARCHAR,
  "imd_quintile_eng_5_n" VARCHAR,
  "imd_quintile_eng_5_perc" VARCHAR,
  "imd_quintile_scot_n" VARCHAR,
  "imd_quintile_scot_1_n" VARCHAR,
  "imd_quintile_scot_1_perc" VARCHAR,
  "imd_quintile_scot_2_n" VARCHAR,
  "imd_quintile_scot_2_perc" VARCHAR,
  "imd_quintile_scot_3_n" VARCHAR,
  "imd_quintile_scot_3_perc" VARCHAR,
  "imd_quintile_scot_4_n" VARCHAR,
  "imd_quintile_scot_4_perc" VARCHAR,
  "imd_quintile_scot_5_n" VARCHAR,
  "imd_quintile_scot_5_perc" VARCHAR,
  "imd_quintile_wal_n" VARCHAR,
  "imd_quintile_wal_1_n" VARCHAR,
  "imd_quintile_wal_1_perc" VARCHAR,
  "imd_quintile_wal_2_n" VARCHAR,
  "imd_quintile_wal_2_perc" VARCHAR,
  "imd_quintile_wal_3_n" VARCHAR,
  "imd_quintile_wal_3_perc" VARCHAR,
  "imd_quintile_wal_4_n" VARCHAR,
  "imd_quintile_wal_4_perc" VARCHAR,
  "imd_quintile_wal_5_n" VARCHAR,
  "imd_quintile_wal_5_perc" VARCHAR,
  "anyimd_n" VARCHAR,
  "anyimd_imd_present_n" VARCHAR,
  "anyimd_imd_present_perc" VARCHAR,
  "anyimd_no_imd_n" VARCHAR,
  "anyimd_no_imd_perc" VARCHAR,
  "monday_0_00to1_59_admiss_n" VARCHAR,
  "monday_2_00to3_59_admiss_n" VARCHAR,
  "monday_4_00to5_59_admiss_n" VARCHAR,
  "monday_6_00to7_59_admiss_n" VARCHAR,
  "monday_8_00to9_59_admiss_n" VARCHAR,
  "monday_10_00to11_59_admiss_n" VARCHAR,
  "monday_12_00to13_59_admiss_n" VARCHAR,
  "monday_14_00to15_59_admiss_n" VARCHAR,
  "monday_16_00to17_59_admiss_n" VARCHAR,
  "monday_18_00to19_59_admiss_n" VARCHAR,
  "monday_20_00to21_59_admiss_n" VARCHAR,
  "monday_22_00to23_59_admiss_n" VARCHAR,
  "tuesday_0_00to1_59_admiss_n" VARCHAR,
  "tuesday_2_00to3_59_admiss_n" VARCHAR,
  "tuesday_4_00to5_59_admiss_n" VARCHAR,
  "tuesday_6_00to7_59_admiss_n" VARCHAR,
  "tuesday_8_00to9_59_admiss_n" VARCHAR,
  "tuesday_10_00to11_59_admiss_n" VARCHAR,
  "tuesday_12_00to13_59_admiss_n" VARCHAR,
  "tuesday_14_00to15_59_admiss_n" VARCHAR,
  "tuesday_16_00to17_59_admiss_n" VARCHAR,
  "tuesday_18_00to19_59_admiss_n" VARCHAR,
  "tuesday_20_00to21_59_admiss_n" VARCHAR,
  "tuesday_22_00to23_59_admiss_n" VARCHAR,
  "wednesday_0_00to1_59_admiss_n" VARCHAR,
  "wednesday_2_00to3_59_admiss_n" VARCHAR,
  "wednesday_4_00to5_59_admiss_n" VARCHAR,
  "wednesday_6_00to7_59_admiss_n" VARCHAR,
  "wednesday_8_00to9_59_admiss_n" VARCHAR,
  "wednesday_10_00to11_59_admiss_n" VARCHAR,
  "wednesday_12_00to13_59_admiss_n" VARCHAR,
  "wednesday_14_00to15_59_admiss_n" VARCHAR,
  "wednesday_16_00to17_59_admiss_n" VARCHAR,
  "wednesday_18_00to19_59_admiss_n" VARCHAR,
  "wednesday_20_00to21_59_admiss_n" VARCHAR,
  "wednesday_22_00to23_59_admiss_n" VARCHAR,
  "thursday_0_00to1_59_admiss_n" VARCHAR,
  "thursday_2_00to3_59_admiss_n" VARCHAR,
  "thursday_4_00to5_59_admiss_n" VARCHAR,
  "thursday_6_00to7_59_admiss_n" VARCHAR,
  "thursday_8_00to9_59_admiss_n" VARCHAR
);

Share link

Anyone who has the link will be able to view this.