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

Eurostat code: hsw_aw_nnaws · (1996 - 2007)

@eurostat.hsw_aw_nnaws

Table List

2 tables(34.88 KB)

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

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

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

@eurostat.hsw_aw_nnaws.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.72 KB
1388 rows
8 columns

freq Freq	unit Unit	severity Severity	wstatus Wstatus	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Number	4 days or over	Contributing family workers	Agriculture, hunting and forestry	European Union - 15 countries (1995-2004) and Norway	1996	24414
Annual	Number	4 days or over	Contributing family workers	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	28915
Annual	Number	4 days or over	Contributing family workers	Manufacturing	European Union - 15 countries (1995-2004) and Norway	1996	615
Annual	Number	4 days or over	Contributing family workers	Electricity, gas and water supply	European Union - 15 countries (1995-2004) and Norway	1996
Annual	Number	4 days or over	Contributing family workers	Construction	European Union - 15 countries (1995-2004) and Norway	1996	377
Annual	Number	4 days or over	Contributing family workers	Wholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goods	European Union - 15 countries (1995-2004) and Norway	1996	187
Annual	Number	4 days or over	Contributing family workers	Hotels and restaurants	European Union - 15 countries (1995-2004) and Norway	1996	11
Annual	Number	4 days or over	Contributing family workers	Transport, storage and communication	European Union - 15 countries (1995-2004) and Norway	1996	79
Annual	Number	4 days or over	Contributing family workers	Financial intermediation; real estate	European Union - 15 countries (1995-2004) and Norway	1996	32
Annual	Number	4 days or over	Contributing family workers	Total - all NACE activities	European Union - 15 countries (1995-2004) and Norway	1996	28959


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

Share link

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