Baselight
Sign In

Self Defined Health Status By Age And Income Quantile

Eurostat code: ilc_lk11 ยท (1995 - 2001)

@eurostat.ilc_lk11

Self Defined Health Status By Age And Income Quantile - Unpivoted
@eurostat.ilc_lk11.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.

  • 5.63 KB
  • 594 rows
  • 6 columns
freq

Freq

age

Age

quantile

Quantile

geo

Geo

time_period

Time Period

value

Value

AnnualTotalFirst quintileAustria199515
AnnualTotalFirst quintileBelgium19959
AnnualTotalFirst quintileGermany199527
AnnualTotalFirst quintileEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)199518
AnnualTotalFirst quintileGreece199517
AnnualTotalFirst quintileSpain199516
AnnualTotalFirst quintileEuropean Union - 15 countries (1995-2004)199517
AnnualTotalFirst quintileFrance199512
AnnualTotalFirst quintileIreland19954
AnnualTotalFirst quintileItaly199516

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