Temporary Staff: Labour Cost, Number Of Employees And Number Of Hours Worked By NACE Rev. 1.1 Activity - LCS Survey 2000

Eurostat code: lc_n00temp · (2000 - 2000)

@eurostat.lc_n00temp

Table List

2 tables(24.08 KB)

Temporary Staff: Labour Cost, Number Of Employees And Number Of Hours Worked By NACE Rev. 1.1 Activity - LCS Survey 2000 - Raw

Temporary Staff: Labour Cost, Number Of Employees And Number Of Hours Worked By NACE Rev. 1.1 Activity - LCS Survey 2000 - Unpivoted

Temporary Staff: Labour Cost, Number Of Employees And Number Of Hours Worked By NACE Rev. 1.1 Activity - LCS Survey 2000 - Unpivoted

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

12.25 KB
1243 rows
6 columns

freq Freq	indic_lc Indic Lc	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Hours worked	Agriculture, hunting and forestry	Estonia	2000
Annual	Hours worked	Agriculture, hunting and forestry	Romania	2000
Annual	Hours worked	Fishing	Estonia	2000
Annual	Hours worked	Fishing	Romania	2000
Annual	Hours worked	Mining and quarrying	Germany	2000
Annual	Hours worked	Mining and quarrying	Estonia	2000
Annual	Hours worked	Mining and quarrying	Greece	2000	10000
Annual	Hours worked	Mining and quarrying	Luxembourg	2000	497164
Annual	Hours worked	Mining and quarrying	Portugal	2000
Annual	Hours worked	Mining and quarrying	Romania	2000


CREATE TABLE tidy (
  "freq" 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.