Baselight

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

Eurostat code: migr_asyumwfna ยท (2021 - 2024)

@eurostat.migr_asyumwfna

Decisions Withdrawing Status Granted As Final Decision In Appeal Or Review To Unaccompanied Minors By Type Of Status Withdrawn, Citizenship And Reason - Annual Data - Unpivoted
@eurostat.migr_asyumwfna.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.

  • 58.27 KB
  • 501610 rows
  • 8 columns
freq

Freq

unit

Unit

citizen

Citizen

decision

Decision

reason

Reason

geo

Geo

time_period

Time Period

value

Value

AnnualPersonAndorraGeneva Convention statusTotalAustria2021
AnnualPersonAndorraGeneva Convention statusTotalBelgium2021
AnnualPersonAndorraGeneva Convention statusTotalBulgaria2021
AnnualPersonAndorraGeneva Convention statusTotalSwitzerland2021
AnnualPersonAndorraGeneva Convention statusTotalCyprus2021
AnnualPersonAndorraGeneva Convention statusTotalCzechia2021
AnnualPersonAndorraGeneva Convention statusTotalGermany2021
AnnualPersonAndorraGeneva Convention statusTotalDenmark2021
AnnualPersonAndorraGeneva Convention statusTotalEstonia2021
AnnualPersonAndorraGeneva Convention statusTotalGreece2021

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

Share link

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