Mean Hourly Earnings By Economic Activity, Collective Pay Agreement, Sex

Eurostat code: earn_ses06_12 · (2006 - 2006)

@eurostat.earn_ses06_12

Table List

2 tables(342.48 KB)

Mean Hourly Earnings By Economic Activity, Collective Pay Agreement, Sex - Raw

Mean Hourly Earnings By Economic Activity, Collective Pay Agreement, Sex - Unpivoted

Mean Hourly Earnings By Economic Activity, Collective Pay Agreement, Sex - Unpivoted

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

168.34 KB
65152 rows
10 columns

freq Freq	nace_r1 Nace R1	sizeclas Sizeclas	unit Unit	cpayagr Cpayagr	indic_se Indic Se	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Belgium	2006	14.84
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Bulgaria	2006	1.52
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Czechia	2006	4.14
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Germany	2006	21.78
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Euro area - 13 countries (2007)	2006	16.56
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Euro area - 16 countries (2009-2010)	2006	11.39
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Estonia	2006	2.52
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Spain	2006	12.66
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	European Union - 25 countries (2004-2006)	2006	6.72
Annual	Mining and quarrying	10 employees or more	Euro	Enterprise or single-employer agreement	Gross earnings	Females	European Union - 27 countries (2007-2013)	2006	5.05


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "sizeclas" VARCHAR,
  "unit" VARCHAR,
  "cpayagr" 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.