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

Eurostat code: hsw_aw_nnaag · (1995 - 2007)

@eurostat.hsw_aw_nnaag

Table List

2 tables(230.37 KB)

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

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

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

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

99.6 KB
33318 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	4 days or over	Total	Agriculture, hunting and forestry	Austria	1995	13337
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Belgium	1995	1213
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Germany	1995	128026
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Denmark	1995	2860
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Greece	1995	650
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Spain	1995	30937
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Finland	1995	1235
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	France	1995	24543
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Ireland	1995	671
Annual	Number	4 days or over	Total	Agriculture, hunting and forestry	Italy	1995	102541


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.