Baselight

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

Eurostat code: lc_lci_r2_q ยท (1996-Q1 - 2024-Q4)

@eurostat.lc_lci_r2_q

Labour Cost Index By NACE Rev. 2 Activity - Nominal Value, Quarterly Data - Unpivoted
@eurostat.lc_lci_r2_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.

  • 5.82 MB
  • 3470433 rows
  • 8 columns
freq

Freq

s_adj

S Adj

unit

Unit

nace_r2

Nace R2

lcstruct

Lcstruct

geo

Geo

time_period

Time Period

value

Value

QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Mining and quarryingWages and salaries (total)Norway1996-Q114.9
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Mining and quarryingLabour costs other than wages and salariesNorway1996-Q141.8
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Mining and quarryingLabour cost for LCI excluding bonusesNorway1996-Q119
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Industry (except construction)Wages and salaries (total)Norway1996-Q124.5
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Industry (except construction)Labour costs other than wages and salariesNorway1996-Q150.1
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Industry (except construction)Labour cost for LCI (compensation of employees plus taxes minus subsidies)Norway1996-Q127.8
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Industry (except construction)Labour cost for LCI excluding bonusesNorway1996-Q127.7
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Industry and constructionWages and salaries (total)Norway1996-Q127.2
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Industry and constructionLabour costs other than wages and salariesNorway1996-Q150.2
QuarterlyCalendar adjusted data, not seasonally adjusted dataIndex, 2016=100Industry and constructionLabour cost for LCI (compensation of employees plus taxes minus subsidies)Norway1996-Q130.1

CREATE TABLE tidy (
  "freq" VARCHAR,
  "s_adj" 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.