Labour Cost Index, Nominal Value - Quarterly Data

Eurostat code: ei_lmlc_q · (1996-Q1 - 2024-Q4)

@eurostat.ei_lmlc_q

Table List

2 tables(7.39 MB)

Labour Cost Index, Nominal Value - Quarterly Data - Raw

Labour Cost Index, Nominal Value - Quarterly Data - Unpivoted

Labour Cost Index, Nominal Value - Quarterly Data - Raw

@eurostat.ei_lmlc_q.raw

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

3.8 MB
23127 rows
123 columns
Only the first 100 columns are shown

freq Freq	p_adj P Adj	unit Unit	s_adj S Adj	nace_r2 Nace R2	indic Indic	geo Geo	n_2000_q1 2000-Q1	n_2000_q2 2000-Q2	n_2000_q3 2000-Q3	n_2000_q4 2000-Q4	n_2001_q1 2001-Q1	n_2001_q2 2001-Q2	n_2001_q3 2001-Q3	n_2001_q4 2001-Q4	n_2002_q1 2002-Q1	n_2002_q2 2002-Q2	n_2002_q3 2002-Q3	n_2002_q4 2002-Q4	n_2003_q1 2003-Q1	n_2003_q2 2003-Q2	n_2003_q3 2003-Q3	n_2003_q4 2003-Q4	n_2004_q1 2004-Q1	n_2004_q2 2004-Q2	n_2004_q3 2004-Q3	n_2004_q4 2004-Q4	n_2005_q1 2005-Q1	n_2005_q2 2005-Q2	n_2005_q3 2005-Q3	n_2005_q4 2005-Q4	n_2006_q1 2006-Q1	n_2006_q2 2006-Q2	n_2006_q3 2006-Q3	n_2006_q4 2006-Q4	n_2007_q1 2007-Q1	n_2007_q2 2007-Q2	n_2007_q3 2007-Q3	n_2007_q4 2007-Q4	n_2008_q1 2008-Q1	n_2008_q2 2008-Q2	n_2008_q3 2008-Q3	n_2008_q4 2008-Q4	n_2009_q1 2009-Q1	n_2009_q2 2009-Q2	n_2009_q3 2009-Q3	n_2009_q4 2009-Q4	n_2010_q1 2010-Q1	n_2010_q2 2010-Q2	n_2010_q3 2010-Q3	n_2010_q4 2010-Q4	n_2011_q1 2011-Q1	n_2011_q2 2011-Q2	n_2011_q3 2011-Q3	n_2011_q4 2011-Q4	n_2012_q1 2012-Q1	n_2012_q2 2012-Q2	n_2012_q3 2012-Q3	n_2012_q4 2012-Q4	n_2013_q1 2013-Q1	n_2013_q2 2013-Q2	n_2013_q3 2013-Q3	n_2013_q4 2013-Q4	n_2014_q1 2014-Q1	n_2014_q2 2014-Q2	n_2014_q3 2014-Q3	n_2014_q4 2014-Q4	n_2015_q1 2015-Q1	n_2015_q2 2015-Q2	n_2015_q3 2015-Q3	n_2015_q4 2015-Q4	n_2016_q1 2016-Q1	n_2016_q2 2016-Q2	n_2016_q3 2016-Q3	n_2016_q4 2016-Q4	n_2017_q1 2017-Q1	n_2017_q2 2017-Q2	n_2017_q3 2017-Q3	n_2017_q4 2017-Q4	n_2018_q1 2018-Q1	n_2018_q2 2018-Q2	n_2018_q3 2018-Q3	n_2018_q4 2018-Q4	n_2019_q1 2019-Q1
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Austria	57.2	63.6	57.1	92.6	60.6	64.9	61.2	70.1	69.1	63.5	61.1	72.7	64.2	65.1	59.8	83.3	79.8	73.1	65.4	85.6	79.8	76.8	63.5	86.2	69.9	73.1	63.7	76	67.1	71.1	66.8	82.5	64.2	74.3	67.6	83.6	71.3	78.8	68.5	89.1	72.1	79.2	68.6	86.5	72	79.9	71.7	91.6	73	84	71.7	92.8	71.8	86.9	70.9	92.4	76.5	89.9	75.1	91.5	76	92.8	78.4	101.3	82.1	95.2	80.4	103.5	81.9	89	76.8	100.1	84.2	96.5	83.7	108.6	88.7
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Belgium	65	66.7	71	80.8	66.6	67.3	73.7	83.6	69.9	70	77.1	84.7	70	71.3	79.2	86.7	70.5	74.7	81.2	88.9	72	76.7	83.6	91.5	75.7	77.1	87.2	91.8	78	79	89	95	81.1	82.4	92.7	96.7	79.8	82.3	91.6	99.1	83	83.7	95.1	99.8	85.7	85.9	95.4	102.1	88.3	88.5	97.9	104.6	89.8	89.8	99.6	106.8	91.1	90.7	100.5	108	91.7	91.1	100.6	108.1	91.8	90.6	99.7	106.7	91.5	90.7	99.6	107.2	91.9	91.2	99.7	107.8	92.8
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Bulgaria	28.3	29.3	34.3	36	29.5	33.3	34.8	36.4	34.6	33.1	33	35.8	36.3	36.5	36.8	39.7	37.6	39.5	40.5	45	40.1	38.4	38.2	46.2	34.5	37	37.1	45.6	38	40.5	44.1	44.4	42.1	46.7	46.2	50	48.7	48.1	48.1	53.5	50.2	51.5	51.9	55.9	52.9	56	55	59	54.9	56.7	59.2	60	57	60.8	63.4	69.3	64.8	64.4	66.4	72.3	62.2	66.6	66.5	68.3	64	68.2	68.6	74.4	73.2	77.7	79.8	88.4	78.5	84	84.7	93.9	87.1
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Cyprus	56.1	66	68.3	72.3	59.4	69.8	72.3	76.5	61.9	72.7	75.3	79.8	65.6	77.1	79.9	84.6	69.9	75.9	79.8	82.6	70.9	76.6	78	86	74.4	78.4	83.7	92.2	70.2	76.2	80.6	84.4	71.7	81.9	82.5	92.3	74.5	85.4	82.1	97.6	80.1	78.8	85.5	90.8	79.6	89.9	87.1	92.8	75.6	84.4	84	87.5	65.3	71.1	79.6	74.6	70	76.4	85.4	83.6	71.9	75.1	76.2	81.7	72.6	80	78.7	86.1	70.9	72.9	71.9	82.4	78	82.7	86.9	101.3	80.3
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Czechia	40.6	45.9	46	48.9	43.3	49	48.3	53.7	47.8	52.3	52.1	57.3	47.2	51.6	50.8	59	44.3	49.4	52.7	61.8	45.5	48.9	50.3	59.9	52	58.2	59.8	71.8	53.5	59.7	59.9	71.1	60.7	64.9	62.8	82.9	60.8	63	62.3	77.6	62.1	67.3	68.3	83.1	65.4	72.2	73	87.5	68.4	75.8	74.8	91.6	70.4	73.1	78.9	92.1	69.9	74.3	73.6	86.9	69.9	73	76.9	89.3	72.5	71.9	79.7	87.2	75.1	83.7	87.7	99.7	75.5	83.9	85.4	95.6	81.2
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Germany																																	96.9	109.7	96.3	110.3	103.6	122.2	104.4	118.3	113.1	128.7	111.4	123.7	122.5	139.4	120.3	134.5	129.2	146.8	125.6	142.8	137.1	148.7	125.9	144.2	126.3	144	123.1	140.6	147.8	161.4	141.8	159.7	112.4	127.7	105.8	124.1	114.9	125.6	110.2	127.8	118.4	127.2	114.4	132.3	115.9
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Denmark
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)					69.7	76	72.7	81.6	67.2	71.8	70.7	77.6	67.1	72.3	70.4	80.9	68.7	74.2	71.7	80	70.2	78.5	73.4	82.7	72.2	78.8	76.2	83	74	81	76.4	83.9	77.4	85.1	80.9	90.5	81	92.4	85.3	94.3	86.6	96	89.2	99.7	92.1	102	93.5	103.9	96	107.2	98.1	109	99.9	108	98.5	107.8	98.2	108.7	101.1	108.9	103.6	112.6	104.3	115.8	93.8	104.4	91	99.9	90.8	99.8	95.6	102.3	94.7	103.3	97.7	107.4	95.1
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Euro area – 20 countries (from 2023)					69	75.2	72.1	80.8	66.7	71.3	70.2	77.2	66.9	72.1	70.2	80.6	68.5	73.9	71.6	79.8	70.1	78.2	73.3	82.5	72.1	78.7	76.2	83	74	80.9	76.4	83.9	77.5	85.2	81.1	90.5	81.1	92.5	85.4	94.3	86.7	96	89.2	99.8	92.1	102	93.6	104	96.3	107.4	98.3	109.2	100.2	108.2	98.7	108.1	98.4	108.9	101.3	109.2	103.8	112.9	104.6	116	94	104.6	91.1	100	90.8	100	95.7	102.4	94.6	103.3	97.6	107.4	95
Quarterly	Nominal value	Index, 2020=100	Calendar adjusted data, not seasonally adjusted data	Mining and quarrying	Labour cost index - labour costs other than wages and salaries	Estonia	23.7	24.6	25.1	25.2	23.6	26.4	26.4	27.1	26.7	29.7	28.8	31	27	30.5	31.3	33	29.8	33.3	35.4	35	36.3	37.4	35.3	43.1	39.2	44.8	44	45.8	44.2	53	48.2	52.4	52.6	66.1	61.7	57.4	55.1	72.9	61.8	61.4	54.6	63.7	59.4	64.1	61.2	65	63.2	61.8	64.7	64.9	66.9	68.6	67.7	75.9	70.6	73.7	74.6	76.2	75.5	76.6	73.2	79.5	78.8	85.3	96.2	83.1	74.1	78.4	78.8	88	86.7	88.3	87.3	91.1	95.7	96.7	104.5


CREATE TABLE raw (
  "freq" VARCHAR,
  "p_adj" VARCHAR,
  "unit" VARCHAR,
  "s_adj" VARCHAR,
  "nace_r2" VARCHAR,
  "indic" VARCHAR,
  "geo" VARCHAR,
  "n_1996_q1" DOUBLE,
  "n_1996_q2" DOUBLE,
  "n_1996_q3" DOUBLE,
  "n_1996_q4" DOUBLE,
  "n_1997_q1" DOUBLE,
  "n_1997_q2" DOUBLE,
  "n_1997_q3" DOUBLE,
  "n_1997_q4" DOUBLE,
  "n_1998_q1" DOUBLE,
  "n_1998_q2" DOUBLE,
  "n_1998_q3" DOUBLE,
  "n_1998_q4" DOUBLE,
  "n_1999_q1" DOUBLE,
  "n_1999_q2" DOUBLE,
  "n_1999_q3" DOUBLE,
  "n_1999_q4" DOUBLE,
  "n_2000_q1" DOUBLE,
  "n_2000_q2" DOUBLE,
  "n_2000_q3" DOUBLE,
  "n_2000_q4" DOUBLE,
  "n_2001_q1" DOUBLE,
  "n_2001_q2" DOUBLE,
  "n_2001_q3" DOUBLE,
  "n_2001_q4" DOUBLE,
  "n_2002_q1" DOUBLE,
  "n_2002_q2" DOUBLE,
  "n_2002_q3" DOUBLE,
  "n_2002_q4" DOUBLE,
  "n_2003_q1" DOUBLE,
  "n_2003_q2" DOUBLE,
  "n_2003_q3" DOUBLE,
  "n_2003_q4" DOUBLE,
  "n_2004_q1" DOUBLE,
  "n_2004_q2" DOUBLE,
  "n_2004_q3" DOUBLE,
  "n_2004_q4" DOUBLE,
  "n_2005_q1" DOUBLE,
  "n_2005_q2" DOUBLE,
  "n_2005_q3" DOUBLE,
  "n_2005_q4" DOUBLE,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE,
  "n_2015_q3" DOUBLE,
  "n_2015_q4" DOUBLE,
  "n_2016_q1" DOUBLE,
  "n_2016_q2" DOUBLE,
  "n_2016_q3" DOUBLE,
  "n_2016_q4" DOUBLE,
  "n_2017_q1" DOUBLE,
  "n_2017_q2" DOUBLE,
  "n_2017_q3" DOUBLE,
  "n_2017_q4" DOUBLE,
  "n_2018_q1" DOUBLE,
  "n_2018_q2" DOUBLE,
  "n_2018_q3" DOUBLE,
  "n_2018_q4" DOUBLE,
  "n_2019_q1" DOUBLE
);