Relative Prevalence Rate Of Work-related Health Problems By Severity, Diagnosis Group, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity

Eurostat code: hsw_hp_svcln · (1999 - 1999)

@eurostat.hsw_hp_svcln

Table List

2 tables(26.31 KB)

Relative Prevalence Rate Of Work-related Health Problems By Severity, Diagnosis Group, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity - Raw

Relative Prevalence Rate Of Work-related Health Problems By Severity, Diagnosis Group, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity - Unpivoted

Relative Prevalence Rate Of Work-related Health Problems By Severity, Diagnosis Group, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity - Unpivoted

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

13.44 KB
2133 rows
10 columns

freq Freq	unit Unit	l_serv L Serv	severity Severity	emp_cont Emp Cont	nace_r1 Nace R1	diagnose Diagnose	geo Geo	time_period Time Period	value Value
Annual	Rate	Total	14 days or over	Limited duration	Agriculture, hunting and forestry	Musculo-skeletal disorders	European Union (aggregate changing according to the context)	1999	162
Annual	Rate	Total	14 days or over	Limited duration	Agriculture, hunting and forestry	Other not elsewhere mentioned	European Union (aggregate changing according to the context)	1999	48
Annual	Rate	Total	14 days or over	Limited duration	Agriculture, hunting and forestry	Pulmonary disorders	European Union (aggregate changing according to the context)	1999	177
Annual	Rate	Total	14 days or over	Limited duration	Agriculture, hunting and forestry	Stress, depression, anxiety	European Union (aggregate changing according to the context)	1999	36
Annual	Rate	Total	14 days or over	Limited duration	Agriculture, hunting and forestry	Total	European Union (aggregate changing according to the context)	1999	105
Annual	Rate	Total	14 days or over	Limited duration	Fishing	Total	European Union (aggregate changing according to the context)	1999	587
Annual	Rate	Total	14 days or over	Limited duration	Mining and quarrying	Musculo-skeletal disorders	European Union (aggregate changing according to the context)	1999	155
Annual	Rate	Total	14 days or over	Limited duration	Mining and quarrying	Total	European Union (aggregate changing according to the context)	1999	72
Annual	Rate	Total	14 days or over	Limited duration	Manufacturing	Musculo-skeletal disorders	European Union (aggregate changing according to the context)	1999	36
Annual	Rate	Total	14 days or over	Limited duration	Manufacturing	Other not elsewhere mentioned	European Union (aggregate changing according to the context)	1999	14


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "l_serv" VARCHAR,
  "severity" VARCHAR,
  "emp_cont" VARCHAR,
  "nace_r1" VARCHAR,
  "diagnose" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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