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

Fatalities

@kaggle.nhs_tobacco_use.fatalities

14.52 KB
1749 rows
7 columns

year Year	icd10_code ICD10 Code	icd10_diagnosis ICD10 Diagnosis	diagnosis_type Diagnosis Type	metric Metric	sex Sex	value Value
2014	All codes	All deaths	All deaths	Number of observed deaths	nan	459087
2014	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 deaths which can be caused by smoking	All deaths which can be caused by smoking	Number of observed deaths	nan	235820
2014	C00-D48	All cancers	All cancers	Number of observed deaths	nan	136312
2014	J00-J99	All respiratory diseases	All respiratory diseases	Number of observed deaths	nan	61744
2014	I00-I99	All circulatory diseases	All circulatory diseases	Number of observed deaths	nan	126101
2014	K00-K93	All diseases of the digestive system	All diseases of the digestive system	Number of observed deaths	nan	22335
2014	C33-C34	Trachea, Lung, Bronchus	Cancers which can be caused by smoking	Number of observed deaths	nan	28826
2014	C00-C14	Upper Respiratory Sites	Cancers which can be caused by smoking	Number of observed deaths	nan	2197
2014	C32	Larynx	Cancers which can be caused by smoking	Number of observed deaths	nan	653
2014	C15	Oesophagus	Cancers which can be caused by smoking	Number of observed deaths	nan	6315


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