Baselight
Sign In

First-time Asylum Applicants - Per Hundred Thousand Persons, Monthly Data

Eurostat code: migr_asyapp1mpm ยท (2008-01 - 2025-01)

@eurostat.migr_asyapp1mpm

First-time Asylum Applicants - Per Hundred Thousand Persons, Monthly Data - Unpivoted
@eurostat.migr_asyapp1mpm.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.

  • 18.3 KB
  • 11372 rows
  • 6 columns
freq

Freq

statinfo

Statinfo

geo

Geo

unit

Unit

time_period

Time Period

value

Value

MonthlyValueBelgiumNumber per hundred thousand persons2008-0110
MonthlyValueSwitzerlandNumber per hundred thousand persons2008-0112
MonthlyValueCyprusNumber per hundred thousand persons2008-0132
MonthlyValueCzechiaNumber per hundred thousand persons2008-012
MonthlyValueGermanyNumber per hundred thousand persons2008-013
MonthlyValueDenmarkNumber per hundred thousand persons2008-014
MonthlyValueEstoniaNumber per hundred thousand persons2008-01
MonthlyValueIrelandNumber per hundred thousand persons2008-017
MonthlyValueItalyNumber per hundred thousand persons2008-012
MonthlyValueLatviaNumber per hundred thousand persons2008-01

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

Share link

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