Assumptions For Net Migration By Age, Sex And Type Of Projection

Eurostat code: proj_19nanmig · (2019 - 2100)

@eurostat.proj_19nanmig

Table List

2 tables(8.77 MB)

Assumptions For Net Migration By Age, Sex And Type Of Projection - Raw

Assumptions For Net Migration By Age, Sex And Type Of Projection - Unpivoted

Assumptions For Net Migration By Age, Sex And Type Of Projection - Unpivoted

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

4.33 MB
2333556 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	25154
Annual	Baseline projections	Person	Females	Total	Belgium	2019	22638
Annual	Baseline projections	Person	Females	Total	Bulgaria	2019	-1337
Annual	Baseline projections	Person	Females	Total	Switzerland	2019	11773
Annual	Baseline projections	Person	Females	Total	Cyprus	2019	3180
Annual	Baseline projections	Person	Females	Total	Czechia	2019	15415
Annual	Baseline projections	Person	Females	Total	Germany	2019	162162
Annual	Baseline projections	Person	Females	Total	Denmark	2019	-493
Annual	Baseline projections	Person	Females	Total	Estonia	2019	2197
Annual	Baseline projections	Person	Females	Total	Greece	2019	723


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.