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

Eurostat code: urt_proj_19ranmig · (2019 - 2100)

@eurostat.urt_proj_19ranmig

Table List

2 tables(737.46 KB)

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

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

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

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

288.29 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	23826
Annual	Border regions	Baseline projections	Total	Females	Person	Belgium	2019	14379
Annual	Border regions	Baseline projections	Total	Females	Person	Bulgaria	2019	-4692
Annual	Border regions	Baseline projections	Total	Females	Person	Switzerland	2019	10824
Annual	Border regions	Baseline projections	Total	Females	Person	Czechia	2019	9316
Annual	Border regions	Baseline projections	Total	Females	Person	Germany	2019	37720
Annual	Border regions	Baseline projections	Total	Females	Person	Denmark	2019	-638
Annual	Border regions	Baseline projections	Total	Females	Person	Estonia	2019	-712
Annual	Border regions	Baseline projections	Total	Females	Person	Greece	2019	1114
Annual	Border regions	Baseline projections	Total	Females	Person	Spain	2019	25125


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.