Authorisations Issued For The Purpose Of Seasonal Work By Economic Sector, Sex And Citizenship

Eurostat code: migr_ressw2 · (2017 - 2023)

@eurostat.migr_ressw2

Table List

2 tables(857.4 KB)

Authorisations Issued For The Purpose Of Seasonal Work By Economic Sector, Sex And Citizenship - Raw

Authorisations Issued For The Purpose Of Seasonal Work By Economic Sector, Sex And Citizenship - Unpivoted

Authorisations Issued For The Purpose Of Seasonal Work By Economic Sector, Sex And Citizenship - Raw

@eurostat.migr_ressw2.raw

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

558.37 KB
491368 rows
13 columns

freq Freq	sex Sex	citizen Citizen	nace_r2 Nace R2	unit Unit	geo Geo
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Austria
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Belgium
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Bulgaria
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Switzerland
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Cyprus
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Czechia
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Germany
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Denmark
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Estonia
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "sex" 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.