Structure Of Labour Cost By NACE Rev. 2 Activity

Eurostat code: lc_an_struc_r2 · (1996 - 2011)

@eurostat.lc_an_struc_r2

Table List

2 tables(67.64 KB)

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

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

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

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

24.47 KB
9194 rows
8 columns

freq Freq	nace_r2 Nace R2	lcstruct Lcstruct	sizeclas Sizeclas	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Wages and salaries (total)	10 employees or more	Percentage	Germany	1996	71.6
Annual	Mining and quarrying	Employers' social contributions and other labour costs paid by employer	10 employees or more	Percentage	Germany	1996	28.4
Annual	Industry (except construction)	Wages and salaries (total)	10 employees or more	Percentage	Germany	1996	77.4
Annual	Industry (except construction)	Employers' social contributions and other labour costs paid by employer	10 employees or more	Percentage	Germany	1996	22.6
Annual	Industry and construction	Wages and salaries (total)	10 employees or more	Percentage	Germany	1996	77
Annual	Industry and construction	Employers' social contributions and other labour costs paid by employer	10 employees or more	Percentage	Germany	1996	23
Annual	Business economy	Wages and salaries (total)	10 employees or more	Percentage	Germany	1996	76.5
Annual	Business economy	Employers' social contributions and other labour costs paid by employer	10 employees or more	Percentage	Germany	1996	23.5
Annual	Industry, construction and services (except activities of households as employers and extra-territorial organisations and bodies)	Wages and salaries (total)	10 employees or more	Percentage	Germany	1996	75.1
Annual	Industry, construction and services (except activities of households as employers and extra-territorial organisations and bodies)	Employers' social contributions and other labour costs paid by employer	10 employees or more	Percentage	Germany	1996	24.9


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

Share link

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