About this Dataset

National COPD Audit Programme Secondary Care Clinical Audit 2017

This presents the data from the National Chronic Obstructive Pulmonary Disease (COPD) Audit Programme’s secondary care clinical audit 2017. The continuous audit, which captures the process and clinical outcomes of treatment in patients admitted to hospital in England and Wales with COPD exacerbations, launched on 1 February 2017. This is the first report post launch of continuous data collection, which presents the results of the cohort of patients discharged between the audit’s launch date and 13 September 2017. In his transparency and open data letter to Cabinet Ministers on 7 July 2011, the Prime Minister restated the commitment to make audit data available from the national audits within the National Clinical Audit and Patient Outcomes Programme. The National COPD Audit Programme have made their data available for this purpose.
Publisher name: Healthcare Quality Improvement Partnership
Last updated: 2024-09-14T22:39:38Z

Tables

National COPD Audit Programme Secondary Care Clinical Audit 2017

@ukgov.national_copd_audit_programme_secondary_care_clinical__d5c0fa60.national_copd_audit_programme_secondary_care_clinical__d5c0fa60

264.86 KB
182 rows
231 columns


CREATE TABLE national_copd_audit_programme_secondary_care_clinical__d5c0fa60 (
  "hospitalname" VARCHAR,
  "trust" VARCHAR,
  "gendernumerator1" VARCHAR,
  "gendernumpc1" VARCHAR,
  "gendernumerator2" VARCHAR,
  "gendernumpc2" VARCHAR,
  "genderdenominator" VARCHAR,
  "age_n" VARCHAR,
  "age_mean" VARCHAR,
  "age_sd" VARCHAR,
  "age_median" VARCHAR,
  "age_lq" VARCHAR,
  "age_uq" VARCHAR,
  "imdnumerator1" VARCHAR,
  "imdnumpc1" VARCHAR,
  "imdnumerator2" VARCHAR,
  "imdnumpc2" VARCHAR,
  "imdnumerator3" VARCHAR,
  "imdnumpc3" VARCHAR,
  "imdnumerator4" VARCHAR,
  "imdnumpc4" VARCHAR,
  "imdnumerator5" VARCHAR,
  "imdnumpc5" VARCHAR,
  "imddenominator" VARCHAR,
  "wimdnumerator1" VARCHAR,
  "wimdnumpc1" VARCHAR,
  "wimdnumerator2" VARCHAR,
  "wimdnumpc2" VARCHAR,
  "wimdnumerator3" VARCHAR,
  "wimdnumpc3" VARCHAR,
  "wimdnumerator4" VARCHAR,
  "wimdnumpc4" VARCHAR,
  "wimdnumerator5" VARCHAR,
  "wimdnumpc5" VARCHAR,
  "wimddenominator" VARCHAR,
  "hospadmissions_n" VARCHAR,
  "hospadmissions_mean" VARCHAR,
  "hospadmissions_sd" VARCHAR,
  "hospadmissions_median" VARCHAR,
  "hospadmissions_lq" VARCHAR,
  "hospadmissions_uq" VARCHAR,
  "admitdaynumerator1" VARCHAR,
  "admitdaynumerator2" VARCHAR,
  "admitdaynumerator3" VARCHAR,
  "admitdaynumerator4" VARCHAR,
  "admitdaynumerator5" VARCHAR,
  "admitdaynumerator6" VARCHAR,
  "admitdaynumerator7" VARCHAR,
  "admitdaydenominator" VARCHAR,
  "admitwaithours_n" VARCHAR,
  "admitwaithours_mean" VARCHAR,
  "admitwaithours_sd" VARCHAR,
  "admitwaithours_median" VARCHAR,
  "admitwaithours_lq" VARCHAR,
  "admitwaithours_uq" VARCHAR,
  "physrevnumerator0" VARCHAR,
  "physrevnumpc0" VARCHAR,
  "physrevnumerator1" VARCHAR,
  "physrevnumpc1" VARCHAR,
  "physrevnumerator2" VARCHAR,
  "physrevnumpc2" VARCHAR,
  "physrevdenominator" VARCHAR,
  "resprevnumerator" VARCHAR,
  "resprevnumpc" VARCHAR,
  "resprevdenominator" VARCHAR,
  "reviewwaithours_mean" VARCHAR,
  "reviewwaithours_sd" VARCHAR,
  "reviewwaithours_median" VARCHAR,
  "reviewwaithours_lq" VARCHAR,
  "reviewwaithours_uq" VARCHAR,
  "specrevnumerator" VARCHAR,
  "specrevnumpc" VARCHAR,
  "specrevdenominator" VARCHAR,
  "specrevdaynumerator1" VARCHAR,
  "specrevdaynumerator2" VARCHAR,
  "specrevdaynumerator3" VARCHAR,
  "specrevdaynumerator4" VARCHAR,
  "specrevdaynumerator5" VARCHAR,
  "specrevdaynumerator6" VARCHAR,
  "specrevdaynumerator7" VARCHAR,
  "specrevdaydenominator" VARCHAR,
  "decafnumerator0" VARCHAR,
  "decafnumpc0" VARCHAR,
  "decafnumerator1" VARCHAR,
  "decafnumpc1" VARCHAR,
  "decafnumerator2" VARCHAR,
  "decafnumpc2" VARCHAR,
  "decafdenominator" VARCHAR,
  "decafscorenumerator0" VARCHAR,
  "decafscorenumpc0" VARCHAR,
  "decafscorenumerator1" VARCHAR,
  "decafscorenumpc1" VARCHAR,
  "decafscorenumerator2" VARCHAR,
  "decafscorenumpc2" VARCHAR,
  "decafscorenumerator3" VARCHAR,
  "decafscorenumpc3" VARCHAR,
  "decafscorenumerator4" VARCHAR,
  "decafscorenumpc4" VARCHAR,
  "decafscorenumerator5" VARCHAR,
  "decafscorenumpc5" VARCHAR
);