Name: Number Of Accidents At Work By NACE Rev. 1.1 Activity And Severity
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

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

This Eurostat dataset contains data on number of accidents at work by nace rev. 1.1 activity and severity, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2012-01-11T23:00:00+0100

Tables

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

@eurostat.hsw_aw_nnasv.raw

20.87 kB
100 rows
17 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "severity" VARCHAR,
  "nace_r1" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1996" DOUBLE  -- 1996,
  "n_1997" DOUBLE  -- 1997,
  "n_1998" DOUBLE  -- 1998,
  "n_1999" DOUBLE  -- 1999,
  "n_2000" DOUBLE  -- 2000,
  "n_2001" DOUBLE  -- 2001,
  "n_2002" DOUBLE  -- 2002,
  "n_2003" DOUBLE  -- 2003,
  "n_2004" DOUBLE  -- 2004,
  "n_2005" DOUBLE  -- 2005,
  "n_2006" DOUBLE  -- 2006,
  "n_2007" DOUBLE  -- 2007
);

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

@eurostat.hsw_aw_nnasv.tidy

14.36 kB
1,200 rows
7 columns

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