Baselight
Sign In

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

Eurostat code: hsw_ph3_07 ยท (2014 - 2022)

@eurostat.hsw_ph3_07

Accidents At Work By Sex, Age, Severity, NACE Rev. 2 Activity And Material Agent Of Deviation - Unpivoted
@eurostat.hsw_ph3_07.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.78 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 fishingFemalesTotalNumberAustria2014307
AnnualBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified4 days or overAgriculture, forestry and fishingFemalesTotalNumberBelgium201417
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 fishingFemalesTotalNumberGermany20149
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 fishingFemalesTotalNumberEstonia201430
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.