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

Eurostat code: proj_19ranmig3 · (2019 - 2100)

@eurostat.proj_19ranmig3

Table List

2 tables(72.62 MB)

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

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

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

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

40.47 MB
30511872 rows
8 columns

freq Freq	projection Projection	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Baseline projections	Total	Females	Person	Mittelburgenland	2019	98
Annual	Baseline projections	Total	Females	Person	Nordburgenland	2019	861
Annual	Baseline projections	Total	Females	Person	Südburgenland	2019	233
Annual	Baseline projections	Total	Females	Person	Mostviertel-Eisenwurzen	2019	351
Annual	Baseline projections	Total	Females	Person	Niederösterreich-Süd	2019	792
Annual	Baseline projections	Total	Females	Person	Sankt Pölten	2019	547
Annual	Baseline projections	Total	Females	Person	Waldviertel	2019	191
Annual	Baseline projections	Total	Females	Person	Weinviertel	2019	374
Annual	Baseline projections	Total	Females	Person	Wiener Umland/Nordteil	2019	1696
Annual	Baseline projections	Total	Females	Person	Wiener Umland/Südteil	2019	1769


CREATE TABLE tidy (
  "freq" 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.