Baselight
Sign In

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 - Unpivoted
@eurostat.hsw_aw_ninsv.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.

  • 25.76 KB
  • 4944 rows
  • 7 columns
freq

Freq

unit

Unit

severity

Severity

injury

Injury

geo

Geo

time_period

Time Period

value

Value

AnnualNumberFrom 14 to 20 daysWounds and superficial injuriesEuropean Union - 15 countries (1995-2004) and Norway1997141117
AnnualNumberFrom 14 to 20 daysSuperficial injuriesEuropean Union - 15 countries (1995-2004) and Norway19975637
AnnualNumberFrom 14 to 20 daysOpen woundsEuropean Union - 15 countries (1995-2004) and Norway19973043
AnnualNumberFrom 14 to 20 daysOther types of wounds and superficial injuriesEuropean Union - 15 countries (1995-2004) and Norway199733118
AnnualNumberFrom 14 to 20 daysBone fracturesEuropean Union - 15 countries (1995-2004) and Norway199727371
AnnualNumberFrom 14 to 20 daysClosed fracturesEuropean Union - 15 countries (1995-2004) and Norway19973009
AnnualNumberFrom 14 to 20 daysOpen fracturesEuropean Union - 15 countries (1995-2004) and Norway1997324
AnnualNumberFrom 14 to 20 daysOther types of bone fracturesEuropean Union - 15 countries (1995-2004) and Norway1997
AnnualNumberFrom 14 to 20 daysDislocations, sprains and strainsEuropean Union - 15 countries (1995-2004) and Norway199770721
AnnualNumberFrom 14 to 20 daysDislocations and subluxationsEuropean Union - 15 countries (1995-2004) and Norway19971945

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

Share link

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