Smoking Prevalence By Sex

Eurostat code: sdg_03_30 · (2006 - 2023)

@eurostat.sdg_03_30

Table List

2 tables(16.82 KB)

Smoking Prevalence By Sex - Unpivoted

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

6.57 KB
627 rows
7 columns

freq Freq	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	15 years or over	Females	Percentage of total population	Austria	2006	24
Annual	15 years or over	Females	Percentage of total population	Belgium	2006	22
Annual	15 years or over	Females	Percentage of total population	Bulgaria	2006	30
Annual	15 years or over	Females	Percentage of total population	Cyprus	2006	16
Annual	15 years or over	Females	Percentage of total population	Czechia	2006	23
Annual	15 years or over	Females	Percentage of total population	Germany	2006	25
Annual	15 years or over	Females	Percentage of total population	Denmark	2006	29
Annual	15 years or over	Females	Percentage of total population	Estonia	2006	24
Annual	15 years or over	Females	Percentage of total population	Greece	2006	37
Annual	15 years or over	Females	Percentage of total population	Spain	2006	28


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

Share link

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