Baselight

Recognised Occupational Diseases Belonging To The Short List, By Economic Sector (NACE Rev 2. Activity) - Experimental Statistics

Eurostat code: hsw_occ_n2 ยท (2013 - 2022)

@eurostat.hsw_occ_n2

Recognised Occupational Diseases Belonging To The Short List, By Economic Sector (NACE Rev 2. Activity) - Experimental Statistics - Unpivoted
@eurostat.hsw_occ_n2.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.

  • 23.52 KB
  • 7104 rows
  • 7 columns
freq

Freq

nace_r2

Nace R2

icd10

Icd10

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, forestry and fishingMalignant neoplasm of bronchus and lungNumberEuropean Union (aggregate changing according to the context)201313
AnnualAgriculture, forestry and fishingMalignant neoplasm of bronchus and lungPercentageEuropean Union (aggregate changing according to the context)20130.8
AnnualAgriculture, forestry and fishingMesotheliomaNumberEuropean Union (aggregate changing according to the context)201325
AnnualAgriculture, forestry and fishingMesotheliomaPercentageEuropean Union (aggregate changing according to the context)20131.5
AnnualAgriculture, forestry and fishingMononeuropathies of upper limbNumberEuropean Union (aggregate changing according to the context)20131107
AnnualAgriculture, forestry and fishingMononeuropathies of upper limbPercentageEuropean Union (aggregate changing according to the context)20134.2
AnnualAgriculture, forestry and fishingOther diseases of inner earNumberEuropean Union (aggregate changing according to the context)2013375
AnnualAgriculture, forestry and fishingOther diseases of inner earPercentageEuropean Union (aggregate changing according to the context)20134.4
AnnualAgriculture, forestry and fishingOther peripheral vascular diseasesNumberEuropean Union (aggregate changing according to the context)201322
AnnualAgriculture, forestry and fishingOther peripheral vascular diseasesPercentageEuropean Union (aggregate changing according to the context)20135

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "icd10" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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