Baselight
Sign In

Incidence Rate Of Accidents At Work By Contact - Mode Of Injury, NACE Rev. 1.1 Activity, Sex, Age And Severity

Eurostat code: hsw_aw_co2 ยท (2005 - 2005)

@eurostat.hsw_aw_co2

Incidence Rate Of Accidents At Work By Contact - Mode Of Injury, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted
@eurostat.hsw_aw_co2.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.

  • 10.75 KB
  • 462 rows
  • 10 columns
freq

Freq

unit

Unit

severity

Severity

age

Age

sex

Sex

nace_r1

Nace R1

modinj

Modinj

geo

Geo

time_period

Time Period

value

Value

AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesContact with electrical voltage, temperature, hazardous substances - not specifiedEuropean Union (aggregate changing according to the context)200535.6
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesDrowned, buried, enveloped - not specifiedEuropean Union (aggregate changing according to the context)20050.8
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesHorizontal or vertical impact with or against a stationary object (the victim is in motion) - not specifiedEuropean Union (aggregate changing according to the context)2005330.1
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesStruck by object in motion, collision with - not specifiedEuropean Union (aggregate changing according to the context)2005136.2
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesContact with sharp, pointed, rough, coarse Material Agent - not specifiedEuropean Union (aggregate changing according to the context)2005171
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesTrapped, crushed, etc. - not specifiedEuropean Union (aggregate changing according to the context)200556.3
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesPhysical or mental stress - not specifiedEuropean Union (aggregate changing according to the context)2005250.8
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesBite, kick, etc. (animal or human) - not specifiedEuropean Union (aggregate changing according to the context)200543.2
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesOther contacts - modes of injury not listed in this classificationEuropean Union (aggregate changing according to the context)200535.3
AnnualRate4 days or overTotalFemalesTotal - all NACE activitiesTotalEuropean Union (aggregate changing according to the context)20051059.3

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

Share link

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