Authorisations For Study And Research By Reason, Type Of Decision, Citizenship And Length Of Validity

Eurostat code: migr_ressrath · (2019 - 2023)

@eurostat.migr_ressrath

Table List

2 tables(1.69 MB)

Authorisations For Study And Research By Reason, Type Of Decision, Citizenship And Length Of Validity - Raw

Authorisations For Study And Research By Reason, Type Of Decision, Citizenship And Length Of Validity - Unpivoted

Authorisations For Study And Research By Reason, Type Of Decision, Citizenship And Length Of Validity - Raw

@eurostat.migr_ressrath.raw

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

1012.08 KB
742584 rows
12 columns

freq Freq	decision Decision	citizen Citizen	duration Duration	reason Reason	unit Unit	geo Geo
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Austria
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Belgium
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Bulgaria
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Switzerland
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Cyprus
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Czechia
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Germany
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Denmark
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Estonia
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "decision" VARCHAR,
  "citizen" VARCHAR,
  "duration" VARCHAR,
  "reason" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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.