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

Eurostat code: migr_asyumacta · (2018 - 2024)

@eurostat.migr_asyumacta

Table List

2 tables(620.21 KB)

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

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

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

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

198.93 KB
1399602 rows
9 columns

freq Freq	applicant Applicant	unit Unit	citizen Citizen	sex Sex	age Age	geo Geo	time_period Time Period
Annual	First time applicant	Person	Andorra	Females	Unknown	Belgium	2018
Annual	First time applicant	Person	Andorra	Females	Unknown	Germany	2018
Annual	First time applicant	Person	Andorra	Females	Unknown	Ireland	2018
Annual	First time applicant	Person	Andorra	Females	Unknown	Norway	2018
Annual	First time applicant	Person	Andorra	Females	From 14 to 17 years	Belgium	2018
Annual	First time applicant	Person	Andorra	Females	From 14 to 17 years	Germany	2018
Annual	First time applicant	Person	Andorra	Females	From 14 to 17 years	Ireland	2018
Annual	First time applicant	Person	Andorra	Females	From 14 to 17 years	Norway	2018
Annual	First time applicant	Person	Andorra	Females	Less than 14 years	Belgium	2018
Annual	First time applicant	Person	Andorra	Females	Less than 14 years	Germany	2018


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

Share link

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