Baselight
Sign In

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

Eurostat code: hsw_aw_mad3 ยท (2005 - 2005)

@eurostat.hsw_aw_mad3

Percentage Distribution Of Accidents At Work By Material Agent Of Deviation, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted
@eurostat.hsw_aw_mad3.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.34 KB
  • 931 rows
  • 10 columns
freq

Freq

unit

Unit

severity

Severity

age

Age

sex

Sex

nace_r1

Nace R1

matagent

Matagent

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesBuildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specifiedEuropean Union (aggregate changing according to the context)200524.8
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesBuildings, structures, surfaces - above ground level (indoor or outdoor) - not specifiedEuropean Union (aggregate changing according to the context)200510.1
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesBuildings, structures, surfaces - below ground level (indoor or outdoor) - not specifiedEuropean Union (aggregate changing according to the context)20050.2
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesSystems for the supply and distribution of materials, pipe networks - not specifiedEuropean Union (aggregate changing according to the context)20050.4
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesMotors, systems for energy transmission and storage - not specifiedEuropean Union (aggregate changing according to the context)20050.4
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesHand tools, not powered - not specifiedEuropean Union (aggregate changing according to the context)20058.7
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesHand-held or hand-guided tools, mechanical - not specifiedEuropean Union (aggregate changing according to the context)20051.3
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesHand tools - without specification of power source - not specifiedEuropean Union (aggregate changing according to the context)20050.5
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesMachines and equipment - portable or mobile - not specifiedEuropean Union (aggregate changing according to the context)20050.7
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesMachines and equipment - fixed - not specifiedEuropean Union (aggregate changing according to the context)20055.2

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

Share link

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