Median Hourly Earnings, All Employees (excluding Apprentices) By Economic Activity

Eurostat code: earn_ses_pub2n · (2010 - 2022)

@eurostat.earn_ses_pub2n

Table List

2 tables(75.63 KB)

Median Hourly Earnings, All Employees (excluding Apprentices) By Economic Activity - Raw

Median Hourly Earnings, All Employees (excluding Apprentices) By Economic Activity - Unpivoted

Median Hourly Earnings, All Employees (excluding Apprentices) By Economic Activity - Unpivoted

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

33.08 KB
8069 rows
7 columns

freq Freq	sizeclas Sizeclas	unit Unit	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	10 employees or more	Euro	Mining and quarrying	Austria	2010	13.9
Annual	10 employees or more	Euro	Mining and quarrying	Belgium	2010	16.78
Annual	10 employees or more	Euro	Mining and quarrying	Bulgaria	2010	2.63
Annual	10 employees or more	Euro	Mining and quarrying	Switzerland	2010	23.53
Annual	10 employees or more	Euro	Mining and quarrying	Cyprus	2010	11.01
Annual	10 employees or more	Euro	Mining and quarrying	Czechia	2010	5.99
Annual	10 employees or more	Euro	Mining and quarrying	Germany	2010	17.45
Annual	10 employees or more	Euro	Mining and quarrying	Denmark	2010	38
Annual	10 employees or more	Euro	Mining and quarrying	Euro area - 17 countries (2011-2013)	2010	14.66
Annual	10 employees or more	Euro	Mining and quarrying	Estonia	2010	5.53


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

Share link

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