Labour Cost Levels By NACE Rev. 2 Activity

Eurostat code: lc_lci_lev · (2008 - 2024)

@eurostat.lc_lci_lev

Table List

2 tables(286.58 KB)

Labour Cost Levels By NACE Rev. 2 Activity - Raw

Labour Cost Levels By NACE Rev. 2 Activity - Unpivoted

Labour Cost Levels By NACE Rev. 2 Activity - Unpivoted

@eurostat.lc_lci_lev.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.

135.77 KB
68087 rows
7 columns

freq Freq	unit Unit	lcstruct Lcstruct	nace_r2 Nace R2	geo Geo	time_period Time Period	value Value
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Austria	2008	22.2
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Bulgaria	2008	3.3
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Cyprus	2008	14.7
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Czechia	2008	8.7
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Germany	2008	25.1
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Denmark	2008	33.7
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2008	18.3
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Euro area - 19 countries (2015-2022)	2008	20.6
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Euro area – 20 countries (from 2023)	2008	20.6
Annual	Euro	Wages and salaries (total)	Mining and quarrying	Estonia	2008	6.9


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "lcstruct" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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