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

Eurostat code: hsw_aw_co3 · (2005 - 2005)

@eurostat.hsw_aw_co3

Table List

2 tables(20.27 KB)

Percentage Distribution Of Accidents At Work By Contact - Mode Of Injury, NACE Rev. 1.1 Activity, Sex, Age And Severity - Raw

Percentage Distribution Of Accidents At Work By Contact - Mode Of Injury, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

Percentage Distribution Of Accidents At Work By Contact - Mode Of Injury, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

@eurostat.hsw_aw_co3.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.42 KB
498 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
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Contact with electrical voltage, temperature, hazardous substances - not specified	European Union (aggregate changing according to the context)	2005	3.4
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Drowned, buried, enveloped - not specified	European Union (aggregate changing according to the context)	2005	0.1
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Horizontal or vertical impact with or against a stationary object (the victim is in motion) - not specified	European Union (aggregate changing according to the context)	2005	31.2
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Struck by object in motion, collision with - not specified	European Union (aggregate changing according to the context)	2005	12.9
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Contact with sharp, pointed, rough, coarse Material Agent - not specified	European Union (aggregate changing according to the context)	2005	16.1
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Trapped, crushed, etc. - not specified	European Union (aggregate changing according to the context)	2005	5.3
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Physical or mental stress - not specified	European Union (aggregate changing according to the context)	2005	23.7
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Bite, kick, etc. (animal or human) - not specified	European Union (aggregate changing according to the context)	2005	4.1
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Other contacts - modes of injury not listed in this classification	European Union (aggregate changing according to the context)	2005	3.3
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Total	European Union (aggregate changing according to the context)	2005	100


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.