Mean Hourly Earnings By Size Class Of The Enterprise, Sex, Occupation

Eurostat code: earn_ses06_18 · (2006 - 2006)

@eurostat.earn_ses06_18

Table List

2 tables(192.83 KB)

Mean Hourly Earnings By Size Class Of The Enterprise, Sex, Occupation - Raw

Mean Hourly Earnings By Size Class Of The Enterprise, Sex, Occupation - Unpivoted

Mean Hourly Earnings By Size Class Of The Enterprise, Sex, Occupation - Unpivoted

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

96.43 KB
33539 rows
9 columns

freq Freq	sizeclas Sizeclas	unit Unit	isco88 Isco88	indic_se Indic Se	sex Sex	geo Geo	time_period Time Period	value Value
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Females	Euro area - 13 countries (2007)	2006	8.79
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Females	Euro area - 16 countries (2009-2010)	2006	8.79
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Females	European Union - 15 countries (1995-2004)	2006	8.79
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Females	European Union - 25 countries (2004-2006)	2006	8.79
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Females	European Union - 27 countries (2007-2013)	2006	8.79
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Males	Euro area - 13 countries (2007)	2006	13.47
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Males	Euro area - 16 countries (2009-2010)	2006	11.68
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Males	European Union - 15 countries (1995-2004)	2006	11.68
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Males	European Union - 25 countries (2004-2006)	2006	13.56
Annual	From 10 to 49 employees	Euro	Armed forces	Gross earnings	Males	European Union - 27 countries (2007-2013)	2006	13.47


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

Share link

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