Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2000

Eurostat code: lc_n00hour · (2000 - 2000)

@eurostat.lc_n00hour

Table List

2 tables(29.25 KB)

Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2000 - Raw

Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2000 - Unpivoted

Hours Worked Compared To Hours Paid, By NACE Rev. 1.1 Activity - LCS Survey 2000 - Unpivoted

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

14.81 KB
3029 rows
6 columns

freq Freq	indic_lc Indic Lc	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	Estonia	2000	1.08
Annual	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	Romania	2000	1.1
Annual	Ratio between hours paid and actually worked	Agriculture, hunting and forestry	Slovakia	2000	1.14
Annual	Ratio between hours paid and actually worked	Fishing	Estonia	2000	1.09
Annual	Ratio between hours paid and actually worked	Fishing	Romania	2000	1.09
Annual	Ratio between hours paid and actually worked	Mining and quarrying	Austria	2000	1.21
Annual	Ratio between hours paid and actually worked	Mining and quarrying	Belgium	2000	1.14
Annual	Ratio between hours paid and actually worked	Mining and quarrying	Cyprus	2000	1.11
Annual	Ratio between hours paid and actually worked	Mining and quarrying	Czechia	2000	1.21
Annual	Ratio between hours paid and actually worked	Mining and quarrying	Germany	2000	1.23


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.