Baselight

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

Eurostat code: lc_n00cost ยท (2000 - 2000)

@eurostat.lc_n00cost

Labour Cost, Wages And Salaries, Direct Remuneration By NACE Rev. 1.1 Activity - LCS Survey 2000 - Unpivoted
@eurostat.lc_n00cost.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.

  • 1.74 MB
  • 272377 rows
  • 9 columns
freq

Freq

currency

Currency

unit

Unit

sizeclas

Sizeclas

lcstruct

Lcstruct

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Agriculture, hunting and forestryEstonia20001.9
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Agriculture, hunting and forestryEuropean Union - 25 countries (2004-2006)20003.82
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Agriculture, hunting and forestryHungary20005.25
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Agriculture, hunting and forestryNew Member States - 10 countries (2004-2006)20003.82
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Agriculture, hunting and forestryPoland2000
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Agriculture, hunting and forestryRomania2000
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Agriculture, hunting and forestrySlovakia20001.87
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)FishingEstonia20002.11
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)FishingEuropean Union - 25 countries (2004-2006)20000.58
AnnualEuroPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)FishingHungary20001.94

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

Share link

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