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) - Raw

@eurostat.migr_immctzprv.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

92.11 KB
6072 rows
13 columns

freq Freq	age Age	citizen Citizen	partner Partner	sex Sex	unit Unit	geo Geo	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Austria	40424	37487	36832	36893	37761	35232
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Belgium	26355	24279	24657	25996	27351	23498
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Bulgaria	330	234	137	195	244	266
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Czechia						6748
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Germany	180351	156926	150155	139163	129522	118934
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Estonia	1129	1271	1595	1466	1379	1260
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Spain	40246	41442	48840	47811	46710	32576
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	France	33302	32667	30458	27443	29537	26747
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Croatia	830	878	799	846	878	1515
Annual	Total	EU27 countries (from 2020) except reporting country	EU27 countries (from 2020) except reporting country	Females	Number	Hungary	4048	4153	4405	4502	4465	7997


CREATE TABLE raw (
  "freq" VARCHAR,
  "age" VARCHAR,
  "citizen" VARCHAR,
  "partner" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE
);

Share link

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