Emigration By Age Group, Sex, Group Of Citizenship And Group Of Country Of Next Residence - Ad Hoc Data Collection (2015-2020)

Eurostat code: migr_emictznxt · (2015 - 2020)

@eurostat.migr_emictznxt

Table List

2 tables(149.92 KB)

Emigration By Age Group, Sex, Group Of Citizenship And Group Of Country Of Next Residence - Ad Hoc Data Collection (2015-2020) - Raw

Emigration By Age Group, Sex, Group Of Citizenship And Group Of Country Of Next Residence - Ad Hoc Data Collection (2015-2020) - Unpivoted

Emigration By Age Group, Sex, Group Of Citizenship And Group Of Country Of Next Residence - Ad Hoc Data Collection (2015-2020) - Unpivoted

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

65.02 KB
30924 rows
9 columns

freq Freq	age Age	citizen Citizen	partner Partner	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Austria	2015	20539
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Belgium	2015	13794
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Bulgaria	2015	117
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Germany	2015	41605
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Estonia	2015	784
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Spain	2015	43281
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Croatia	2015	129
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Hungary	2015	2830
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Italy	2015	11017
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Number	Females	Lithuania	2015	31


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "citizen" VARCHAR,
  "partner" 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.