Baselight

Accidents At Work By NACE Rev. 2 Activity And Size Of Enterprise

Eurostat code: hsw_n2_05 ยท (2008 - 2022)

@eurostat.hsw_n2_05

Accidents At Work By NACE Rev. 2 Activity And Size Of Enterprise - Unpivoted
@eurostat.hsw_n2_05.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.

  • 521.92 KB
  • 287569 rows
  • 8 columns
freq

Freq

nace_r2

Nace R2

sizeclas

Sizeclas

severity

Severity

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, forestry and fishingZero4 days or overNumberAustria200870
AnnualAgriculture, forestry and fishingZero4 days or overNumberBelgium2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberBulgaria2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberSwitzerland2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberCyprus2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberCzechia2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberGermany2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberDenmark2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberEstonia2008
AnnualAgriculture, forestry and fishingZero4 days or overNumberGreece2008

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "sizeclas" 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.