Projected Life Expectancy By Age (in Completed Years), Sex And Type Of Projection

Eurostat code: proj_19nalexp · (2019 - 2100)

@eurostat.proj_19nalexp

Table List

2 tables(2.34 MB)

Projected Life Expectancy By Age (in Completed Years), Sex And Type Of Projection - Raw

Projected Life Expectancy By Age (in Completed Years), Sex And Type Of Projection - Unpivoted

Projected Life Expectancy By Age (in Completed Years), Sex And Type Of Projection - Unpivoted

@eurostat.proj_19nalexp.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.06 MB
810324 rows
8 columns

freq Freq	projection Projection	unit Unit	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Year	Females	1 year	Austria	2019	83.6
Annual	Baseline projections	Year	Females	1 year	Belgium	2019	83.5
Annual	Baseline projections	Year	Females	1 year	Bulgaria	2019	78.2
Annual	Baseline projections	Year	Females	1 year	Switzerland	2019	85.1
Annual	Baseline projections	Year	Females	1 year	Cyprus	2019	84.2
Annual	Baseline projections	Year	Females	1 year	Czechia	2019	81.5
Annual	Baseline projections	Year	Females	1 year	Germany	2019	82.9
Annual	Baseline projections	Year	Females	1 year	Denmark	2019	82.5
Annual	Baseline projections	Year	Females	1 year	Estonia	2019	82.6
Annual	Baseline projections	Year	Females	1 year	Greece	2019	83.6


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

Share link

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