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

About this Dataset

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

This Eurostat dataset contains data on first time asylum applicants by citizenship - monthly data (until december 2007), 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

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

@eurostat.migr_asyctzm.raw

342.18 KB
5853 rows
112 columns


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

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

@eurostat.migr_asyctzm.tidy

193.76 KB
476614 rows
6 columns


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