Baselight
Sign In

Former Daily Tobacco Smokers By Sex, Age And Income Quintile

Eurostat code: hlth_ehis_sk2i ยท (2019 - 2019)

@eurostat.hlth_ehis_sk2i

Former Daily Tobacco Smokers By Sex, Age And Income Quintile - Unpivoted
@eurostat.hlth_ehis_sk2i.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.

  • 22.05 KB
  • 8809 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

quant_inc

Quant Inc

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageFemalesTotalFirst quintileAustria201921.8
AnnualPercentageFemalesTotalFirst quintileBelgium201916.8
AnnualPercentageFemalesTotalFirst quintileBulgaria20196.6
AnnualPercentageFemalesTotalFirst quintileCyprus20195.4
AnnualPercentageFemalesTotalFirst quintileCzechia201919.3
AnnualPercentageFemalesTotalFirst quintileDenmark201934.9
AnnualPercentageFemalesTotalFirst quintileEstonia201917.8
AnnualPercentageFemalesTotalFirst quintileGreece20198.7
AnnualPercentageFemalesTotalFirst quintileSpain201913.8
AnnualPercentageFemalesTotalFirst quintileEuropean Union - 27 countries (from 2020)201920.6

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

Share link

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