Baselight
Sign In

Causes Of Death - Years And Potential Years Of Life Lost By NUTS 2 Region Of Residence, 3 Year Average

Eurostat code: hlth_cd_ypyll · (2013 - 2022)

@eurostat.hlth_cd_ypyll

Causes Of Death - Years And Potential Years Of Life Lost By NUTS 2 Region Of Residence, 3 Year Average - Unpivoted
@eurostat.hlth_cd_ypyll.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.

  • 90.93 KB
  • 13497 rows
  • 7 columns
freq

Freq

unit

Unit

sex

Sex

icd10

Icd10

geo

Geo

time_period

Time Period

value

Value

AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Austria20132317.3
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Ostösterreich20132490.4
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Burgenland20132052.3
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Niederösterreich20132221.8
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Wien20132806.7
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Südösterreich20132337.1
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Kärnten20132417.8
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Steiermark20132300.7
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Westösterreich20132039.2
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Oberösterreich20132066.5

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

Share link

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