Net Migration By Age And Sex

Eurostat code: migr_netmigr · (2013 - 2023)

@eurostat.migr_netmigr

Table List

2 tables(645.06 KB)

Net Migration By Age And Sex - Unpivoted

Net Migration By Age And Sex - Unpivoted

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

289.14 KB
135206 rows
8 columns

freq Freq	agedef Agedef	age Age	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Age in completed years	Total	Number	Females	Austria	2013	23809
Annual	Age in completed years	Total	Number	Females	Belgium	2013	14646
Annual	Age in completed years	Total	Number	Females	Bulgaria	2013	-1763
Annual	Age in completed years	Total	Number	Females	Switzerland	2013	29021
Annual	Age in completed years	Total	Number	Females	Cyprus	2013	-3780
Annual	Age in completed years	Total	Number	Females	Czechia	2013	1598
Annual	Age in completed years	Total	Number	Females	Germany	2013	187769
Annual	Age in completed years	Total	Number	Females	Denmark	2013	7653
Annual	Age in completed years	Total	Number	Females	Estonia	2013	-1723
Annual	Age in completed years	Total	Number	Females	Greece	2013	-15504


CREATE TABLE tidy (
  "freq" VARCHAR,
  "agedef" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.