Baselight

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

Eurostat code: hlth_silc_02 ยท (2008 - 2024)

@eurostat.hlth_silc_02

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

  • 1.23 MB
  • 923711 rows
  • 9 columns
freq

Freq

unit

Unit

isced11

Isced11

age

Age

sex

Sex

levels

Levels

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadAustria20081.5
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadBelgium20082.2
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadBulgaria20081.2
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadSwitzerland20080.6
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadCyprus20080.8
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadCzechia20080.6
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadGermany20081.6
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadDenmark20081.3
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)20081.5
AnnualPercentageLess than primary, primary and lower secondary education (levels 0-2)From 16 to 24 yearsFemalesBadEuro area - 18 countries (2014)20081.5

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.