Healthy Life Years By Sex (from 2004 Onwards)

Eurostat code: hlth_hlye$dv_287

@eurostat.hlth_hlye_dv_287

Table List

2 tables(31.4 KB)

Healthy Life Years By Sex (from 2004 Onwards) - Raw

Healthy Life Years By Sex (from 2004 Onwards) - Unpivoted

Healthy Life Years By Sex (from 2004 Onwards) - Unpivoted

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

11.21 KB
1896 rows
7 columns

freq Freq	unit Unit	sex Sex	indic_he Indic He	geo Geo	time_period Time Period	value Value
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Austria	2013	73.7
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Belgium	2013	79.2
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Bulgaria	2013	86.1
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Switzerland	2013	72.4
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Cyprus	2013	78.4
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Czechia	2013	80.8
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Germany	2013	71.2
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Denmark	2013	75.2
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Estonia	2013	71.7
Annual	Percentage	Total	Healthy life years at birth in percentage of the total life expectancy	Greece	2013	79.7


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

Share link

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