Asylum Applicants By Type, Citizenship, Age And Sex - Annual Aggregated Data

Eurostat code: migr_asyappctza · (2008 - 2024)

@eurostat.migr_asyappctza

Table List

2 tables(5.34 MB)

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

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

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

@eurostat.migr_asyappctza.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.

2.35 MB
7525048 rows
9 columns

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


CREATE TABLE tidy (
  "freq" VARCHAR,
  "citizen" VARCHAR,
  "sex" VARCHAR,
  "unit" 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.