Median Hourly Earnings, All Employees (excluding Apprentices) By Educational Attainment Level

Eurostat code: earn_ses_pub2i · (2006 - 2022)

@eurostat.earn_ses_pub2i

Table List

2 tables(34.52 KB)

Median Hourly Earnings, All Employees (excluding Apprentices) By Educational Attainment Level - Raw

Median Hourly Earnings, All Employees (excluding Apprentices) By Educational Attainment Level - Unpivoted

Median Hourly Earnings, All Employees (excluding Apprentices) By Educational Attainment Level - Unpivoted

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

15.6 KB
2245 rows
7 columns

freq Freq	sizeclas Sizeclas	isced11 Isced11	unit Unit	geo Geo	time_period Time Period	value Value
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Austria	2006	9.2
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Belgium	2006	12.41
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Bulgaria	2006	0.64
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Cyprus	2006	6.95
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Czechia	2006	2.63
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Germany	2006	11.13
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Denmark	2006	17.87
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Euro area - 17 countries (2011-2013)	2006	9.17
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Estonia	2006	2.21
Annual	10 employees or more	Less than primary, primary and lower secondary education (levels 0-2)	Euro	Greece	2006	6.5


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

Share link

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