Asylum Applicants Considered To Be Unaccompanied Minors By Citizenship, Age And Sex - Annual Data

Eurostat code: migr_asyunaa · (2008 - 2024)

@eurostat.migr_asyunaa

Table List

2 tables(790.25 KB)

Asylum Applicants Considered To Be Unaccompanied Minors By Citizenship, Age And Sex - Annual Data - Raw

Asylum Applicants Considered To Be Unaccompanied Minors By Citizenship, Age And Sex - Annual Data - Unpivoted

Asylum Applicants Considered To Be Unaccompanied Minors By Citizenship, Age And Sex - Annual Data - Unpivoted

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

333.37 KB
2261733 rows
8 columns

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


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

Share link

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