Baselight

Standardised Prevalence Rate Of Work-related Health Problems By Severity, Diagnosis Group, NACE Rev. 1.1 Activity And Age

Eurostat code: hsw_hp_svdna ยท (1999 - 1999)

@eurostat.hsw_hp_svdna

Standardised Prevalence Rate Of Work-related Health Problems By Severity, Diagnosis Group, NACE Rev. 1.1 Activity And Age - Unpivoted
@eurostat.hsw_hp_svdna.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.6 KB
  • 927 rows
  • 9 columns
freq

Freq

unit

Unit

age

Age

severity

Severity

nace_r1

Nace R1

diagnose

Diagnose

geo

Geo

time_period

Time Period

value

Value

AnnualRateTotal14 days or overAgriculture, hunting and forestryMusculo-skeletal disordersEuropean Union (aggregate changing according to the context)1999975
AnnualRateTotal14 days or overAgriculture, hunting and forestryOther not elsewhere mentionedEuropean Union (aggregate changing according to the context)1999240
AnnualRateTotal14 days or overAgriculture, hunting and forestryPulmonary disordersEuropean Union (aggregate changing according to the context)199975
AnnualRateTotal14 days or overAgriculture, hunting and forestryStress, depression, anxietyEuropean Union (aggregate changing according to the context)199999
AnnualRateTotal14 days or overAgriculture, hunting and forestryTotalEuropean Union (aggregate changing according to the context)19991528
AnnualRateTotal14 days or overFishingMusculo-skeletal disordersEuropean Union (aggregate changing according to the context)19991602
AnnualRateTotal14 days or overFishingOther not elsewhere mentionedEuropean Union (aggregate changing according to the context)19991305
AnnualRateTotal14 days or overFishingTotalEuropean Union (aggregate changing according to the context)19993026
AnnualRateTotal14 days or overMining and quarryingMusculo-skeletal disordersEuropean Union (aggregate changing according to the context)1999636
AnnualRateTotal14 days or overMining and quarryingOther not elsewhere mentionedEuropean Union (aggregate changing according to the context)1999308

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

Share link

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