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

Eurostat code: migr_asyappctza$dv_618

@eurostat.migr_asyappctza_dv_618

Table List

2 tables(35.12 KB)

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_dv_618.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.

13.82 KB
1983 rows
9 columns

freq Freq	citizen Citizen	sex Sex	unit Unit	age Age	asyl_app Asyl App	geo Geo	time_period Time Period	value Value
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Austria	2015	12650
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Belgium	2015	4960
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Bulgaria	2015	2215
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Switzerland	2015	3810
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Cyprus	2015	155
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Czechia	2015	40
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Germany	2015	34580
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Denmark	2015	2485
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Estonia	2015	10
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Greece	2015	785


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.