Baselight

Asylum Applications Of Unaccompanied Minors Withdrawn By Citizenship, Age, Sex And Type Of Withdrawal - Annual Aggregated Data

Eurostat code: migr_asyumwita ยท (2018 - 2024)

@eurostat.migr_asyumwita

Asylum Applications Of Unaccompanied Minors Withdrawn By Citizenship, Age, Sex And Type Of Withdrawal - Annual Aggregated Data - Unpivoted
@eurostat.migr_asyumwita.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.

  • 213.66 KB
  • 1753775 rows
  • 9 columns
freq

Freq

withdraw

Withdraw

unit

Unit

citizen

Citizen

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualExplicitPersonAndorraFemalesUnknownSweden2018
AnnualExplicitPersonAndorraFemalesFrom 14 to 17 yearsSweden2018
AnnualExplicitPersonAndorraFemalesLess than 14 yearsSweden2018
AnnualExplicitPersonAndorraFemalesLess than 18 yearsSweden2018
AnnualExplicitPersonAndorraMalesUnknownSweden2018
AnnualExplicitPersonAndorraMalesFrom 14 to 17 yearsSweden2018
AnnualExplicitPersonAndorraMalesLess than 14 yearsSweden2018
AnnualExplicitPersonAndorraMalesLess than 18 yearsSweden2018
AnnualExplicitPersonAndorraTotalUnknownSweden2018
AnnualExplicitPersonAndorraTotalFrom 14 to 17 yearsSweden2018

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

Share link

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