Based on a comparison of coronavirus deaths in 210 countries relative to their population, Peru had the most losses to COVID-19 up until July 13, 2022. As of the same date, the virus had infected over 557.8 million people worldwide, and the number of deaths had totaled more than 6.3 million. Note, however, that COVID-19 test rates can vary per country. Additionally, big differences show up between countries when combining the number of deaths against confirmed COVID-19 cases. The source seemingly does not differentiate between "the Wuhan strain" (2019-nCOV) of COVID-19, "the Kent mutation" (B.1.1.7) that appeared in the UK in late 2020, the 2021 Delta variant (B.1.617.2) from India or the Omicron variant (B.1.1.529) from South Africa.

The difficulties of death figures

This table aims to provide a complete picture on the topic, but it very much relies on data that has become more difficult to compare. As the coronavirus pandemic developed across the world, countries already used different methods to count fatalities, and they sometimes changed them during the course of the pandemic. On April 16, for example, the Chinese city of Wuhan added a 50 percent increase in their death figures to account for community deaths. These deaths occurred outside of hospitals and went unaccounted for so far. The state of New York did something similar two days before, revising their figures with 3,700 new deaths as they started to include “assumed” coronavirus victims. The United Kingdom started counting deaths in care homes and private households on April 29, adjusting their number with about 5,000 new deaths (which were corrected lowered again by the same amount on August 18). This makes an already difficult comparison even more difficult. Belgium, for example, counts suspected coronavirus deaths in their figures, whereas other countries have not done that (yet). This means two things. First, it could have a big impact on both current as well as future figures. On April 16 already, UK health experts stated that if their numbers were corrected for community deaths like in Wuhan, the UK number would change from 205 to “above 300”. This is exactly what happened two weeks later. Second, it is difficult to pinpoint exactly which countries already have “revised” numbers (like Belgium, Wuhan or New York) and which ones do not. One work-around could be to look at (freely accessible) timelines that track the reported daily increase of deaths in certain countries. Several of these are available on our platform, such as for Belgium, Italy and Sweden. A sudden large increase might be an indicator that the domestic sources changed their methodology.

Where are these numbers coming from?

The numbers shown here were collected by Johns Hopkins University, a source that manually checks the data with domestic health authorities. For the majority of countries, this is from national authorities. In some cases, like China, the United States, Canada or Australia, city reports or other various state authorities were consulted. In this statistic, these separately reported numbers were put together. For more information or other freely accessible content, please visit our dedicated Facts and Figures page.

As of May 2, 2023, the outbreak of the coronavirus disease (COVID-19) had spread to almost every country in the world, and more than 6.86 million people had died after contracting the respiratory virus. Over 1.16 million of these deaths occurred in the United States.

Waves of infections Almost every country and territory worldwide have been affected by the COVID-19 disease. At the end of 2021 the virus was once again circulating at very high rates, even in countries with relatively high vaccination rates such as the United States and Germany. As rates of new infections increased, some countries in Europe, like Germany and Austria, tightened restrictions once again, specifically targeting those who were not yet vaccinated. However, by spring 2022, rates of new infections had decreased in many countries and restrictions were once again lifted.

What are the symptoms of the virus? It can take up to 14 days for symptoms of the illness to start being noticed. The most commonly reported symptoms are a fever and a dry cough, leading to shortness of breath. The early symptoms are similar to other common viruses such as the common cold and flu. These illnesses spread more during cold months, but there is no conclusive evidence to suggest that temperature impacts the spread of the SARS-CoV-2 virus. Medical advice should be sought if you are experiencing any of these symptoms.

It is estimated that from 2020 to 2021, the mean rate of excess deaths associated with the COVID-19 pandemic from all-causes was highest in Peru. In 2020-2021, there were around 437 excess deaths due to the COVID-19 pandemic per 100,000 population in Peru. This statistic shows the mean number of excess deaths associated with the COVID-19 pandemic from all-causes in 2020-2021 in select countries worldwide, per 100,000 population.

This file contains COVID-19 death counts, death rates, and percent of total deaths by jurisdiction of residence. The data is grouped by different time periods including 3-month period, weekly, and total (cumulative since January 1, 2020). United States death counts and rates include the 50 states, plus the District of Columbia and New York City. New York state estimates exclude New York City. Puerto Rico is included in HHS Region 2 estimates. Deaths with confirmed or presumed COVID-19, coded to ICD–10 code U07.1. Number of deaths reported in this file are the total number of COVID-19 deaths received and coded as of the date of analysis and may not represent all deaths that occurred in that period. Counts of deaths occurring before or after the reporting period are not included in the file. Data during recent periods are incomplete because of the lag in time between when the death occurred and when the death certificate is completed, submitted to NCHS and processed for reporting purposes. This delay can range from 1 week to 8 weeks or more, depending on the jurisdiction and cause of death. Death counts should not be compared across states. Data timeliness varies by state. Some states report deaths on a daily basis, while other states report deaths weekly or monthly. The ten (10) United States Department of Health and Human Services (HHS) regions include the following jurisdictions. Region 1: Connecticut, Maine, Massachusetts, New Hampshire, Rhode Island, Vermont; Region 2: New Jersey, New York, New York City, Puerto Rico; Region 3: Delaware, District of Columbia, Maryland, Pennsylvania, Virginia, West Virginia; Region 4: Alabama, Florida, Georgia, Kentucky, Mississippi, North Carolina, South Carolina, Tennessee; Region 5: Illinois, Indiana, Michigan, Minnesota, Ohio, Wisconsin; Region 6: Arkansas, Louisiana, New Mexico, Oklahoma, Texas; Region 7: Iowa, Kansas, Missouri, Nebraska; Region 8: Colorado, Montana, North Dakota, South Dakota, Utah, Wyoming; Region 9: Arizona, California, Hawaii, Nevada; Region 10: Alaska, Idaho, Oregon, Washington. Rates were calculated using the population estimates for 2021, which are estimated as of July 1, 2021 based on the Blended Base produced by the US Census Bureau in lieu of the April 1, 2020 decennial population count. The Blended Base consists of the blend of Vintage 2020 postcensal population estimates, 2020 Demographic Analysis Estimates, and 2020 Census PL 94-171 Redistricting File (see https://www2.census.gov/programs-surveys/popest/technical-documentation/methodology/2020-2021/methods-statement-v2021.pdf). Rates are based on deaths occurring in the specified week/month and are age-adjusted to the 2000 standard population using the direct method (see https://www.cdc.gov/nchs/data/nvsr/nvsr70/nvsr70-08-508.pdf). These rates differ from annual age-adjusted rates, typically presented in NCHS publications based on a full year of data and annualized weekly/monthly age-adjusted rates which have been adjusted to allow comparison with annual rates. Annualization rates presents deaths per year per 100,000 population that would be expected in a year if the observed period specific (weekly/monthly) rate prevailed for a full year. Sub-national death counts between 1-9 are suppressed in accordance with NCHS data confidentiality standards. Rates based on death counts less than 20 are suppressed in accordance with NCHS standards of reliability as specified in NCHS Data Presentation Standards for Proportions (available from: https://www.cdc.gov/nchs/data/series/sr_02/sr02_175.pdf.).

COVID-19 rate of death, or the known deaths divided by confirmed cases, was over ten percent in Yemen, the only country that has 1,000 or more cases. This according to a calculation that combines coronavirus stats on both deaths and registered cases for 221 different countries. Note that death rates are not the same as the chance of dying from an infection or the number of deaths based on an at-risk population. By April 26, 2022, the virus had infected over 510.2 million people worldwide, and led to a loss of 6.2 million. The source seemingly does not differentiate between "the Wuhan strain" (2019-nCOV) of COVID-19, "the Kent mutation" (B.1.1.7) that appeared in the UK in late 2020, the 2021 Delta variant (B.1.617.2) from India or the Omicron variant (B.1.1.529) from South Africa.

Where are these numbers coming from?

The numbers shown here were collected by Johns Hopkins University, a source that manually checks the data with domestic health authorities. For the majority of countries, this is from national authorities. In some cases, like China, the United States, Canada or Australia, city reports or other various state authorities were consulted. In this statistic, these separately reported numbers were put together. Note that Statista aims to also provide domestic source material for a more complete picture, and not to just look at one particular source. Examples are these statistics on the confirmed coronavirus cases in Russia or the COVID-19 cases in Italy, both of which are from domestic sources. For more information or other freely accessible content, please visit our dedicated Facts and Figures page.

A word on the flaws of numbers like this

People are right to ask whether these numbers are at all representative or not for several reasons. First, countries worldwide decide differently on who gets tested for the virus, meaning that comparing case numbers or death rates could to some extent be misleading. Germany, for example, started testing relatively early once the country’s first case was confirmed in Bavaria in January 2020, whereas Italy tests for the coronavirus postmortem. Second, not all people go to see (or can see, due to testing capacity) a doctor when they have mild symptoms. Countries like Norway and the Netherlands, for example, recommend people with non-severe symptoms to just stay at home. This means not all cases are known all the time, which could significantly alter the death rate as it is presented here. Third and finally, numbers like this change very frequently depending on how the pandemic spreads or the national healthcare capacity. It is therefore recommended to look at other (freely accessible) content that dives more into specifics, such as the coronavirus testing capacity in India or the number of hospital beds in the UK. Only with additional pieces of information can you get the full picture, something that this statistic in its current state simply cannot provide.

Updates

• Notice of data discontinuation: Since the start of the pandemic, AP has reported case and death counts from data provided by Johns Hopkins University. Johns Hopkins University has announced that they will stop their daily data collection efforts after March 10. As Johns Hopkins stops providing data, the AP will also stop collecting daily numbers for COVID cases and deaths. The HHS and CDC now collect and visualize key metrics for the pandemic. AP advises using those resources when reporting on the pandemic going forward.

  • CDC Weekly case and death counts (national and state level)
  • CDC County level cases and deaths
  • HHS New hospital admissions
  • CDC NowCast COVID variant proportions (national and regional level)

• April 9, 2020

  • The population estimate data for New York County, NY has been updated to include all five New York City counties (Kings County, Queens County, Bronx County, Richmond County and New York County). This has been done to match the Johns Hopkins COVID-19 data, which aggregates counts for the five New York City counties to New York County.

• April 20, 2020

  • Johns Hopkins death totals in the US now include confirmed and probable deaths in accordance with CDC guidelines as of April 14. One significant result of this change was an increase of more than 3,700 deaths in the New York City count. This change will likely result in increases for death counts elsewhere as well. The AP does not alter the Johns Hopkins source data, so probable deaths are included in this dataset as well.

• April 29, 2020

  • The AP is now providing timeseries data for counts of COVID-19 cases and deaths. The raw counts are provided here unaltered, along with a population column with Census ACS-5 estimates and calculated daily case and death rates per 100,000 people. Please read the updated caveats section for more information.

• September 1st, 2020

  • Johns Hopkins is now providing counts for the five New York City counties individually.

• February 12, 2021

  • The Ohio Department of Health recently announced that as many as 4,000 COVID-19 deaths may have been underreported through the state’s reporting system, and that the "daily reported death counts will be high for a two to three-day period."
  • Because deaths data will be anomalous for consecutive days, we have chosen to freeze Ohio's rolling average for daily deaths at the last valid measure until Johns Hopkins is able to back-distribute the data. The raw daily death counts, as reported by Johns Hopkins and including the backlogged death data, will still be present in the new_deaths column.

• February 16, 2021

  - Johns Hopkins has reconciled Ohio's historical deaths data with the state.

  Overview

The AP is using data collected by the Johns Hopkins University Center for Systems Science and Engineering as our source for outbreak caseloads and death counts for the United States and globally.

The Hopkins data is available at the county level in the United States. The AP has paired this data with population figures and county rural/urban designations, and has calculated caseload and death rates per 100,000 people. Be aware that caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.

This data is from the Hopkins dashboard that is updated regularly throughout the day. Like all organizations dealing with data, Hopkins is constantly refining and cleaning up their feed, so there may be brief moments where data does not appear correctly. At this link, you’ll find the Hopkins daily data reports, and a clean version of their feed.

The AP is updating this dataset hourly at 45 minutes past the hour.

To learn more about AP's data journalism capabilities for publishers, corporations and financial institutions, go here or email kromano@ap.org.

Queries

Use AP's queries to filter the data or to join to other datasets we've made available to help cover the coronavirus pandemic

• Filter cases by state here

• Rank states by their status as current hotspots. Calculates the 7-day rolling average of new cases per capita in each state: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=481e82a4-1b2f-41c2-9ea1-d91aa4b3b1ac

• Find recent hotspots within your state by running a query to calculate the 7-day rolling average of new cases by capita in each county: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=b566f1db-3231-40fe-8099-311909b7b687&showTemplatePreview=true

• Join county-level case data to an earlier dataset released by AP on local hospital capacity here. To find out more about the hospital capacity dataset, see the full details.

• Pull the 100 counties with the highest per-capita confirmed cases here

• Rank all the counties by the highest per-capita rate of new cases in the past 7 days here. Be aware that because this ranks per-capita caseloads, very small counties may rise to the very top, so take into account raw caseload figures as well.

Interactive

The AP has designed an interactive map to track COVID-19 cases reported by Johns Hopkins.

@(https://datawrapper.dwcdn.net/nRyaf/15/)

Interactive Embed Code

<iframe title="USA counties (2018) choropleth map Mapping COVID-19 cases by county" aria-describedby="" id="datawrapper-chart-nRyaf" src="https://datawrapper.dwcdn.net/nRyaf/10/" scrolling="no" frameborder="0" style="width: 0; min-width: 100% !important;" height="400"></iframe><script type="text/javascript">(function() {'use strict';window.addEventListener('message', function(event) {if (typeof event.data['datawrapper-height'] !== 'undefined') {for (var chartId in event.data['datawrapper-height']) {var iframe = document.getElementById('datawrapper-chart-' + chartId) || document.querySelector("iframe[src*='" + chartId + "']");if (!iframe) {continue;}iframe.style.height = event.data['datawrapper-height'][chartId] + 'px';}}});})();</script>

Caveats

• This data represents the number of cases and deaths reported by each state and has been collected by Johns Hopkins from a number of sources cited on their website.
• In some cases, deaths or cases of people who've crossed state lines -- either to receive treatment or because they became sick and couldn't return home while traveling -- are reported in a state they aren't currently in, because of state reporting rules.
• In some states, there are a number of cases not assigned to a specific county -- for those cases, the county name is "unassigned to a single county"
• This data should be credited to Johns Hopkins University's COVID-19 tracking project. The AP is simply making it available here for ease of use for reporters and members.
• Caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.
• Population estimates at the county level are drawn from 2014-18 5-year estimates from the American Community Survey.
• The Urban/Rural classification scheme is from the Center for Disease Control and Preventions's National Center for Health Statistics. It puts each county into one of six categories -- from Large Central Metro to Non-Core -- according to population and other characteristics. More details about the classifications can be found here.

Johns Hopkins timeseries data - Johns Hopkins pulls data regularly to update their dashboard. Once a day, around 8pm EDT, Johns Hopkins adds the counts for all areas they cover to the timeseries file. These counts are snapshots of the latest cumulative counts provided by the source on that day. This can lead to inconsistencies if a source updates their historical data for accuracy, either increasing or decreasing the latest cumulative count. - Johns Hopkins periodically edits their historical timeseries data for accuracy. They provide a file documenting all errors in their timeseries files that they have identified and fixed here

Attribution

This data should be credited to Johns Hopkins University COVID-19 tracking project

The New York Times is releasing a series of data files with cumulative counts of coronavirus cases in the United States, at the state and county level, over time. We are compiling this time series data from state and local governments and health departments in an attempt to provide a complete record of the ongoing outbreak.

Since late January, The Times has tracked cases of coronavirus in real time as they were identified after testing. Because of the widespread shortage of testing, however, the data is necessarily limited in the picture it presents of the outbreak.

We have used this data to power our maps and reporting tracking the outbreak, and it is now being made available to the public in response to requests from researchers, scientists and government officials who would like access to the data to better understand the outbreak.

The data begins with the first reported coronavirus case in Washington State on Jan. 21, 2020. We will publish regular updates to the data in this repository.

Daily updates of Covid-19 Global Excess Deaths from the Economist's GitHub repository: https://github.com/TheEconomist/covid-19-the-economist-global-excess-deaths-model

Interpreting estimates

Estimating excess deaths for every country every day since the pandemic began is a complex and difficult task. Rather than being overly confident in a single number, limited data means that we can often only give a very very wide range of plausible values. Focusing on central estimates in such cases would be misleading: unless ranges are very narrow, the 95% range should be reported when possible. The ranges assume that the conditions for bootstrap confidence intervals are met. Please see our tracker page and methodology for more information.

New variants

The Omicron variant, first detected in southern Africa in November 2021, appears to have characteristics that are different to earlier versions of sars-cov-2. Where this variant is now dominant, this change makes estimates uncertain beyond the ranges indicated. Other new variants may do the same. As more data is incorporated from places where new variants are dominant, predictions improve.

Non-reporting countries

Turkmenistan and the Democratic People's Republic of Korea have not reported any covid-19 figures since the start of the pandemic. They also have not published all-cause mortality data. Exports of estimates for the Democratic People's Republic of Korea have been temporarily disabled as it now issues contradictory data: reporting a significant outbreak through its state media, but zero confirmed covid-19 cases/deaths to the WHO.

Acknowledgements

A special thanks to all our sources and to those who have made the data to create these estimates available. We list all our sources in our methodology. Within script 1, the source for each variable is also given as the data is loaded, with the exception of our sources for excess deaths data, which we detail in on our free-to-read excess deaths tracker as well as on GitHub. The gradient booster implementation used to fit the models is aGTBoost, detailed here.

Calculating excess deaths for the entire world over multiple years is both complex and imprecise. We welcome any suggestions on how to improve the model, be it data, algorithm, or logic. If you have one, please open an issue.

The Economist would also like to acknowledge the many people who have helped us refine the model so far, be it through discussions, facilitating data access, or offering coding assistance. A special thanks to Ariel Karlinsky, Philip Schellekens, Oliver Watson, Lukas Appelhans, Berent Å. S. Lunde, Gideon Wakefield, Johannes Hunger, Carol D'Souza, Yun Wei, Mehran Hosseini, Samantha Dolan, Mollie Van Gordon, Rahul Arora, Austin Teda Atmaja, Dirk Eddelbuettel and Tom Wenseleers.

All coding and data collection to construct these models (and make them update dynamically) was done by Sondre Ulvund Solstad. Should you have any questions about them after reading the methodology, please open an issue or contact him at sondresolstad@economist.com.

Suggested citation The Economist and Solstad, S. (corresponding author), 2021. The pandemic’s true death toll. [online] The Economist. Available at: https://www.economist.com/graphic-detail/coronavirus-excess-deaths-estimates [Accessed ---]. First published in the article "Counting the dead", The Economist, issue 20, 2021.

Read the associated blogpost for a detailed description of how this dataset was prepared; plus extra code for producing animated maps.

Context

The 2019 Novel Coronavirus (COVID-19) continues to spread in countries around the world. This dataset provides daily updated number of reported cases & deaths in Germany on the federal state (Bundesland) and county (Landkreis/Stadtkreis) level. In April 2021 I added a dataset on vaccination progress. In addition, I provide geospatial shape files and general state-level population demographics to aid the analysis.

Content

The dataset consists of thre main csv files: covid_de.csv, demgraphics_de.csv, and covid_de_vaccines.csv. The geospatial shapes are included in the de_state.* files. See the column descriptions below for more detailed information.

• covid_de.csv: COVID-19 cases and deaths which will be updated daily. The original data are being collected by Germany's Robert Koch Institute and can be download through the National Platform for Geographic Data (the latter site also hosts an interactive dashboard). I reshaped and translated the data (using R tidyverse tools) to make it better accessible. This blogpost explains how I prepared the data, and describes how to produces animated maps.

• demographics_de.csv: General Demographic Data about Germany on the federal state level. Those have been downloaded from Germany's Federal Office for Statistics (Statistisches Bundesamt) through their Open Data platform GENESIS. The data reflect the (most recent available) estimates on 2018-12-31. You can find the corresponding table here.

• covid_de_vaccines.csv: In April 2021 I added this file that contains the Covid-19 vaccination progress for Germany as a whole. It details daily doses, broken down cumulatively by manufacturer, as well as the cumulative number of people having received their first and full vaccination. The earliest data are from 2020-12-27.

• de_state.*: Geospatial shape files for Germany's 16 federal states. Downloaded via Germany's Federal Agency for Cartography and Geodesy . Specifically, the shape file was obtained from this link.

Column Description

COVID-19 dataset covid_de.csv:

• state: Name of the German federal state. Germany has 16 federal states. I removed converted special characters from the original data.

• county: The name of the German Landkreis (LK) or Stadtkreis (SK), which correspond roughly to US counties.

• age_group: The COVID-19 data is being reported for 6 age groups: 0-4, 5-14, 15-34, 35-59, 60-79, and above 80 years old. As a shortcut the last category I'm using "80-99", but there might well be persons above 99 years old in this dataset. This column has a few NA entries.

• gender: Reported as male (M) or female (F). This column has a few NA entries.

• date: The calendar date of when a case or death were reported. There might be delays that will be corrected by retroactively assigning cases to earlier dates.

• cases: COVID-19 cases that have been confirmed through laboratory work. This and the following 2 columns are counts per day, not cumulative counts.

• deaths: COVID-19 related deaths.

• recovered: Recovered cases.

Demographic dataset demographics_de.csv:

• state, gender, age_group: same as above. The demographic data is available in higher age resolution, but I have binned it here to match the corresponding age groups in the covid_de.csv file.

• population: Population counts for the respective categories. These numbers reflect the (most recent available) estimates on 2018-12-31.

Vaccination progress dataset covid_de_vaccines.csv:

• date: calendar date of vaccination

• doses, doses_first, doses_second: Daily count of administered doses: total, 1st shot, 2nd shot.

• pfizer_cumul, moderna_cumul, astrazeneca_cumul: Daily cumulative number of administered vaccinations by manufacturer.

• persons_first_cumul, persons_full_cumul: Daily cumulative number of people having received their 1st shot and full vaccination, respectively.

Acknowledgements

All the data have been extracted from open data sources which are being gratefully acknowledged:

• The [Robert ...

Excess Deaths excl COVID: Predicted: Above Expected: Arkansas data was reported at 0.000 Number in 30 Oct 2021. This stayed constant from the previous number of 0.000 Number for 23 Oct 2021. Excess Deaths excl COVID: Predicted: Above Expected: Arkansas data is updated weekly, averaging 0.000 Number from Jan 2017 (Median) to 30 Oct 2021, with 251 observations. The data reached an all-time high of 93.000 Number in 07 Aug 2021 and a record low of 0.000 Number in 30 Oct 2021. Excess Deaths excl COVID: Predicted: Above Expected: Arkansas data remains active status in CEIC and is reported by Centers for Disease Control and Prevention. The data is categorized under Global Database’s United States – Table US.G012: Number of Excess Deaths: by States: All Causes excluding COVID-19: Predicted (Discontinued).

The United States is the country with the greatest number of COVID-19 deaths in 2020, 2021, and 2022. Both the U.S. and the world exhibited an increase in the number of COVID-related deaths in 2021 and a decrease in 2022. The U.S. share of COVID-related deaths declined in 2021 but rose in 2022, leading to a cumulative total U.S. mortality share of 17%. The extent to which the U.S. is an outlier is even greater based on the monetized mortality costs. Using the value of a statistical life to monetize the mortality impact increases the performance gap between the U.S. and the rest of the world because of the high mortality risk valuation in the U.S. The worldwide COVID-19 mortality cost was $29.4 trillion as of January 1, 2023, with a U.S. share of $12.7 trillion, or 43% of the global total. Throughout the COVID pandemic, the U.S. mortality cost share has been in the narrow range of 43% to 45%. Given the high U.S. value of a statistical life, these monetized mortality cost values are more than double the U.S. share of COVID-related deaths. The U.S. mortality cost share is greater if the value of a statistical life declines more than proportionally with income for low-income countries.

2019 Novel Coronavirus COVID-19 (2019-nCoV) Visual Dashboard and Map:
https://www.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6

• Confirmed Cases by Country/Region/Sovereignty
• Confirmed Cases by Province/State/Dependency
• Deaths
• Recovered

Downloadable data:
https://github.com/CSSEGISandData/COVID-19

Additional Information about the Visual Dashboard:
https://systems.jhu.edu/research/public-health/ncov

Age-standardised mortality rates for deaths involving coronavirus (COVID-19), non-COVID-19 deaths and all deaths by vaccination status, broken down by age group.

It is estimated that by the end of 2021 the COVID-19 pandemic had caused around 14.9 million excess deaths worldwide. South-East Asia accounted for the highest number of these deaths with about 5.99 million excess deaths due to the pandemic. This statistic shows the cumulative mean number of excess deaths associated with the COVID-19 pandemic worldwide as of the end of 2021, by region.

United States Excess Death excl COVID: Predicted: Single Excess Est: Connecticut data was reported at 0.000 Number in 01 Jan 2022. This stayed constant from the previous number of 0.000 Number for 25 Dec 2021. United States Excess Death excl COVID: Predicted: Single Excess Est: Connecticut data is updated weekly, averaging 0.000 Number from Jan 2017 to 01 Jan 2022, with 261 observations. The data reached an all-time high of 153.000 Number in 18 Sep 2021 and a record low of 0.000 Number in 01 Jan 2022. United States Excess Death excl COVID: Predicted: Single Excess Est: Connecticut data remains active status in CEIC and is reported by Centers for Disease Control and Prevention. The data is categorized under Global Database’s United States – Table US.G014: Number of Excess Deaths: by States: All Causes excluding COVID-19: Predicted.

Life table data for "Bounce backs amid continued losses: Life expectancy changes since COVID-19"

cc-by Jonas Schöley, José Manuel Aburto, Ilya Kashnitsky, Maxi S. Kniffka, Luyin Zhang, Hannaliis Jaadla, Jennifer B. Dowd, and Ridhi Kashyap. "Bounce backs amid continued losses: Life expectancy changes since COVID-19".

These are CSV files of life tables over the years 2015 through 2021 across 29 countries analyzed in the paper "Bounce backs amid continued losses: Life expectancy changes since COVID-19".

40-lifetables.csv

Life table statistics 2015 through 2021 by sex, region and quarter with uncertainty quantiles based on Poisson replication of death counts. Actual life tables and expected life tables (under the assumption of pre-COVID mortality trend continuation) are provided.

30-lt_input.csv

Life table input data.

id: unique row identifier

region_iso: iso3166-2 region codes

sex: Male, Female, Total

year: iso year

age_start: start of age group

age_width: width of age group, Inf for age_start 100, otherwise 1

nweeks_year: number of weeks in that year, 52 or 53

death_total: number of deaths by any cause

population_py: person-years of exposure (adjusted for leap-weeks and missing weeks in input data on all cause deaths)

death_total_nweeksmiss: number of weeks in the raw input data with at least one missing death count for this region-sex-year stratum. missings are counted when the week is implicitly missing from the input data or if any NAs are encounted in this week or if age groups are implicitly missing for this week in the input data (e.g. 40-45, 50-55)

death_total_minnageraw: the minimum number of age-groups in the raw input data within this region-sex-year stratum

death_total_maxnageraw: the maximum number of age-groups in the raw input data within this region-sex-year stratum

death_total_minopenageraw: the minimum age at the start of the open age group in the raw input data within this region-sex-year stratum

death_total_maxopenageraw: the maximum age at the start of the open age group in the raw input data within this region-sex-year stratum

death_total_source: source of the all-cause death data

death_total_prop_q1: observed proportion of deaths in first quarter of year

death_total_prop_q2: observed proportion of deaths in second quarter of year

death_total_prop_q3: observed proportion of deaths in third quarter of year

death_total_prop_q4: observed proportion of deaths in fourth quarter of year

death_expected_prop_q1: expected proportion of deaths in first quarter of year

death_expected_prop_q2: expected proportion of deaths in second quarter of year

death_expected_prop_q3: expected proportion of deaths in third quarter of year

death_expected_prop_q4: expected proportion of deaths in fourth quarter of year

population_midyear: midyear population (July 1st)

population_source: source of the population count/exposure data

death_covid: number of deaths due to covid

death_covid_date: number of deaths due to covid as of

death_covid_nageraw: the number of age groups in the covid input data

ex_wpp_estimate: life expectancy estimates from the World Population prospects for a five year period, merged at the midpoint year

ex_hmd_estimate: life expectancy estimates from the Human Mortality Database

nmx_hmd_estimate: death rate estimates from the Human Mortality Database

nmx_cntfc: Lee-Carter death rate projections based on trend in the years 2015 through 2019

Deaths

source:

STMF input data series (https://www.mortality.org/Public/STMF/Outputs/stmf.csv)

ONS for GB-EAW pre 2020

CDC for US pre 2020

STMF:

harmonized to single ages via pclm

pclm iterates over country, sex, year, and within-year age grouping pattern and converts irregular age groupings, which may vary by country, year and week into a regular age grouping of 0:110

smoothing parameters estimated via BIC grid search seperately for every pclm iteration

last age group set to [110,111)

ages 100:110+ are then summed into 100+ to be consistent with mid-year population information

deaths in unknown weeks are considered; deaths in unknown ages are not considered

ONS:

data already in single ages

ages 100:105+ are summed into 100+ to be consistent with mid-year population information

PCLM smoothing applied to for consistency reasons

CDC:

The CDC data comes in single ages 0:100 for the US. For 2020 we only have the STMF data in a much coarser age grouping, i.e. (0, 1, 5, 15, 25, 35, 45, 55, 65, 75, 85+). In order to calculate life-tables in a manner consistent with 2020, we summarise the pre 2020 US death counts into the 2020 age grouping and then apply the pclm ungrouping into single year ages, mirroring the approach to the 2020 data

Population

source:

for years 2000 to 2019: World Population Prospects 2019 single year-age population estimates 1950-2019

for year 2020: World Population Prospects 2019 single year-age population projections 2020-2100

mid-year population

mid-year population translated into exposures:

if a region reports annual deaths using the Gregorian calendar definition of a year (365 or 366 days long) set exposures equal to mid year population estimates

if a region reports annual deaths using the iso-week-year definition of a year (364 or 371 days long), and if there is a leap-week in that year, set exposures equal to 371/364*mid_year_population to account for the longer reporting period. in years without leap-weeks set exposures equal to mid year population estimates. further multiply by fraction of observed weeks on all weeks in a year.

COVID deaths

source: COVerAGE-DB (https://osf.io/mpwjq/)

the data base reports cumulative numbers of COVID deaths over days of a year, we extract the most up to date yearly total

External life expectancy estimates

source:

World Population Prospects (https://population.un.org/wpp/Download/Files/1_Indicators%20(Standard)/CSV_FILES/WPP2019_Life_Table_Medium.csv), estimates for the five year period 2015-2019

Human Mortality Database (https://mortality.org/), single year and age tables

The United States is the country with the greatest number of COVID-19 deaths in 2020, 2021, and 2022. Both the U.S. and the world exhibited an increase in the number of COVID-related deaths in 2021 and a decrease in 2022. The U.S. share of COVID-related deaths declined in 2021 but rose in 2022, leading to a cumulative total U.S. mortality share of 17%. The extent to which the U.S. is an outlier is even greater based on the monetized mortality costs. Using the value of a statistical life to monetize the mortality impact increases the performance gap between the U.S. and the rest of the world because of the high mortality risk valuation in the U.S. The worldwide COVID-19 mortality cost was $29.4 trillion as of January 1, 2023, with a U.S. share of $12.7 trillion, or 43% of the global total. Throughout the COVID pandemic, the U.S. mortality cost share has been in the narrow range of 43% to 45%. Given the high U.S. value of a statistical life, these monetized mortality cost values are more than double the U.S. share of COVID-related deaths. The U.S. mortality cost share is greater if the value of a statistical life declines more than proportionally with income for low-income countries.

Context

There's a story behind every dataset and here's your opportunity to share yours.

Content

The datasets contain a selection of various data on COVID-19 from January 1st 2020 to June 28th 2021

Acknowledgements

We wouldn't be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.

Inspiration

Your data will be in front of the world's largest data science community. What questions do you want to see answered?

Content

This dataset contains Covid-19 data of world countries as on November 08, 2021

## Attribute Information

• Country - Name of world countries
• Total Cases - Total number of Covid-19 cases
• Total Deaths - Total number of Deaths
• Total Recovered - Total number of recovered cases
• Active Cases - Total number of Active cases
• Total Cases/1 mil population- Total Cases per 1 million of the population
• Death/1 mil population - Total Deaths per 1 million of the population
• Total Tests - Total number of Covid tests done
• Tests/1 mil population - Covid tests done per 1 million of the population
• Population - Population of the country

Source

Link : https://www.worldometers.info/coronavirus/#countries

Upvote if you find it useful

United States Excess Death excl COVID: Predicted: Single Estimate: Maine data was reported at 0.000 Number in 16 Sep 2023. This stayed constant from the previous number of 0.000 Number for 09 Sep 2023. United States Excess Death excl COVID: Predicted: Single Estimate: Maine data is updated weekly, averaging 0.000 Number from Jan 2017 (Median) to 16 Sep 2023, with 350 observations. The data reached an all-time high of 54.000 Number in 06 Nov 2021 and a record low of 0.000 Number in 16 Sep 2023. United States Excess Death excl COVID: Predicted: Single Estimate: Maine data remains active status in CEIC and is reported by Centers for Disease Control and Prevention. The data is categorized under Global Database’s United States – Table US.G012: Number of Excess Deaths: by States: All Causes excluding COVID-19: Predicted (Discontinued).