Number Of Employees And Hours Worked, By Working Time, NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000

Eurostat code: lc_r00num1 · (2000 - 2000)

@eurostat.lc_r00num1

Table List

2 tables(497.7 KB)

Number Of Employees And Hours Worked, By Working Time, NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000 - Raw

Number Of Employees And Hours Worked, By Working Time, NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000 - Unpivoted

Number Of Employees And Hours Worked, By Working Time, NACE Rev. 1.1 Activity And NUTS 1 Region - LCS Survey 2000 - Unpivoted

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

248.11 KB
43450 rows
9 columns

freq Freq	sizeclas Sizeclas	indic_lc Indic Lc	worktime Worktime	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Austria	2000	77
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Ostösterreich	2000
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Südösterreich	2000	65
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Westösterreich	2000	12
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Belgium	2000	1
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Vlaams Gewest	2000
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Région wallonne	2000	1
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Germany	2000	3943
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Baden-Württemberg	2000	79
Annual	10 employees or more	Apprentices	Total	Mining and quarrying	Number	Bayern	2000	146


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

Share link

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