Incidence Rate Of Accidents At Work By Working Environment, NACE Rev. 1.1 Activity, Sex, Age And Severity

Eurostat code: hsw_aw_we2 · (2005 - 2005)

@eurostat.hsw_aw_we2

Table List

2 tables(21.43 KB)

Incidence Rate Of Accidents At Work By Working Environment, NACE Rev. 1.1 Activity, Sex, Age And Severity - Raw

Incidence Rate Of Accidents At Work By Working Environment, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

Incidence Rate Of Accidents At Work By Working Environment, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted

@eurostat.hsw_aw_we2.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 KB
553 rows
10 columns

freq Freq	unit Unit	severity Severity	age Age	sex Sex	nace_r1 Nace R1	wrkenv Wrkenv	geo Geo	time_period Time Period	value Value
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Total	European Union (aggregate changing according to the context)	2005	1063.8
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Industrial site	European Union (aggregate changing according to the context)	2005	265.6
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Construction site, construction, opencast quarry, opencast mine	European Union (aggregate changing according to the context)	2005	13.3
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Farming, breeding, fish farming, forest zone	European Union (aggregate changing according to the context)	2005	49.5
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Tertiary activity area, office, amusement area, miscellaneous	European Union (aggregate changing according to the context)	2005	382.4
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Health establishment	European Union (aggregate changing according to the context)	2005	151.4
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Public area	European Union (aggregate changing according to the context)	2005	142.9
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	In the home	European Union (aggregate changing according to the context)	2005	32.6
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Sports area	European Union (aggregate changing according to the context)	2005	13.4
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	In the air, elevated, excluding construction sites	European Union (aggregate changing according to the context)	2005	1.5


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

Share link

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