Immigration By Age, Sex And Group Of Citizenship

Eurostat code: migr_imm2ctz · (1998 - 2023)

@eurostat.migr_imm2ctz

Table List

2 tables(3.18 MB)

Immigration By Age, Sex And Group Of Citizenship - Raw

Immigration By Age, Sex And Group Of Citizenship - Unpivoted

Immigration By Age, Sex And Group Of Citizenship - Raw

@eurostat.migr_imm2ctz.raw

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

1.65 MB
68011 rows
33 columns

freq Freq	age Age	agedef Agedef	citizen Citizen	unit Unit	sex Sex	geo Geo	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Austria	28638	35797		34825	39696	44245	48664	45613	38905	31751	32405	29420	30323	34895	39238	43786	48788	65441	55097	48739	45444	46329	42715	46214	97378	64503
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Belgium	29382	33021	31296	39605	40608	40118	42604	48787	49847	52652			57172	62255	54994	51411	51236	56379	50222	51820	55655	59833	47172	55678	93814	71027
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Bulgaria										25					3346	5544	7295	6276	5522	5844	5960	6588	6190	6852	8357	18085
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Switzerland	36508		42245				49223	47344	50424	65014	73807	65680	66023	59482	59265	64459	62616	61336	59968	57238	57673	57407	53380	57705	66610	117356
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Cyprus												11965	10556	11702	9631	7852	6434	7243	7794	10531	11001	11244	9572	12979	17286	19850
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Czechia				4835	16532	19171	17793	21663	25362	39916	31183	20973	13116	8184	12156	10735	10201	10685	25494	19222	24054	37307	23423	25160	199366	72472
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Germany	238298	276749	265996	281414	276097	252963	249470	239173	224185	230914	228943	123805	142589	172174	214641	254772	315637	527015	400525	338557	322159	312937	245256	307908	970170	512028
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Denmark	14307	14210	15492	16939	15616	13857	14175	15060	16449	19902	17840	16624	16972	16872	17495	19812	22295	26358	25669	23501	21507	19945	18014	21351	54839	38385
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Estonia							331	369	625	822	771	859	489	724	494	718	506	2823	2937	3297	3601	4119	3727	4702	24324	9576
Annual	Total	Age in completed years	Foreign country and stateless	Number	Females	Greece											19970	16750	16250	15286	14805	14490	13742	15315	32809	29993	32372	33479	27754	10743	29978	25912


CREATE TABLE raw (
  "freq" VARCHAR,
  "age" VARCHAR,
  "agedef" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);