Short-term Update Of The Projected Population (2022-2032)

Eurostat code: proj_stp22 · (2019 - 2032)

@eurostat.proj_stp22

Table List

2 tables(58.18 KB)

Short-term Update Of The Projected Population (2022-2032) - Raw

Short-term Update Of The Projected Population (2022-2032) - Unpivoted

Short-term Update Of The Projected Population (2022-2032) - Unpivoted

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

25.12 KB
4410 rows
6 columns

freq Freq	projection Projection	indic_de Indic De	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Population on 1 January - total	Austria	2019	8858775
Annual	Baseline projections	Population on 1 January - total	Belgium	2019	11455519
Annual	Baseline projections	Population on 1 January - total	Bulgaria	2019	7000039
Annual	Baseline projections	Population on 1 January - total	Switzerland	2019	8544527
Annual	Baseline projections	Population on 1 January - total	Cyprus	2019	875899
Annual	Baseline projections	Population on 1 January - total	Czechia	2019	10649800
Annual	Baseline projections	Population on 1 January - total	Germany	2019	83019213
Annual	Baseline projections	Population on 1 January - total	Denmark	2019	5806081
Annual	Baseline projections	Population on 1 January - total	Euro area - 19 countries (2015-2022)	2019	341524067
Annual	Baseline projections	Population on 1 January - total	Euro area – 20 countries (from 2023)	2019	345600313


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

Share link

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