Baselight
Sign In

Daily Smokers Of Cigarettes By Sex, Age And Income Quintile

Eurostat code: hlth_ehis_sk3i$dv_304

@eurostat.hlth_ehis_sk3i_dv_304

Daily Smokers Of Cigarettes By Sex, Age And Income Quintile - Unpivoted
@eurostat.hlth_ehis_sk3i_dv_304.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.

  • 7.4 KB
  • 195 rows
  • 9 columns
freq

Freq

unit

Unit

smoking

Smoking

quant_inc

Quant Inc

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage20 or more cigarettes per dayTotalTotalTotalAustria20149.3
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalBelgium20146.6
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalBulgaria201412.7
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalCyprus201412.1
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalCzechia20146
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalGermany20145
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalDenmark20143.9
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalEstonia20147.5
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalGreece201415.1
AnnualPercentage20 or more cigarettes per dayTotalTotalTotalSpain20146.8

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