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

Eurostat code: hsw_aw_nnasx · (1993 - 2007)

@eurostat.hsw_aw_nnasx

Table List

2 tables(183.85 KB)

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

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

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

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

79.39 KB
24471 rows
8 columns

freq Freq	unit Unit	severity Severity	sex Sex	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Austria	1993	4856
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Belgium	1993	168
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Greece	1993	83
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Spain	1993	3782
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Finland	1993	326
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	France	1993	3813
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Ireland	1993	17
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Italy	1993	47136
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Luxembourg	1993	133
Annual	Number	4 days or over	Females	Agriculture, hunting and forestry	Netherlands	1993


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

Share link

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