Mean Monthly Hours Paid By Sex, Occupation And Size Class Of The Enterprise (2022)

Eurostat code: earn_ses22_39 · (2022 - 2022)

@eurostat.earn_ses22_39

Table List

2 tables(48.76 KB)

Mean Monthly Hours Paid By Sex, Occupation And Size Class Of The Enterprise (2022) - Raw

Mean Monthly Hours Paid By Sex, Occupation And Size Class Of The Enterprise (2022) - Unpivoted

Mean Monthly Hours Paid By Sex, Occupation And Size Class Of The Enterprise (2022) - Unpivoted

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

24.39 KB
9620 rows
9 columns

freq Freq	sex Sex	indic_se Indic Se	sizeclas Sizeclas	isco08 Isco08	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Hours paid	From 1 to 9 employees	Managers	Number	Bulgaria	2022	132
Annual	Females	Hours paid	From 1 to 9 employees	Managers	Number	Switzerland	2022	139
Annual	Females	Hours paid	From 1 to 9 employees	Managers	Number	Germany	2022	122
Annual	Females	Hours paid	From 1 to 9 employees	Managers	Number	Spain	2022	156
Annual	Females	Hours paid	From 1 to 9 employees	Managers	Number	Lithuania	2022	129
Annual	Females	Hours paid	From 1 to 9 employees	Managers	Number	Latvia	2022	86
Annual	Females	Hours paid	From 1 to 9 employees	Managers	Number	Norway	2022	143
Annual	Females	Hours paid	From 1 to 9 employees	Non manual workers	Number	Bulgaria	2022	144
Annual	Females	Hours paid	From 1 to 9 employees	Non manual workers	Number	Switzerland	2022	106
Annual	Females	Hours paid	From 1 to 9 employees	Non manual workers	Number	Cyprus	2022	151


CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "indic_se" VARCHAR,
  "sizeclas" VARCHAR,
  "isco08" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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