Final Decisions In Appeal Or Review On Applications By Type Of Decision, Citizenship, Age And Sex - Annual Data

Eurostat code: migr_asydcfina · (2008 - 2024)

@eurostat.migr_asydcfina

Table List

2 tables(7.76 MB)

Final Decisions In Appeal Or Review On Applications By Type Of Decision, Citizenship, Age And Sex - Annual Data - Raw

Final Decisions In Appeal Or Review On Applications By Type Of Decision, Citizenship, Age And Sex - Annual Data - Unpivoted

Final Decisions In Appeal Or Review On Applications By Type Of Decision, Citizenship, Age And Sex - Annual Data - Unpivoted

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

3.2 MB
20762341 rows
9 columns

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


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

Share link

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