Structure Of Labour Cost By NACE Rev. 1.1 Activity

Eurostat code: lc_an_struc · (1995 - 2008)

@eurostat.lc_an_struc

Table List

2 tables(181.91 KB)

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

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

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

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

69.26 KB
20469 rows
7 columns

freq Freq	nace_r1 Nace R1	lcstruct Lcstruct	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Wages and salaries (total)	Percentage	Czechia	1995	69.8
Annual	Mining and quarrying	Wages and salaries (total)	Percentage	Greece	1995	76.23
Annual	Mining and quarrying	Wages and salaries (total)	Percentage	Sweden	1995	66.14
Annual	Mining and quarrying	Wages and salaries (total)	Percentage	Slovenia	1995	79.5
Annual	Mining and quarrying	Direct remuneration, bonuses and allowances	Percentage	Czechia	1995	58.9
Annual	Mining and quarrying	Direct remuneration, bonuses and allowances	Percentage	Greece	1995	69.23
Annual	Mining and quarrying	Direct remuneration, bonuses and allowances	Percentage	Sweden	1995	58.48
Annual	Mining and quarrying	Direct remuneration, bonuses and allowances	Percentage	Slovenia	1995	60.2
Annual	Mining and quarrying	Employers' social contributions (total)	Percentage	Czechia	1995	28
Annual	Mining and quarrying	Employers' social contributions (total)	Percentage	Greece	1995	23.32


CREATE TABLE tidy (
  "freq" 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.