Dataset: Life Expectancy (period)

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.38 MB
419195 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.49 MB
437645 rows
6 columns


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

World Population Prospects

@owid.life_expectancy.owid_life_expectancy_only_proj_1

399.09 KB
241819 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.55 KB
233772 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

1.97 MB
481716 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.41 MB
484181 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
);