Structure Of Earnings Survey: Hourly Earnings

Eurostat code: earn_ses_hourly · (2002 - 2022)

@eurostat.earn_ses_hourly

Table List

2 tables(25.99 MB)

Structure Of Earnings Survey: Hourly Earnings - Raw

Structure Of Earnings Survey: Hourly Earnings - Unpivoted

Structure Of Earnings Survey: Hourly Earnings - Raw

@eurostat.earn_ses_hourly.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

13.38 MB
1803549 rows
14 columns

freq Freq	nace_r2 Nace R2	isco08 Isco08	worktime Worktime	age Age	sex Sex	indic_se Indic Se	geo Geo	n_2006 2006	n_2018 2018
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	Euro area - 17 countries (2011-2013)		15.85
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	Euro area - 18 countries (2014)		15.85
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	Euro area - 19 countries (2015-2022)		15.85
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	European Union - 27 countries (2007-2013)		15.85
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	European Union - 27 countries (from 2020)	14.23	15.85
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	Italy
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	Norway		20.4
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in euro	Slovenia
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in PPS	Euro area - 17 countries (2011-2013)		14.92
Annual	Industry and construction	Armed forces occupations	Full-time	Total	Females	First decile earnings in PPS	Euro area - 18 countries (2014)		14.94


CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "isco08" VARCHAR,
  "worktime" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "indic_se" VARCHAR,
  "geo" VARCHAR,
  "n_2002" DOUBLE,
  "n_2006" DOUBLE,
  "n_2010" DOUBLE,
  "n_2014" DOUBLE,
  "n_2018" DOUBLE,
  "n_2022" DOUBLE
);

Share link

Anyone who has the link will be able to view this.