All Valid Permits By Reason, Length Of Validity And Citizenship On 31 December Of Each Year

Eurostat code: migr_resvalid · (2008 - 2023)

@eurostat.migr_resvalid

Table List

2 tables(4.65 MB)

All Valid Permits By Reason, Length Of Validity And Citizenship On 31 December Of Each Year - Raw

All Valid Permits By Reason, Length Of Validity And Citizenship On 31 December Of Each Year - Unpivoted

All Valid Permits By Reason, Length Of Validity And Citizenship On 31 December Of Each Year - Unpivoted

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

2.4 MB
1232021 rows
8 columns

freq Freq	duration Duration	reason Reason	unit Unit	citizen Citizen	geo Geo	time_period Time Period	value Value
Annual	From 3 to 5 months	Education reasons	Person	United Arab Emirates	Germany	2008	10
Annual	From 3 to 5 months	Education reasons	Person	United Arab Emirates	Ireland	2008	5
Annual	From 3 to 5 months	Education reasons	Person	United Arab Emirates	Italy	2008	1
Annual	From 3 to 5 months	Education reasons	Person	Afghanistan	Czechia	2008	1
Annual	From 3 to 5 months	Education reasons	Person	Afghanistan	Germany	2008	23
Annual	From 3 to 5 months	Education reasons	Person	Afghanistan	Ireland	2008	1
Annual	From 3 to 5 months	Education reasons	Person	Afghanistan	Italy	2008	11
Annual	From 3 to 5 months	Education reasons	Person	Afghanistan	Netherlands	2008	1
Annual	From 3 to 5 months	Education reasons	Person	Afghanistan	Romania	2008	1
Annual	From 3 to 5 months	Education reasons	Person	Albania	Cyprus	2008	4


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

Share link

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