Baselight
Sign In

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

Eurostat code: migr_asyumdcfna ยท (2021 - 2024)

@eurostat.migr_asyumdcfna

Final Decisions In Appeal Or Review On Applications Of Unaccompanied Minors By Type Of Decision, Citizenship, Age And Sex - Annual Data - Unpivoted
@eurostat.migr_asyumdcfna.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.

  • 201.92 KB
  • 2336488 rows
  • 9 columns
freq

Freq

unit

Unit

citizen

Citizen

sex

Sex

decision

Decision

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPersonAndorraFemalesGeneva Convention statusUnknownAustria2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownBelgium2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownBulgaria2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownSwitzerland2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownCzechia2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownGermany2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownDenmark2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownEstonia2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownGreece2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownSpain2021

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

Share link

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