Baselight

Excess Mortality (various Sources)

@owid.excess_mortality

Loading...
Loading...

About this Dataset

Excess Mortality (various Sources)

All-cause mortality data is from the Human Mortality Database (HMD) Short-term Mortality Fluctuations project and the World Mortality Dataset (WMD). Both sources are updated weekly.

We do not use the data from some countries in WMD because they fail to meet the following data quality criteria: 1) at least three years of historical data; and 2) data published either weekly or monthly. The full list of excluded countries and reasons for exclusion can be found in this spreadsheet: https://docs.google.com/spreadsheets/d/1JPMtzsx-smO3_K4ReK_HMeuVLEzVZ71qHghSuAfG788/edit?usp=sharing.

For a full list of source information (i.e., HMD or WMD) country by country, see: https://ourworldindata.org/excess-mortality-covid#source-information-country-by-country.

We calculate P-scores using the reported deaths data from HMD and WMD and the projected deaths since 2020 from WMD (which we use for all countries and regions, including for deaths broken down by age group). The P-score is the percentage difference between the reported number of weekly or monthly deaths since 2020 and the projected number of deaths for the same period based on previous years (years available from 2015 until 2019).

We calculate the number of weekly deaths for the United Kingdom by summing the weekly deaths from England & Wales, Scotland, and Northern Ireland.

For important issues and caveats to understand when interpreting excess mortality data, see our excess mortality page at https://ourworldindata.org/excess-mortality-covid.

For a more detailed description_short of the HMD data, including week date definitions, the coverage (of individuals, locations, and time), whether dates are for death occurrence or registration, the original national source information, and important caveats, see the HMD metadata file at https://www.mortality.org/Public/STMF_DOC/STMFmetadata.pdf.

For a more detailed description_short of the WMD data, including original source information, see their GitHub page at https://github.com/akarlinsky/world_mortality.

Tables

Excess Mortality

@owid.excess_mortality.owid_excess_mortality
  • 1.37 MB
  • 22615 rows
  • 43 columns
Loading...

CREATE TABLE owid_excess_mortality (
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "time" INTEGER,
  "time_unit" VARCHAR,
  "average_deaths_2015_2019_all_ages" FLOAT,
  "p_avg_0_14" FLOAT,
  "p_avg_15_64" FLOAT,
  "p_avg_65_74" FLOAT,
  "p_avg_75_84" FLOAT,
  "p_avg_85p" FLOAT,
  "p_avg_all_ages" FLOAT,
  "projected_deaths_since_2020_all_ages" FLOAT,
  "p_proj_0_14" FLOAT,
  "p_proj_15_64" FLOAT,
  "p_proj_65_74" FLOAT,
  "p_proj_75_84" FLOAT,
  "p_proj_85p" FLOAT,
  "p_proj_all_ages" FLOAT,
  "excess_proj_all_ages" FLOAT,
  "deaths_since_2020_all_ages" FLOAT,
  "deaths_2010_all_ages" INTEGER,
  "deaths_2011_all_ages" INTEGER,
  "deaths_2012_all_ages" INTEGER,
  "deaths_2013_all_ages" INTEGER,
  "deaths_2014_all_ages" INTEGER,
  "deaths_2015_all_ages" FLOAT,
  "deaths_2016_all_ages" FLOAT,
  "deaths_2017_all_ages" FLOAT,
  "deaths_2018_all_ages" FLOAT,
  "deaths_2019_all_ages" FLOAT,
  "deaths_2020_all_ages" FLOAT,
  "deaths_2021_all_ages" FLOAT,
  "deaths_2022_all_ages" FLOAT,
  "deaths_2023_all_ages" FLOAT,
  "deaths_2024_all_ages" FLOAT,
  "deaths_2025_all_ages" UINTEGER,
  "cum_excess_proj_all_ages" FLOAT,
  "cum_proj_deaths_all_ages" FLOAT,
  "cum_p_proj_all_ages" FLOAT,
  "excess_per_million_proj_all_ages" FLOAT,
  "cum_excess_per_million_proj_all_ages" FLOAT,
  "cum_excess_proj_all_ages_last12m" VARCHAR,
  "cum_excess_per_million_proj_all_ages_last12m" VARCHAR
);

Share link

Anyone who has the link will be able to view this.