Relative Incidence Rate Of Accidental Injuries At Work By Severity, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity (EU Mean Rate = 100 For Each Severity)

Eurostat code: hsw_ij_svcln · (1999 - 1999)

@eurostat.hsw_ij_svcln

Table List

2 tables(19.33 KB)

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity (EU Mean Rate = 100 For Each Severity) - Raw

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity (EU Mean Rate = 100 For Each Severity) - Unpivoted

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity (EU Mean Rate = 100 For Each Severity) - Unpivoted

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

9.95 KB
841 rows
9 columns

freq Freq	unit Unit	l_serv L Serv	severity Severity	nace_r1 Nace R1	emp_cont Emp Cont	geo Geo	time_period Time Period	value Value
Annual	Rate	Total	14 days or over	Agriculture, hunting and forestry	Limited duration	European Union (aggregate changing according to the context)	1999	88
Annual	Rate	Total	14 days or over	Agriculture, hunting and forestry	Unlimited duration	European Union (aggregate changing according to the context)	1999	173
Annual	Rate	Total	14 days or over	Agriculture, hunting and forestry	Training or probationary period	European Union (aggregate changing according to the context)	1999	117
Annual	Rate	Total	14 days or over	Agriculture, hunting and forestry	Total	European Union (aggregate changing according to the context)	1999	144
Annual	Rate	Total	14 days or over	Fishing	Unlimited duration	European Union (aggregate changing according to the context)	1999	181
Annual	Rate	Total	14 days or over	Mining and quarrying	Unlimited duration	European Union (aggregate changing according to the context)	1999	152
Annual	Rate	Total	14 days or over	Mining and quarrying	Total	European Union (aggregate changing according to the context)	1999	139
Annual	Rate	Total	14 days or over	Manufacturing	Limited duration	European Union (aggregate changing according to the context)	1999	119
Annual	Rate	Total	14 days or over	Manufacturing	Unlimited duration	European Union (aggregate changing according to the context)	1999	128
Annual	Rate	Total	14 days or over	Manufacturing	Training or probationary period	European Union (aggregate changing according to the context)	1999	119


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

Share link

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