Baselight
Sign In

Fatal Accidents At Work By NACE Rev. 2 Activity

Eurostat code: hsw_n2_02 ยท (2008 - 2022)

@eurostat.hsw_n2_02

Fatal Accidents At Work By NACE Rev. 2 Activity - Unpivoted
@eurostat.hsw_n2_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.

  • 137.59 KB
  • 111512 rows
  • 6 columns
freq

Freq

unit

Unit

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualNumberAgriculture, forestry and fishingAustria200876
AnnualNumberAgriculture, forestry and fishingBelgium20083
AnnualNumberAgriculture, forestry and fishingBulgaria20085
AnnualNumberAgriculture, forestry and fishingSwitzerland20084
AnnualNumberAgriculture, forestry and fishingCyprus2008
AnnualNumberAgriculture, forestry and fishingCzechia200816
AnnualNumberAgriculture, forestry and fishingGermany2008102
AnnualNumberAgriculture, forestry and fishingDenmark200810
AnnualNumberAgriculture, forestry and fishingEstonia20081
AnnualNumberAgriculture, forestry and fishingGreece20082

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