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

Eurostat code: hlth_ehis_sk3e$dv_298

@eurostat.hlth_ehis_sk3e_dv_298

Table List

2 tables(15.08 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_dv_298.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.

7.49 KB
195 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	All ISCED 2011 levels	Total	Total	Austria	2014	9.3
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Belgium	2014	6.6
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Bulgaria	2014	12.7
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Cyprus	2014	12.1
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Czechia	2014	6
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Germany	2014	5
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Denmark	2014	3.9
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Estonia	2014	7.5
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Greece	2014	15.1
Annual	Percentage	20 or more cigarettes per day	All ISCED 2011 levels	Total	Total	Spain	2014	6.8


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.