Baselight
Sign In

Standardised Incidence Rate Of Accidents At Work By NACE Rev. 1.1 Activity And Size Of Enterprise

Eurostat code: hsw_aw_inasz ยท (1996 - 2007)

@eurostat.hsw_aw_inasz

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

  • 11.94 KB
  • 1246 rows
  • 8 columns
freq

Freq

unit

Unit

severity

Severity

sizeclas

Sizeclas

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualRate4 days or overZeroAgriculture; 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 Norway19963557
AnnualRate4 days or overZeroManufacturingEuropean Union - 15 countries (1995-2004) and Norway199610522
AnnualRate4 days or overZeroElectricity, gas and water supplyEuropean Union - 15 countries (1995-2004) and Norway19967536
AnnualRate4 days or overZeroConstructionEuropean Union - 15 countries (1995-2004) and Norway19967091
AnnualRate4 days or overZeroWholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goodsEuropean Union - 15 countries (1995-2004) and Norway19961487
AnnualRate4 days or overZeroHotels and restaurantsEuropean Union - 15 countries (1995-2004) and Norway19961312
AnnualRate4 days or overZeroTransport, storage and communicationEuropean Union - 15 countries (1995-2004) and Norway19966760
AnnualRate4 days or overZeroFinancial intermediation; real estateEuropean Union - 15 countries (1995-2004) and Norway1996647
AnnualRate4 days or overFrom 1 to 9 employeesAgriculture; 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 Norway19964241
AnnualRate4 days or overFrom 1 to 9 employeesManufacturingEuropean Union - 15 countries (1995-2004) and Norway19966238

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

Share link

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