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

Eurostat code: hsw_aw_nnasz · (1996 - 2007)

@eurostat.hsw_aw_nnasz

Table List

2 tables(43.79 KB)

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

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

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

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

17.79 KB
2293 rows
8 columns

freq Freq	unit Unit	severity Severity	sizeclas Sizeclas	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Number	4 days or over	Zero	Agriculture, hunting and forestry	European Union - 15 countries (1995-2004) and Norway	1996	6102
Annual	Number	4 days or over	Zero	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; transport; financial intermediation; real estate	European Union - 15 countries (1995-2004) and Norway	1996	134137
Annual	Number	4 days or over	Zero	Manufacturing	European Union - 15 countries (1995-2004) and Norway	1996	37583
Annual	Number	4 days or over	Zero	Electricity, gas and water supply	European Union - 15 countries (1995-2004) and Norway	1996	375
Annual	Number	4 days or over	Zero	Construction	European Union - 15 countries (1995-2004) and Norway	1996	45756
Annual	Number	4 days or over	Zero	Wholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goods	European Union - 15 countries (1995-2004) and Norway	1996	18630
Annual	Number	4 days or over	Zero	Hotels and restaurants	European Union - 15 countries (1995-2004) and Norway	1996	3615
Annual	Number	4 days or over	Zero	Transport, storage and communication	European Union - 15 countries (1995-2004) and Norway	1996	14440
Annual	Number	4 days or over	Zero	Financial intermediation; real estate	European Union - 15 countries (1995-2004) and Norway	1996	6836
Annual	Number	4 days or over	Zero	Total - all NACE activities	European Union - 15 countries (1995-2004) and Norway	1996	149972


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

Share link

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