Baselight
Sign In

Population On 1 January By Sex, Citizenship And Group Of Country Of Birth

Eurostat code: migr_pop5ctz ยท (2009 - 2024)

@eurostat.migr_pop5ctz

Population On 1 January By Sex, Citizenship And Group Of Country Of Birth - Raw
@eurostat.migr_pop5ctz.raw

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

  • 914.73 KB
  • 86493 rows
  • 22 columns
freq

Freq

c_birth

C Birth

citizen

Citizen

unit

Unit

sex

Sex

geo

Geo

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

AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesAustria1111
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesBelgium1
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesSwitzerland12
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesDenmark
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesEstonia
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesFinland
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesHungary
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesIreland
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesIceland1
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesLiechtenstein

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

Share link

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