Baselight
Sign In

Mean Monthly Earnings By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L

Eurostat code: earn_ses06_21 ยท (2006 - 2006)

@eurostat.earn_ses06_21

About this Dataset

Mean Monthly Earnings By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L

This Eurostat dataset contains data on mean monthly earnings by sex, age, occupation - nace rev. 1.1, c-o excluding l, as collected and published by the Statistical Office of the European Union.

Tables included:

  • raw: Original table as downloaded from Eurostat.
  • tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2017-01-31T23:00:00+0100

Tables

Mean Monthly Earnings By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L - Raw

@eurostat.earn_ses06_21.raw
  • 181.1 KB
  • 92036 rows
  • 9 columns
Loading...
 

CREATE TABLE raw (
  "freq" VARCHAR,
  "sizeclas" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "isco88" VARCHAR,
  "indic_se" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "n_2006" DOUBLE
);

Mean Monthly Earnings By Sex, Age, Occupation - NACE Rev. 1.1, C-O Excluding L - Unpivoted

@eurostat.earn_ses06_21.tidy
  • 176.92 KB
  • 81284 rows
  • 10 columns
Loading...
 

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