Name: Decisions On Asylum Applications By Citizenship (until December 2007) - Monthly Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Decisions On Asylum Applications By Citizenship (until December 2007) - Monthly Data

This Eurostat dataset contains data on decisions on asylum applications by citizenship (until december 2007) - monthly data, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2022-07-04T23:00:00+0200

Tables

Decisions On Asylum Applications By Citizenship (until December 2007) - Monthly Data - Raw

@eurostat.migr_asydctzm.raw

893.95 KB
41527 rows
77 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "decision" VARCHAR,
  "citizen" VARCHAR,
  "geo" VARCHAR,
  "n_2002_01" DOUBLE,
  "n_2002_02" DOUBLE,
  "n_2002_03" DOUBLE,
  "n_2002_04" DOUBLE,
  "n_2002_05" DOUBLE,
  "n_2002_06" DOUBLE,
  "n_2002_07" DOUBLE,
  "n_2002_08" DOUBLE,
  "n_2002_09" DOUBLE,
  "n_2002_10" DOUBLE,
  "n_2002_11" DOUBLE,
  "n_2002_12" DOUBLE,
  "n_2003_01" DOUBLE,
  "n_2003_02" DOUBLE,
  "n_2003_03" DOUBLE,
  "n_2003_04" DOUBLE,
  "n_2003_05" DOUBLE,
  "n_2003_06" DOUBLE,
  "n_2003_07" DOUBLE,
  "n_2003_08" DOUBLE,
  "n_2003_09" DOUBLE,
  "n_2003_10" DOUBLE,
  "n_2003_11" DOUBLE,
  "n_2003_12" DOUBLE,
  "n_2004_01" DOUBLE,
  "n_2004_02" DOUBLE,
  "n_2004_03" DOUBLE,
  "n_2004_04" DOUBLE,
  "n_2004_05" DOUBLE,
  "n_2004_06" DOUBLE,
  "n_2004_07" DOUBLE,
  "n_2004_08" DOUBLE,
  "n_2004_09" DOUBLE,
  "n_2004_10" DOUBLE,
  "n_2004_11" DOUBLE,
  "n_2004_12" DOUBLE,
  "n_2005_01" DOUBLE,
  "n_2005_02" DOUBLE,
  "n_2005_03" DOUBLE,
  "n_2005_04" DOUBLE,
  "n_2005_05" DOUBLE,
  "n_2005_06" DOUBLE,
  "n_2005_07" DOUBLE,
  "n_2005_08" DOUBLE,
  "n_2005_09" DOUBLE,
  "n_2005_10" DOUBLE,
  "n_2005_11" DOUBLE,
  "n_2005_12" DOUBLE,
  "n_2006_01" DOUBLE,
  "n_2006_02" DOUBLE,
  "n_2006_03" DOUBLE,
  "n_2006_04" DOUBLE,
  "n_2006_05" DOUBLE,
  "n_2006_06" DOUBLE,
  "n_2006_07" DOUBLE,
  "n_2006_08" DOUBLE,
  "n_2006_09" DOUBLE,
  "n_2006_10" DOUBLE,
  "n_2006_11" DOUBLE,
  "n_2006_12" DOUBLE,
  "n_2007_01" DOUBLE,
  "n_2007_02" DOUBLE,
  "n_2007_03" DOUBLE,
  "n_2007_04" DOUBLE,
  "n_2007_05" DOUBLE,
  "n_2007_06" DOUBLE,
  "n_2007_07" DOUBLE,
  "n_2007_08" DOUBLE,
  "n_2007_09" DOUBLE,
  "n_2007_10" DOUBLE,
  "n_2007_11" DOUBLE,
  "n_2007_12" DOUBLE
);

Decisions On Asylum Applications By Citizenship (until December 2007) - Monthly Data - Unpivoted

@eurostat.migr_asydctzm.tidy

656.76 KB
2338193 rows
7 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "decision" VARCHAR,
  "citizen" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);