Baselight
Sign In

Causes Of Death - Potential Years Of Life Lost By Residence

Eurostat code: hlth_cd_apyll ยท (2011 - 2022)

@eurostat.hlth_cd_apyll

Causes Of Death - Potential Years Of Life Lost By Residence - Unpivoted
@eurostat.hlth_cd_apyll.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.

  • 11.94 KB
  • 1269 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-T98Austria20112381
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Belgium20112783
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Bulgaria20114491
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Switzerland20112072
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Cyprus20111745
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Czechia20112829
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Germany20112593
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Denmark20112798
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Estonia20113416
AnnualYearFemalesAll causes of death (A00-Y89) excluding S00-T98Greece20112238

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