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

Eurostat code: migr_immctzprv · (2015 - 2020)

@eurostat.migr_immctzprv

Table List

2 tables(162.88 KB)

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

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

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

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

70.77 KB
33358 rows
9 columns

freq Freq	age Age	citizen Citizen	partner Partner	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Austria	2015	40424
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Belgium	2015	26355
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Bulgaria	2015	330
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Germany	2015	180351
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Estonia	2015	1129
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Spain	2015	40246
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	France	2015	33302
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Croatia	2015	830
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Hungary	2015	4048
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Italy	2015	36859


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