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

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

299.03 KB
2143602 rows
8 columns

freq Freq	sex Sex	citizen Citizen	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Czechia	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Germany	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Estonia	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Greece	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Spain	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	France	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Croatia	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Hungary	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Italy	2017
Annual	Females	Andorra	Agriculture, forestry and fishing	Number	Lithuania	2017


CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "citizen" VARCHAR,
  "nace_r2" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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