Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_sk4u · (2014 - 2019)

@eurostat.hlth_ehis_sk4u

Table List

2 tables(170.23 KB)

Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Degree Of Urbanisation - Raw

Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Degree Of Urbanisation - Unpivoted

Daily Exposure To Tobacco Smoke Indoors By Sex, Age And Degree Of Urbanisation - Unpivoted

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

81.86 KB
54174 rows
9 columns

freq Freq	frequenc Frequenc	deg_urb Deg Urb	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Austria	2014	18
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Belgium	2014	13.7
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Bulgaria	2014	16.5
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Cyprus	2014	8.4
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Czechia	2014	7.3
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Germany	2014	7.1
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Denmark	2014	6
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Estonia	2014	7.1
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Greece	2014	34.2
Annual	At least 1 hour every day	Cities	Females	Total	Percentage	Spain	2014	8.7


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

Share link

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