Number Of Accidents At Work By NACE Rev. 1.1 Activity And Severity

Eurostat code: hsw_aw_nnasv · (1996 - 2007)

@eurostat.hsw_aw_nnasv

Table List

2 tables(34.4 KB)

Number Of Accidents At Work By NACE Rev. 1.1 Activity And Severity - Raw

Number Of Accidents At Work By NACE Rev. 1.1 Activity And Severity - Unpivoted

Number Of Accidents At Work By NACE Rev. 1.1 Activity And Severity - Unpivoted

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

14.02 KB
1200 rows
7 columns

freq Freq	severity Severity	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 14 to 20 days	Agriculture, hunting and forestry	Number	European Union - 15 countries (1995-2004) and Norway	1996	34452
Annual	From 14 to 20 days	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; transport; financial intermediation; real estate	Number	European Union - 15 countries (1995-2004) and Norway	1996	338630
Annual	From 14 to 20 days	Manufacturing	Number	European Union - 15 countries (1995-2004) and Norway	1996	115797
Annual	From 14 to 20 days	Electricity, gas and water supply	Number	European Union - 15 countries (1995-2004) and Norway	1996	2354
Annual	From 14 to 20 days	Construction	Number	European Union - 15 countries (1995-2004) and Norway	1996	65676
Annual	From 14 to 20 days	Wholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goods	Number	European Union - 15 countries (1995-2004) and Norway	1996	47478
Annual	From 14 to 20 days	Hotels and restaurants	Number	European Union - 15 countries (1995-2004) and Norway	1996	16187
Annual	From 14 to 20 days	Transport, storage and communication	Number	European Union - 15 countries (1995-2004) and Norway	1996	27559
Annual	From 14 to 20 days	Financial intermediation; real estate	Number	European Union - 15 countries (1995-2004) and Norway	1996	24611
Annual	From 14 to 20 days	Total - all NACE activities	Number	European Union - 15 countries (1995-2004) and Norway	1996	401726


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

Share link

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