Relative Incidence Rate Of Accidental Injuries At Work By Severity, Frequency Of Shift Work And Age (EU Mean Rate = 100 For Each Severity)

Eurostat code: hsw_ij_svsha · (1999 - 1999)

@eurostat.hsw_ij_svsha

Table List

2 tables(12.24 KB)

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Frequency Of Shift Work And Age (EU Mean Rate = 100 For Each Severity) - Raw

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Frequency Of Shift Work And Age (EU Mean Rate = 100 For Each Severity) - Unpivoted

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Frequency Of Shift Work And Age (EU Mean Rate = 100 For Each Severity) - Unpivoted

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

6.4 KB
74 rows
8 columns

freq Freq	unit Unit	age Age	severity Severity	frequenc Frequenc	geo Geo	time_period Time Period	value Value
Annual	Rate	Total	14 days or over	Never	European Union (aggregate changing according to the context)	1999	92
Annual	Rate	Total	14 days or over	Sometimes	European Union (aggregate changing according to the context)	1999	129
Annual	Rate	Total	14 days or over	Total	European Union (aggregate changing according to the context)	1999	100
Annual	Rate	Total	14 days or over	Usually	European Union (aggregate changing according to the context)	1999	135
Annual	Rate	Total	4 days or over	Never	European Union (aggregate changing according to the context)	1999	92
Annual	Rate	Total	4 days or over	Sometimes	European Union (aggregate changing according to the context)	1999	130
Annual	Rate	Total	4 days or over	Total	European Union (aggregate changing according to the context)	1999	100
Annual	Rate	Total	4 days or over	Usually	European Union (aggregate changing according to the context)	1999	138
Annual	Rate	Total	Total	Never	European Union (aggregate changing according to the context)	1999	89
Annual	Rate	Total	Total	Sometimes	European Union (aggregate changing according to the context)	1999	136


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "age" VARCHAR,
  "severity" VARCHAR,
  "frequenc" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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