Short-term Population Projections (2023-2050)

Eurostat code: proj_stp24 · (2023 - 2050)

@eurostat.proj_stp24

Table List

2 tables(166.03 KB)

Short-term Population Projections (2023-2050) - Raw

Short-term Population Projections (2023-2050) - Unpivoted

Short-term Population Projections (2023-2050) - Unpivoted

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

71.03 KB
13272 rows
6 columns

freq Freq	indic_de Indic De	projection Projection	geo Geo	time_period Time Period	value Value
Annual	Deaths - total	Baseline projections	Austria	2023	89760
Annual	Deaths - total	Baseline projections	Belgium	2023	111311
Annual	Deaths - total	Baseline projections	Bulgaria	2023	101006
Annual	Deaths - total	Baseline projections	Switzerland	2023	71822
Annual	Deaths - total	Baseline projections	Cyprus	2023	6707
Annual	Deaths - total	Baseline projections	Czechia	2023	112795
Annual	Deaths - total	Baseline projections	Germany	2023	1027916
Annual	Deaths - total	Baseline projections	Denmark	2023	58384
Annual	Deaths - total	Baseline projections	Euro area – 20 countries (from 2023)	2023	3691489
Annual	Deaths - total	Baseline projections	Estonia	2023	16002


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_de" VARCHAR,
  "projection" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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