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

Eurostat code: hsw_aw_maa2 · (2005 - 2005)

@eurostat.hsw_aw_maa2

Table List

2 tables(24.4 KB)

Incidence Rate Of Accidents At Work By Material Agent Of Specific Physical Activity, NACE Rev. 1.1 Activity, Sex, Age And Severity - Raw

Incidence Rate Of Accidents At Work By Material Agent Of Specific Physical Activity, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

Incidence Rate Of Accidents At Work By Material Agent Of Specific Physical Activity, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

@eurostat.hsw_aw_maa2.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.

12.49 KB
829 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
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Buildings, structures, surfaces - at ground level (indoor or outdoor, fixed or mobile, temporary or not) - not specified	European Union (aggregate changing according to the context)	2005	192.6
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Buildings, structures, surfaces - above ground level (indoor or outdoor) - not specified	European Union (aggregate changing according to the context)	2005	80
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Buildings, structures, surfaces - below ground level (indoor or outdoor) - not specified	European Union (aggregate changing according to the context)	2005	1
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Systems for the supply and distribution of materials, pipe networks - not specified	European Union (aggregate changing according to the context)	2005	6
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Motors, systems for energy transmission and storage - not specified	European Union (aggregate changing according to the context)	2005	3.4
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Hand tools, not powered - not specified	European Union (aggregate changing according to the context)	2005	85.4
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Hand-held or hand-guided tools, mechanical - not specified	European Union (aggregate changing according to the context)	2005	17.6
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Hand tools - without specification of power source - not specified	European Union (aggregate changing according to the context)	2005	7.1
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Machines and equipment - portable or mobile - not specified	European Union (aggregate changing according to the context)	2005	10.7
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Machines and equipment - fixed - not specified	European Union (aggregate changing according to the context)	2005	56


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.