Dataset: Life Tables

Diff Ratios

@owid.life_tables.owid_diff_ratios

35.92 MB
2222309 rows
7 columns


CREATE TABLE owid_diff_ratios (
  "country" VARCHAR,
  "year" INTEGER,
  "age" VARCHAR,
  "type" VARCHAR,
  "life_expectancy_fm_diff" FLOAT,
  "life_expectancy_fm_ratio" FLOAT,
  "central_death_rate_mf_ratio" FLOAT
);

Life Tables 1

@owid.life_tables.owid_life_tables_1

336.7 MB
6409071 rows
18 columns


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

Life Tables 2

@owid.life_tables.owid_life_tables_2

318.47 MB
6679628 rows
15 columns


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

Life Tables (by Age And Year)

@owid.life_tables.owid_period_1x1

28.87 MB
1288377 rows
12 columns


CREATE TABLE owid_period_1x1 (
  "country" VARCHAR,
  "year" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "avg_survival_length" FLOAT,
  "num_survivors" UINTEGER,
  "num_deaths" INTEGER,
  "num_person_years_lived" UINTEGER,
  "num_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT
);

Life Tables (by Age And 10-year Time Interval)

@owid.life_tables.owid_period_1x10

3.11 MB
134532 rows
12 columns


CREATE TABLE owid_period_1x10 (
  "country" VARCHAR,
  "year" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "avg_survival_length" FLOAT,
  "num_survivors" UINTEGER,
  "num_deaths" INTEGER,
  "num_person_years_lived" UINTEGER,
  "num_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT
);

Life Tables (by Age And 5-year Time Interval)

@owid.life_tables.owid_period_1x5

5.94 MB
261072 rows
12 columns


CREATE TABLE owid_period_1x5 (
  "country" VARCHAR,
  "year" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "avg_survival_length" FLOAT,
  "num_survivors" UINTEGER,
  "num_deaths" INTEGER,
  "num_person_years_lived" UINTEGER,
  "num_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT
);

Life Tables (by 5-year Age Group And Year)

@owid.life_tables.owid_period_5x1

7.23 MB
278568 rows
12 columns


CREATE TABLE owid_period_5x1 (
  "country" VARCHAR,
  "year" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "avg_survival_length" FLOAT,
  "num_survivors" UINTEGER,
  "num_deaths" INTEGER,
  "num_person_years_lived" UINTEGER,
  "num_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT
);

Life Tables (by 5-year Age Group And 10-year Time Interval)

@owid.life_tables.owid_period_5x10

859.54 KB
29088 rows
12 columns


CREATE TABLE owid_period_5x10 (
  "country" VARCHAR,
  "year" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "avg_survival_length" FLOAT,
  "num_survivors" UINTEGER,
  "num_deaths" INTEGER,
  "num_person_years_lived" UINTEGER,
  "num_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT
);

Life Tables (by 5-year Age Group And 5-year Time Interval)

@owid.life_tables.owid_period_5x5

1.52 MB
56448 rows
12 columns


CREATE TABLE owid_period_5x5 (
  "country" VARCHAR,
  "year" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "avg_survival_length" FLOAT,
  "num_survivors" UINTEGER,
  "num_deaths" INTEGER,
  "num_person_years_lived" UINTEGER,
  "num_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT
);

Life Tables

About this Dataset