Number Of Accidents At Work By Part Of Body Injured And Severity

Eurostat code: hsw_aw_nbosv · (1996 - 2007)

@eurostat.hsw_aw_nbosv

Table List

2 tables(33.83 KB)

Number Of Accidents At Work By Part Of Body Injured And Severity - Raw

Number Of Accidents At Work By Part Of Body Injured And Severity - Unpivoted

Number Of Accidents At Work By Part Of Body Injured And Severity - Unpivoted

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

13.74 KB
1200 rows
7 columns

freq Freq	unit Unit	severity Severity	bodypart Bodypart	geo Geo	time_period Time Period	value Value
Annual	Number	From 14 to 20 days	Head, not further specified	European Union - 15 countries (1995-2004) and Norway	1996	24246
Annual	Number	From 14 to 20 days	Neck, inclusive spine and vertebra in the neck	European Union - 15 countries (1995-2004) and Norway	1996	8619
Annual	Number	From 14 to 20 days	Back, including spine and vertebra in the back	European Union - 15 countries (1995-2004) and Norway	1996	37296
Annual	Number	From 14 to 20 days	Torso and organs, not further specified	European Union - 15 countries (1995-2004) and Norway	1996	25095
Annual	Number	From 14 to 20 days	Upper extremities, not further specified	European Union - 15 countries (1995-2004) and Norway	1996	168573
Annual	Number	From 14 to 20 days	Lower extremities, not further specified	European Union - 15 countries (1995-2004) and Norway	1996	109004
Annual	Number	From 14 to 20 days	Whole body and multiple sites, not further specified	European Union - 15 countries (1995-2004) and Norway	1996	14486
Annual	Number	From 14 to 20 days	Other parts of body injured, not mentioned above	European Union - 15 countries (1995-2004) and Norway	1996	543
Annual	Number	From 14 to 20 days	Total	European Union - 15 countries (1995-2004) and Norway	1996	401726
Annual	Number	From 14 to 20 days	Part of body injured not specified	European Union - 15 countries (1995-2004) and Norway	1996	13864


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

Share link

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