Daily Smokers Of Cigarettes By Sex, Age And Educational Attainment Level

Eurostat code: hlth_ehis_sk3e · (2014 - 2019)

@eurostat.hlth_ehis_sk3e

Table List

2 tables(139.29 KB)

Daily Smokers Of Cigarettes By Sex, Age And Educational Attainment Level - Raw

Daily Smokers Of Cigarettes By Sex, Age And Educational Attainment Level - Unpivoted

Daily Smokers Of Cigarettes By Sex, Age And Educational Attainment Level - Unpivoted

@eurostat.hlth_ehis_sk3e.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.

66.98 KB
43419 rows
9 columns

freq Freq	unit Unit	smoking Smoking	isced11 Isced11	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Austria	2014	9.8
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Belgium	2014	6.6
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Bulgaria	2014	5.6
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Cyprus	2014	3.1
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Czechia	2014	2.1
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Germany	2014	3.4
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Denmark	2014	3.6
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Estonia	2014	3.2
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Greece	2014	8
Annual	Percentage	20 or more cigarettes per day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Spain	2014	4.5


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "smoking" VARCHAR,
  "isced11" 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.