Mean Annual Holidays By Economic Activity, Sex, Employment Contract

Eurostat code: earn_ses_agt43 · (2002 - 2002)

@eurostat.earn_ses_agt43

Table List

2 tables(29.21 KB)

Mean Annual Holidays By Economic Activity, Sex, Employment Contract - Raw

Mean Annual Holidays By Economic Activity, Sex, Employment Contract - Unpivoted

Mean Annual Holidays By Economic Activity, Sex, Employment Contract - Unpivoted

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

14.89 KB
6983 rows
8 columns

freq Freq	nace_r1 Nace R1	emp_cont Emp Cont	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Apprentice or trainee	Day	Females	Euro area - 12 countries (2001-2006)	2002	28
Annual	Mining and quarrying	Apprentice or trainee	Day	Females	European Union - 15 countries (1995-2004)	2002	28
Annual	Mining and quarrying	Apprentice or trainee	Day	Females	European Union - 25 countries (2004-2006)	2002	28
Annual	Mining and quarrying	Apprentice or trainee	Day	Males	Euro area - 12 countries (2001-2006)	2002	30
Annual	Mining and quarrying	Apprentice or trainee	Day	Males	European Union - 15 countries (1995-2004)	2002	30
Annual	Mining and quarrying	Apprentice or trainee	Day	Males	European Union - 25 countries (2004-2006)	2002	30
Annual	Mining and quarrying	Apprentice or trainee	Day	Total	Euro area - 12 countries (2001-2006)	2002	30
Annual	Mining and quarrying	Apprentice or trainee	Day	Total	European Union - 15 countries (1995-2004)	2002	30
Annual	Mining and quarrying	Apprentice or trainee	Day	Total	European Union - 25 countries (2004-2006)	2002	30
Annual	Mining and quarrying	Limited duration except apprentice and trainee	Day	Females	Austria	2002	25


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

Share link

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