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

Eurostat code: proj_23nalexp · (2022 - 2100)

@eurostat.proj_23nalexp

Table List

2 tables(2.71 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_23nalexp.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.24 MB
957480 rows
8 columns

freq Freq	projection Projection	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Females	1 year	Year	Austria	2022	83.6
Annual	Baseline projections	Females	1 year	Year	Belgium	2022	84
Annual	Baseline projections	Females	1 year	Year	Bulgaria	2022	77.3
Annual	Baseline projections	Females	1 year	Year	Switzerland	2022	85.4
Annual	Baseline projections	Females	1 year	Year	Cyprus	2022	83.9
Annual	Baseline projections	Females	1 year	Year	Czechia	2022	81.2
Annual	Baseline projections	Females	1 year	Year	Germany	2022	83.2
Annual	Baseline projections	Females	1 year	Year	Denmark	2022	83.1
Annual	Baseline projections	Females	1 year	Year	Estonia	2022	82.1
Annual	Baseline projections	Females	1 year	Year	Greece	2022	83.6


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

Share link

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