About this Dataset

Life Expectancy (period)

Life tables from UN and HMD.

For period data, data prior to 1950 is from HMD, and data from 1950 onwards is from UN WPP.

Tables

World Population Prospects

@owid.life_expectancy.owid_life_expectancy_1

2.49 MB
419,195 rows
6 columns


CREATE TABLE owid_life_expectancy_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" INTEGER,
  "life_expectancy" FLOAT,
  "life_expectancy_0" FLOAT
);

Life Expectancy 2

@owid.life_expectancy.owid_life_expectancy_2

2.3 MB
416,080 rows
5 columns


CREATE TABLE owid_life_expectancy_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" INTEGER,
  "life_expectancy" FLOAT
);

Life Expectancy At Birth

@owid.life_expectancy.owid_life_expectancy_at_birth

137.5 kB
21,565 rows
5 columns


CREATE TABLE owid_life_expectancy_at_birth (
  "country" VARCHAR,
  "year" INTEGER,
  "source" VARCHAR,
  "life_expectancy_0" FLOAT,
  "source_url" VARCHAR
);

World Population Prospects

@owid.life_expectancy.owid_life_expectancy_only_proj_1

408.67 kB
241,819 rows
6 columns


CREATE TABLE owid_life_expectancy_only_proj_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" INTEGER,
  "life_expectancy_only_proj" FLOAT,
  "life_expectancy_0_only_proj" FLOAT
);

Life Expectancy Only Proj 2

@owid.life_expectancy.owid_life_expectancy_only_proj_2

889.62 kB
233,772 rows
6 columns


CREATE TABLE owid_life_expectancy_only_proj_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" INTEGER,
  "life_expectancy_only_proj" FLOAT,
  "life_expectancy_0_only_proj" FLOAT
);

World Population Prospects

@owid.life_expectancy.owid_life_expectancy_with_proj_1

2.07 MB
481,716 rows
6 columns


CREATE TABLE owid_life_expectancy_with_proj_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" INTEGER,
  "life_expectancy_with_proj" FLOAT,
  "life_expectancy_0_with_proj" FLOAT
);

Life Expectancy With Proj 2

@owid.life_expectancy.owid_life_expectancy_with_proj_2

2.52 MB
484,181 rows
6 columns


CREATE TABLE owid_life_expectancy_with_proj_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" INTEGER,
  "life_expectancy_with_proj" FLOAT,
  "life_expectancy_0_with_proj" FLOAT
);