Back to dataset

National COPD Audit Programme secondary care clinical audit 2017COPD secondary care clinical audit 2017 - Data description file

You're previewing the first 4 rows of this file.

Download this file
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8 Column 9 Column 10 Column 11 Column 12 Column 13 Column 14 Column 15 Column 16 Column 17 Column 18 Column 19 Column 20 Column 21 Column 22 Column 23 Column 24 Column 25 Column 26 Column 27 Column 28 Column 29 Column 30 Column 31 Column 32 Column 33 Column 34 Column 35 Column 36 Column 37 Column 38 Column 39 Column 40 Column 41 Column 42 Column 43 Column 44 Column 45 Column 46 Column 47 Column 48 Column 49 Column 50 Column 51 Column 52 Column 53 Column 54 Column 55 Column 56 Column 57 Column 58 Column 59 Column 60 Column 61 Column 62 Column 63 Column 64 Column 65 Column 66 Column 67 Column 68 Column 69 Column 70 Column 71 Column 72 Column 73 Column 74 Column 75 Column 76 Column 77 Column 78 Column 79 Column 80 Column 81 Column 82 Column 83 Column 84 Column 85 Column 86 Column 87 Column 88 Column 89 Column 90 Column 91 Column 92 Column 93 Column 94 Column 95 Column 96 Column 97 Column 98 Column 99 Column 100 Column 101 Column 102 Column 103 Column 104 Column 105 Column 106 Column 107 Column 108 Column 109 Column 110 Column 111 Column 112 Column 113 Column 114 Column 115 Column 116 Column 117 Column 118 Column 119 Column 120 Column 121 Column 122 Column 123 Column 124 Column 125 Column 126 Column 127 Column 128 Column 129 Column 130 Column 131 Column 132 Column 133 Column 134 Column 135 Column 136 Column 137 Column 138 Column 139 Column 140 Column 141 Column 142 Column 143 Column 144 Column 145 Column 146 Column 147 Column 148 Column 149 Column 150 Column 151 Column 152 Column 153 Column 154 Column 155 Column 156 Column 157 Column 158 Column 159 Column 160 Column 161 Column 162 Column 163 Column 164 Column 165 Column 166 Column 167 Column 168 Column 169 Column 170 Column 171 Column 172 Column 173 Column 174 Column 175 Column 176 Column 177 Column 178 Column 179 Column 180 Column 181 Column 182 Column 183 Column 184 Column 185 Column 186 Column 187 Column 188 Column 189 Column 190 Column 191 Column 192 Column 193 Column 194 Column 195 Column 196 Column 197 Column 198 Column 199 Column 200 Column 201 Column 202 Column 203 Column 204 Column 205 Column 206 Column 207 Column 208 Column 209 Column 210 Column 211 Column 212 Column 213 Column 214 Column 215 Column 216 Column 217 Column 218 Column 219 Column 220 Column 221 Column 222 Column 223 Column 224 Column 225 Column 226 Column 227 Column 228 Column 229 Column 230 Column 231
hospitalName Trust gendernumerator1 gendernumpc1 gendernumerator2 gendernumpc2 genderdenominator age_N age_mean age_sd age_median age_lq age_uq imdnumerator1 imdnumpc1 imdnumerator2 imdnumpc2 imdnumerator3 imdnumpc3 imdnumerator4 imdnumpc4 imdnumerator5 imdnumpc5 imddenominator wimdnumerator1 wimdnumpc1 wimdnumerator2 wimdnumpc2 wimdnumerator3 wimdnumpc3 wimdnumerator4 wimdnumpc4 wimdnumerator5 wimdnumpc5 wimddenominator hospadmissions_N hospadmissions_mean hospadmissions_sd hospadmissions_median hospadmissions_lq hospadmissions_uq admitdaynumerator1 admitdaynumerator2 admitdaynumerator3 admitdaynumerator4 admitdaynumerator5 admitdaynumerator6 admitdaynumerator7 admitdaydenominator admitwaithours_N admitwaithours_mean admitwaithours_sd admitwaithours_median admitwaithours_lq admitwaithours_uq physrevnumerator0 physrevnumpc0 physrevnumerator1 physrevnumpc1 physrevnumerator2 physrevnumpc2 physrevdenominator resprevnumerator resprevnumpc resprevdenominator reviewwaithours_mean reviewwaithours_sd reviewwaithours_median reviewwaithours_lq reviewwaithours_uq specrevnumerator specrevnumpc specrevdenominator specrevdaynumerator1 specrevdaynumerator2 specrevdaynumerator3 specrevdaynumerator4 specrevdaynumerator5 specrevdaynumerator6 specrevdaynumerator7 specrevdaydenominator decafnumerator0 decafnumpc0 decafnumerator1 decafnumpc1 decafnumerator2 decafnumpc2 decafdenominator decafscorenumerator0 decafscorenumpc0 decafscorenumerator1 decafscorenumpc1 decafscorenumerator2 decafscorenumpc2 decafscorenumerator3 decafscorenumpc3 decafscorenumerator4 decafscorenumpc4 decafscorenumerator5 decafscorenumpc5 decafscorenumerator6 decafscorenumpc6 decafscoredenominator o2numerator0 o2numpc0 o2numerator1 o2numpc1 o2numerator2 o2numpc2 o2denominator o2targnumerator1 o2targnumpc1 o2targnumerator2 o2targnumpc2 o2targnumerator3 o2targnumpc3 o2targnumerator4 o2targnumpc4 o2targdenominator nivnumerator nivnumpc nivdenominator nivwaithours_N nivwaithours_mean nivwaithours_sd nivwaithours_median nivwaithours_lq nivwaithours_uq niv3hrsnumerator0 niv3hrsnumpc0 niv3hrsnumerator1 niv3hrsnumpc1 niv3hrsnumerator2 niv3hrsnumpc2 niv3hrsdenominator spirnumerator spirnumpc spirdenominator q72fev1_N q72fev1_mean q72fev1_sd q72fev1_median q72fev1_lq q72fev1_uq obsnumerator0 obsnumpc0 obsnumerator1 obsnumpc1 obsnumerator2 obsnumpc2 obsdenominator smoknumerator1 smoknumpc1 smoknumerator2 smoknumpc2 smoknumerator3 smoknumpc3 smoknumerator4 smoknumpc4 smokdenominator smokcessnumerator0 smokcessnumpc0 smokcessnumerator1 smokcessnumpc1 smokcessnumerator2 smokcessnumpc2 smokcessnumerator3 smokcessnumpc3 smokcessdenominator disdaynumerator1 disdaynumpc1 disdaynumerator2 disdaynumpc2 disdaynumerator3 disdaynumpc3 disdaynumerator4 disdaynumpc4 disdaynumerator5 disdaynumpc5 disdaynumerator6 disdaynumpc6 disdaynumerator7 disdaynumpc7 disdaydenominator lengthofstay_N lengthofstay_mean lengthofstay_sd lengthofstay_median lengthofstay_lq lengthofstay_uq diednumerator diednumpc dieddenominator bundlenumerator0 bundlenumpc0 bundlenumerator1 bundlenumpc1 bundlenumerator2 bundlenumpc2 bundlenumerator3 bundlenumpc3 bundlenumerator4 bundlenumpc4 bundlenumerator5 bundlenumpc5 bundledenominator q94nonumerator q94nonumpc q94denominator q94assteamnumerator q94assteamnumpc q94gpfuadvisednumerator q94gpfuadvisednumpc q94gpfuarrangednumerator q94gpfuarrangednumpc q94phonenumerator q94phonenumpc q94commadvisednumerator q94commadvisednumpc q94commarrangednumerator q94commarrangednumpc q94hospadvisednumerator q94hospadvisednumpc q94hosparrangednumerator q94hosparrangednumpc q94otherhealthcarenumerator q94otherhealthcarenumpc q94eolnumerator q94eolnumpc q94othernumerator q94othernumpc
Hospital name Trust name Number of men Percentage of men Number of women Percentage of women Number of patients with a gender recorded Number of patients with an age recorded The mean age Standard deviation of the mean age The median age The age lower quartile The age upper quartile Number of patients in quintile one of English IMD (most deprived) Percentage of patients in first quintile English IMD Number of patients in quintile two of English IMD Percentage of patients in second quintile English IMD Number of patients in quintile three of English IMD Percentage of patients in third quintile English IMD Number of patients in quintile four of English IMD Percentage of patients in fourth quintile English IMD Number of patients in quintile five of English IMD (least deprived) Percentage of patients in fifth quintile English IMD Number of patients with an English IMD rank Number of patients in quintile one of Welsh IMD (most deprived) Percentage in first quintile Welsh IMD Number of patients in quintile two of Welsh IMD Percentage in second quintile Welsh IMD Number of patients in quintile three of Welsh IMD Percentage in third quintile Welsh IMD Number of patients in quintile four of Welsh IMD Percentage in fourth quintile Welsh IMD Number of patients in quintile five of Welsh IMD (least deprived) Percentage in fifth quintile Welsh IMD Number of patients with an Welsh IMD rank Number of hospital admissions Mean Number of hospital admissions Standard deviation of the mean Number of hospital admissions Median Number of hospital admissions Lower quartile of number of hospital admissions Upper quartile of number of hospital admissions Number of patients admitted on Sunday Number of patients admitted on Monday Number of patients admitted on Tuesday Number of patients admitted on Wednesday Number of patients admitted on Thursday Number of patients admitted on Friday Number of patients admitted on Saturday Number of patients with an admission day record Number of patients with an arrival and admission time recorded Mean wait (in hours) from arrival to admission Standard deviation of the mean wait from arrival to admission Median wait from arrival to admission Lower quartile of wait from arrival to admission Upper quartile of wait from arrival to admission Number of patients not reviewed by an acute physician of grade ST3 or above Percentage of patients not reviewed by an acute physician of grade ST3 or above Number of patients reviewed by an acute physician of grade ST3 or above Percentage of patients reviewed by an acute physician of grade ST3 or above Number of patients where it was not recorded whether they were reviewed by an acute physician of grade ST3 or above Percentage of patients where it was not recorded whether they were reviewed by an acute physician of grade ST3 or above Number of patients where a response was recorded to whether the patient had been reviewed by an acute physician of grade ST3 or above Number of patients reviewed by a member of the respiratory team during the admission Percentage of patients reviewed by a member of the respiratory team during the admission Number of patients with a response recorded for reviewed by a member of the respiratory team during the admission Mean wait (in hours) from admission to specialist review Standard deviation of mean wait from admission to specialist review Median wait from admission to specialist review Lower quartile of wait from admission to specialist review Upper quartile of wait from admission to specialist review Number of patients who have had a specialist review within 24 hours of admission Percentage of patients who have had a specialist review within 24 hours of admission All patients Number of patients who had a specialist review on Sunday Number of patients who had a specialist review on Monday Number of patients who had a specialist review on Tuesday Number of patients who had a specialist review on Wednesday Number of patients who had a specialist review on Thursday Number of patients who had a specialist review on Friday Number of patients who had a specialist review on Saturday Number of patients who have had a respiratory specialist review Number of patients with no DECAF score Percentage of patients with no DECAF score Number of patients with a DECAF score Percentage of patients with a DECAF score Number of patients where it was not clear if there was a DECAF score Percentage of patients where it was not clear if there was a DECAF score All patients Number of patients with a DECAF score of zero Percentage of patients with a DECAF score of zero Number of patients with a DECAF score of one Percentage of patients with a DECAF score of one Number of patients with a DECAF score of two Percentage of patients with a DECAF score of two Number of patients with a DECAF score of three Percentage of patients with a DECAF score of three Number of patients with a DECAF score of four Percentage of patients with a DECAF score of four Number of patients with a DECAF score of five Percentage of patients with a DECAF score of five Number of patients with a DECAF score of six Percentage of patients with a DECAF score of six Number of patients with a DECAF score Number of patients with no oxygen prescribed Percentage of patients with no oxygen prescribed Number of patients with oxygen prescribed Percentage of patients with oxygen prescribed Number of patients where supplemental oxygen was not required Percentage of patients where supplemental oxygen was not required All patients Number of patients where oxygen was prescribed to 88-92% target range Percentage of patients where oxygen was prescribed to 88-92% target range Number of patients where oxygen was prescribed to 84-98% target range Percentage of patients where oxygen was prescribed to 84-98% target range Number of patients where oxygen was prescribed to other target range Percentage of patients where oxygen was prescribed to other target range Number of patients where oxygen target range was not stiplulated Percentage of patients where oxygen target range was not stiplulated Number of patients prescribed oxygen Number of patients that received acute treatment with NIV Percentage of patients that received acute treatment with NIV All patients Number of patients with an NIV time recorded Mean wait (in hours) for acute treatment with NIV Standard deviation of mean wait (in hours) for acute treatment with NIV Median mean wait (in hours) for acute treatment with NIV Lower quartile of wait (in hours) for acute treatment with NIV Upper quartile of wait (in hours) for acute treatment with NIV Number of patients that did not receive acute threatment with NIV within three hours of arrival Percentage of patients that did not receive acute threatment with NIV within three hours of arrival Number of patients that received acute threatment with NIV within three hours of arrival Percentage of patients that received acute threatment with NIV within three hours of arrival Number of patients where no time and/or date was recorded for acute treatment with NIV Percentage of patients where no time and/or date was recorded for acute treatment with NIV Number of patients receiving NIV Number of patients with a spirometry result available Percentage of patients with a spirometry result available All patients Number of patients with a spirometry result available Mean of patients most recent FEV1 standard deviation of mean of patients most recent FEV1 Median of patients most recent FEV1 Lower quartile of patients most recent FEV1 Upper quartile of patients most recent FEV1 Number of patients with no airflow obstruction Percentage of patients with no airflow obstruction Number of patients with airflow obstruction Percentage of patients with airflow obstruction Number of patients with airflow obstruction invalid ratio Percentage of patients with airflow obstruction invalid ratio Number of patients with a spirometry result available Number of patients with smoking status never smoked Percentage of patients with smoking status never smoked Number of patients with smoking status ex-smoker Percentage of patients with smoking status ex-smoker Number of patients with smoking status current smoker Percentage of patients with smoking status current smoker Number of patients with smoking status not known and or not recorded Percentage of patients with smoking status not known and or not recorded All patients Number of patients not prescribed smoking-cessation pharmocotherapy during the admission Percentage of patients not prescribed smoking-cessation pharmocotherapy during the admission Number of patients prescribed smoking-cessation pharmocotherapy during the admission Percentage of patients prescribed smoking-cessation pharmocotherapy during the admission Number of patients with no record of the offer of smoking cessation pharmacotherapy Percentage of patients with no record of the offer of smoking cessation pharmacotherapy Number of patients where smoking cessation pharmacotherapy was offered during the admission but it was declined Percentage of patients where smoking cessation pharmacotherapy was offered during the admission but it was declined Number of patients that are current smokers Number of patients with discharge day Sunday Percentage of patients with discharge day Sunday Number of patients with discharge day Monday Percentage of patients with discharge day Monday Number of patients with discharge day Tuesday Percentage of patients with discharge day Tuesday Number of patients with discharge day Wednesday Percentage of patients with discharge day Wednesday Number of patients with discharge day Thursday Percentage of patients with discharge day Thursday Number of patients with discharge day Friday Percentage of patients with discharge day Friday Number of patients with discharge day Saturday Percentage of patients with discharge day Saturday All patients All patients Mean length of stay Standard deviation of mean length of stay Median length of stay Lower quartile length of stay Upper quartile length of stay Number of patients that died as an inpatient Percentage of patients that died as an inpatient All patients Number of patients that did not have a discharge bundle completed for their admission Percentage of patients that did not have a discharge bundle completed for their admission Number of patients that had a discharge bundle completed for their admission Percentage of patients that had a discharge bundle completed for their admission Number of patients where it was not clear if a discharge bundle was completed for their admission Percentage of patients where it was not clear if a discharge bundle was completed for their admission Number of patients that self-discharged Percentage of patients that self-discharged Number of patients that died as an inpatient Percentage of patients that died as an inpatient Number of patients that had other reason for discharge bundle completion Percentage of patients that had other reason for discharge bundle completion All patients Number of patients where no follow-up arrangements were apparent Percentage of patients where no follow-up arrangements were apparent All discharged patients Number of patients discharged under the care of an early/assisted discharge team or integrated care service Percentage of patients discharged under the care of an early/assisted discharge team or integrated care service Number of patients where GP follow-up advised Percentage of patients where GP follow-up advised Number of patients where GP follow-up arranged Percentage of patients where GP follow-up arranged Number of patients where follow-up phone call scheduled Percentage of patients where follow-up phone call scheduled Number of patients where community respiratory clinic follow-up advised Percentage of patients where community respiratory clinic follow-up advised Number of patients where community respiratory clinic follow-up arranged Percentage of patients where community respiratory clinic follow-up arranged Number of patients where hospital respiratory clinic follow-up advised Percentage of patients where hospital respiratory clinic follow-up advised Number of patients where hospital respiratory clinic follow-up arranged Percentage of patients where hospital respiratory clinic follow-up arranged Number of patients where no follow-up arranged as discharged to other healthcare facility Percentage of patients where no follow-up arranged as discharged to other healthcare facility Number of patients discharged for end-of-life care Percentage of patients discharged for end-of-life care Number of patients with other follow-up arrangements Percentage of patients with other follow-up arrangements
text text integer percentage integer percentage integer integer integer integer integer integer integer integer percentage integer percentage integer percentage integer percentage integer percentage integer integer percentage integer percentage integer percentage integer percentage integer percentage integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer integer percentage integer percentage integer percentage Integer Integer percentage Integer Integer Integer Integer Integer Integer Integer Percentage Integer Integer Integer Integer Integer Integer Integer Integer Integer Integer Percentage Integer Percentage Integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Integer Percentage Integer Integer Integer Integer Integer Integer Integer Integer Percentage Integer Percentage integer Percentage integer integer Percentage integer integer integer integer integer integer integer integer Percentage integer Percentage integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Integer Integer Integer Integer Integer Integer Integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Integer Percentage Integer Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage Integer Percentage
text text 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0 0 0 0 0 0 0.0% 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0 0 0 0 0 0 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0 0 0 0 0 0 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0.0% 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%