Baselight

Decisions Withdrawing Status Granted At First Instance Decision By Type Of Status Withdrawn, Citizenship And Reason - Annual Aggregated Data

Eurostat code: migr_asywitfsta ยท (2008 - 2024)

@eurostat.migr_asywitfsta

Decisions Withdrawing Status Granted At First Instance Decision By Type Of Status Withdrawn, Citizenship And Reason - Annual Aggregated Data - Raw
@eurostat.migr_asywitfsta.raw

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

  • 246.86 KB
  • 136784 rows
  • 23 columns
freq

Freq

unit

Unit

citizen

Citizen

reason

Reason

decision

Decision

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

n_2024

2024

AnnualPersonAndorraTotalGeneva Convention statusAustria
AnnualPersonAndorraTotalGeneva Convention statusBelgium
AnnualPersonAndorraTotalGeneva Convention statusBulgaria
AnnualPersonAndorraTotalGeneva Convention statusSwitzerland
AnnualPersonAndorraTotalGeneva Convention statusCyprus
AnnualPersonAndorraTotalGeneva Convention statusCzechia
AnnualPersonAndorraTotalGeneva Convention statusGermany
AnnualPersonAndorraTotalGeneva Convention statusDenmark
AnnualPersonAndorraTotalGeneva Convention statusEstonia
AnnualPersonAndorraTotalGeneva Convention statusGreece

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

Share link

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