Baselight
Sign In

Structure Of Labour Cost By NACE Rev. 1.1 Activity And NUTS 1 Region - % Of Total Cost, LCS Survey 2000

Eurostat code: lc_r00struc ยท (2000 - 2000)

@eurostat.lc_r00struc

Structure Of Labour Cost By NACE Rev. 1.1 Activity And NUTS 1 Region - % Of Total Cost, LCS Survey 2000 - Unpivoted
@eurostat.lc_r00struc.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.

  • 207.62 KB
  • 94321 rows
  • 7 columns
freq

Freq

lcstruct

Lcstruct

nace_r1

Nace R1

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCompensation of employees (total)Agriculture, hunting and forestryPercentageEstonia200099.25
AnnualCompensation of employees (total)Agriculture, hunting and forestryPercentageHungary200099.06
AnnualCompensation of employees (total)Agriculture, hunting and forestryPercentagePoland200093.5
AnnualCompensation of employees (total)Agriculture, hunting and forestryPercentageRomania200098.19
AnnualCompensation of employees (total)Agriculture, hunting and forestryPercentageSlovakia200099.7
AnnualCompensation of employees (total)FishingPercentageEstonia200099.23
AnnualCompensation of employees (total)FishingPercentageHungary2000102.82
AnnualCompensation of employees (total)FishingPercentagePoland200068.06
AnnualCompensation of employees (total)FishingPercentageRomania200098.33
AnnualCompensation of employees (total)Mining and quarryingPercentageAustria200096.93

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

Share link

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