Baselight
Sign In

Structure Of Labour Cost By NACE Rev. 1.1 Activity - % Of Total Cost, LCS Survey 2008

Eurostat code: lc_n08struc_r1 ยท (2008 - 2008)

@eurostat.lc_n08struc_r1

Structure Of Labour Cost By NACE Rev. 1.1 Activity - % Of Total Cost, LCS Survey 2008 - Unpivoted
@eurostat.lc_n08struc_r1.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.

  • 89.93 KB
  • 34739 rows
  • 8 columns
freq

Freq

sizeclas

Sizeclas

nace_r1

Nace R1

lcstruct

Lcstruct

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageAustria200896.69
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageBulgaria200895.48
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageSwitzerland2008100
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageCyprus200899.52
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageCzechia200899.24
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageGermany200898.83
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageDenmark200897.11
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageEuro area - 16 countries (2009-2010)200898.15
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageEuro area - 17 countries (2011-2013)200898.16
Annual10 employees or moreMining and quarryingCompensation of employees (total)PercentageEuro area - 18 countries (2014)200898.16

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

Share link

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