Baselight
Sign In

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

Eurostat code: hsw_aw_ws1 ยท (2005 - 2005)

@eurostat.hsw_aw_ws1

Number Of Accidents At Work By Type Of Workstation, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted
@eurostat.hsw_aw_ws1.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.83 KB
  • 208 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

AnnualNumber4 days or overTotalFemalesTotal - all NACE activitiesTotalEuropean Union (aggregate changing according to the context)2005253872
AnnualNumber4 days or overTotalFemalesTotal - all NACE activitiesUsual workstation or within the usual local unit of workEuropean Union (aggregate changing according to the context)2005232952
AnnualNumber4 days or overTotalFemalesTotal - all NACE activitiesOccasional or mobile workstation or in a journey on behalf of the employerEuropean Union (aggregate changing according to the context)200514489
AnnualNumber4 days or overTotalFemalesTotal - all NACE activitiesOther workstationEuropean Union (aggregate changing according to the context)20056431
AnnualNumber4 days or overTotalMalesTotal - all NACE activitiesTotalEuropean Union (aggregate changing according to the context)2005875570
AnnualNumber4 days or overTotalMalesTotal - all NACE activitiesUsual workstation or within the usual local unit of workEuropean Union (aggregate changing according to the context)2005770818
AnnualNumber4 days or overTotalMalesTotal - all NACE activitiesOccasional or mobile workstation or in a journey on behalf of the employerEuropean Union (aggregate changing according to the context)200556472
AnnualNumber4 days or overTotalMalesTotal - all NACE activitiesOther workstationEuropean Union (aggregate changing according to the context)200548280
AnnualNumber4 days or overTotalTotalAgriculture, hunting and forestryTotalEuropean Union (aggregate changing according to the context)200560475
AnnualNumber4 days or overTotalTotalAgriculture, hunting and forestryUsual workstation or within the usual local unit of workEuropean Union (aggregate changing according to the context)200555847

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.