Mean Annual Holidays By Size Of The Enterprise, Sex, Occupation
Eurostat code: earn_ses_agt46 ยท (2002 - 2002)
@eurostat.earn_ses_agt46
Mean Annual Holidays By Size Of The Enterprise, Sex, Occupation - Unpivoted
@eurostat.earn_ses_agt46.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.
- 13.5 KB
- 7627 rows
- 8 columns
freqFreq | sizeclasSizeclas | isco88Isco88 | unitUnit | sexSex | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|---|
| Annual | From 10 to 49 employees | Armed forces | Day | Females | Norway | 2002 | 23 |
| Annual | From 10 to 49 employees | Armed forces | Day | Males | Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) | 2002 | 25 |
| Annual | From 10 to 49 employees | Armed forces | Day | Males | Euro area - 12 countries (2001-2006) | 2002 | 25 |
| Annual | From 10 to 49 employees | Armed forces | Day | Males | European Union - 15 countries (1995-2004) | 2002 | 25 |
| Annual | From 10 to 49 employees | Armed forces | Day | Males | European Union - 25 countries (2004-2006) | 2002 | 25 |
| Annual | From 10 to 49 employees | Armed forces | Day | Males | Netherlands | 2002 | 25 |
| Annual | From 10 to 49 employees | Armed forces | Day | Males | Norway | 2002 | 20 |
| Annual | From 10 to 49 employees | Armed forces | Day | Total | Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023) | 2002 | 25 |
| Annual | From 10 to 49 employees | Armed forces | Day | Total | Euro area - 12 countries (2001-2006) | 2002 | 25 |
| Annual | From 10 to 49 employees | Armed forces | Day | Total | European Union - 15 countries (1995-2004) | 2002 | 25 |
CREATE TABLE tidy (
"freq" VARCHAR,
"sizeclas" VARCHAR,
"isco88" VARCHAR,
"unit" VARCHAR,
"sex" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);