Baselight
Sign In

First Permits Issued For Family Reasons By Reason, Length Of Validity And Citizenship

Eurostat code: migr_resfam ยท (2008 - 2023)

@eurostat.migr_resfam

First Permits Issued For Family Reasons By Reason, Length Of Validity And Citizenship - Raw
@eurostat.migr_resfam.raw

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

  • 2.28 MB
  • 217836 rows
  • 22 columns
freq

Freq

citizen

Citizen

reason

Reason

duration

Duration

unit

Unit

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

AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonAustria
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonBelgium11
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonBulgaria
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonSwitzerland111
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonCyprus
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonCzechia
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonGermany
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonDenmark
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonEstonia
AnnualAndorraFamily reasonsFrom 3 to 5 monthsPersonGreece

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