Baselight

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

Eurostat code: lc_n04cost ยท (2004 - 2004)

@eurostat.lc_n04cost

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

  • 2.52 MB
  • 422003 rows
  • 9 columns
freq

Freq

currency

Currency

nace_r1

Nace R1

unit

Unit

sizeclas

Sizeclas

lcstruct

Lcstruct

geo

Geo

time_period

Time Period

value

Value

AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)European Union - 27 countries (2007-2013)20042.5
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)European Union - 28 countries (2013-2020)20042.5
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Hungary20043.27
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs (excluding apprentices)Romania20041.26
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs for apprenticesEuropean Union - 27 countries (2007-2013)20040.98
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs for apprenticesEuropean Union - 28 countries (2013-2020)20040.98
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs for apprenticesHungary20042.01
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesTotal labour costs for apprenticesRomania20040.95
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesWages and salaries (excluding apprentices)European Union - 27 countries (2007-2013)20041.83
AnnualEuroAgriculture, hunting and forestryPer employee in full-time equivalents, per hourFrom 10 to 49 employeesWages and salaries (excluding apprentices)European Union - 28 countries (2013-2020)20041.83

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

Share link

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