About this Dataset

Potential Years Of Life Lost

Potential Years of Life Lost (PYLL) is a summary measure of premature mortality which provides an explicit way of weighting deaths occurring at younger ages, which are, a priori, preventable. The calculation of PYLL involves summing up deaths occurring at each age and multiplying this with the number of remaining years to live up to a selected age limit. The limit of 75 years has been chosen for the calculations in OECD Health Statistics.

The selected ICD categories presented in the OECD Health Statistics database are detailed in an Excel file available for download, with codes according to the Tenth revision of the International Classification of Diseases (ICD) along with codes from other ICD revisions used in the WHO Mortality Database.

Please refer to the Sources and Methods for detailed country-specific information.

Tables

Observations

@oecd.oecd_els_hd_dsd_health_stat_df_pyll_v1_1.observations

1.06 MB
330,777 rows
21 columns

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "ref_area" VARCHAR,
  "freq" VARCHAR,
  "measure" VARCHAR,
  "unit_measure" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "socio_econ_status" VARCHAR,
  "death_cause" VARCHAR,
  "calc_methodology" VARCHAR,
  "gestation_threshold" VARCHAR,
  "health_status" VARCHAR,
  "disease" VARCHAR,
  "cancer_site" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "decimals" BIGINT,
  "obs_status" VARCHAR,
  "obs_status2" VARCHAR,
  "obs_status3" VARCHAR,
  "unit_mult" BIGINT
);