Population On 1st January By Age, Sex And Type Of Projection

Eurostat code: proj_19np · (2019 - 2100)

@eurostat.proj_19np

Table List

2 tables(56.7 MB)

Population On 1st January By Age, Sex And Type Of Projection - Raw

Population On 1st January By Age, Sex And Type Of Projection - Unpivoted

Population On 1st January By Age, Sex And Type Of Projection - Unpivoted

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

28.27 MB
5219136 rows
8 columns

freq Freq	projection Projection	unit Unit	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Person	Females	Total	Austria	2019	4501742
Annual	Baseline projections	Person	Females	Total	Belgium	2019	5810693
Annual	Baseline projections	Person	Females	Total	Bulgaria	2019	3604338
Annual	Baseline projections	Person	Females	Total	Switzerland	2019	4307406
Annual	Baseline projections	Person	Females	Total	Cyprus	2019	448068
Annual	Baseline projections	Person	Females	Total	Czechia	2019	5405606
Annual	Baseline projections	Person	Females	Total	Germany	2019	42052522
Annual	Baseline projections	Person	Females	Total	Denmark	2019	2917008
Annual	Baseline projections	Person	Females	Total	Euro area - 19 countries (2015-2022)	2019	174864934
Annual	Baseline projections	Person	Females	Total	Euro area – 20 countries (from 2023)	2019	176968608


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.