Asylum Applications By State Of Procedure by Eurostat | Demographics and Population Studies

About this Dataset

Asylum Applications By State Of Procedure

This Eurostat dataset contains data on asylum applications by state of procedure, 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-05-13T23:00:00+0200

Tables

Asylum Applications By State Of Procedure - Raw

@eurostat.sdg_10_60.raw

20.13 KB
66 rows
21 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "asyl_app" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Asylum Applications By State Of Procedure - Unpivoted

@eurostat.sdg_10_60.tidy

9.77 KB
1033 rows
6 columns


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