Baselight
Sign In

Accidents At Work By Sex, Age, Severity, NACE Rev. 2 Activity And Contact Mode Of Injury

Eurostat code: hsw_ph3_08 ยท (2014 - 2022)

@eurostat.hsw_ph3_08

Accidents At Work By Sex, Age, Severity, NACE Rev. 2 Activity And Contact Mode Of Injury - Unpivoted
@eurostat.hsw_ph3_08.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.14 MB
  • 7974300 rows
  • 10 columns
freq

Freq

modinj

Modinj

severity

Severity

nace_r2

Nace R2

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberAustria201410
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberBelgium20142
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberBulgaria2014
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberSwitzerland2014
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberCyprus2014
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberCzechia2014
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberGermany2014136
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberDenmark20144
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberEstonia20142
AnnualContact with electrical voltage, temperature, hazardous substances - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberGreece2014

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

Share link

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