Back to dataset

National Asthma and COPD Audit Programme (NACAP) - COPD Secondary Care Clinical Audit 2017/18COPD secondary care clinical audit 2017-18 - Data file

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

hospital.name	trust.name	cases_n	age_n	age_med	age_lo.Q	age_hi.Q	gen_N	gen_Mal_n	gen_Mal_p	gen_Fem_n	gen_Fem_p	2017_gen_N	IMD.q.eng_N	IMD.q.eng_1_n	IMD.q.eng_1_p	IMD.q.eng_2_n	IMD.q.eng_2_p	IMD.q.eng_3_n	IMD.q.eng_3_p	IMD.q.eng_4_n	IMD.q.eng_4_p	IMD.q.eng_5_n	IMD.q.eng_5_p	WIMD.q.wal_N	WIMD.q.wal_1_n	WIMD.q.wal_1_p	WIMD.q.wal_2_n	WIMD.q.wal_2_p	WIMD.q.wal_3_n	WIMD.q.wal_3_p	WIMD.q.wal_4_n	WIMD.q.wal_4_p	WIMD.q.wal_5_n	WIMD.q.wal_5_p	mal_age_n	mal_age_med	mal_age_lo.q	mal_age_hi.q	fem_age_n	fem_age_med	fem_age_lo.q	fem_age_hi.q	admitwaithours_n	admitwaithours_med	admitwaithours_lo.q	admitwaithours_hi.q	Los_n	Los_med	Los_lo.quart	Los_hi.quart	died_N	died_Yes_n	died_Yes_p	Aphysrev_N	Aphysrev_Yes_n	Aphysrev_Yes_p	Resprev_N	Resprev_Yes_n	Resprev_Yes_p	Resprev24hrs_N	Resprev24hrs_Yes_n	Resprev24hrs_Yes_p	Resprevhours_n	Resprevhours_med	Resprevhours_lo.q	Resprevhours_hi.q	o2req_N	o2_req_Pres_n	o2_req_Pres_p	o2targ_N	o2targ_88-92%_n	o2targ_88-92%_p	o2targ_94-98%_n	o2targ_94-98%_p	o2targ_Other_n	o2targ_Other_p	o2targ_not_stipulated_n	o2targ_not_stipulated_p	nivwithin2hrs_N	nivwithin2hrs_No_n	nivwithin2hrs_No_perc	nivwithin2hrs_Yes_n	nivwithin2hrs_Yes_perc	nivwithin2hrs_No_time_recorded_n	nivwithin2hrs_No_time_recorded_perc	nivtime_N	nivtime_<2_Hours_n	nivtime_<2_Hours_perc	nivtime_2-24_Hours_n	nivtime_2-24_Hours_perc	nivtime_>24_Hours_n	nivtime_>24_Hours_perc	nivwaithours_n	nivwaithours_median	nivwaithours_lo.quart	nivwaithours_hi.quart	q71spir_N	q71spir_No_n	q71spir_No_perc	q71spir_Yes_n	q71spir_Yes_perc	obstruct_N	obstruct_Invalid_ratio(<0.2or>1)_n	obstruct_Invalid_ratio(<0.2or>1)_perc	obstruct_No(>=0.7)_n	obstruct_No(>=0.7)_perc	obstruct_Yes(<0.7)_n	obstruct_Yes(<0.7)_perc	q72fev1_n	q72fev1_median	q72fev1_lo.quart	q72fev1_hi.quart	q81smokstatus_N	q81smokstatus_Never_smoked_n	q81smokstatus_Never_smoked_perc	q81smokstatus_Ex-smoker_n	q81smokstatus_Ex-smoker_perc	q81smokstatus_Current_smoker_n	q81smokstatus_Current_smoker_perc	q81smokstatus_Not_recorded_n	q81smokstatus_Not_recorded_perc	q82smokcess_N	q82smokcess_No_n	q82smokcess_No_perc	q82smokcess_Yes_n	q82smokcess_Yes_perc	q82smokcess_Not_recorded_n	q82smokcess_Not_recorded_perc	q82smokcess_Offered_but_declined_n	q82smokcess_Offered_but_declined_perc	q41decafrec_N	q41decafrec_No_n	q41decafrec_No_perc	q41decafrec_Yes_n	q41decafrec_Yes_perc	q41decafrec_Not_clear_n	q41decafrec_Not_clear_perc	q42decaf_N	q42decaf_0_n	q42decaf_0_perc	q42decaf_1_n	q42decaf_1_perc	q42decaf_2_n	q42decaf_2_perc	q42decaf_3_n	q42decaf_3_perc	q42decaf_4_n	q42decaf_4_perc	q42decaf_5_n	q42decaf_5_perc	q42decaf_6_n	q42decaf_6_perc	discharge_day_N	discharge_day_Monday_n	discharge_day_Monday_perc	discharge_day_Tuesday_n	discharge_day_Tuesday_perc	discharge_day_Wednesday_n	discharge_day_Wednesday_perc	discharge_day_Thursday_n	discharge_day_Thursday_perc	discharge_day_Friday_n	discharge_day_Friday_perc	discharge_day_Saturday_n	discharge_day_Saturday_perc	discharge_day_Sunday_n	discharge_day_Sunday_perc	q93bts_N	q93bts_No_n	q93bts_No_perc	q93bts_Yes_n	q93bts_Yes_perc	q93bts_Not_clear_n	q93bts_Not_clear_perc	q93bts_Patient_self_discharged_n	q93bts_Patient_self_discharged_perc	q93bts_Patient_died_n	q93bts_Patient_died_perc	q93bts_Other_n	q93bts_Other_perc	anyarrangementsapparent_N	anyarrangementsapparent_No_n	anyarrangementsapparent_No_perc	anyarrangementsapparent_Yes_n	anyarrangementsapparent_Yes_perc	q94assteam_N	q94assteam_No_n	q94assteam_No_perc	q94assteam_Yes_n	q94assteam_Yes_perc	q94gpfuadvised_N	q94gpfuadvised_No_n	q94gpfuadvised_No_perc	q94gpfuadvised_Yes_n	q94gpfuadvised_Yes_perc	q94gpfuarranged_N	q94gpfuarranged_No_n	q94gpfuarranged_No_perc	q94gpfuarranged_Yes_n	q94gpfuarranged_Yes_perc	q94phone_N	q94phone_No_n	q94phone_No_perc	q94phone_Yes_n	q94phone_Yes_perc	q94commadvised_N	q94commadvised_No_n	q94commadvised_No_perc	q94commadvised_Yes_n	q94commadvised_Yes_perc	q94commarranged_N	q94commarranged_No_n	q94commarranged_No_perc	q94commarranged_Yes_n	q94commarranged_Yes_perc	q94hospadvised_N	q94hospadvised_No_n	q94hospadvised_No_perc	q94hospadvised_Yes_n	q94hospadvised_Yes_perc	q94hosparranged_N	q94hosparranged_No_n	q94hosparranged_No_perc	q94hosparranged_Yes_n	q94hosparranged_Yes_perc	q94otherhealthcare_N	q94otherhealthcare_No_n	q94otherhealthcare_No_perc	q94otherhealthcare_Yes_n	q94otherhealthcare_Yes_perc	q94eol_N	q94eol_No_n	q94eol_No_perc	q94eol_Yes_n	q94eol_Yes_perc	q94other_N	q94other_No_n	q94other_No_perc	q94other_Yes_n	q94other_Yes_perc
All	All	74645	74645	73	65	79	74645	34850	46.7	39795	53.3	Not set	71177	24351	34.2	16560	23.3	12682	17.8	10194	14.3	7390	10.4	2704	1043	38.6	689	25.5	455	16.8	278	10.3	239	8.8	34850	73	66	79	39795	73	65	80	74645	3.9	1.9	6.2	71799	4	2	7	74645	2846	3.8	74645	64347	86.2	74645	63229	84.7	74645	47761	64	63229	15.0	6.3	23.8	59379	42736	72	42736	36359	85.1	3678	8.6	1551	3.6	1148	2.7	7690	4414	57.4	1618	21	1658	21.6	6032	1618	26.8	3451	57.2	963	16	6032	4.6	1.8	13.4	74636	44443	59.5	30193	40.5	30193	467	1.5	3639	12.1	26087	86.4	30193	0.9	0.7	1.3	74645	2229	3	43846	58.7	24124	32.3	4446	6	24124	3221	13.4	6194	25.7	4715	19.5	9994	41.4	74636	59661	79.9	13072	17.5	1903	2.5	13072	2675	20.5	4441	34	3626	27.7	1737	13.3	496	3.8	91	0.7	6	0	71799	11349	15.8	12712	17.7	12382	17.2	11790	16.4	13016	18.1	5931	8.3	4619	6.4	74645	17550	23.5	50184	67.2	2848	3.8	390	0.5	2846	3.8	827	1.1	71790	11733	16.3	60057	83.7	71790	59348	82.7	12442	17.3	71790	59092	82.3	12698	17.7	71790	70069	97.6	1721	2.4	71790	65182	90.8	6608	9.2	71790	66909	93.2	4881	6.8	71790	60005	83.6	11785	16.4	71790	68094	94.9	3696	5.1	71790	55646	77.5	16144	22.5	71790	70824	98.7	966	1.3	71790	71472	99.6	318	0.4	71790	63265	88.1	8525	11.9
England	England	72022	72022	73	65	79	72022	33685	46.8	38337	53.2	Not set	71162	24346	34.2	16555	23.3	12679	17.8	10192	14.3	7390	10.4	125	30	24	14	11.2	32	25.6	34	27.2	15	12	33685	73	66	79	38337	73	65	80	72022	3.9	1.9	6.1	69284	4	2	7	72022	2738	3.8	72022	62714	87.1	72022	61364	85.2	72022	46630	64.7	61364	14.9	6.3	23.6	57235	41596	72.7	41596	35336	85	3650	8.8	1525	3.7	1085	2.6	7300	4173	57.2	1546	21.2	1581	21.7	5719	1546	27	3287	57.5	886	15.5	5719	4.5	1.8	13.0	72014	42507	59	29507	41	29507	454	1.5	3554	12	25499	86.4	29507	0.9	0.7	1.3	72022	2136	3	42430	58.9	23125	32.1	4331	6	23125	3000	13	5867	25.4	4375	18.9	9883	42.7	72014	57071	79.2	13045	18.1	1898	2.6	13045	2672	20.5	4426	33.9	3621	27.8	1734	13.3	495	3.8	91	0.7	6	0	69284	10919	15.8	12237	17.7	11934	17.2	11379	16.4	12517	18.1	5794	8.4	4504	6.5	72022	15335	21.3	49965	69.4	2773	3.9	384	0.5	2738	3.8	827	1.1	69276	10878	15.7	58398	84.3	69276	57028	82.3	12248	17.7	69276	56754	81.9	12522	18.1	69276	67631	97.6	1645	2.4	69276	62742	90.6	6534	9.4	69276	64441	93	4835	7	69276	57678	83.3	11598	16.7	69276	65837	95	3439	5	69276	53924	77.8	15352	22.2	69276	68347	98.7	929	1.3	69276	68964	99.5	312	0.5	69276	61159	88.3	8117	11.7
Wales	Wales	2623	2623	72	64	78	2623	1165	44.4	1458	55.6	Not set	15	5	33.3	5	33.3	<5	NA	<5	NA	<5	NA	2579	1013	39.3	675	26.2	423	16.4	244	9.5	224	8.7	1165	72	66	79	1458	71	64	78	2623	2.5	0.4	7.5	2515	4	2	8	2623	108	4.1	2623	1633	62.3	2623	1865	71.1	2623	1131	43.1	1865	18.3	4.1	45.7	2144	1140	53.2	1140	1023	89.7	28	2.5	26	2.3	63	5.5	390	241	61.8	72	18.5	77	19.7	313	72	23	164	52.4	77	24.6	313	7.3	2.2	21.9	2622	1936	73.8	686	26.2	686	13	1.9	85	12.4	588	85.7	686	1	0.7	1.3	2623	93	3.5	1416	54	999	38.1	115	4.4	999	221	22.1	327	32.7	340	34	111	11.1	2622	2590	98.8	27	1	5	0.2	27	<5	NA	15	55.6	5	18.5	<5	NA	<5	NA	<5	NA	<5	NA	2515	430	17.1	475	18.9	448	17.8	411	16.3	499	19.8	137	5.4	115	4.6	2623	2215	84.4	219	8.3	75	2.9	6	0.2	108	4.1	<5	NA	2514	855	34	1659	66	2514	2320	92.3	194	7.7	2514	2338	93	176	7	2514	2438	97	76	3	2514	2440	97.1	74	2.9	2514	2468	98.2	46	1.8	2514	2327	92.6	187	7.4	2514	2257	89.8	257	10.2	2514	1722	68.5	792	31.5	2514	2477	98.5	37	1.5	2514	2508	99.8	6	0.2	2514	2106	83.8	408	16.2
Morriston Hospital	ABERTAWE BRO MORGANNWG UNIVERSITY LHB	276	276	69	64	76	276	138	50	138	50	Not set	<5	<5	NA	<5	NA	<5	NA	<5	NA	<5	NA	275	130	47.3	59	21.5	37	13.5	24	8.7	25	9.1	138	72	65	79	138	68	61.25	75	276	0.6	0.2	1.4	265	5	3	9	276	11	4	276	117	42.4	276	179	64.9	276	76	27.5	179	34.9	6.1	72.0	276	188	68.1	188	157	83.5	<5	NA	<5	NA	25	13.3	47	27	57.4	11	23.4	9	19.1	38	11	28.9	17	44.7	10	26.3	38	8.0	1.4	32.4	276	243	88	33	12	33	<5	NA	6	18.2	27	81.8	33	0.9	0.7	1.2	276	7	2.5	137	49.6	129	46.7	<5	NA	129	58	45	35	27.1	20	15.5	16	12.4	276	276	100	<5	NA	<5	NA	<5	<5	NA	<5	NA	<5	NA	<5	NA	<5	NA	<5	NA	<5	NA	265	49	18.5	48	18.1	55	20.8	37	14	51	19.2	14	5.3	11	4.2	276	265	96	<5	NA	<5	NA	<5	NA	11	4	<5	NA	265	130	49.1	135	50.9	265	265	100	<5	NA	265	258	97.4	7	2.6	265	255	96.2	10	3.8	265	265	100	<5	NA	265	262	98.9	<5	NA	265	257	97	8	3	265	259	97.7	6	2.3	265	198	74.7	67	25.3	265	264	99.6	<5	NA	265	264	99.6	<5	NA	265	226	85.3	39	14.7