Baselight
Sign In

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

Eurostat code: migr_pop6ctb ยท (2009 - 2024)

@eurostat.migr_pop6ctb

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

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

  • 980.83 KB
  • 86752 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

AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesAustria
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesBelgium61098
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesSwitzerland7814
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesDenmark1
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesEstonia
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesFinland
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesHungary
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesIreland42222
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesIceland1
AnnualAndorraEU27 countries (2007-2013) except reporting countryNumberFemalesLiechtenstein

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.