Baselight
Sign In

Mean Hourly Earnings By Size Of The Enterprise, Sex, Occupation

Eurostat code: earn_ses_agt18 ยท (2002 - 2002)

@eurostat.earn_ses_agt18

Mean Hourly Earnings By Size Of The Enterprise, Sex, Occupation - Unpivoted
@eurostat.earn_ses_agt18.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.

  • 131.25 KB
  • 38899 rows
  • 9 columns
freq

Freq

sizeclas

Sizeclas

unit

Unit

isco88

Isco88

indic_se

Indic Se

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsFemalesNorway200221.04
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsMalesEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)200216.36
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsMalesEuropean Union - 15 countries (1995-2004)200216.36
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsMalesEuropean Union - 25 countries (2004-2006)200216.36
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsMalesNetherlands200216.36
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsMalesNorway200220.09
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsTotalEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)200216.36
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsTotalEuropean Union - 15 countries (1995-2004)200216.36
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsTotalEuropean Union - 25 countries (2004-2006)200216.36
AnnualFrom 10 to 49 employeesEuroArmed forcesGross earningsTotalNetherlands200216.36

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