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

Eurostat code: lc_n04struc · (2004 - 2004)

@eurostat.lc_n04struc

Table List

2 tables(523.24 KB)

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

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

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

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

248.83 KB
111510 rows
8 columns

freq Freq	sizeclas Sizeclas	nace_r1 Nace R1	lcstruct Lcstruct	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Compensation of employees (total)	Percentage	European Union - 27 countries (2007-2013)	2004	97.86
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Compensation of employees (total)	Percentage	European Union - 28 countries (2013-2020)	2004	97.86
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Wages and salaries (total)	Percentage	European Union - 27 countries (2007-2013)	2004	73.36
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Wages and salaries (total)	Percentage	European Union - 28 countries (2013-2020)	2004	73.36
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Wages and salaries (excluding apprentices)	Percentage	European Union - 27 countries (2007-2013)	2004	73.35
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Wages and salaries (excluding apprentices)	Percentage	European Union - 28 countries (2013-2020)	2004	73.35
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Direct remuneration, bonuses and allowances	Percentage	European Union - 27 countries (2007-2013)	2004	63.32
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Direct remuneration, bonuses and allowances	Percentage	European Union - 28 countries (2013-2020)	2004	63.32
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Payments for days not worked	Percentage	European Union - 27 countries (2007-2013)	2004	6.64
Annual	From 10 to 49 employees	Agriculture, hunting and forestry	Payments for days not worked	Percentage	European Union - 28 countries (2013-2020)	2004	6.64


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.