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

Eurostat code: hlth_ehis_de3 · (2008 - 2008)

@eurostat.hlth_ehis_de3

Table List

2 tables(18.78 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_de3.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.

9.64 KB
1500 rows
7 columns

freq Freq	sex Sex	age Age	isced97 Isced97	geo Geo	time_period Time Period	value Value
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Austria	2008	17.3
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Belgium	2008	19.1
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Bulgaria	2008	9.6
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Cyprus	2008	7.7
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Czechia	2008	19.3
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Germany	2008	21.5
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Estonia	2008	12.7
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Greece	2008	18.5
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Spain	2008	18.3
Annual	Females	Total	Pre-primary, primary and lower secondary education (levels 0-2)	Hungary	2008	21.5


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

Share link

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