Baselight

Percentage Distribution Of Accidents At Work By Deviation, NACE Rev. 1.1 Activity, Sex, Age And Severity

Eurostat code: hsw_aw_de3 ยท (2005 - 2005)

@eurostat.hsw_aw_de3

Percentage Distribution Of Accidents At Work By Deviation, NACE Rev. 1.1 Activity, Sex, Age And Severity - Unpivoted
@eurostat.hsw_aw_de3.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.56 KB
  • 501 rows
  • 10 columns
freq

Freq

unit

Unit

severity

Severity

age

Age

sex

Sex

nace_r1

Nace R1

deviatn

Deviatn

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesDeviation due to electrical problems, explosion, fireEuropean Union (aggregate changing according to the context)20050.4
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesDeviation by overflow, overturn, leak, flow, vaporisation, emissionEuropean Union (aggregate changing according to the context)20051.9
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesBreakage, bursting, splitting, slipping, fall, collapse of material agentEuropean Union (aggregate changing according to the context)20056.3
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesLoss of control (total or partial) of machine, means of transport or handling equipment, hand-held tool, object, animalEuropean Union (aggregate changing according to the context)200519.9
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesSlipping - stumbling and falling - fall of personsEuropean Union (aggregate changing according to the context)200529.1
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesBody movement without any physical stress (generally leading to an external injury)European Union (aggregate changing according to the context)200514.9
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesBody movement under or with physical stress (generally leading to an internal injury)European Union (aggregate changing according to the context)200521.4
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesShock, fright, violence, aggression, threat, presenceEuropean Union (aggregate changing according to the context)20054.2
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesOther deviations not listed above in this classification.European Union (aggregate changing according to the context)20051.8
AnnualPercentage4 days or overTotalFemalesTotal - all NACE activitiesTotalEuropean Union (aggregate changing according to the context)2005100

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

Share link

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