Structure Of Labour Cost By NACE Rev. 2 Activity - % Of Total Cost

Eurostat code: lc_nstruc_r2 · (2008 - 2020)

@eurostat.lc_nstruc_r2

Table List

2 tables(6.94 MB)

Structure Of Labour Cost By NACE Rev. 2 Activity - % Of Total Cost - Raw

Structure Of Labour Cost By NACE Rev. 2 Activity - % Of Total Cost - Unpivoted

Structure Of Labour Cost By NACE Rev. 2 Activity - % Of Total Cost - Unpivoted

@eurostat.lc_nstruc_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.

3.32 MB
1506176 rows
8 columns

freq Freq	sizeclas Sizeclas	lcstruct Lcstruct	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Austria	2008	97.86
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Bulgaria	2008	99.74
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Cyprus	2008	99.49
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Czechia	2008	99.43
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Germany	2008	100.25
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Denmark	2008	97.2
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Euro area - 16 countries (2009-2010)	2008	98.99
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Euro area - 17 countries (2011-2013)	2008	98.99
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Euro area - 18 countries (2014)	2008	98.99
Annual	From 10 to 49 employees	Compensation of employees (total)	Mining and quarrying	Percentage	Euro area - 19 countries (2015-2022)	2008	98.99


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.