Diff Ratios

@owid.life_tables.owid_diff_ratios

37.67 MB
2,222,309 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

353.06 MB
6,409,071 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

333.94 MB
6,679,628 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

30.27 MB
1,288,377 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.27 MB
134,532 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

6.22 MB
261,072 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.58 MB
278,568 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

880.17 kB
29,088 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.6 MB
56,448 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