Baselight
Sign In

Standardised Incidence Rate Of Accidents At Work By NACE Rev. 1.1 Activity And Employment Status

Eurostat code: hsw_aw_inaws ยท (1996 - 2007)

@eurostat.hsw_aw_inaws

Standardised Incidence Rate Of Accidents At Work By NACE Rev. 1.1 Activity And Employment Status - Unpivoted
@eurostat.hsw_aw_inaws.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.

  • 10.29 KB
  • 780 rows
  • 8 columns
freq

Freq

unit

Unit

severity

Severity

wstatus

Wstatus

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualRate4 days or overContributing family workersAgriculture, hunting and forestryEuropean Union - 15 countries (1995-2004) and Norway19965483
AnnualRate4 days or overContributing family workersAgriculture; manufacturing; electricity, gas and water supply; construction; wholesale and retail trade; hotels and restaurants; transport; financial intermediation; real estateEuropean Union - 15 countries (1995-2004) and Norway19963178
AnnualRate4 days or overContributing family workersManufacturingEuropean Union - 15 countries (1995-2004) and Norway1996882
AnnualRate4 days or overContributing family workersElectricity, gas and water supplyEuropean Union - 15 countries (1995-2004) and Norway1996
AnnualRate4 days or overContributing family workersConstructionEuropean Union - 15 countries (1995-2004) and Norway19961204
AnnualRate4 days or overContributing family workersWholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goodsEuropean Union - 15 countries (1995-2004) and Norway199673
AnnualRate4 days or overContributing family workersHotels and restaurantsEuropean Union - 15 countries (1995-2004) and Norway199612
AnnualRate4 days or overContributing family workersTransport, storage and communicationEuropean Union - 15 countries (1995-2004) and Norway1996863
AnnualRate4 days or overContributing family workersFinancial intermediation; real estateEuropean Union - 15 countries (1995-2004) and Norway199656
AnnualRate4 days or overEmployed personsAgriculture, hunting and forestryEuropean Union - 15 countries (1995-2004) and Norway19966737

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

Share link

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