Baselight
Sign In

Resettled Persons By Age, Sex, Citizenship And Decision - Annual Data

Eurostat code: migr_asyresda ยท (2021 - 2024)

@eurostat.migr_asyresda

Resettled Persons By Age, Sex, Citizenship And Decision - Annual Data - Unpivoted
@eurostat.migr_asyresda.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.

  • 410.13 KB
  • 4103916 rows
  • 9 columns
freq

Freq

unit

Unit

decision

Decision

citizen

Citizen

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPersonGeneva Convention statusAndorraFemalesTotalAustria2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalBelgium2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalBulgaria2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalSwitzerland2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalCyprus2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalCzechia2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalGermany2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalDenmark2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalEstonia2021
AnnualPersonGeneva Convention statusAndorraFemalesTotalGreece2021

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "decision" 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.