Dataset: Average Hours Worked And Paid Per Employee, By Working Time And NACE Rev. 2 Activity

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_r2 Nace R2	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	Mining and quarrying	Hours per employee	Germany	2008	1758
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 - 16 countries (2009-2010)	2008	1679
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)	2008	1679
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)	2008	1679
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)	2008	1679
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 – 20 countries (from 2023)	2008	1679
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 - 15 countries (1995-2004)	2008	1685
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 - 25 countries (2004-2006)	2008	1685
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)	2008	1685
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 (from 2020)	2008	1679

freq

Freq

sizeclas

Sizeclas

worktime

Worktime

indic_lc

Indic Lc

nace_r2

Nace R2

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

Mining and quarrying

Hours per employee

Germany

2008

1758

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 - 16 countries (2009-2010)

2008

1679

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)

2008

1679

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)

2008

1679

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)

2008

1679

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 – 20 countries (from 2023)

2008

1679

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 - 15 countries (1995-2004)

2008

1685

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 - 25 countries (2004-2006)

2008

1685

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)

2008

1685

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 (from 2020)

2008

1679

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

Average Hours Worked And Paid Per Employee, By Working Time And NACE Rev. 2 Activity

Table List

Average Hours Worked And Paid Per Employee, By Working Time And NACE Rev. 2 Activity - Unpivoted

@eurostat.lc_nnum2_r2.tidy

freq

sizeclas

worktime

indic_lc

nace_r2

unit

geo

time_period

value

Share link