Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2004

Eurostat code: lc_n04hour · (2004 - 2004)

@eurostat.lc_n04hour

Table List

2 tables(52.8 KB)

Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2004 - Raw

Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2004 - Unpivoted

Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2004 - Unpivoted

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

26.58 KB
4677 rows
7 columns

freq Freq	sizeclas Sizeclas	indic_lc Indic Lc	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	Euro area - 13 countries (2007)	2004	1.22
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	European Union - 25 countries (2004-2006)	2004	1.17
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	European Union - 27 countries (2007-2013)	2004	1.12
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	European Union - 27 countries (from 2020)	2004	1.12
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	European Union - 28 countries (2013-2020)	2004	1.12
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	Hungary	2004	1.13
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	Romania	2004	1.11
Annual	10 employees or more	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	Slovenia	2004	1.22
Annual	10 employees or more	Ratio between hours paid and actually worked	Fishing	Euro area - 13 countries (2007)	2004	1.19
Annual	10 employees or more	Ratio between hours paid and actually worked	Fishing	European Union - 25 countries (2004-2006)	2004	1.16


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

Share link

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