First-time Asylum Applicants - % Of Total Asylum Applicants

Eurostat code: migr_asyapp1pc · (2008 - 2024)

@eurostat.migr_asyapp1pc

Table List

2 tables(21.96 KB)

First-time Asylum Applicants - % Of Total Asylum Applicants - Raw

First-time Asylum Applicants - % Of Total Asylum Applicants - Unpivoted

First-time Asylum Applicants - % Of Total Asylum Applicants - Unpivoted

@eurostat.migr_asyapp1pc.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.

5.87 KB
484 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Percentage	Belgium	2008	73.2
Annual	Percentage	Switzerland	2008	91.4
Annual	Percentage	Cyprus	2008	100
Annual	Percentage	Czechia	2008	63.7
Annual	Percentage	Germany	2008	79.4
Annual	Percentage	Denmark	2008	100
Annual	Percentage	Estonia	2008	100
Annual	Percentage	Ireland	2008	98.5
Annual	Percentage	Italy	2008	100
Annual	Percentage	Latvia	2008	94.4


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

Share link

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