Baselight

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

Eurostat code: hsw_aw_inasx ยท (1993 - 2007)

@eurostat.hsw_aw_inasx

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

  • 48.31 KB
  • 10067 rows
  • 8 columns
freq

Freq

unit

Unit

severity

Severity

sex

Sex

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualRate4 days or overFemalesAgriculture, hunting and forestryAustria19933734
AnnualRate4 days or overFemalesAgriculture, hunting and forestryBelgium19937689
AnnualRate4 days or overFemalesAgriculture, hunting and forestryGreece1993881
AnnualRate4 days or overFemalesAgriculture, hunting and forestrySpain19931037
AnnualRate4 days or overFemalesAgriculture, hunting and forestryFinland1993632
AnnualRate4 days or overFemalesAgriculture, hunting and forestryFrance19935157
AnnualRate4 days or overFemalesAgriculture, hunting and forestryIreland1993112
AnnualRate4 days or overFemalesAgriculture, hunting and forestryItaly19938156
AnnualRate4 days or overFemalesAgriculture, hunting and forestryPortugal19934866
AnnualRate4 days or overFemalesAgriculture, hunting and forestrySweden19931841

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

Share link

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