Baselight
Sign In

Mean Hourly Earnings By Economic Activity, Sex, Length Of Service With The Enterprise

Eurostat code: earn_ses06_17 ยท (2006 - 2006)

@eurostat.earn_ses06_17

Mean Hourly Earnings By Economic Activity, Sex, Length Of Service With The Enterprise - Unpivoted
@eurostat.earn_ses06_17.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.

  • 293.74 KB
  • 121206 rows
  • 10 columns
freq

Freq

nace_r1

Nace R1

sizeclas

Sizeclas

unit

Unit

l_serv

L Serv

indic_se

Indic Se

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesAustria200612.67
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesBelgium200615.81
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesBulgaria20061.4
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesCyprus20067.97
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesCzechia20063.93
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesDenmark200633.47
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesEuro area - 13 countries (2007)200613.61
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesEuro area - 16 countries (2009-2010)200612.8
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesEstonia20062.6
AnnualMining and quarrying10 employees or moreEuroTotalGross earningsFemalesGreece20066.64

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