Dataset: World Population Prospects

About this Dataset

World Population Prospects

Abridged life tables up to age 100 by sex and both sexes combined providing a set of values showing the mortality experience of a hypothetical group of infants born at the same time and subject throughout their lifetime to the specific mortality rates of a given year (period life tables), from 1950 to 2021.

Tables

World Population Prospects

@owid.un_wpp_lt.owid_un_wpp_lt_1

283.74 MB
5584896 rows
14 columns


CREATE TABLE owid_un_wpp_lt_1 (
  "location" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "probability_of_survival" FLOAT,
  "number_survivors" FLOAT,
  "number_deaths" FLOAT,
  "number_person_years_lived" FLOAT,
  "survivorship_ratio" FLOAT,
  "number_person_years_remaining" FLOAT,
  "life_expectancy" FLOAT,
  "average_survival_length" FLOAT
);

World Population Prospects

@owid.un_wpp_lt.owid_un_wpp_lt_2

297.52 MB
5852142 rows
29 columns


CREATE TABLE owid_un_wpp_lt_2 (
  "location" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "agegrp" VARCHAR,
  "loctypename" VARCHAR,
  "sortorder" INTEGER,
  "locid" INTEGER,
  "notes" VARCHAR,
  "iso3_code" VARCHAR,
  "iso2_code" VARCHAR,
  "sdmx_code" INTEGER,
  "loctypeid" INTEGER,
  "parentid" INTEGER,
  "varid" INTEGER,
  "midperiod" FLOAT,
  "sexid" INTEGER,
  "agegrpspan" INTEGER,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "probability_of_survival" FLOAT,
  "number_survivors" FLOAT,
  "number_deaths" FLOAT,
  "number_person_years_lived" FLOAT,
  "survivorship_ratio" FLOAT,
  "number_person_years_remaining" FLOAT,
  "life_expectancy" FLOAT,
  "average_survival_length" FLOAT
);

World Population Prospects

@owid.un_wpp_lt.owid_un_wpp_lt_proj

300.2 MB
6089391 rows
29 columns


CREATE TABLE owid_un_wpp_lt_proj (
  "location" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "agegrp" VARCHAR,
  "loctypename" VARCHAR,
  "sortorder" INTEGER,
  "locid" INTEGER,
  "notes" VARCHAR,
  "iso3_code" VARCHAR,
  "iso2_code" VARCHAR,
  "sdmx_code" INTEGER,
  "loctypeid" INTEGER,
  "parentid" INTEGER,
  "varid" INTEGER,
  "midperiod" FLOAT,
  "sexid" INTEGER,
  "agegrpspan" INTEGER,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "probability_of_survival" FLOAT,
  "number_survivors" FLOAT,
  "number_deaths" FLOAT,
  "number_person_years_lived" FLOAT,
  "survivorship_ratio" FLOAT,
  "number_person_years_remaining" FLOAT,
  "life_expectancy" FLOAT,
  "average_survival_length" FLOAT
);