Baselight
Sign In

Structure Of Labour Cost By NACE Rev. 2 Activity And NUTS 1 Region - % Of Total Cost

Eurostat code: lc_rstruc_r2 · (2008 - 2020)

@eurostat.lc_rstruc_r2

Structure Of Labour Cost By NACE Rev. 2 Activity And NUTS 1 Region - % Of Total Cost - Unpivoted
@eurostat.lc_rstruc_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.

  • 1.06 MB
  • 488064 rows
  • 8 columns
freq

Freq

sizeclas

Sizeclas

lcstruct

Lcstruct

nace_r2

Nace R2

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageOstösterreich200896.1
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageSüdösterreich200897.11
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageWestösterreich200897.06
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageSeverna i Yugoiztochna Bulgaria200893.95
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageYugozapadna i Yuzhna tsentralna Bulgaria200897.4
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageBaden-Württemberg200899.51
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageBayern200899.64
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageBrandenburg200899.98
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageHessen200899.84
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageMecklenburg-Vorpommern2008100.1

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

Share link

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