Asylum Applications Withdrawn By Citizenship, Age, Sex And Type Of Withdrawal - Annual Aggregated Data

Eurostat code: migr_asywitha · (2008 - 2024)

@eurostat.migr_asywitha

Table List

2 tables(2.84 MB)

Asylum Applications Withdrawn By Citizenship, Age, Sex And Type Of Withdrawal - Annual Aggregated Data - Raw

Asylum Applications Withdrawn By Citizenship, Age, Sex And Type Of Withdrawal - Annual Aggregated Data - Unpivoted

Asylum Applications Withdrawn By Citizenship, Age, Sex And Type Of Withdrawal - Annual Aggregated Data - Unpivoted

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

1.13 MB
6069518 rows
9 columns

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


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

Share link

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