Authorisations For Long-term Mobility Of Researchers By Reason, Type Of Decision, Citizenship And Length Of Validity

Eurostat code: migr_ressrltm · (2019 - 2023)

@eurostat.migr_ressrltm

Table List

2 tables(206.44 KB)

Authorisations For Long-term Mobility Of Researchers By Reason, Type Of Decision, Citizenship And Length Of Validity - Raw

Authorisations For Long-term Mobility Of Researchers By Reason, Type Of Decision, Citizenship And Length Of Validity - Unpivoted

Authorisations For Long-term Mobility Of Researchers By Reason, Type Of Decision, Citizenship And Length Of Validity - Unpivoted

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

65.22 KB
387953 rows
9 columns

freq Freq	reason Reason	decision Decision	duration Duration	citizen Citizen	unit Unit	geo Geo	time_period Time Period
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Austria	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Bulgaria	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Germany	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Croatia	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Italy	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Lithuania	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Latvia	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Malta	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Netherlands	2019
Annual	Family reasons	Decision to grant	From 181 to 360 days	Andorra	Number	Romania	2019


CREATE TABLE tidy (
  "freq" VARCHAR,
  "reason" VARCHAR,
  "decision" VARCHAR,
  "duration" 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.