Baselight
Sign In

Median Hourly Earnings, All Employees (excluding Apprentices) By Sex

Eurostat code: earn_ses_pub2s$dv_1879

@eurostat.earn_ses_pub2s_dv_1879

Median Hourly Earnings, All Employees (excluding Apprentices) By Sex - Unpivoted
@eurostat.earn_ses_pub2s_dv_1879.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.

  • 8.67 KB
  • 558 rows
  • 7 columns
freq

Freq

sizeclas

Sizeclas

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual10 employees or moreFemalesEuroAustria20069.75
Annual10 employees or moreFemalesEuroBelgium200613.76
Annual10 employees or moreFemalesEuroBulgaria20060.79
Annual10 employees or moreFemalesEuroCyprus20067.09
Annual10 employees or moreFemalesEuroCzechia20063.15
Annual10 employees or moreFemalesEuroGermany200613.19
Annual10 employees or moreFemalesEuroDenmark200619.37
Annual10 employees or moreFemalesEuroEuro area - 17 countries (2011-2013)200611.31
Annual10 employees or moreFemalesEuroEstonia20062.54
Annual10 employees or moreFemalesEuroGreece20066.94

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