Baselight

Accidents At Work By Days Lost And NACE Rev. 2 Activity

Eurostat code: hsw_n2_04 ยท (2008 - 2022)

@eurostat.hsw_n2_04

Accidents At Work By Days Lost And NACE Rev. 2 Activity - Unpivoted
@eurostat.hsw_n2_04.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.

  • 1.13 MB
  • 613570 rows
  • 7 columns
freq

Freq

nace_r2

Nace R2

severity

Severity

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberAustria2008166
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberBelgium200848
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberBulgaria20087
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberSwitzerland2008250
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberCyprus20082
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberCzechia2008
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberGermany2008
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberDenmark2008113
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberEstonia200873
AnnualAgriculture, forestry and fishingFrom 14 to 20 daysNumberGreece200892

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

Share link

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