Baselight
Sign In

Accidental Injuries At Work By Type Of Injury, Work Status After The Accidental Injury And Age

Eurostat code: hsw_ij_inwsa ยท (1999 - 1999)

@eurostat.hsw_ij_inwsa

Accidental Injuries At Work By Type Of Injury, Work Status After The Accidental Injury And Age - Unpivoted
@eurostat.hsw_ij_inwsa.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.

  • 8.04 KB
  • 616 rows
  • 8 columns
freq

Freq

unit

Unit

wsta_acc

Wsta Acc

age

Age

injury

Injury

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageChange of work or workplace because of the accidental injuryTotalContusions, bruisingsEuropean Union (aggregate changing according to the context)19991.6
AnnualPercentageChange of work or workplace because of the accidental injuryTotalCuts, lacerations, severed nerves or tendonsEuropean Union (aggregate changing according to the context)19991.6
AnnualPercentageChange of work or workplace because of the accidental injuryTotalBone fracturesEuropean Union (aggregate changing according to the context)19993.9
AnnualPercentageChange of work or workplace because of the accidental injuryTotalDislocations, sprains and strainsEuropean Union (aggregate changing according to the context)19994
AnnualPercentageChange of work or workplace because of the accidental injuryTotalTraumatic amputations (loss of body parts)European Union (aggregate changing according to the context)19997.3
AnnualPercentageChange of work or workplace because of the accidental injuryTotalBurns, scalds and frostbitesEuropean Union (aggregate changing according to the context)19992
AnnualPercentageChange of work or workplace because of the accidental injuryTotalAcute infectionsEuropean Union (aggregate changing according to the context)19990.5
AnnualPercentageChange of work or workplace because of the accidental injuryTotalOther not elsewhere mentionedEuropean Union (aggregate changing according to the context)19992.7
AnnualPercentageChange of work or workplace because of the accidental injuryTotalPoisonings, gassings and asphyxiationsEuropean Union (aggregate changing according to the context)19998
AnnualPercentageChange of work or workplace because of the accidental injuryTotalTotalEuropean Union (aggregate changing according to the context)19992.4

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

Share link

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