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

Eurostat code: proj_23np · (2022 - 2100)

@eurostat.proj_23np

Table List

2 tables(58.03 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_23np.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.79 MB
5005440 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	Total	Person	Austria	2022	4553444
Annual	Baseline projections	Females	Total	Person	Belgium	2022	5883978
Annual	Baseline projections	Females	Total	Person	Bulgaria	2022	3527626
Annual	Baseline projections	Females	Total	Person	Switzerland	2022	4400588
Annual	Baseline projections	Females	Total	Person	Cyprus	2022	463622
Annual	Baseline projections	Females	Total	Person	Czechia	2022	5332932
Annual	Baseline projections	Females	Total	Person	Germany	2022	42170339
Annual	Baseline projections	Females	Total	Person	Denmark	2022	2950505
Annual	Baseline projections	Females	Total	Person	Euro area – 20 countries (from 2023)	2022	177096882
Annual	Baseline projections	Females	Total	Person	Estonia	2022	698381


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.