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.2 KB
2079 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.52 KB
1749 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.06 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,
  "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.35 KB
11 rows
9 columns


CREATE TABLE prescriptions (
  "year" VARCHAR,
  "all_pharmacotherapy_prescriptions" BIGINT,
  "nicotine_replacement_therapy_nrt_prescriptions" BIGINT,
  "bupropion_zyban_prescriptions" BIGINT,
  "varenicline_champix_prescriptions" DOUBLE,
  "net_ingredient_cost_of_all_pharmacotherapies" BIGINT,
  "net_ingredient_cost_of_nicotine_replacement_therapies_nrt" BIGINT,
  "net_ingredient_cost_of_bupropion_zyban" BIGINT,
  "net_ingredient_cost_of_varenicline_champix" DOUBLE
);

Smokers

@kaggle.nhs_tobacco_use.smokers

7.67 KB
84 rows
9 columns


CREATE TABLE smokers (
  "year" BIGINT,
  "method" VARCHAR,
  "sex" VARCHAR,
  "n_16_and_over" BIGINT,
  "n_16_24" BIGINT,
  "n_25_34" BIGINT,
  "n_35_49" BIGINT,
  "n_50_59" BIGINT,
  "n_60_and_over" BIGINT
);