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

Eurostat code: migr_asywitfstq · (2008-Q1 - 2025-Q1)

@eurostat.migr_asywitfstq

Table List

2 tables(1.24 MB)

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

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

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

@eurostat.migr_asywitfstq.raw

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

815.15 KB
136784 rows
75 columns

freq Freq	unit Unit	citizen Citizen	reason Reason	decision Decision	geo Geo
Quarterly	Person	Andorra	Total	Geneva Convention status	Austria
Quarterly	Person	Andorra	Total	Geneva Convention status	Belgium
Quarterly	Person	Andorra	Total	Geneva Convention status	Bulgaria
Quarterly	Person	Andorra	Total	Geneva Convention status	Switzerland
Quarterly	Person	Andorra	Total	Geneva Convention status	Cyprus
Quarterly	Person	Andorra	Total	Geneva Convention status	Czechia
Quarterly	Person	Andorra	Total	Geneva Convention status	Germany
Quarterly	Person	Andorra	Total	Geneva Convention status	Denmark
Quarterly	Person	Andorra	Total	Geneva Convention status	Estonia
Quarterly	Person	Andorra	Total	Geneva Convention status	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "citizen" VARCHAR,
  "reason" VARCHAR,
  "decision" VARCHAR,
  "geo" VARCHAR,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE,
  "n_2015_q3" DOUBLE,
  "n_2015_q4" DOUBLE,
  "n_2016_q1" DOUBLE,
  "n_2016_q2" DOUBLE,
  "n_2016_q3" DOUBLE,
  "n_2016_q4" DOUBLE,
  "n_2017_q1" DOUBLE,
  "n_2017_q2" DOUBLE,
  "n_2017_q3" DOUBLE,
  "n_2017_q4" DOUBLE,
  "n_2018_q1" DOUBLE,
  "n_2018_q2" DOUBLE,
  "n_2018_q3" DOUBLE,
  "n_2018_q4" DOUBLE,
  "n_2019_q1" DOUBLE,
  "n_2019_q2" DOUBLE,
  "n_2019_q3" DOUBLE,
  "n_2019_q4" DOUBLE,
  "n_2020_q1" DOUBLE,
  "n_2020_q2" DOUBLE,
  "n_2020_q3" DOUBLE,
  "n_2020_q4" DOUBLE,
  "n_2021_q1" DOUBLE,
  "n_2021_q2" DOUBLE,
  "n_2021_q3" DOUBLE,
  "n_2021_q4" DOUBLE,
  "n_2022_q1" DOUBLE,
  "n_2022_q2" DOUBLE,
  "n_2022_q3" DOUBLE,
  "n_2022_q4" DOUBLE,
  "n_2023_q1" DOUBLE,
  "n_2023_q2" DOUBLE,
  "n_2023_q3" DOUBLE,
  "n_2023_q4" DOUBLE,
  "n_2024_q1" DOUBLE,
  "n_2024_q2" DOUBLE,
  "n_2024_q3" DOUBLE,
  "n_2024_q4" DOUBLE,
  "n_2025_q1" DOUBLE
);