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 - Unpivoted

@eurostat.migr_asyappctzm.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

15.4 MB
92854724 rows
9 columns

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


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

Share link

Anyone who has the link will be able to view this.