First Time Asylum Applicants By Citizenship - Monthly Data (until December 2007)

Eurostat code: migr_asyctzm · (1999-01 - 2007-12)

@eurostat.migr_asyctzm

Table List

2 tables(535.94 KB)

First Time Asylum Applicants By Citizenship - Monthly Data (until December 2007) - Raw

First Time Asylum Applicants By Citizenship - Monthly Data (until December 2007) - Unpivoted

First Time Asylum Applicants By Citizenship - Monthly Data (until December 2007) - Raw

@eurostat.migr_asyctzm.raw

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

342.18 KB
5853 rows
112 columns
Only the first 100 columns are shown

freq Freq	unit Unit	citizen Citizen	geo Geo
Monthly	Person	Andorra	Austria
Monthly	Person	Andorra	Belgium
Monthly	Person	Andorra	Bulgaria
Monthly	Person	Andorra	Cyprus
Monthly	Person	Andorra	Czechia
Monthly	Person	Andorra	Germany
Monthly	Person	Andorra	Denmark
Monthly	Person	Andorra	Estonia
Monthly	Person	Andorra	Greece
Monthly	Person	Andorra	Spain


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "citizen" VARCHAR,
  "geo" VARCHAR,
  "n_1999_01" DOUBLE,
  "n_1999_02" DOUBLE,
  "n_1999_03" DOUBLE,
  "n_1999_04" DOUBLE,
  "n_1999_05" DOUBLE,
  "n_1999_06" DOUBLE,
  "n_1999_07" DOUBLE,
  "n_1999_08" DOUBLE,
  "n_1999_09" DOUBLE,
  "n_1999_10" DOUBLE,
  "n_1999_11" DOUBLE,
  "n_1999_12" DOUBLE,
  "n_2000_01" DOUBLE,
  "n_2000_02" DOUBLE,
  "n_2000_03" DOUBLE,
  "n_2000_04" DOUBLE,
  "n_2000_05" DOUBLE,
  "n_2000_06" DOUBLE,
  "n_2000_07" DOUBLE,
  "n_2000_08" DOUBLE,
  "n_2000_09" DOUBLE,
  "n_2000_10" DOUBLE,
  "n_2000_11" DOUBLE,
  "n_2000_12" DOUBLE,
  "n_2001_01" DOUBLE,
  "n_2001_02" DOUBLE,
  "n_2001_03" DOUBLE,
  "n_2001_04" DOUBLE,
  "n_2001_05" DOUBLE,
  "n_2001_06" DOUBLE,
  "n_2001_07" DOUBLE,
  "n_2001_08" DOUBLE,
  "n_2001_09" DOUBLE,
  "n_2001_10" DOUBLE,
  "n_2001_11" DOUBLE,
  "n_2001_12" DOUBLE,
  "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
);