Authorisations For The Purpose Of Seasonal Work By Status, Length Of Validity, Economic Sector And Citizenship

Eurostat code: migr_ressw1_1 · (2017 - 2023)

@eurostat.migr_ressw1_1

Table List

2 tables(2.6 MB)

Authorisations For The Purpose Of Seasonal Work By Status, Length Of Validity, Economic Sector And Citizenship - Raw

Authorisations For The Purpose Of Seasonal Work By Status, Length Of Validity, Economic Sector And Citizenship - Unpivoted

Authorisations For The Purpose Of Seasonal Work By Status, Length Of Validity, Economic Sector And Citizenship - Raw

@eurostat.migr_ressw1_1.raw

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

1.84 MB
1542192 rows
14 columns

freq Freq	duration Duration	decision Decision	citizen Citizen	nace_r2 Nace R2	unit Unit	geo Geo
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Austria
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Belgium
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Bulgaria
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Switzerland
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Cyprus
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Czechia
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Germany
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Denmark
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Estonia
Annual	From 1 to 90 days	Decision to grant	Andorra	Agriculture, forestry and fishing	Number	Greece


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