Many readers may know that, since last fall, I’ve been working part-time at the Documenting COVID-19 project: a public records, data, and investigative project at Columbia University’s Brown Institute for Media Innovation and the public records site MuckRock.
One major focus at Documenting COVID-19 is our Uncounted investigation, an effort to understand how COVID-19 deaths—and other deaths indirectly caused by the pandemic—have gone under-reported in the last two years. The CDC has reported nearly one million official COVID-19 deaths; but that figure doesn’t include over 300,000 deaths of natural causes that occurred over what researchers expected in 2020 and 2021.
These natural causes logged on Americans’ death certificates—such as diabetes, heart disease, and respiratory conditions—may have been linked to COVID-19. In fact, about 158,000 deaths during the pandemic were specifically linked to natural causes that the CDC considers potentially COVID-related. But the official records make it hard to say for sure.
In a story with USA TODAY published late last year, Documenting COVID-19 found massive gaps and inconsistencies in the U.S.’s death system, which likely contributed to these undercounts. These include: a lack of standardization for medical examiners and coroners’ offices, workers in these positions becoming overwhelmed during the pandemic, and failures in some cases to order COVID-19 tests for patients or push back when families insisted a death wasn’t COVID-related.
Documenting COVID-19 is working on further follow-up stories in this investigation. But we also want to empower other reporters—especially local reporters—and researchers to investigate pandemic deaths. To that end, our team recently released a GitHub data repository that provides county-level CDC mortality data from 2020 and 2021.
The data come from the CDC’s provisional mortality database; our team signed a data-use agreement with the agency so that we can use their API to gather data more quickly and efficiently than what’s possible with the CDC’s WONDER portal.
Here’s a brief summary of what’s in the repository, taken from a write-up by my colleague Dillon Bergin:
- Leading external causes of death in the 113 CDC code list, by underlying cause of death;
- Natural causes of death associated with COVID-19, using the CDC’s categories for excess deaths associated with COVID-19, by underlying cause of death;
- All deaths by race and ethnicity, with age-adjusted rate, regardless of underlying cause of death;
- Information to help contextualize the CDC data, including excess mortality numbers modeled by demographers at Boston University, vaccination rates, and a Department of Justice survey released in December of all medical examiner and coroner offices in the country.
And here are some other links related to Uncounted and the CDC’s mortality data:
- A landing page on MuckRock including all stories in the Uncounted project;
- A Q&A with me and Dillon from last December, discussing the CDC’s data;
- A reporting recipe on using the CDC’s data for local investigations;
- A webinar with the Documenting COVID-19 team about these data.
If you’re a journalist who wants to use these data, the Documenting COVID-19 team is happy to help! If you have questions or want support, feel free to reach out to the team at email@example.com, or to me specifically at firstname.lastname@example.org.