Baselight
Sign In

First Instance Decisions On Applications Of Unaccompanied Minors By Type Of Decision, Citizenship, Age And Sex - Annual Aggregated Data

Eurostat code: migr_asyumdcfa ยท (2021 - 2024)

@eurostat.migr_asyumdcfa

First Instance Decisions On Applications Of Unaccompanied Minors By Type Of Decision, Citizenship, Age And Sex - Annual Aggregated Data - Unpivoted
@eurostat.migr_asyumdcfa.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.

  • 250.04 KB
  • 2309244 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 statusUnknownDenmark2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownEstonia2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownGreece2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownSpain2021
AnnualPersonAndorraFemalesGeneva Convention statusUnknownEuropean Union - 27 countries (from 2020)2021

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.