Daily Smokers Of Cigarettes By Sex, Age And Income Quintile

Eurostat code: hlth_ehis_sk3i$dv_2705

@eurostat.hlth_ehis_sk3i_dv_2705

Table List

2 tables(25.79 KB)

Daily Smokers Of Cigarettes By Sex, Age And Income Quintile - Raw

Daily Smokers Of Cigarettes By Sex, Age And Income Quintile - Unpivoted

Daily Smokers Of Cigarettes By Sex, Age And Income Quintile - Unpivoted

@eurostat.hlth_ehis_sk3i_dv_2705.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

12.36 KB
3398 rows
9 columns

freq Freq	unit Unit	smoking Smoking	quant_inc Quant Inc	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Austria	2014	5.5
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Bulgaria	2014	8.8
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Cyprus	2014	4.1
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Czechia	2014
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Germany	2014	1.1
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Denmark	2014	2.5
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Estonia	2014
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Greece	2014	5.3
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	Spain	2014	1.7
Annual	Percentage	20 or more cigarettes per day	First quintile	Females	From 15 to 24 years	European Union - 27 countries (from 2020)	2014	2.1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "smoking" VARCHAR,
  "quant_inc" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.