Asylum Applicants By Citizenship - Annual Data (until 2007)

Eurostat code: migr_asyctz · (1985 - 2007)

@eurostat.migr_asyctz

Table List

2 tables(164.65 KB)

Asylum Applicants By Citizenship - Annual Data (until 2007) - Raw

Asylum Applicants By Citizenship - Annual Data (until 2007) - Unpivoted

Asylum Applicants By Citizenship - Annual Data (until 2007) - Unpivoted

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

71.87 KB
62549 rows
6 columns

freq Freq	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Andorra	Person	Austria	1985
Annual	Andorra	Person	Luxembourg	1985
Annual	United Arab Emirates	Person	Austria	1985
Annual	United Arab Emirates	Person	Luxembourg	1985
Annual	Afghanistan	Person	Austria	1985	35
Annual	Afghanistan	Person	Germany	1985	2630
Annual	Afghanistan	Person	Luxembourg	1985
Annual	Afghanistan	Person	Netherlands	1985	135
Annual	Afghanistan	Person	United Kingdom	1985	45
Annual	Africa	Person	Austria	1985	25


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.