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

Eurostat code: hsw_aw_ws2 · (2005 - 2005)

@eurostat.hsw_aw_ws2

Table List

2 tables(18.55 KB)

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

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

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

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

9.57 KB
198 rows
10 columns

freq Freq	unit Unit	severity Severity	age Age	sex Sex	nace_r1 Nace R1	wrkstat Wrkstat	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	1005.2
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Usual workstation or within the usual local unit of work	European Union (aggregate changing according to the context)	2005	922.4
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Occasional or mobile workstation or in a journey on behalf of the employer	European Union (aggregate changing according to the context)	2005	57.4
Annual	Rate	4 days or over	Total	Females	Total - all NACE activities	Other workstation	European Union (aggregate changing according to the context)	2005	25.5
Annual	Rate	4 days or over	Total	Males	Total - all NACE activities	Total	European Union (aggregate changing according to the context)	2005	2809.9
Annual	Rate	4 days or over	Total	Males	Total - all NACE activities	Usual workstation or within the usual local unit of work	European Union (aggregate changing according to the context)	2005	2473.7
Annual	Rate	4 days or over	Total	Males	Total - all NACE activities	Occasional or mobile workstation or in a journey on behalf of the employer	European Union (aggregate changing according to the context)	2005	181.2
Annual	Rate	4 days or over	Total	Males	Total - all NACE activities	Other workstation	European Union (aggregate changing according to the context)	2005	154.9
Annual	Rate	4 days or over	Total	Total	Agriculture, hunting and forestry	Total	European Union (aggregate changing according to the context)	2005	1150.4
Annual	Rate	4 days or over	Total	Total	Agriculture, hunting and forestry	Usual workstation or within the usual local unit of work	European Union (aggregate changing according to the context)	2005	1062.3


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

Share link

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