Daily Smokers By Number Of Cigarettes By Sex, Age And Educational Attainment Level (%)

Eurostat code: hlth_ehis_de5 · (2008 - 2008)

@eurostat.hlth_ehis_de5

Table List

2 tables(22.85 KB)

Daily Smokers By Number Of Cigarettes By Sex, Age And Educational Attainment Level (%) - Raw

Daily Smokers By Number Of Cigarettes By Sex, Age And Educational Attainment Level (%) - Unpivoted

Daily Smokers By Number Of Cigarettes By Sex, Age And Educational Attainment Level (%) - Unpivoted

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

11.6 KB
2654 rows
8 columns

freq Freq	sex Sex	age Age	smoking Smoking	isced97 Isced97	geo Geo	time_period Time Period	value Value
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Belgium	2008	7.4
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Bulgaria	2008	3.2
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Cyprus	2008	3.5
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Czechia	2008	7.2
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Germany	2008	5.3
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Estonia	2008	2.9
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Greece	2008	10.8
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Spain	2008	5.7
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Hungary	2008	6.9
Annual	Females	Total	Daily cigarette smoker - 20 or more per day	Pre-primary, primary and lower secondary education (levels 0-2)	Latvia	2008	3


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

Share link

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