Population On 1 January By Age Group, Sex And Level Of Human Development Of The Country Of Birth

Eurostat code: migr_pop8ctb · (2014 - 2024)

@eurostat.migr_pop8ctb

Table List

2 tables(2.79 MB)

Population On 1 January By Age Group, Sex And Level Of Human Development Of The Country Of Birth - Raw

Population On 1 January By Age Group, Sex And Level Of Human Development Of The Country Of Birth - Unpivoted

Population On 1 January By Age Group, Sex And Level Of Human Development Of The Country Of Birth - Raw

@eurostat.migr_pop8ctb.raw

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

1.46 MB
43004 rows
17 columns

freq Freq	age Age	c_birth C Birth	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
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Austria	156511	158207	160040	161756	163662	164472	165668
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Belgium	48174	48134	48254	48461	48810	49405	50026
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Switzerland	97327	99057	101115	103110	105092		109308
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Cyprus	324
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Czechia	1325		1508	1862	2014	2527	2775
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Germany	795777
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Denmark	17380	17525	17704	17898	18184	18446	18617
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Estonia	38	44	66	76	105	131	178
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Greece	27076
Annual	Total	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Number	Females	Spain	3700


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

Share link

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