Baselight

Standardised Incidence Rate Of Accidents At Work By NACE Rev. 1.1 Activity, Severity And Age

Eurostat code: hsw_aw_inaag ยท (1995 - 2007)

@eurostat.hsw_aw_inaag

Standardised Incidence Rate Of Accidents At Work By NACE Rev. 1.1 Activity, Severity And Age - Unpivoted
@eurostat.hsw_aw_inaag.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.

  • 63.59 KB
  • 15046 rows
  • 8 columns
freq

Freq

unit

Unit

severity

Severity

age

Age

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualRate4 days or overTotalAgriculture, hunting and forestryAustria19954952
AnnualRate4 days or overTotalAgriculture, hunting and forestryBelgium19957320
AnnualRate4 days or overTotalAgriculture, hunting and forestryGermany199511390
AnnualRate4 days or overTotalAgriculture, hunting and forestryDenmark19952671
AnnualRate4 days or overTotalAgriculture, hunting and forestryGreece19951901
AnnualRate4 days or overTotalAgriculture, hunting and forestrySpain19952410
AnnualRate4 days or overTotalAgriculture, hunting and forestryFinland1995925
AnnualRate4 days or overTotalAgriculture, hunting and forestryFrance19955442
AnnualRate4 days or overTotalAgriculture, hunting and forestryIreland1995470
AnnualRate4 days or overTotalAgriculture, hunting and forestryItaly19957125

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

Share link

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