Projected Deaths By Age, Sex, Type Of Projection And Other Typologies

Eurostat code: urt_proj_19rdth · (2019 - 2100)

@eurostat.urt_proj_19rdth

Table List

2 tables(851.48 KB)

Projected Deaths By Age, Sex, Type Of Projection And Other Typologies - Raw

Projected Deaths By Age, Sex, Type Of Projection And Other Typologies - Unpivoted

Projected Deaths By Age, Sex, Type Of Projection And Other Typologies - Unpivoted

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

382.11 KB
70356 rows
9 columns

freq Freq	terrtypo Terrtypo	projection Projection	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Border regions	Baseline projections	Total	Females	Person	Austria	2019	37807
Annual	Border regions	Baseline projections	Total	Females	Person	Belgium	2019	42179
Annual	Border regions	Baseline projections	Total	Females	Person	Bulgaria	2019	27955
Annual	Border regions	Baseline projections	Total	Females	Person	Switzerland	2019	32143
Annual	Border regions	Baseline projections	Total	Females	Person	Czechia	2019	48977
Annual	Border regions	Baseline projections	Total	Females	Person	Germany	2019	119529
Annual	Border regions	Baseline projections	Total	Females	Person	Denmark	2019	3509
Annual	Border regions	Baseline projections	Total	Females	Person	Estonia	2019	3998
Annual	Border regions	Baseline projections	Total	Females	Person	Greece	2019	8543
Annual	Border regions	Baseline projections	Total	Females	Person	Spain	2019	43899


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

Share link

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