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

Eurostat code: urt_pjangrp3 · (2014 - 2023)

@eurostat.urt_pjangrp3

Table List

2 tables(2.68 MB)

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

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

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

@eurostat.urt_pjangrp3.raw

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

1.36 MB
34677 rows
16 columns

freq Freq	unit Unit	sex Sex	age Age	terrtypo Terrtypo	geo Geo	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	Number	Females	Total	Border regions	Albania	597512	674594	667871	665685	664529	662026	654079	550809	539409	530408
Annual	Number	Females	Total	Border regions	Austria	2228363	3923237	3965374	3997043	4020181	4038525	4058957	2304760	2314056	2338941
Annual	Number	Females	Total	Border regions	Belgium	3581891	4200636	4217292	4232479	4246611	4262842	4283314	3665848	3683366	3716943
Annual	Number	Females	Total	Border regions	Bulgaria	1696146	1876840	1857756	1837300	1818574	1799911	1782913	1595629	1571673	1480534
Annual	Number	Females	Total	Border regions	Switzerland	3051852	3792344	3830401	3867164	3895522	3921943	3948905	3244639	3269470	3296717
Annual	Number	Females	Total	Border regions	Cyprus
Annual	Number	Females	Total	Border regions	Czechia	3792931	4712645	4714733	4719190	4725301	4734983	4744952	3730283	3726280	3826776
Annual	Number	Females	Total	Border regions	Germany	6850426	9989840	10047282	10064293	10085506	10100633	10110925	6939320	6946883	7044706
Annual	Number	Females	Total	Border regions	Denmark	999866	358000	359172	360505	361250	361417	361115	1047410	1052565	1065938
Annual	Number	Females	Total	Border regions	Estonia		326130	323125	320201	317088	315577	313648	311456	312837	318190


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "terrtypo" VARCHAR,
  "geo" VARCHAR,
  "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
);

Share link

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