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

178.11 kB
16,161 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

170.17 kB
14,763 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.83 MB
1,961,484 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

6.09 MB
1,739,241 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

161.27 kB
13,077 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.68 MB
810,155 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.61 MB
708,943 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

21.93 MB
3,699,519 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

19.4 MB
3,271,455 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

117.2 MB
5,659,065 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

58.69 MB
2,440,664 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

51.3 MB
2,136,227 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.82 MB
1,981,434 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.71 MB
1,770,810 rows
5 columns


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