Labour Cost Index By NACE Rev. 2 Activity - Nominal Value, Annual Data

Eurostat code: lc_lci_r2_a · (1996 - 2024)

@eurostat.lc_lci_r2_a

Table List

2 tables(842.62 KB)

Labour Cost Index By NACE Rev. 2 Activity - Nominal Value, Annual Data - Raw

Labour Cost Index By NACE Rev. 2 Activity - Nominal Value, Annual Data - Unpivoted

Labour Cost Index By NACE Rev. 2 Activity - Nominal Value, Annual Data - Unpivoted

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

399.82 KB
228531 rows
7 columns

freq Freq	unit Unit	nace_r2 Nace R2	lcstruct Lcstruct	geo Geo	time_period Time Period	value Value
Annual	Index, 2016=100	Mining and quarrying	Wages and salaries (total)	Norway	1996	20
Annual	Index, 2016=100	Mining and quarrying	Labour costs other than wages and salaries	Norway	1996	47.3
Annual	Index, 2016=100	Mining and quarrying	Labour cost for LCI excluding bonuses	Norway	1996	24.2
Annual	Index, 2016=100	Industry (except construction)	Wages and salaries (total)	Norway	1996	29.5
Annual	Index, 2016=100	Industry (except construction)	Labour costs other than wages and salaries	Norway	1996	56
Annual	Index, 2016=100	Industry (except construction)	Labour cost for LCI (compensation of employees plus taxes minus subsidies)	Norway	1996	32.9
Annual	Index, 2016=100	Industry (except construction)	Labour cost for LCI excluding bonuses	Norway	1996	32.9
Annual	Index, 2016=100	Industry and construction	Wages and salaries (total)	Norway	1996	31.9
Annual	Index, 2016=100	Industry and construction	Labour costs other than wages and salaries	Norway	1996	56
Annual	Index, 2016=100	Industry and construction	Labour cost for LCI (compensation of employees plus taxes minus subsidies)	Norway	1996	34.9


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

Share link

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