Labour Cost, Wages And Salaries, Direct Remuneration By NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000

Eurostat code: lc_r00cost · (2000 - 2000)

@eurostat.lc_r00cost

Table List

2 tables(1.34 MB)

Labour Cost, Wages And Salaries, Direct Remuneration By NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000 - Raw

Labour Cost, Wages And Salaries, Direct Remuneration By NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000 - Unpivoted

Labour Cost, Wages And Salaries, Direct Remuneration By NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000 - Unpivoted

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

686.7 KB
128781 rows
9 columns

freq Freq	sizeclas Sizeclas	lcstruct Lcstruct	unit Unit	currency Currency	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Austria	2000	27.66
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Ostösterreich	2000	26.94
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Südösterreich	2000	29.47
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Westösterreich	2000	24.73
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Belgium	2000	26.67
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Vlaams Gewest	2000	28.89
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Région wallonne	2000	25.9
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Germany	2000	31.57
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Baden-Württemberg	2000	25.5
Annual	10 employees or more	Total labour costs (excluding apprentices)	Per employee in full-time equivalents, per hour	Euro	Mining and quarrying	Bayern	2000	23.45


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

Share link

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