Baselight
Sign In

Accidents At Work By Sex, Age, Severity, NACE Rev. 2 Activity And Material Agent Of Specific Physical Activity

Eurostat code: hsw_ph3_05 ยท (2014 - 2022)

@eurostat.hsw_ph3_05

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

  • 9.16 MB
  • 17416740 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 fishingFemalesTotalNumberAustria2014
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 fishingFemalesTotalNumberBulgaria20142
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 fishingFemalesTotalNumberCyprus2014
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberCzechia2014
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 fishingFemalesTotalNumberDenmark2014
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberEstonia201437
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberGreece2014

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.