Baselight
Sign In

Immigration By Sex, Country Of Birth And Group Of Citizenship

Eurostat code: migr_imm7ctb ยท (2008 - 2023)

@eurostat.migr_imm7ctb

Immigration By Sex, Country Of Birth And Group Of Citizenship - Raw
@eurostat.migr_imm7ctb.raw

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

  • 701.58 KB
  • 99107 rows
  • 22 columns
freq

Freq

citizen

Citizen

c_birth

C Birth

unit

Unit

sex

Sex

geo

Geo

n_2008

2008

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

AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesAustria
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesBelgium2
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesBulgaria
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesSwitzerland25
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 countryAndorraNumberFemalesCroatia
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesHungary
AnnualEU27 countries (2007-2013) except reporting countryAndorraNumberFemalesIceland1

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

Share link

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