Decisions Withdrawing Status Granted At First Instance Decision By Type Of Status Withdrawn, Citizenship And Reason - Annual Aggregated Data

Eurostat code: migr_asywitfsta · (2008 - 2024)

@eurostat.migr_asywitfsta

Table List

2 tables(394.47 KB)

Decisions Withdrawing Status Granted At First Instance Decision By Type Of Status Withdrawn, Citizenship And Reason - Annual Aggregated Data - Raw

Decisions Withdrawing Status Granted At First Instance Decision By Type Of Status Withdrawn, Citizenship And Reason - Annual Aggregated Data - Unpivoted

Decisions Withdrawing Status Granted At First Instance Decision By Type Of Status Withdrawn, Citizenship And Reason - Annual Aggregated Data - Unpivoted

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

147.61 KB
822725 rows
8 columns

freq Freq	unit Unit	citizen Citizen	reason Reason	decision Decision	geo Geo	time_period Time Period
Annual	Person	Andorra	Total	Geneva Convention status	Austria	2008
Annual	Person	Andorra	Total	Geneva Convention status	Belgium	2008
Annual	Person	Andorra	Total	Geneva Convention status	Bulgaria	2008
Annual	Person	Andorra	Total	Geneva Convention status	Switzerland	2008
Annual	Person	Andorra	Total	Geneva Convention status	Czechia	2008
Annual	Person	Andorra	Total	Geneva Convention status	Germany	2008
Annual	Person	Andorra	Total	Geneva Convention status	Estonia	2008
Annual	Person	Andorra	Total	Geneva Convention status	Greece	2008
Annual	Person	Andorra	Total	Geneva Convention status	Spain	2008
Annual	Person	Andorra	Total	Geneva Convention status	France	2008


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

Share link

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