Decisions Withdrawing Status Granted As Final Decision In Appeal Or Review By Type Of Status Withdrawn, Citizenship And Reason - Annual Data

Eurostat code: migr_asywitfina · (2008 - 2024)

@eurostat.migr_asywitfina

Table List

2 tables(353.38 KB)

Decisions Withdrawing Status Granted As Final Decision In Appeal Or Review By Type Of Status Withdrawn, Citizenship And Reason - Annual Data - Raw

Decisions Withdrawing Status Granted As Final Decision In Appeal Or Review By Type Of Status Withdrawn, Citizenship And Reason - Annual Data - Unpivoted

Decisions Withdrawing Status Granted As Final Decision In Appeal Or Review By Type Of Status Withdrawn, Citizenship And Reason - Annual Data - Unpivoted

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

122.28 KB
800204 rows
8 columns

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


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

Share link

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