Daily Smokers Of Cigarettes By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_sk3u · (2014 - 2019)

@eurostat.hlth_ehis_sk3u

Table List

2 tables(124.55 KB)

Daily Smokers Of Cigarettes By Sex, Age And Degree Of Urbanisation - Raw

Daily Smokers Of Cigarettes By Sex, Age And Degree Of Urbanisation - Unpivoted

Daily Smokers Of Cigarettes By Sex, Age And Degree Of Urbanisation - Unpivoted

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

60.17 KB
43079 rows
9 columns

freq Freq	smoking Smoking	deg_urb Deg Urb	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Austria	2014	11.2
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Belgium	2014	6.5
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Bulgaria	2014	7.4
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Cyprus	2014	5.5
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Czechia	2014	2.8
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Germany	2014	3.4
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Denmark	2014	2.3
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Estonia	2014	2.2
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Greece	2014	9.3
Annual	20 or more cigarettes per day	Cities	Females	Total	Percentage	Spain	2014	4.7


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