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

Eurostat code: urt_proj_19rp · (2019 - 2100)

@eurostat.urt_proj_19rp

Table List

2 tables(1019.02 KB)

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

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

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

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

501.62 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	4038525
Annual	Border regions	Baseline projections	Total	Females	Person	Belgium	2019	4262842
Annual	Border regions	Baseline projections	Total	Females	Person	Bulgaria	2019	1799911
Annual	Border regions	Baseline projections	Total	Females	Person	Switzerland	2019	3921943
Annual	Border regions	Baseline projections	Total	Females	Person	Czechia	2019	4734983
Annual	Border regions	Baseline projections	Total	Females	Person	Germany	2019	10100633
Annual	Border regions	Baseline projections	Total	Females	Person	Denmark	2019	361417
Annual	Border regions	Baseline projections	Total	Females	Person	Estonia	2019	315577
Annual	Border regions	Baseline projections	Total	Females	Person	Greece	2019	674679
Annual	Border regions	Baseline projections	Total	Females	Person	Spain	2019	4545745


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.