Baselight

Non-fatal Accidents At Work By NACE Rev. 2 Activity And Sex

Eurostat code: hsw_n2_01 ยท (2008 - 2022)

@eurostat.hsw_n2_01

Non-fatal Accidents At Work By NACE Rev. 2 Activity And Sex - Unpivoted
@eurostat.hsw_n2_01.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.43 MB
  • 431943 rows
  • 7 columns
freq

Freq

unit

Unit

nace_r2

Nace R2

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualNumberAgriculture, forestry and fishingFemalesAustria20081608
AnnualNumberAgriculture, forestry and fishingFemalesBelgium200895
AnnualNumberAgriculture, forestry and fishingFemalesBulgaria200817
AnnualNumberAgriculture, forestry and fishingFemalesSwitzerland2008223
AnnualNumberAgriculture, forestry and fishingFemalesCyprus20085
AnnualNumberAgriculture, forestry and fishingFemalesCzechia2008212
AnnualNumberAgriculture, forestry and fishingFemalesGermany200814011
AnnualNumberAgriculture, forestry and fishingFemalesDenmark2008292
AnnualNumberAgriculture, forestry and fishingFemalesEstonia2008287
AnnualNumberAgriculture, forestry and fishingFemalesGreece200835

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

Share link

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