Baselight
Sign In

Accidents At Work By Sex, Age, Severity, NACE Rev. 2 Activity And Working Environment

Eurostat code: hsw_ph3_02 ยท (2014 - 2022)

@eurostat.hsw_ph3_02

Accidents At Work By Sex, Age, Severity, NACE Rev. 2 Activity And Working Environment - Unpivoted
@eurostat.hsw_ph3_02.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.22 MB
  • 11961450 rows
  • 10 columns
freq

Freq

wrkenv

Wrkenv

severity

Severity

nace_r2

Nace R2

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberAustria20141088
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberBelgium201469
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberBulgaria20144
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberSwitzerland2014340
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberCyprus20145
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberCzechia2014802
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberGermany201413494
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberDenmark2014300
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberEstonia2014165
AnnualTotal4 days or overAgriculture, forestry and fishingFemalesTotalNumberGreece20146

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