Baselight

Relative Standardised Incidence Rate Of Accidental Injuries At Work By Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity (mean Rate For Each Member State = 100)

Eurostat code: hsw_ij_cln ยท (1999 - 1999)

@eurostat.hsw_ij_cln

Relative Standardised Incidence Rate Of Accidental Injuries At Work By Permanency Of The Job, Length Of Service In The Enterprise And NACE Rev. 1.1 Activity (mean Rate For Each Member State = 100) - Unpivoted
@eurostat.hsw_ij_cln.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.

  • 12.09 KB
  • 2281 rows
  • 8 columns
freq

Freq

unit

Unit

emp_cont

Emp Cont

l_serv

L Serv

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryGermany1999174
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryDenmark1999111
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestrySpain199961
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryEuropean Union (aggregate changing according to the context)1999103
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryFinland1999135
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryHungary1999277
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryIreland1999132
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryItaly1999127
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestryPortugal199984
AnnualRateEmployers, self-employed and family workersTotalAgriculture, hunting and forestrySweden1999173

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

Share link

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