Dataset: Average Hours Worked And Paid Per Employee, By Working Time And NACE Rev. 1.1 Activity - LCS Survey 2004

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.

freq Freq	sizeclas Sizeclas	worktime Worktime	indic_lc Indic Lc	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Agriculture, hunting and forestry	Hours per employee	European Union - 27 countries (2007-2013)	2004	1808
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Agriculture, hunting and forestry	Hours per employee	European Union - 28 countries (2013-2020)	2004	1808
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Agriculture, hunting and forestry	Hours per employee	Romania	2004	1764
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Mining and quarrying	Hours per employee	Germany	2004	1813.58
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Mining and quarrying	Hours per employee	Denmark	2004	2350
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Mining and quarrying	Hours per employee	Euro area - 17 countries (2011-2013)	2004	2188
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Mining and quarrying	Hours per employee	Euro area - 18 countries (2014)	2004	2190
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Mining and quarrying	Hours per employee	Euro area - 19 countries (2015-2022)	2004	2190
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Mining and quarrying	Hours per employee	Greece	2004	960
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Mining and quarrying	Hours per employee	European Union - 27 countries (2007-2013)	2004	1903

freq

Freq

sizeclas

Sizeclas

worktime

Worktime

indic_lc

Indic Lc

nace_r1

Nace R1

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Agriculture, hunting and forestry

Hours per employee

European Union - 27 countries (2007-2013)

2004

1808

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Agriculture, hunting and forestry

Hours per employee

European Union - 28 countries (2013-2020)

2004

1808

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Agriculture, hunting and forestry

Hours per employee

Romania

2004

1764

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Mining and quarrying

Hours per employee

Germany

2004

1813.58

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Mining and quarrying

Hours per employee

Denmark

2004

2350

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Mining and quarrying

Hours per employee

Euro area - 17 countries (2011-2013)

2004

2188

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Mining and quarrying

Hours per employee

Euro area - 18 countries (2014)

2004

2190

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Mining and quarrying

Hours per employee

Euro area - 19 countries (2015-2022)

2004

2190

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Mining and quarrying

Hours per employee

Greece

2004

960

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Mining and quarrying

Hours per employee

European Union - 27 countries (2007-2013)

2004

1903

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

Average Hours Worked And Paid Per Employee, By Working Time And NACE Rev. 1.1 Activity - LCS Survey 2004

Table List

Average Hours Worked And Paid Per Employee, By Working Time And NACE Rev. 1.1 Activity - LCS Survey 2004 - Unpivoted

@eurostat.lc_n04num2.tidy

freq

sizeclas

worktime

indic_lc

nace_r1

unit

geo

time_period

value

Share link