Baselight
Sign In

Beneficiaries Of Temporary Protection By Citizenship - Per Thousand Persons

Eurostat code: migr_asytpspop ยท (2022-03 - 2025-02)

@eurostat.migr_asytpspop

Beneficiaries Of Temporary Protection By Citizenship - Per Thousand Persons - Unpivoted
@eurostat.migr_asytpspop.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.

  • 16.16 KB
  • 3399 rows
  • 6 columns
freq

Freq

citizen

Citizen

unit

Unit

geo

Geo

time_period

Time Period

value

Value

MonthlyExtra-EU27 (from 2020)NumberBelgium2022-032.28
MonthlyExtra-EU27 (from 2020)NumberBulgaria2022-034.74
MonthlyExtra-EU27 (from 2020)NumberSwitzerland2022-031.73
MonthlyExtra-EU27 (from 2020)NumberCyprus2022-030.74
MonthlyExtra-EU27 (from 2020)NumberCzechia2022-0323.79
MonthlyExtra-EU27 (from 2020)NumberDenmark2022-030.21
MonthlyExtra-EU27 (from 2020)NumberEstonia2022-0310.37
MonthlyExtra-EU27 (from 2020)NumberGreece2022-03
MonthlyExtra-EU27 (from 2020)NumberSpain2022-030.69
MonthlyExtra-EU27 (from 2020)NumberFinland2022-030.51

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

Share link

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