Tobacco Use And Mortality, 2004-2015

Hospital admissions, prescriptions, and fatalities in England

@kaggle.nhs_tobacco_use

Table List

5 tables(59.8 KB)

Admissions

Fatalities

Metrics

Prescriptions

Smokers

Admissions

@kaggle.nhs_tobacco_use.admissions

18.2 KB
2079 rows
7 columns

year Year	icd10_code ICD10 Code	icd10_diagnosis ICD10 Diagnosis	diagnosis_type Diagnosis Type	metric Metric	sex Sex	value Value
2014/15	All codes	All admissions	All admissions	Number of admissions	nan	11011882
2014/15	C33-C34 & C00-C14 & C15 & C32 & C53 & C67 & C64-C66 & C68 & C16 & C25 & C80 & C92 & J40-J43 & J44 & J10-J18 & I00-I09 & I26-I51 & I20-I25 & I72-I78 & I60-I69 & I71 & I70 & K25-K27 & K50 & K05 & H25 & S72.0-S72.2 & O03	All diseases which can be caused by smoking	All diseases which can be caused by smoking	Number of admissions	nan	1713330
2014/15	C00-D48	All cancers	All cancers	Number of admissions	nan	1691035
2014/15	J00-J99	All respiratory diseases	All respiratory diseases	Number of admissions	nan	611002
2014/15	I00-I99	All circulatory diseases	All circulatory diseases	Number of admissions	nan	907157
2014/15	K00-K93	All diseases of the digestive system	All diseases of the digestive system	Number of admissions	nan	1460719
2014/15	C33-C34	Trachea, Lung, Bronchus	Cancers which can be caused by smoking	Number of admissions	nan	88408
2014/15	C00-C14	Upper Respiratory Sites	Cancers which can be caused by smoking	Number of admissions	nan	21715
2014/15	C15	Oesophagus	Cancers which can be caused by smoking	Number of admissions	nan	29703
2014/15	C32	Larynx	Cancers which can be caused by smoking	Number of admissions	nan	4625


CREATE TABLE admissions (
  "year" VARCHAR,
  "icd10_code" VARCHAR,
  "icd10_diagnosis" VARCHAR,
  "diagnosis_type" VARCHAR,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "value" VARCHAR
);