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

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

713.51 KB
2502344 rows
9 columns

freq Freq	decision Decision	citizen Citizen	duration Duration	reason Reason	unit Unit	geo Geo	time_period Time Period
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Bulgaria	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Estonia	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Spain	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Finland	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	France	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Croatia	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Italy	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Lithuania	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Latvia	2019
Annual	Decision to grant	Andorra	From 181 to 360 days	Au pairing	Number	Malta	2019


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

Share link

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