Baselight

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

Eurostat code: hsw_hp_dinag ยท (1999 - 1999)

@eurostat.hsw_hp_dinag

Standardised Prevalence Rate Of Work-related Health Problems By Diagnosis Group, NACE Rev. 1.1 Activity And Age - Unpivoted
@eurostat.hsw_hp_dinag.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.

  • 22.87 KB
  • 2970 rows
  • 8 columns
freq

Freq

unit

Unit

age

Age

nace_r1

Nace R1

diagnose

Diagnose

geo

Geo

time_period

Time Period

value

Value

AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersDenmark19995513
AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersSpain1999809
AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersEuropean Union (aggregate changing according to the context)19992895
AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersHungary1999819
AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersItaly19992983
AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersLuxembourg19995905
AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersSweden19994387
AnnualRateTotalAgriculture, hunting and forestryMusculo-skeletal disordersUnited Kingdom19992038
AnnualRateTotalAgriculture, hunting and forestryOther not elsewhere mentionedDenmark19992164
AnnualRateTotalAgriculture, hunting and forestryOther not elsewhere mentionedSpain1999756

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "age" 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.