Baselight
Sign In

Decisions Granting Temporary Protection By Citizenship, Age And Sex - Quarterly Data

Eurostat code: migr_asytpfq ยท (2022-Q1 - 2024-Q4)

@eurostat.migr_asytpfq

Decisions Granting Temporary Protection By Citizenship, Age And Sex - Quarterly Data - Unpivoted
@eurostat.migr_asytpfq.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.

  • 336.79 KB
  • 2391070 rows
  • 8 columns
freq

Freq

unit

Unit

citizen

Citizen

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

QuarterlyPersonAndorraFemalesTotalAustria2022-Q1
QuarterlyPersonAndorraFemalesTotalBelgium2022-Q1
QuarterlyPersonAndorraFemalesTotalBulgaria2022-Q1
QuarterlyPersonAndorraFemalesTotalSwitzerland2022-Q1
QuarterlyPersonAndorraFemalesTotalCyprus2022-Q1
QuarterlyPersonAndorraFemalesTotalCzechia2022-Q1
QuarterlyPersonAndorraFemalesTotalGermany2022-Q1
QuarterlyPersonAndorraFemalesTotalDenmark2022-Q1
QuarterlyPersonAndorraFemalesTotalEstonia2022-Q1
QuarterlyPersonAndorraFemalesTotalGreece2022-Q1

CREATE TABLE tidy (
  "freq" 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.