Population On 1 January By Age, Sex And Broad Group Of Citizenship

Eurostat code: migr_pop2ctz · (1998 - 2024)

@eurostat.migr_pop2ctz

Table List

2 tables(5.7 MB)

Population On 1 January By Age, Sex And Broad Group Of Citizenship - Raw

Population On 1 January By Age, Sex And Broad Group Of Citizenship - Unpivoted

Population On 1 January By Age, Sex And Broad Group Of Citizenship - Raw

@eurostat.migr_pop2ctz.raw

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

3.03 MB
45568 rows
33 columns

freq Freq	age Age	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	n_2024 2024
Annual	Total	Foreign country and stateless	Number	Females	Andorra									23832	24382
Annual	Total	Foreign country and stateless	Number	Females	Austria				336071	334982	346794	354948	366938	379174	385793	404159	421266	435114	451744	470822	496844	526542	562672	611580	646846	675046	697605	722254	743666	767225	843795	877037
Annual	Total	Foreign country and stateless	Number	Females	Belgium	430256	427146	431207	415543	409439	409501	417648	425152	441403	457726	476551	495325	518236	566190	583505	595324	605081	623726	646151	657466	668306	685832	703828	712512	729954	782547	803504
Annual	Total	Foreign country and stateless	Number	Females	Bulgaria											19982	20472	20945	21384	21734	23565	27057	32120	35817	38468	41672	45747	50383	54170	31892	39432	55578
Annual	Total	Foreign country and stateless	Number	Females	Switzerland	637966	644051	657379	667239	679555	694870	707938	719889	728418	733858	753425	783214	804844	828077	851545	876505	908577	937887	961890	984152	997717	1009948	1024511	1043026	1059781	1083564	1147204
Annual	Total	Foreign country and stateless	Number	Females	Cyprus												67426	89387	92180	94959	93722	92924	91230	89583	89806	92150	94953	96346	89370	92659	114608	119077
Annual	Total	Foreign country and stateless	Number	Females	Czechia			83916	68293	64423	71361	78095	81452	104722	119217	138555	162784	174375	176433	179606	181216	187538	196527	205060	220364	223540	239688	249456	221705	240293	429557	477450
Annual	Total	Foreign country and stateless	Number	Females	Germany	3268189	3341626	3375334	3370320	3414302	3453958	3481378	3483231	3243866	3498737	3529287	3511082	3498393	3057369	3151709	3280251	3440178	3659559	4047813	4310525	4531748	4735291	4901083	5008273	5171053	5520406	5769827
Annual	Total	Foreign country and stateless	Number	Females	Denmark	123918	128024	130601	130805	135316	135349	138311	136512	137872	141451	150715	160775	167332	175969	182613	190220	200915	211581	229333	238789	249080	258998	265385	267112	277175	310127	323762
Annual	Total	Foreign country and stateless	Number	Females	Estonia			134376									107020	105952	103180	102190	97743	96361	96926	96531	95551	95242	95451	95123	94871	95058	115789	121116


CREATE TABLE raw (
  "freq" VARCHAR,
  "age" 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,
  "n_2024" DOUBLE
);