Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Educational Attainment Level

Eurostat code: hlth_ehis_sk4e · (2014 - 2019)

@eurostat.hlth_ehis_sk4e

Table List

2 tables(172.03 KB)

Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Educational Attainment Level - Raw

Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Educational Attainment Level - Unpivoted

Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Educational Attainment Level - Unpivoted

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

82.18 KB
53815 rows
9 columns

freq Freq	unit Unit	frequenc Frequenc	isced11 Isced11	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Austria	2014	16.3
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Belgium	2014	16
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Bulgaria	2014	16.5
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Cyprus	2014	6.5
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Czechia	2014	9.2
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Germany	2014	8.1
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Denmark	2014	11
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Estonia	2014	10.2
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Greece	2014	23.3
Annual	Percentage	At least 1 hour every day	Less than primary, primary and lower secondary education (levels 0-2)	Females	Total	Spain	2014	8.2


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