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

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	Mining and quarrying	Hours per employee	Germany	2000	1680
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	2000	2117
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 (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2000	2183
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)	2000	2172
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	Italy	2000	2593
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	Portugal	2000	1793
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	United Kingdom	2000	2107
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Industry (except construction)	Hours per employee	Austria	2000	1802
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Industry (except construction)	Hours per employee	Belgium	2000	21801
Annual	From 10 to 49 employees	Yearly average in full-time equivalents	Average annual hours actually worked per apprentice	Industry (except construction)	Hours per employee	Cyprus	2000	3648

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

Mining and quarrying

Hours per employee

Germany

2000

1680

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

2000

2117

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 (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)

2000

2183

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)

2000

2172

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

Italy

2000

2593

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

Portugal

2000

1793

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

United Kingdom

2000

2107

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Industry (except construction)

Hours per employee

Austria

2000

1802

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Industry (except construction)

Hours per employee

Belgium

2000

21801

Annual

From 10 to 49 employees

Yearly average in full-time equivalents

Average annual hours actually worked per apprentice

Industry (except construction)

Hours per employee

Cyprus

2000

3648

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 2000

Table List

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

@eurostat.lc_n00num2.tidy

freq

sizeclas

worktime

indic_lc

nace_r1

unit

geo

time_period

value

Share link