Baselight

Percentage Distribution Of Causes Of Disability By Sex And Economic Activity (NACE Rev. 1)

Eurostat code: hlth_db_emcana ยท (2002 - 2002)

@eurostat.hlth_db_emcana

Percentage Distribution Of Causes Of Disability By Sex And Economic Activity (NACE Rev. 1) - Unpivoted
@eurostat.hlth_db_emcana.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.

  • 16.4 KB
  • 3686 rows
  • 7 columns
freq

Freq

nace_r1

Nace R1

sex

Sex

hp_cause

Hp Cause

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, hunting and forestryFemalesBorn with it or birth injuryCzechia20029.5
AnnualAgriculture, hunting and forestryFemalesBorn with it or birth injuryEuropean Union - 15 countries (1995-2004)20026.1
AnnualAgriculture, hunting and forestryFemalesBorn with it or birth injuryEuropean Union - 25 countries (2004-2006)20026.1
AnnualAgriculture, hunting and forestryFemalesBorn with it or birth injuryRomania20025.4
AnnualAgriculture, hunting and forestryFemalesNo responseGreece200219
AnnualAgriculture, hunting and forestryFemalesNo responseEuropean Union - 15 countries (1995-2004)20023.5
AnnualAgriculture, hunting and forestryFemalesNo responseEuropean Union - 25 countries (2004-2006)20023.1
AnnualAgriculture, hunting and forestryFemalesHousehold, leisure and sports accident or injury (non-work related)European Union - 15 countries (1995-2004)20022.4
AnnualAgriculture, hunting and forestryFemalesHousehold, leisure and sports accident or injury (non-work related)European Union - 25 countries (2004-2006)20022.5
AnnualAgriculture, hunting and forestryFemalesHousehold, leisure and sports accident or injury (non-work related)Romania20023.6

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "sex" VARCHAR,
  "hp_cause" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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