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

Eurostat code: earn_ses_agt12 · (2002 - 2002)

@eurostat.earn_ses_agt12

Table List

2 tables(280.56 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_ses_agt12.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.

140.58 KB
38971 rows
9 columns

freq Freq	nace_r1 Nace R1	unit Unit	cpayagr Cpayagr	indic_se Indic Se	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Belgium	2002	15.56
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Bulgaria	2002	1.06
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Czechia	2002	2.53
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Germany	2002	14.51
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2002	11.69
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Euro area - 12 countries (2001-2006)	2002	11.68
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Estonia	2002	1.54
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Greece	2002	8.72
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	Spain	2002	11.4
Annual	Mining and quarrying	Euro	Enterprise or single-employer agreement	Gross earnings	Females	European Union - 15 countries (1995-2004)	2002	11.86


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