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 - Raw

@eurostat.migr_resvalid.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

2.25 MB
158668 rows
22 columns

freq Freq	duration Duration	reason Reason	unit Unit	citizen Citizen	geo Geo	n_2013 2013	n_2017 2017
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Austria
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Belgium
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Bulgaria
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Switzerland		1
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Cyprus
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Czechia
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Germany	1
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Denmark
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Estonia
Annual	From 3 to 5 months	Education reasons	Person	Andorra	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "duration" VARCHAR,
  "reason" VARCHAR,
  "unit" VARCHAR,
  "citizen" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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