Dataset: Persons Subject Of Asylum Applications Pending At The End Of The Month By Citizenship, Age And Sex - Monthly Data

About this Dataset

Persons Subject Of Asylum Applications Pending At The End Of The Month By Citizenship, Age And Sex - Monthly Data

This Eurostat dataset contains data on persons subject of asylum applications pending at the end of the month by citizenship, age and sex - 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: 2025-06-06T23:00:00+0200

Tables

Persons Subject Of Asylum Applications Pending At The End Of The Month By Citizenship, Age And Sex - Monthly Data - Raw

@eurostat.migr_asypenctzm.raw

15.6 MB
224128 rows
215 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "citizen" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "geo" VARCHAR,
  "n_2008_01" DOUBLE,
  "n_2008_02" DOUBLE,
  "n_2008_03" DOUBLE,
  "n_2008_04" DOUBLE,
  "n_2008_05" DOUBLE,
  "n_2008_06" DOUBLE,
  "n_2008_07" DOUBLE,
  "n_2008_08" DOUBLE,
  "n_2008_09" DOUBLE,
  "n_2008_10" DOUBLE,
  "n_2008_11" DOUBLE,
  "n_2008_12" DOUBLE,
  "n_2009_01" DOUBLE,
  "n_2009_02" DOUBLE,
  "n_2009_03" DOUBLE,
  "n_2009_04" DOUBLE,
  "n_2009_05" DOUBLE,
  "n_2009_06" DOUBLE,
  "n_2009_07" DOUBLE,
  "n_2009_08" DOUBLE,
  "n_2009_09" DOUBLE,
  "n_2009_10" DOUBLE,
  "n_2009_11" DOUBLE,
  "n_2009_12" DOUBLE,
  "n_2010_01" DOUBLE,
  "n_2010_02" DOUBLE,
  "n_2010_03" DOUBLE,
  "n_2010_04" DOUBLE,
  "n_2010_05" DOUBLE,
  "n_2010_06" DOUBLE,
  "n_2010_07" DOUBLE,
  "n_2010_08" DOUBLE,
  "n_2010_09" DOUBLE,
  "n_2010_10" DOUBLE,
  "n_2010_11" DOUBLE,
  "n_2010_12" DOUBLE,
  "n_2011_01" DOUBLE,
  "n_2011_02" DOUBLE,
  "n_2011_03" DOUBLE,
  "n_2011_04" DOUBLE,
  "n_2011_05" DOUBLE,
  "n_2011_06" DOUBLE,
  "n_2011_07" DOUBLE,
  "n_2011_08" DOUBLE,
  "n_2011_09" DOUBLE,
  "n_2011_10" DOUBLE,
  "n_2011_11" DOUBLE,
  "n_2011_12" DOUBLE,
  "n_2012_01" DOUBLE,
  "n_2012_02" DOUBLE,
  "n_2012_03" DOUBLE,
  "n_2012_04" DOUBLE,
  "n_2012_05" DOUBLE,
  "n_2012_06" DOUBLE,
  "n_2012_07" DOUBLE,
  "n_2012_08" DOUBLE,
  "n_2012_09" DOUBLE,
  "n_2012_10" DOUBLE,
  "n_2012_11" DOUBLE,
  "n_2012_12" DOUBLE,
  "n_2013_01" DOUBLE,
  "n_2013_02" DOUBLE,
  "n_2013_03" DOUBLE,
  "n_2013_04" DOUBLE,
  "n_2013_05" DOUBLE,
  "n_2013_06" DOUBLE,
  "n_2013_07" DOUBLE,
  "n_2013_08" DOUBLE,
  "n_2013_09" DOUBLE,
  "n_2013_10" DOUBLE,
  "n_2013_11" DOUBLE,
  "n_2013_12" DOUBLE,
  "n_2014_01" DOUBLE,
  "n_2014_02" DOUBLE,
  "n_2014_03" DOUBLE,
  "n_2014_04" DOUBLE,
  "n_2014_05" DOUBLE,
  "n_2014_06" DOUBLE,
  "n_2014_07" DOUBLE,
  "n_2014_08" DOUBLE,
  "n_2014_09" DOUBLE,
  "n_2014_10" DOUBLE,
  "n_2014_11" DOUBLE,
  "n_2014_12" DOUBLE,
  "n_2015_01" DOUBLE,
  "n_2015_02" DOUBLE,
  "n_2015_03" DOUBLE,
  "n_2015_04" DOUBLE,
  "n_2015_05" DOUBLE,
  "n_2015_06" DOUBLE,
  "n_2015_07" DOUBLE,
  "n_2015_08" DOUBLE,
  "n_2015_09" DOUBLE,
  "n_2015_10" DOUBLE
);

Persons Subject Of Asylum Applications Pending At The End Of The Month By Citizenship, Age And Sex - Monthly Data - Unpivoted

@eurostat.migr_asypenctzm.tidy

13.53 MB
41675490 rows
8 columns


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