Number Of Fatal Accidents At Work By Member State And Age, Excluding Road Traffic Accidents And Accidents On Board Of Any Mean Of Transport In The Course Of Work

Eurostat code: hsw_aw_fnms · (1994 - 2007)

@eurostat.hsw_aw_fnms

Table List

2 tables(30.38 KB)

Number Of Fatal Accidents At Work By Member State And Age, Excluding Road Traffic Accidents And Accidents On Board Of Any Mean Of Transport In The Course Of Work - Raw

Number Of Fatal Accidents At Work By Member State And Age, Excluding Road Traffic Accidents And Accidents On Board Of Any Mean Of Transport In The Course Of Work - Unpivoted

Number Of Fatal Accidents At Work By Member State And Age, Excluding Road Traffic Accidents And Accidents On Board Of Any Mean Of Transport In The Course Of Work - Unpivoted

@eurostat.hsw_aw_fnms.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.37 KB
1742 rows
8 columns

freq Freq	unit Unit	severity Severity	age Age	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Austria	1994	161
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Belgium	1994	94
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Germany	1994	910
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Denmark	1994	44
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Greece	1994	52
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Spain	1994	489
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Finland	1994	42
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	France	1994	427
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Ireland	1994	44
Annual	Number	Fatal	Total	Agriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; financial intermediation; real estate	Italy	1994	709


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

Share link

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