Dataset: Human Mortality Database

About this Dataset

Human Mortality Database

The Human Mortality Database (HMD) is a collaborative project sponsored by the University of California, Berkeley (in the United States of America) and the Max Planck Institute for Demographic Research (in Germany).

It provides researchers with comprehensive data on mortality from around 40 countries around the world, which have very high coverage and quality of data at the national level, through vital registration and potentially census data.

Data is given in terms of period or cohort estimates:

Period data refers to a snapshot estimated with data at a particular interval. For period life expectancy at birth, this refers to the estimated life expectancy at birth based on a synthetic cohort created using mortality rates across age groups in a given year.
Cohort data refers to estimates of a particular birth cohort. For cohort life expectancy at birth, this refers to the average number of years that people in the birth cohort survived. Cohort data may use birth cohorts that are ‘almost extinct’ rather than entirely extinct.

'Interval' refers to the specific age- and time- period of the estimate. An interval can be a one year period for a single-age group, or it can be wider. For example, the life expectancy of a 40 year old in 2019 corresponds to an interval of 1 single-age group in 1 year. The central death rate of 5–9 year olds in 2020 corresponds to an interval of a 5 year age group in 1 year.

Tables

Human Mortality Database

@owid.hmd.owid_births_1

173.94 KB
16161 rows
5 columns


CREATE TABLE owid_births_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "births" UINTEGER,
  "birth_rate" FLOAT
);

Human Mortality Database

@owid.hmd.owid_births_2

166.18 KB
14763 rows
5 columns


CREATE TABLE owid_births_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "births" UINTEGER,
  "birth_rate" FLOAT
);

Human Mortality Database

@owid.hmd.owid_deaths_1

6.52 MB
1961484 rows
5 columns


CREATE TABLE owid_deaths_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "deaths" FLOAT
);

Human Mortality Database

@owid.hmd.owid_deaths_2

5.81 MB
1739241 rows
5 columns


CREATE TABLE owid_deaths_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "deaths" FLOAT
);

Human Mortality Database

@owid.hmd.owid_deaths_agg

157.49 KB
13077 rows
5 columns


CREATE TABLE owid_deaths_agg (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "deaths" FLOAT,
  "death_rate" FLOAT
);

Human Mortality Database

@owid.hmd.owid_diff_ratios_1

9.23 MB
810155 rows
7 columns


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

Human Mortality Database

@owid.hmd.owid_diff_ratios_2

8.21 MB
708943 rows
7 columns


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

Human Mortality Database

@owid.hmd.owid_exposures_1

20.91 MB
3699519 rows
6 columns


CREATE TABLE owid_exposures_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "type" VARCHAR,
  "exposure" FLOAT
);

Human Mortality Database

@owid.hmd.owid_exposures_2

18.5 MB
3271455 rows
6 columns


CREATE TABLE owid_exposures_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "type" VARCHAR,
  "exposure" FLOAT
);

Human Mortality Database

@owid.hmd.owid_hmd

111.77 MB
5659065 rows
19 columns


CREATE TABLE owid_hmd (
  "format" VARCHAR,
  "type" VARCHAR,
  "country" VARCHAR,
  "year" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "central_death_rate" FLOAT,
  "probability_of_death" FLOAT,
  "average_survival_length" FLOAT,
  "number_survivors" UINTEGER,
  "number_deaths" INTEGER,
  "number_person_years_lived" UINTEGER,
  "number_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT,
  "exposure" FLOAT,
  "deaths" FLOAT,
  "life_expectancy_fm_diff" FLOAT,
  "life_expectancy_fm_ratio" FLOAT,
  "central_death_rate_mf_ratio" FLOAT
);

Human Mortality Database

@owid.hmd.owid_life_tables_1

55.97 MB
2440664 rows
13 columns


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

Human Mortality Database

@owid.hmd.owid_life_tables_2

48.93 MB
2136227 rows
13 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" UINTEGER,
  "number_deaths" INTEGER,
  "number_person_years_lived" UINTEGER,
  "number_person_years_remaining" UINTEGER,
  "life_expectancy" FLOAT
);

Human Mortality Database

@owid.hmd.owid_population_1

10.32 MB
1981434 rows
5 columns


CREATE TABLE owid_population_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "population" FLOAT
);

Human Mortality Database

@owid.hmd.owid_population_2

9.26 MB
1770810 rows
5 columns


CREATE TABLE owid_population_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "population" FLOAT
);