Population On 1 January By Broad Age Group, Sex And Other Typologies

Eurostat code: urt_pjanaggr3 · (1990 - 2023)

@eurostat.urt_pjanaggr3

Table List

2 tables(1.18 MB)

Population On 1 January By Broad Age Group, Sex And Other Typologies - Raw

Population On 1 January By Broad Age Group, Sex And Other Typologies - Unpivoted

Population On 1 January By Broad Age Group, Sex And Other Typologies - Raw

@eurostat.urt_pjanaggr3.raw

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

598.69 KB
8265 rows
39 columns

freq Freq	sex Sex	age Age	terrtypo Terrtypo	geo Geo	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	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	Females	Total	Border regions	Albania																							699565	691150	682896	674594	667871	665685	664529	662026	654079	550809	539409	530408
Annual	Females	Total	Border regions	Austria												3668647	3686523	3701996	3721402	3747501	3770825	3784505	3797968	3811219	3820387	2209882	3847476	3866928	3891616	3923237	3965374	3997043	4020181	4038525	4058957	2304760	2314056	2338941
Annual	Females	Total	Border regions	Belgium															3950559	3966884	3988342	4011606	4036444	4062141	4088250		4153834	4171468	4184801	4200636	4217292	4232479	4246611	4262842	4283314	3665848	3683366	3716943
Annual	Females	Total	Border regions	Bulgaria	2488410	2456325	2433309	2398809	2391825	2381844					2295878	2279550	2177266	2145986	2117517	2090770	2064462	2039399	2014576	1991762	1970672	1743964	1930976	1912428	1894616	1876840	1857756	1837300	1818574	1799911	1782913	1595629	1571673	1480534
Annual	Females	Total	Border regions	Switzerland	3130920	3168603	3204693	3232388	3258770	3280952	3300090	3307874	3312943	3324818	3340912	3237292	3382615	3407319	3428973	3450651	3468596	3488765	3521857	3565976	3602825	2957486	3672114	3706546	3749628	3792344	3830401	3867164	3895522	3921943	3948905	3244639	3269470	3296717
Annual	Females	Total	Border regions	Cyprus
Annual	Females	Total	Border regions	Czechia			4661638	4667699								4634090	4626146	4622770	4620985	4620619	4623822	4632407	4658950	4682918	4694074	3805633	4708558	4710480	4709451	4712645	4714733	4719190	4725301	4734983	4744952	3730283	3726280	3826776
Annual	Females	Total	Border regions	Germany																						6874197	9983874	9975990	9973497	9989840	10047282	10064293	10085506	10100633	10110925	6939320	6946883	7044706
Annual	Females	Total	Border regions	Denmark																		355132	356354	357937	357948	975631	358295	358107	357853	358000	359172	360505	361250	361417	361115	1047410	1052565	1065938
Annual	Females	Total	Border regions	Estonia											381550	378960	375400	371500	366230	361270	357250	352970	349610	346550	343450		335045	332093	327929	326130	323125	320201	317088	315577	313648	311456	312837	318190


CREATE TABLE raw (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "terrtypo" VARCHAR,
  "geo" VARCHAR,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "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
);