Name: Tobacco Use And Mortality, 2004-2015
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Tobacco Use And Mortality, 2004-2015

Context

Conditions that could be caused by smoking resulted in 1.7 million admissions to hospitals in England, for adults aged 35 and over, in 2014-2015 -- an average of 4,700 admissions per day! These figures refer to admissions with a primary diagnosis of a disease that can be caused by smoking, but for which smoking may or may not have actually been the cause.

Content

The Statistics on Smoking in England report aims to present a broad picture of health issues relating to smoking in England and covers topics such as smoking prevalence, habits, behaviours, and attitudes, smoking-related health issues and mortality, and associated costs.

Acknowledgements

This report contains data and information previously published by the Health and Social Care Information Centre (HSCIC), Department of Health, the Office for National Statistics, and Her Majesty’s Revenue and Customs.

Tables

Admissions

@kaggle.nhs_tobacco_use.admissions

18.64 kB
2,079 rows
7 columns

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

Fatalities

@kaggle.nhs_tobacco_use.fatalities

14.87 kB
1,749 rows
7 columns

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

Metrics

@kaggle.nhs_tobacco_use.metrics

10.3 kB
36 rows
9 columns

CREATE TABLE metrics (
  "year" BIGINT,
  "tobacco_price_index" DOUBLE,
  "retail_prices_index" DOUBLE,
  "tobacco_price_index_relative_to_retail_price_index" DOUBLE,
  "real_households_disposable_income" DOUBLE  -- Real Households\u0027 Disposable Income,
  "affordability_of_tobacco_index" DOUBLE,
  "household_expenditure_on_tobacco" DOUBLE,
  "household_expenditure_total" DOUBLE,
  "expenditure_on_tobacco_as_a_percentage_of_expenditure" DOUBLE
);

Prescriptions

@kaggle.nhs_tobacco_use.prescriptions

9.58 kB
11 rows
9 columns

CREATE TABLE prescriptions (
  "year" VARCHAR,
  "all_pharmacotherapy_prescriptions" BIGINT,
  "nicotine_replacement_therapy_nrt_prescriptions" BIGINT  -- Nicotine Replacement Therapy (NRT) Prescriptions,
  "bupropion_zyban_prescriptions" BIGINT  -- Bupropion (Zyban) Prescriptions,
  "varenicline_champix_prescriptions" DOUBLE  -- Varenicline (Champix) Prescriptions,
  "net_ingredient_cost_of_all_pharmacotherapies" BIGINT,
  "net_ingredient_cost_of_nicotine_replacement_therapies_nrt" BIGINT  -- Net Ingredient Cost Of Nicotine Replacement Therapies (NRT),
  "net_ingredient_cost_of_bupropion_zyban" BIGINT  -- Net Ingredient Cost Of Bupropion (Zyban),
  "net_ingredient_cost_of_varenicline_champix" DOUBLE  -- Net Ingredient Cost Of Varenicline (Champix)
);

Smokers

@kaggle.nhs_tobacco_use.smokers

7.86 kB
84 rows
9 columns

CREATE TABLE smokers (
  "year" BIGINT,
  "method" VARCHAR,
  "sex" VARCHAR,
  "n_16_and_over" BIGINT  -- 16 And Over,
  "n_16_24" BIGINT  -- 16-24,
  "n_25_34" BIGINT  -- 25-34,
  "n_35_49" BIGINT  -- 35-49,
  "n_50_59" BIGINT  -- 50-59,
  "n_60_and_over" BIGINT  -- 60 And Over
);