Labour Cost Index By NACE Rev. 1.1 Activity - Item Weights

Eurostat code: lc_lci_r1_itw · (1996 - 2008)

@eurostat.lc_lci_r1_itw

Table List

2 tables(162.62 KB)

Labour Cost Index By NACE Rev. 1.1 Activity - Item Weights - Raw

Labour Cost Index By NACE Rev. 1.1 Activity - Item Weights - Unpivoted

Labour Cost Index By NACE Rev. 1.1 Activity - Item Weights - Unpivoted

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

59.34 KB
19784 rows
6 columns

freq Freq	lcstruct Lcstruct	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Wages and salaries (total)	Mining and quarrying	Austria	1996	3.6
Annual	Wages and salaries (total)	Mining and quarrying	Belgium	1996	1.4
Annual	Wages and salaries (total)	Mining and quarrying	Bulgaria	1996	40.1
Annual	Wages and salaries (total)	Mining and quarrying	Cyprus	1996	4.2
Annual	Wages and salaries (total)	Mining and quarrying	Czechia	1996	28
Annual	Wages and salaries (total)	Mining and quarrying	Germany	1996	7.9
Annual	Wages and salaries (total)	Mining and quarrying	Denmark	1996	5.1
Annual	Wages and salaries (total)	Mining and quarrying	Estonia	1996	30.9
Annual	Wages and salaries (total)	Mining and quarrying	Greece	1996	15.4
Annual	Wages and salaries (total)	Mining and quarrying	Spain	1996	10.6


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

Share link

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