First Instance Decisions On Applications By Type Of Decision, Citizenship, Age And Sex - Quarterly Data

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

@eurostat.migr_asydcfstq

Table List

2 tables(29.31 MB)

First Instance Decisions On Applications By Type Of Decision, Citizenship, Age And Sex - Quarterly Data - Raw

First Instance Decisions On Applications By Type Of Decision, Citizenship, Age And Sex - Quarterly Data - Unpivoted

First Instance Decisions On Applications By Type Of Decision, Citizenship, Age And Sex - Quarterly Data - Raw

@eurostat.migr_asydcfstq.raw

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

16.95 MB
1344768 rows
76 columns

freq Freq	unit Unit	citizen Citizen	sex Sex	age Age	decision Decision	geo Geo
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Austria
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Belgium
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Bulgaria
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Switzerland
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Cyprus
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Czechia
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Germany
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Denmark
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Estonia
Quarterly	Person	Andorra	Females	Total	Geneva Convention status	Greece


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