Baselight

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Working Hours And Sex (EU Mean Rate = 100 For Each Severity)

Eurostat code: hsw_ij_svhos ยท (1999 - 1999)

@eurostat.hsw_ij_svhos

Relative Incidence Rate Of Accidental Injuries At Work By Severity, Working Hours And Sex (EU Mean Rate = 100 For Each Severity) - Unpivoted
@eurostat.hsw_ij_svhos.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.31 KB
  • 57 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

severity

Severity

worktime

Worktime

geo

Geo

time_period

Time Period

value

Value

AnnualRateFemales14 days or overFrom 10 to 19 hoursEuropean Union (aggregate changing according to the context)1999103
AnnualRateFemales14 days or overFrom 20 to 29 hoursEuropean Union (aggregate changing according to the context)199973
AnnualRateFemales14 days or overFrom 30 to 39 hoursEuropean Union (aggregate changing according to the context)199963
AnnualRateFemales14 days or overFrom 40 to 49 hoursEuropean Union (aggregate changing according to the context)199978
AnnualRateFemales14 days or over50 hours or overEuropean Union (aggregate changing according to the context)199953
AnnualRateFemales14 days or overTotalEuropean Union (aggregate changing according to the context)199975
AnnualRateFemales4 days or overFrom 10 to 19 hoursEuropean Union (aggregate changing according to the context)199993
AnnualRateFemales4 days or overFrom 20 to 29 hoursEuropean Union (aggregate changing according to the context)199976
AnnualRateFemales4 days or overFrom 30 to 39 hoursEuropean Union (aggregate changing according to the context)199969
AnnualRateFemales4 days or overFrom 40 to 49 hoursEuropean Union (aggregate changing according to the context)199969

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

Share link

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