Asylum Applicants By Type, Citizenship, Age And Sex - Monthly Data

Eurostat code: migr_asyappctzm · (2008-01 - 2025-03)

@eurostat.migr_asyappctzm

Table List

2 tables(38.21 MB)

Asylum Applicants By Type, Citizenship, Age And Sex - Monthly Data - Raw

Asylum Applicants By Type, Citizenship, Age And Sex - Monthly Data - Unpivoted

Asylum Applicants By Type, Citizenship, Age And Sex - Monthly Data - Raw

@eurostat.migr_asyappctzm.raw

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

22.81 MB
665792 rows
214 columns
Only the first 100 columns are shown

freq Freq	unit Unit	citizen Citizen	sex Sex	age Age	asyl_app Asyl App	geo Geo
Monthly	Person	Andorra	Females	Total	Asylum applicant	Austria
Monthly	Person	Andorra	Females	Total	Asylum applicant	Belgium
Monthly	Person	Andorra	Females	Total	Asylum applicant	Bulgaria
Monthly	Person	Andorra	Females	Total	Asylum applicant	Switzerland
Monthly	Person	Andorra	Females	Total	Asylum applicant	Cyprus
Monthly	Person	Andorra	Females	Total	Asylum applicant	Czechia
Monthly	Person	Andorra	Females	Total	Asylum applicant	Germany
Monthly	Person	Andorra	Females	Total	Asylum applicant	Denmark
Monthly	Person	Andorra	Females	Total	Asylum applicant	Estonia
Monthly	Person	Andorra	Females	Total	Asylum applicant	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "citizen" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "asyl_app" 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
);