Back to dataset

National Asthma and COPD Audit Programme (NACAP): Secondary care outcomes 2018-20NACAP secondary care outcomes report 2018-20_Adult asthma CSV

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

Clinical outcomes for adults admitted to hospital with an asthma attack between November 2018 and March 2020
Data field	region	ics	trust_code	trust_name	hosp_code	hosp_name	country	mortality_denom_N	died30_n	died30_perc	died90_n	died90_perc	died30hospcount_reason_N	COD30_diag_code_highest_diag_1	COD30_diag_code_highest_diag_2	COD30_diag_code_highest_diag_3	COD30diagcount_highest_diag_1	COD30diagcount_highest_diag_2	COD30diagcount_highest_diag_3	CODdiag30perc_highest_diag_1	CODdiag30perc_highest_diag_2	CODdiag30perc_highest_diag_3	died90hospcount_reason_N	COD90_diag_code_highest_diag_1	COD90_diag_code_highest_diag_2	COD90_diag_code_highest_diag_3	COD90diagcount_highest_diag_1	COD90diagcount_highest_diag_2	COD90diagcount_highest_diag_3	CODdiag90perc_highest_diag_1	CODdiag90perc_highest_diag_2	CODdiag90perc_highest_diag_3	readmitted30_N	readmitted30_No_n	readmitted30_No_perc	readmitted30_Yes_n	readmitted30_Yes_perc	readmitted90_N	readmitted90_No_n	readmitted90_No_perc	readmitted90_Yes_n	readmitted90_Yes_perc	read30hospcount_reason_N	readmiss30_diag_code_highest_diag_1	readmiss30_diag_code_highest_diag_2	readmiss30_diag_code_highest_diag_3	readmiss30diagcount_highest_diag_1	readmiss30diagcount_highest_diag_2	readmiss30diagcount_highest_diag_3	readmissdiag30perc_highest_diag_1	readmissdiag30perc_highest_diag_2	readmissdiag30perc_highest_diag_3	read90hospcount_reason_N	readmiss90_diag_code_highest_diag_1	readmiss90_diag_code_highest_diag_2	readmiss90_diag_code_highest_diag_3	readmiss90diagcount_highest_diag_1	readmiss90diagcount_highest_diag_2	readmiss90diagcount_highest_diag_3	readmissdiag90perc_highest_diag_1	readmissdiag90perc_highest_diag_2	readmissdiag90perc_highest_diag_3	age_N	age_median	age_lo.quart	age_hi.quart	gender_N	gender_Male_n	gender_Male_perc	gender_Female_n	gender_Female_perc	gender_Transgender_n	gender_Transgender_perc	gender_Other_n	gender_Other_perc	gender_Not_recorded/Preferred_not_to_say_n	gender_Not_recorded/Preferred_not_to_say_perc	IMD_quintile_all_N	IMD_quintile_all_1_n	IMD_quintile_all_1_perc	IMD_quintile_all_2_n	IMD_quintile_all_2_perc	IMD_quintile_all_3_n	IMD_quintile_all_3_perc	IMD_quintile_all_4_n	IMD_quintile_all_4_perc	IMD_quintile_all_5_n	IMD_quintile_all_5_perc	IMD_quintile_all_Missing_n	IMD_quintile_all_Missing_perc	CCIweightedcat_N	CCIweightedcat_0-1_n	CCIweightedcat_0-1_perc	CCIweightedcat_2_n	CCIweightedcat_2_perc	CCIweightedcat_3_n	CCIweightedcat_3_perc	CCIweightedcat_4_n	CCIweightedcat_4_perc	CCIweightedcat_5_n	CCIweightedcat_5_perc	CCIweightedcat_6_n	CCIweightedcat_6_perc	CCIweightedcat_7+_n	CCIweightedcat_7+_perc
Description	NHS region	Integrated Care System (ICS)	Not set	Trust name	Not set	Hospital name	Country	Mortality after index admission Denominator	Number of patients who died within 30-days of index admission Numerator	Percentage of patients who died within 30-days of index admission Numerator	Number of patients who died within 90-days of index admission Numerator	Percentage of patients who died within 90-days of index admission Numerator	30-day mortality after index admission_Top 3 reasons Denominator	30-day mortality after index admission_Top 3 reasons Reason 1_ICD-10 code Code	30-day mortality after index admission_Top 3 reasons Reason 2_ICD-10 code Code	30-day mortality after index admission_Top 3 reasons Reason 3_ICD-10 code Code	30-day mortality after index admission_Top 3 reasons Reason 1 Numerator	30-day mortality after index admission_Top 3 reasons Reason 2 Numerator	30-day mortality after index admission_Top 3 reasons Reason 3 Numerator	30-day mortality after index admission_Top 3 reasons Reason 1 Percentage	30-day mortality after index admission_Top 3 reasons Reason 2 Percentage	30-day mortality after index admission_Top 3 reasons Reason 3 Percentage	90-day mortality after index admission_Top 3 reasons Denominator	90-day mortality after index admission_Top 3 reasons Reason 1_ICD-10 code Code	90-day mortality after index admission_Top 3 reasons Reason 2_ICD-10 code Code	90-day mortality after index admission_Top 3 reasons Reason 3_ICD-10 code Code	90-day mortality after index admission_Top 3 reasons Reason 1 Numerator	90-day mortality after index admission_Top 3 reasons Reason 2 Numerator	90-day mortality after index admission_Top 3 reasons Reason 3 Numerator	90-day mortality after index admission_Top 3 reasons Reason 1 Percentage	90-day mortality after index admission_Top 3 reasons Reason 2 Percentage	90-day mortality after index admission_Top 3 reasons Reason 3 Percentage	30-day readmission after index discharge Denominator	30-day readmission after index discharge_No Numerator	30-day readmission after index discharge_No Percentage	30-day readmission after index discharge_Yes Numerator	30-day readmission after index discharge_Yes Percentage	90-day readmission after index discharge Denominator	90-day readmission after index discharge_No Numerator	90-day readmission after index discharge_No Percentage	90-day readmission after index discharge_Yes Numerator	90-day readmission after index discharge_Yes Percentage	30-day mortality after index admission_Top 3 reasons Denominator	30-day readmission after index discharge_Top 3 reasons Reason 1_ICD-10 code Code	30-day readmission after index discharge_Top 3 reasons Reason 2_ICD-10 code Code	30-day readmission after index discharge_Top 3 reasons Reason 3_ICD-10 code Code	30-day readmission after index discharge_Top 3 reasons Reason 1 Numerator	30-day readmission after index discharge_Top 3 reasons Reason 2 Numerator	30-day readmission after index discharge_Top 3 reasons Reason 3 Numerator	30-day readmission after index discharge_Top 3 reasons Reason 1 Percentage	30-day readmission after index discharge_Top 3 reasons Reason 2 Percentage	30-day readmission after index discharge_Top 3 reasons Reason 3 Percentage	90-day readmission after index discharge_Top 3 reasons Denominator	90-day readmission after index discharge_Top 3 reasons Reason 1_ICD-10 code Code	90-day readmission after index discharge_Top 3 reasons Reason 2_ICD-10 code Code	90-day readmission after index discharge_Top 3 reasons Reason 3_ICD-10 code Code	90-day readmission after index discharge_Top 3 reasons Reason 1 Numerator	90-day readmission after index discharge_Top 3 reasons Reason 2 Numerator	90-day readmission after index discharge_Top 3 reasons Reason 3 Numerator	90-day readmission after index discharge_Top 3 reasons Reason 1 Percentage	90-day readmission after index discharge_Top 3 reasons Reason 2 Percentage	90-day readmission after index discharge_Top 3 reasons Reason 3 Percentage	Age Denominator	Age Median	Age Lower quartile	Age Upper quartile	Gender Denominator	Gender_Male Numerator	Gender_Male Percentage	Gender_Female Numerator	Gender_Female Percentage	Gender_Transgender Numerator	Gender_Transgender Percentage	Gender_Other Numerator	Gender_Other Percentage	Gender_Not recorded/Preferred not to say Numerator	Gender_Not recorded/Preferred not to say Percentage	Socio-economic status Denominator	Socio-economic status Quintile 1 Numerator	Socio-economic status Quintile 1 Percentage	Socio-economic status Quintile 2 Numerator	Socio-economic status Quintile 2 Percentage	Socio-economic status Quintile 3 Numerator	Socio-economic status Quintile 3 Percentage	Socio-economic status Quintile 4 Numerator	Socio-economic status Quintile 4 Percentage	Socio-economic status Quintile 5 Numerator	Socio-economic status Quintile 5 Percentage	Socio-economic status Missing Numerator	Socio-economic status Missing Percentage	Charlson comorbidity index (CCI) Denominator	CCI_Category 0-1 Numerator	CCI_Category 0-1 Percentage	CCI_Category 2 Numerator	CCI_Category 2 Percentage	CCI_Category 3 Numerator	CCI_Category 3 Percentage	CCI_Category 4 Numerator	CCI_Category 4 Percentage	CCI_Category 5 Numerator	CCI_Category 5 Percentage	CCI_Category 6 Numerator	CCI_Category 6 Percentage	CCI_Category 7+ Numerator	CCI_Category 7+ Percentage
Value type 1	Text	Text	Not set	Text	Not set	Text	Text	Integer	Integer	Percentage	Integer	Percentage	Integer	Text	Text	Text	Integer	Integer	Integer	Percentage	Percentage	Percentage	Integer	Text	Text	Text	Integer	Integer	Integer	Percentage	Percentage	Percentage	Integer	Integer	Percentage	Integer	Percentage	Integer	Integer	Percentage	Integer	Percentage	Integer	Text	Text	Text	Integer	Integer	Integer	Percentage	Percentage	Percentage	Integer	Text	Text	Text	Integer	Integer	Integer	Percentage	Percentage	Percentage	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	Percentage	Integer	Integer	Percentage	Integer	Percentage	Integer	Percentage	Integer	Percentage	Integer	Percentage	Integer	Percentage	Integer	Percentage
Value type 2	Text	Text	Not set	Text	Not set	Text	Text	0	0	%	0	%	0	Text	Text	Text	0	0	0	%	%	%	0	Text	Text	Text	0	0	0	%	%	%	0	0	%	0	%	0	0	%	0	%	0	Text	Text	Text	0	0	0	%	%	%	0	Text	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	%