Baselight
Sign In

Self-perceived Health By Sex, Age And Educational Attainment Level

Eurostat code: hlth_silc_02$dv_381

@eurostat.hlth_silc_02_dv_381

Self-perceived Health By Sex, Age And Educational Attainment Level - Unpivoted
@eurostat.hlth_silc_02_dv_381.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.

  • 16.62 KB
  • 4683 rows
  • 9 columns
freq

Freq

unit

Unit

isced11

Isced11

age

Age

sex

Sex

levels

Levels

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadAustria20087
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadBelgium20086.3
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadBulgaria200810.7
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadSwitzerland20082.7
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadCyprus20086.4
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadCzechia200810.5
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadGermany20086.5
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadDenmark20085.3
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)20086.8
AnnualPercentageAll ISCED 2011 levels16 years or overTotalBadEuro area - 18 countries (2014)20087

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

Share link

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