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

Eurostat code: migr_asydctzm · (2002-01 - 2007-12)

@eurostat.migr_asydctzm

Table List

2 tables(1.51 MB)

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

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

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

@eurostat.migr_asydctzm.raw

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

893.95 KB
41527 rows
77 columns

freq Freq	unit Unit	decision Decision	citizen Citizen	geo Geo	n_2005_01 2005-01
Monthly	Person	Applications pending at the end of the period	Andorra	Bulgaria
Monthly	Person	Applications pending at the end of the period	Andorra	Cyprus
Monthly	Person	Applications pending at the end of the period	Andorra	Czechia
Monthly	Person	Applications pending at the end of the period	Andorra	Germany	1705
Monthly	Person	Applications pending at the end of the period	Andorra	Denmark
Monthly	Person	Applications pending at the end of the period	Andorra	Estonia
Monthly	Person	Applications pending at the end of the period	Andorra	Greece
Monthly	Person	Applications pending at the end of the period	Andorra	Hungary
Monthly	Person	Applications pending at the end of the period	Andorra	Italy
Monthly	Person	Applications pending at the end of the period	Andorra	Lithuania


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
);