Population On 1 January By Age Group, Sex And Citizenship

Eurostat code: migr_pop1ctz$dv_1764

@eurostat.migr_pop1ctz_dv_1764

Table List

2 tables(991.24 KB)

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

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

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

@eurostat.migr_pop1ctz_dv_1764.raw

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

517.22 KB
11009 rows
16 columns

freq Freq	citizen Citizen	age Age	unit Unit	sex Sex	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
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Austria				325577	343490	360534	378663	396247	411982
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Belgium				424893	431107	439888	449197	456913	466883
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Switzerland				605152	612668	619698	628151	640271	650331
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Cyprus								50835	49692
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Czechia				80250	84610	89666	94146	73027	78104
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Germany							2032300	2078973	2112125
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Denmark				85997	90561	95231	98694	101275	109139
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Estonia				6110	6944	7631	7464	7574	7977
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Greece								106108	74121
Annual	EU27 countries (from 2020) except reporting country	Total	Number	Females	Spain	798830	780625	774701	771835	777613	790533	807626	813720	823430


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

Share link

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