Labour Costs By NACE Rev. 2 Activity

Eurostat code: lc_an_cost_r2 · (1996 - 2011)

@eurostat.lc_an_cost_r2

Table List

2 tables(255.7 KB)

Labour Costs By NACE Rev. 2 Activity - Raw

Labour Costs By NACE Rev. 2 Activity - Unpivoted

Labour Costs By NACE Rev. 2 Activity - Unpivoted

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

103.59 KB
27642 rows
8 columns

freq Freq	nace_r2 Nace R2	sizeclas Sizeclas	indic_lc Indic Lc	currency Currency	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	10 employees or more	Labour cost per hour	Euro	Germany	1996	29.09
Annual	Mining and quarrying	10 employees or more	Labour cost per hour	National currency	Germany	1996	28.4
Annual	Mining and quarrying	10 employees or more	Labour cost per hour	Purchasing Power Standard	Germany	1996	25.47
Annual	Mining and quarrying	10 employees or more	Labour cost per month	Euro	Germany	1996	3965
Annual	Mining and quarrying	10 employees or more	Labour cost per month	National currency	Germany	1996	3871
Annual	Mining and quarrying	10 employees or more	Labour cost per month	Purchasing Power Standard	Germany	1996	3472
Annual	Industry (except construction)	10 employees or more	Labour cost per hour	Euro	Germany	1996	25.5
Annual	Industry (except construction)	10 employees or more	Labour cost per hour	National currency	Germany	1996	24.9
Annual	Industry (except construction)	10 employees or more	Labour cost per hour	Purchasing Power Standard	Germany	1996	22.33
Annual	Industry (except construction)	10 employees or more	Labour cost per month	Euro	Germany	1996	3288


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

Share link

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