Labour Cost Index By NACE Rev. 1.1 Activity - Nominal Value, Quarterly Data

Eurostat code: lc_lci_r1_q · (1996-Q1 - 2008-Q4)

@eurostat.lc_lci_r1_q

Table List

2 tables(2.2 MB)

Labour Cost Index By NACE Rev. 1.1 Activity - Nominal Value, Quarterly Data - Raw

Labour Cost Index By NACE Rev. 1.1 Activity - Nominal Value, Quarterly Data - Unpivoted

Labour Cost Index By NACE Rev. 1.1 Activity - Nominal Value, Quarterly Data - Unpivoted

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

1.03 MB
617566 rows
8 columns

freq Freq	s_adj S Adj	unit Unit	nace_r1 Nace R1	lcstruct Lcstruct	geo Geo	time_period Time Period	value Value
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Austria	1996-Q1	86.7
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Belgium	1996-Q1	83.8
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Cyprus	1996-Q1	65.4
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Czechia	1996-Q1	61.3
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	1996-Q1	81.9
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Euro area - 12 countries (2001-2006)	1996-Q1	81.4
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Euro area - 13 countries (2007)	1996-Q1	81.1
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Euro area - 15 countries (2008)	1996-Q1	81.1
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Euro area - 16 countries (2009-2010)	1996-Q1	80.9
Quarterly	Calendar adjusted data, not seasonally adjusted data	Index, 2000=100	Mining and quarrying	Wages and salaries (total)	Estonia	1996-Q1	54.4


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

Share link

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