Baselight

Number Of Accidents At Work By Type Of Injury And Severity

Eurostat code: hsw_aw_ninsv ยท (1997 - 2007)

@eurostat.hsw_aw_ninsv

Number Of Accidents At Work By Type Of Injury And Severity - Raw
@eurostat.hsw_aw_ninsv.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

  • 34.33 KB
  • 488 rows
  • 16 columns
freq

Freq

unit

Unit

severity

Severity

injury

Injury

geo

Geo

n_1997

1997

n_1998

1998

n_1999

1999

n_2000

2000

n_2001

2001

n_2002

2002

n_2003

2003

n_2004

2004

n_2005

2005

n_2006

2006

n_2007

2007

AnnualNumberFrom 14 to 20 daysWounds and superficial injuriesEuropean Union - 15 countries (1995-2004) and Norway1411171391321375339318189612731157502077658744627019562167
AnnualNumberFrom 14 to 20 daysSuperficial injuriesEuropean Union - 15 countries (1995-2004) and Norway5637611957032969728772293923465036598414234390739572
AnnualNumberFrom 14 to 20 daysOpen woundsEuropean Union - 15 countries (1995-2004) and Norway3043303329532559622554242792771228028315743263151199
AnnualNumberFrom 14 to 20 daysOther types of wounds and superficial injuriesEuropean Union - 15 countries (1995-2004) and Norway331183627234550391723456134343739571726938278725215
AnnualNumberFrom 14 to 20 daysBone fracturesEuropean Union - 15 countries (1995-2004) and Norway2737126861260282621525509244461962620556165651543413034
AnnualNumberFrom 14 to 20 daysClosed fracturesEuropean Union - 15 countries (1995-2004) and Norway3009300729592934209283542214754574956586685
AnnualNumberFrom 14 to 20 daysOpen fracturesEuropean Union - 15 countries (1995-2004) and Norway32432229432415225564801696738719
AnnualNumberFrom 14 to 20 daysOther types of bone fracturesEuropean Union - 15 countries (1995-2004) and Norway7787366937581153
AnnualNumberFrom 14 to 20 daysDislocations, sprains and strainsEuropean Union - 15 countries (1995-2004) and Norway7072172671795334212638273323154347047312471154588742541
AnnualNumberFrom 14 to 20 daysDislocations and subluxationsEuropean Union - 15 countries (1995-2004) and Norway194523412530396838724819465964176331649327018

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "severity" VARCHAR,
  "injury" VARCHAR,
  "geo" VARCHAR,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE
);

Share link

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