Name: Average Gross Annual Earnings In Industry And Services, By Sex
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Average Gross Annual Earnings In Industry And Services, By Sex

This Eurostat dataset contains data on average gross annual earnings in industry and services, by sex, 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: 2023-12-22T11:00:00+0100

Tables

Average Gross Annual Earnings In Industry And Services, By Sex - Raw

@eurostat.tps00175.raw

9.79 kB
54 rows
11 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "sizeclas" VARCHAR,
  "worktime" VARCHAR,
  "sex" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE  -- 2008,
  "n_2009" DOUBLE  -- 2009,
  "n_2010" DOUBLE  -- 2010,
  "n_2011" DOUBLE  -- 2011
);

Average Gross Annual Earnings In Industry And Services, By Sex - Unpivoted

@eurostat.tps00175.tidy

8.57 kB
180 rows
9 columns

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