Number Of Accidents At Work By Specific Physical Activity, NACE Rev. 1.1 Activity, Sex, Age And Severity

Eurostat code: hsw_aw_pa1 · (2005 - 2005)

@eurostat.hsw_aw_pa1

Table List

2 tables(21.13 KB)

Number Of Accidents At Work By Specific Physical Activity, NACE Rev. 1.1 Activity, Sex, Age And Severity - Raw

Number Of Accidents At Work By Specific Physical Activity, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

Number Of Accidents At Work By Specific Physical Activity, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

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

10.85 KB
439 rows
10 columns

freq Freq	unit Unit	severity Severity	age Age	sex Sex	nace_r1 Nace R1	physact Physact	geo Geo	time_period Time Period	value Value
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Operating machine	European Union (aggregate changing according to the context)	2005	20298
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Working with hand-held tools	European Union (aggregate changing according to the context)	2005	40426
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Driving/being on board a means of transport or handling equipment	European Union (aggregate changing according to the context)	2005	25198
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Handling of objects	European Union (aggregate changing according to the context)	2005	104950
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Carrying by hand	European Union (aggregate changing according to the context)	2005	52360
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Movement	European Union (aggregate changing according to the context)	2005	145264
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Presence	European Union (aggregate changing according to the context)	2005	8397
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Other specific physical activities not listed in this classification	European Union (aggregate changing according to the context)	2005	8453
Annual	Percentage	4 days or over	Total	Females	Total - all NACE activities	Total	European Union (aggregate changing according to the context)	2005	405348
Annual	Percentage	4 days or over	Total	Males	Total - all NACE activities	Operating machine	European Union (aggregate changing according to the context)	2005	106560


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

Share link

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