Healthy Life Expectancy Based On Self-perceived Health

Eurostat code: hlth_silc_17 · (2004 - 2022)

@eurostat.hlth_silc_17

Table List

2 tables(52.23 KB)

Healthy Life Expectancy Based On Self-perceived Health - Raw

Healthy Life Expectancy Based On Self-perceived Health - Unpivoted

Healthy Life Expectancy Based On Self-perceived Health - Unpivoted

@eurostat.hlth_silc_17.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.

14.37 KB
5319 rows
7 columns

freq Freq	unit Unit	indic_he Indic He	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Year	Health expectancy in absolute values at 50	Females	Austria	2004	27.1
Annual	Year	Health expectancy in absolute values at 50	Females	Belgium	2004	27.6
Annual	Year	Health expectancy in absolute values at 50	Females	Denmark	2004	27.2
Annual	Year	Health expectancy in absolute values at 50	Females	Estonia	2004	20.4
Annual	Year	Health expectancy in absolute values at 50	Females	Greece	2004	25.9
Annual	Year	Health expectancy in absolute values at 50	Females	Spain	2004	24
Annual	Year	Health expectancy in absolute values at 50	Females	European Union - 27 countries (from 2020)	2004	25.1
Annual	Year	Health expectancy in absolute values at 50	Females	European Union - 28 countries (2013-2020)	2004	25.1
Annual	Year	Health expectancy in absolute values at 50	Females	Finland	2004	27.1
Annual	Year	Health expectancy in absolute values at 50	Females	France	2004	27.6


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

Share link

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