Baselight
Sign In

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

Eurostat code: lc_r04struc · (2004 - 2004)

@eurostat.lc_r04struc

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

  • 155.04 KB
  • 65541 rows
  • 8 columns
freq

Freq

sizeclas

Sizeclas

lcstruct

Lcstruct

nace_r1

Nace R1

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual10 employees or moreCompensation of employees (total)Agriculture, hunting and forestryPercentageKözép-Magyarország200497.7
Annual10 employees or moreCompensation of employees (total)Agriculture, hunting and forestryPercentageDunántúl200497.78
Annual10 employees or moreCompensation of employees (total)Agriculture, hunting and forestryPercentageAlföld és Észak200497.94
Annual10 employees or moreCompensation of employees (total)FishingPercentageKözép-Magyarország200495.4
Annual10 employees or moreCompensation of employees (total)FishingPercentageDunántúl200496.48
Annual10 employees or moreCompensation of employees (total)FishingPercentageAlföld és Észak200496.94
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageOstösterreich200496.25
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageSüdösterreich200497.07
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageWestösterreich200497.29
Annual10 employees or moreCompensation of employees (total)Mining and quarryingPercentageVlaams Gewest200499.54

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