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

@eurostat.migr_asyappctza_dv_618.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

21.31 KB
204 rows
17 columns

freq Freq	citizen Citizen	sex Sex	unit Unit	age Age	asyl_app Asyl App	geo Geo	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023	n_2024 2024
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Austria	12650	5150	2185	805	1155	1520	5900	14120	6295	2070
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Belgium	4960	1905	1640	1900	2490	2160	3715	4635	3435	3570
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Bulgaria	2215	3010	505	515	535	820	2990	3275	3725	2585
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Switzerland	3810	2630	1170	800	980	970	1650	4480	5430	4000
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Cyprus	155	245	220	275	455	255	550	1105	970	810
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Czechia	40	55	40	40	45	10	25	40	40	20
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Germany	34580	66640	17525	12170	9795	7390	11315	16080	26090	22110
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Denmark	2485	1325	520	340	290	185	205	470	230	200
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Estonia	10	5	5	5	5			30	20	10
Annual	Extra-EU27 (from 2020)	Total	Person	From 14 to 17 years	Asylum applicant	Greece	785	4915	5445	5470	6945	3615	3790	4960	5150	6835


CREATE TABLE raw (
  "freq" VARCHAR,
  "citizen" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "age" VARCHAR,
  "asyl_app" VARCHAR,
  "geo" VARCHAR,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Share link

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