Baselight
Sign In

Labour Cost, Wages And Salaries, Direct Remuneration By NACE Rev. 2 Activity And NUTS 1 Region

Eurostat code: lc_rcost_r2 · (2008 - 2020)

@eurostat.lc_rcost_r2

Labour Cost, Wages And Salaries, Direct Remuneration By NACE Rev. 2 Activity And NUTS 1 Region - Unpivoted
@eurostat.lc_rcost_r2.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.

  • 4.22 MB
  • 847104 rows
  • 9 columns
freq

Freq

currency

Currency

unit

Unit

sizeclas

Sizeclas

lcstruct

Lcstruct

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingOstösterreich200834.06
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingSüdösterreich200827.99
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingWestösterreich200830.78
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingSeverna i Yugoiztochna Bulgaria20085.28
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingYugozapadna i Yuzhna tsentralna Bulgaria20083.77
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingBaden-Württemberg200831.11
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingBayern200825.77
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingBrandenburg200838.79
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingHessen200828.43
AnnualEuroPer employee in full-time equivalents, per hour10 employees or moreTotal labour costs (excluding apprentices)Mining and quarryingMecklenburg-Vorpommern200818.3

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

Share link

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