Accidental Injuries At Work By Severity And Type Of Injury

Eurostat code: hsw_ij_svinj · (1999 - 1999)

@eurostat.hsw_ij_svinj

Table List

2 tables(14.59 KB)

Accidental Injuries At Work By Severity And Type Of Injury - Raw

Accidental Injuries At Work By Severity And Type Of Injury - Unpivoted

Accidental Injuries At Work By Severity And Type Of Injury - Unpivoted

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

7.58 KB
1206 rows
7 columns

freq Freq	unit Unit	severity Severity	injury Injury	geo Geo	time_period Time Period	value Value
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Denmark	1999	3.3
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Greece	1999	5.6
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Spain	1999	4.2
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	European Union (aggregate changing according to the context)	1999	3.2
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Finland	1999	2.8
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Hungary	1999	6.4
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Ireland	1999
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Italy	1999	3.7
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Luxembourg	1999	7.1
Annual	Percentage	From 1 to 3 days	Contusions, bruisings	Portugal	1999	2.4


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.