Baselight
Sign In

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

Eurostat code: hsw_ph3_09 ยท (2014 - 2022)

@eurostat.hsw_ph3_09

Accidents At Work By Sex, Age, Severity, NACE Rev. 2 Activity And Material Agent Of Contact Mode Injury - Unpivoted
@eurostat.hsw_ph3_09.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.

  • 11.48 MB
  • 17543460 rows
  • 10 columns
freq

Freq

matagent

Matagent

severity

Severity

nace_r2

Nace R2

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberAustria2014449
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberBelgium2014
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberBulgaria20144
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberSwitzerland2014
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberCyprus20143
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberCzechia2014201
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberGermany2014
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberDenmark201413
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberEstonia201455
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberGreece20142

CREATE TABLE tidy (
  "freq" VARCHAR,
  "matagent" 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.