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

Metrics

@kaggle.nhs_tobacco_use.metrics

10.06 KB
36 rows
9 columns

year Year	tobacco_price_index Tobacco Price Index	retail_prices_index Retail Prices Index	tobacco_price_index_relative_to_retail_price_index Tobacco Price Index Relative To Retail Price Index	real_households_disposable_income Real Households\u0027 Disposable Income	affordability_of_tobacco_index Affordability Of Tobacco Index	household_expenditure_on_tobacco Household Expenditure On Tobacco	household_expenditure_total Household Expenditure Total	expenditure_on_tobacco_as_a_percentage_of_expenditure Expenditure On Tobacco As A Percentage Of Expenditure
2015	1294.3	386.7	334.7	196.4	58.7	19252	1152387	1.7
2014	1226	383	320.1	190	59.4	19411	1118992	1.7
2013	1139.3	374.2	304.5	190.3	62.5	18683	1073106	1.7
2012	1057.8	363.1	291.3	192.9	66.2	18702	1029378	1.8
2011	974.9	351.9	277.1	189.3	68.3	18217	990828	1.8
2010	878.3	334.5	262.6	195	74.3	17176	954781	1.8
2009	815.9	319.7	255.2	195.7	76.7	16209	911665	1.8
2008	784.7	321.3	244.2	192.5	78.8	15879	928265	1.7
2007	751.5	309.1	243.1	195.9	80.6	15766	898478	1.8
2006	713.7	296.4	240.8	192.3	79.9	15542	851456	1.8


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
);