Featured sources

COVID-19 Data Dispatch Source List

This table includes all COVID-19 data sources featured in the COVID-19 Data Dispatch newsletter, starting with the first issue in July 2020. It's updated weekly when new issues are sent out.
CategoryNameLinkWeek featuredDescription
CensusCensus COVID-19 Demographic and Economic Resourceshttps://covid19.census.gov/12/6/20My coworker Diana Shishkina recently alerted me to a Census page which compiles and visualizes a great deal of data on how COVID-19 has impacted Americans. It includes data from weekly small business surveys, the Household Pulse Survey, and a wealth of other information.
CensusHousehold Pulse Survey by the U.S. Censushttps://www.census.gov/programs-surveys/household-pulse-survey/data.html8/16/20From the end of April through the end of July, the U.S. Census ran a survey program to collect data on how the COVID-19 pandemic impacted the lives of American residents. The survey results include questions on education, employment, food security, health, and housing. I looked at the survey’s final release for a Stacker story; you can see a few statistics and charts from that story here: https://twitter.com/betsyladyzhets/status/1294393954327244812
11/8 update: The dataset was so widely used that the Census expanded it to a second round of surveys, from August through October. New data are being released in two-week intervals.
Charity/aidCharity Navigatorhttps://www.charitynavigator.org/8/30/20Charity Navigator is a database that compiles and evaluates charities based on their financial health and accountability. The database has detailed rankings and search capability, and when a crisis hits—such as the recent California wildfires or Hurricane Laura—they put together quick lists of organizations where any interested samaritans can help the cause.
Charity/aidMutual Aid Disaster Reliefhttps://mutualaiddisasterrelief.org/collective-care/9/20/20This past spring saw an explosion of mutual aid groups across the country, as people helped their neighbors with food, medical supplies, and other needs in the absence of government-sponsored aid. These groups may no longer be in the spotlight, but as federal relief bills continue to stall, they still need support. Organizations like Mutual Aid Disaster Relief can help you find a mutual aid group in your area.
DemographicColors of COVIDhttps://thecolorsofcovid.com/9/6/20This Canadian project relies on public surveys to collect data on how COVID-19 is impacting marginalized communities in the country. The project plans to release quarterly reports with these survey results.
DemographicGenderSci Lab’s US Gender/Sex Covid-19 Data Trackerhttps://www.genderscilab.org/gender-and-sex-in-covid199/13/20The GenderSci Lab, an interdisciplinary research project, is tracking COVID-19 by gender by compiling information from state reports. The tracker includes case counts, death counts, and mortality rates.
DemographicThe COVID Racial Data Tracker, by the COVID Tracking Projecthttps://covidtracking.com/race7/26/20COVID-19 is killing Black Americans at 2.5 times the rate of white Americans. The COVID Racial Data Tracker (or CRDT) keeps tabs on this disparity and others by collecting case and death counts, broken down by race and ethnicity, from state COVID dashboards. Our dataset is updated twice a week. And I say “our” because I work on this dataset; I’m happy to answer questions about it (betsyladyzhets@gmail.com).
DemographicThe COVID Tracking Project’s City Datasethttps://docs.google.com/spreadsheets/u/1/d/e/2PACX-1vRg-dB5Pjt-zN38BZNoCdOk_RJ_MyYFAl3QIkK5fKSddUy44DUgJwZuhjCz8KPMpiFKRwhoIwfs0NbZ/pubhtml11/15/20For about five months, COVID Tracking Project volunteers collected and standardized data from highly populated cities and counties across the country. The project started in late May with the intent of tracking COVID-19 in cities that were seeing large Black Lives Matter protests, then expanded following the Sunbelt surge in June. 65 cities and counties are included in the dataset; you can read more about the dataset’s methodology and major findings on the Project’s blog.
https://covidtracking.com/blog/introducing-the-covid-tracking-project-city-dataset
Economy/fundingCOVID-19 relief trackerhttps://covidtracker.pogo.org/12/6/20The Project on Government Oversight (POGO) has a new tracker which shows where COVID-19 relief funds from the federal government have been spent. The dashboard visualizes data from USAspending.gov, and is searchable by state, county, and ZIP code.
Economy/fundingSearchable database of federal COVID-19 purchaseshttps://projects.propublica.org/coronavirus-contracts/12/13/20Since March, ProPublica has tracked where federal government spending on the pandemic is going. The database represents $28 billion, 14,209 government contracts, and 6,832 individual vendors. Data can be sorted by spending categories, vendor types, and contract sizes.
Economy/fundingSearchable database of PPP datahttps://searchppp.com/12/13/20On December 1, the Small Business Administration released extensive data on loans issued through the Paycheck Protection Program (PPP), including specific loan amounts and company names. Accountable.US, a nonpartisan watchdog group, has made this information available in an easy-to-navigate database. You can search for a specific business or filter by different geographic regions and industries.
Healthcare systemAllocating Regeneron’s treatmenthttps://www.phe.gov/emergency/events/COVID19/investigation-MCM/cas_imd/Pages/allocation.aspx12/6/20On November 21, Regeneron’s monoclonal antibody treatment received Emergency Use Authorization from the FDA. A new dataset from the HHS shows how this drug is being allocated to states and territories. For more information on the dataset, see HHS’s November 23 press release. https://www.hhs.gov/about/news/2020/11/23/hhs-allocates-regeneron-therapeutic-treat-patients-mild-moderate-covid-19.html
Healthcare systemAmerica’s Health Rankings’ Senior Reporthttps://assets.americashealthrankings.org/app/uploads/ahr-senior-report_2019_final.pdf9/6/20America’s Health Rankings has conducted annual reviews of health metrics in every U.S. state since 1990. The organization’s most recent Senior Report is over 100 pages of data on older Americans, including rankings of the healthiest states for seniors.
Healthcare systemCOVID Care Maphttps://www.covidcaremap.org/8/23/20Dave Luo, another COVID Tracking Project volunteer, also runs this volunteer effort to aggregate and clean public data on health care system capacity. The source has mapped capacity figures at the state, county, and individual facility levels, as well as other healthcare data from sources such as the Institute for Health Metrics and Evaluation (IHME).
Healthcare systemCOVID-19 Reported Patient Impact and Hospital Capacity by Facilityhttps://healthdata.gov/dataset/covid-19-reported-patient-impact-and-hospital-capacity-facility12/20/20On Monday, the HHS published a new hospitalization dataset including capacity, new admissions, and other COVID-19-related numbers—for over 4,000 individual facilities across America. This is, as I put it in a COVID Tracking Project blog post analyzing the dataset, a big deal. For more detail, see: https://coviddatadispatch.com/2020/12/13/covid-19-data-for-your-local-hospital/
Healthcare systemCOVIDcasthttps://covidcast.cmu.edu/?sensor=doctor-visits-smoothed_adj_cli&level=county&date=20200909&signalType=value&encoding=color&mode=overview9/13/20This dashboard, by the Delphi Group at Carnegie Mellon University, features interactive maps for a variety of COVID-19 indicators, including movement trends, doctors’ visits , and even test positivity based on antigen tests.
1/24/21 update: I’m featuring the source again this week because recently, the Delphi Group collected survey data on vaccine acceptance. You can download the data and compare vaccine hesitancy across counties; read more about the release in MIT Technology Review. This dashboard, by the Delphi Group at Carnegie Mellon University, features interactive maps for a variety of COVID-19 indicators, including movement trends, doctors’ visits , and even test positivity based on antigen tests.
https://www.technologyreview.com/2021/01/16/1016264/covid-vaccine-acceptance-us-county/
Healthcare systemFederal allocation of remdesivirhttps://www.phe.gov/emergency/events/COVID19/investigation-MCM/Pages/commercial-allocation-table.aspx8/23/20This public dataset from HHS shows how many cases of remdesivir, an antiviral drug which has become an important treatment option for COVID-19 patients, have been distributed to each state since early July. The dataset is cited in an NPR investigation which reports confusion and lack of transparency about how remdesivir distribution is decided. https://www.npr.org/sections/health-shots/2020/08/19/903946857/how-feds-decide-on-remdesivir-shipments-to-states-remains-mysterious
Healthcare systemHHS Protect Public Data Hubhttps://protect-public.hhs.gov/11/1/20For a few months now, the HHS Protect Public Data Hub has only hosted COVID-19 hospitalization data. But recently, the website expanded to include a section on national testing. Users can clearly see cumulative PCR testing numbers from the country, download the full dataset, and read documentation. This dataset has been publicly available on healthdata.gov since July, but through hosting it on the HHS Protect Public Data Hub, the agency has made it more easily accessible for Americans who are not data nerds like myself.
Healthcare systemHospital facilities visualization by the COVID Tracking Projecthttps://covidtracking.com/data/hospital-facilities1/10/21Last month, the Department of Health and Human Services (HHS) released an extensive dataset showing how COVID-19 patients are impacting hospitals at the individual facility level. (See my Dec. 13 post for more information on this dataset.) The COVID Tracking Project has produced an interactive visualization from this dataset, allowing users to zoom in to individual facilities or search for hospitals in a particular city or ZIP code. I contributed some copy to this page. https://coviddatadispatch.com/2020/12/13/covid-19-data-for-your-local-hospital/
Healthcare systemTherapeutics distribution (from HHS)https://protect-public.hhs.gov/pages/therapeutics-distribution1/10/21The HHS is posting a list of locations that have received monoclonal antibody therapies, for the purpose of treating COVID-19. Bamlanivimab, one such therapy, received EUA from the FDA in early November. The HHS page notes that this is not a complete list: “Although monoclonal antibody therapeutic treatments have been shipped nationwide, shipment locations are displayed for those States that have opted to have their locations displayed on this public website.”
Healthcare systemHospital discharge summaries (from the Healthcare Cost and Utilization Project)https://www.hcup-us.ahrq.gov/reports/trendtables/summarytrendtables.jsp1/10/21This project, under the HHS umbrella, posts time series data on U.S. hospital patients. The site recently posted summaries on patients from April to June 2020, including datasets specific to COVID-19, flu, and other viral respiratory infections. As epidemiologist Jason Salemi explains in a summary Twitter thread, the data doesn’t provide new information but may be useful for a researcher looking to dig into spring and summer hospitalization trends. https://twitter.com/JasonSalemi/status/1346296905471442945
Higher edCollege COVID-19 Outbreak Watchlisthttps://public.tableau.com/profile/benjamin.renton#!/vizhome/CollegeCovid-19OutbreakWatchlist/CollegeCovid-19OutbreakWatchlist9/6/20Education reporter (and friend of this newsletter!) Benjy Renton has launched a dashboard keeping track of COVID-19 outbreaks on college and university campuses. The dashboard organizes outbreaks according to their alert level, based on new cases in the past week.
Higher edCollege/University COVID-19 Dashboardshttps://docs.google.com/spreadsheets/d/e/2PACX-1vQsCbJGsSWSGw_T44-OAkW0DBOWjLdpXBO2s5fINRGJWjAOzAAFhEo-0Y-H8fmrlAd7gOpg48q4zx0N/pubhtml8/30/20For this issue, I surveyed the COVID-19 dashboards of 50 higher education institutions across the country... The 50 dashboards I examined include public and private schools in 26 states. Rather than attempting to count the number of COVID-19 cases occurring at colleges and universities, I chose to focus on how schools are reporting: what COVID-19 metrics are they making public, and how often are these metrics updated?
Higher edCOVID-19 Testing in US Collegeshttps://docs.google.com/spreadsheets/d/10I8bVkLzvrmXJsb5N-8JSFpWw5vBwDKYzyOVAI4viKo/edit#gid=15144408598/23/20Sina Booeshaghi and Lior Pachter, two researchers from CalTech, put together a database documenting testing plans at over 500 colleges and universities throughout the U.S. The database is open for updates; anyone who would like to suggest an edit or contribute testing information on a new school can contact the researchers, whose emails are listed in the spreadsheet. Booeshaghi and Pachter wrote a paper on their findings, which is available in preprint form on medRxiv (it has not yet been reviewed by other scientists). https://www.medrxiv.org/content/10.1101/2020.08.09.20171223v1
Higher edNYT College and University COVID-19 countshttps://github.com/nytimes/covid-19-data/tree/master/colleges10/11/20The NYT is now releasing the data behind its counts of COVID-19 cases reported on college and university campuses, which the paper has been collecting in surveys since July. The survey includes over 1,700 colleges. This initial data release only includes cumulative data as of September 8—and it does not include denominators. NYT reports that the data will be updated “approximately every two weeks.” https://www.nytimes.com/interactive/2020/us/covid-college-cases-tracker.html
Higher edThe Buffalo News’ trackers of COVID-19 cases in college athleticshttps://docs.google.com/spreadsheets/d/16iV64rAhzjDeQIdyUiLe2rfkBefYZBLrt0quuCg8BHg/edit#gid=0
https://docs.google.com/spreadsheets/d/11YytG28gK1zne6hPMiT2mXCXGzmXB68UnNQ6nZjlUBY/edit#gid=0
12/20/20CDD reader Rachel Lenzi, who covers college athletics for The Buffalo News, has kindly allowed me to share her spreadsheets compiling COVID-19 reports of COVID-19 cases in NCAA football and basketball programs.
Higher edThe College Crisis Initiativehttps://collegecrisis.shinyapps.io/dashboard/8/23/20Davidson College’s College Crisis Initiative (or C2i) maps out fall 2020 plans for about 3,000 colleges and universities. Clicking on a college in the interactive map leads users to see a brief description of the school’s opening policy, along with a link to the school’s website. Corrections may be submitted via a Google form. https://docs.google.com/forms/d/e/1FAIpQLSdBSH_8nkA-ApxWvwPtslP8rVV13IJXG7lMYaUWnqMplB1cWA/viewform
Higher edWe Rate Covid Dashboardshttps://www.ratecoviddashboard.com/9/13/20Two weeks ago, I analyzed college and university COVID-19 dashboards for my newsletter. This project from public health experts at Yale and Harvard, meanwhile, goes much further: the researchers have developed a rating scheme based on available metrics, legibility, update schedules, and more, and rated over 100 dashboards so far.
JournalismCOVID-19 Cutback Trackerhttps://www.cjr.org/widescreen/covid-cutback-tracker.php9/13/20Researchers at the Tow Center for Digital Journalism at Columbia University have tracked layoffs, furloughs, closures, and other cutbacks to journalistic outlets since March 2020. Findings from the project were released this past Wednesday in a new tracker.
JournalismJournalism and the Pandemic Surveyhttps://www.icfj.org/our-work/journalism-and-pandemic-survey10/18/20The International Center for Jounalists and the Tow Center for Digital Journalism at Columbia University are conducting a massive survey, mapping the impacts of COVID-19 on journalists around the world. The first report from this survey was released last week; you can read about its initial findings here. https://www.niemanlab.org/2020/10/journalists-are-struggling-with-mental-health-financial-hardship-and-disinformation-according-to-a-startling-and-disturbing-survey/
JournalismThe CoronaVirusFacts Alliance Databasehttps://www.poynter.org/ifcn-covid-19-misinformation/8/2/20Since the start of the pandemic, Poynter’s International Fact-Checking Network has connected fact-checkers in over 70 countries working to correct COVID-19 misinformation. The results of these fact-checkers’ work are compiled in a database, which you can search by country, fact rating, and topic.
K-12 schoolsCOVID-19 in Wisconsin schoolshttps://projects.jsonline.com/topics/coronavirus/schools/coronavirus-in-wisconsin-schools-search-covid-19.html9/20/20Wisconsin journalists have stepped in to monitor COVID-19 outbreaks in schools, as the state has so far failed to report these data. A public dashboard available via the Milwaukee Journal Sentinel and the USA Today Network allows users to see case counts and resulting quarantine and cleaning actions at K-12 schools across the state. Wisconsin residents can submit additional cases through a Google form. https://docs.google.com/forms/d/e/1FAIpQLSfoCx7lx30YmDSqSZD1VvCOb7emv-Zoac65ux1-QfG7oIOF9w/viewform
K-12 schoolsCOVID-19 School Response Dashboardhttps://statsiq.co1.qualtrics.com/public-dashboard/v0/dashboard/5f62eaee4451ae001535c839#/dashboard/5f62eaee4451ae001535c839?pageId=Page_1ac6a6bc-92b6-423e-9f7a-259a1864831810/4/20Clearly, we need denominators for our case counts. And a new dataset is out to provide this crucial metric. Emily Oster, Professor of Economics and Public Policy at Brown University, collaborated with software company Qualtrics and several national education associations to build a COVID-19 school dashboard which focuses on case rates, not counts. I emailed Oster for my 10/4 newsletter, so this issue includes detailed info on the dataset's methodology: https://coviddatadispatch.substack.com/p/school-data-with-denominators
K-12 schoolsDistrict Budget Decisionshttps://edunomicslab.org/district-budget-decisions-labor-implications/8/23/20Edunomics Lab at Georgetown University has compiled a database of choices school districts are making about how to change their budgets and hiring during the COVID-19 pandemic. The database includes 302 districts at the time I send this newsletter; district choices are categorized as budget trimming, salary reductions, benefits adjustment, furloughs, and layoffs.
K-12 schoolsK-12 school closures, quarantines, and/or deathshttps://app.smartsheet.com/b/publish?EQBCT=00a2d3fbe4184e75b06f392fc66dca138/30/20Alisha Morris, a theater teacher in Kansas, started compiling news reports on instances of COVID-19 causing schools to stall or alter reopening plans. Morris’ project grew into a national spreadsheet with hundreds of COVID-19 school case reports spanning every U.S. state. The National Education Association now runs this dataset; concerned students, parents, and teachers can now explore the data and report cases on a NEA-run website. You can also explore the dataset through a Tableau dashboard created by one volunteer. https://public.tableau.com/profile/jon.w1876?fbclid=IwAR2cW3O_WiyP4QR8dyyaJ0M4RmxhWTTY_VbJYvr4KDqRhlhD0fmvhpYePfk#!/vizhome/COVID-19USSchools/Dashboard1
K-12 schoolsLeading in Crisis briefshttps://www.cpre.org/leading-crisis11/29/20A series of briefs from the Consortium for Policy Research in Education document how 120 principals in 19 states responded to COVID-19 in the spring. The briefs compile analyses, summaries, and recommendations on topics ranging from accountability during scool closures to calm during crisis.
K-12 schoolsMissing in the Margins: Estimating the Scale of the COVID-19 Attendance Crisishttps://bellwethereducation.org/publication/missing-margins-estimating-scale-covid-19-attendance-crisis10/25/20This new report by Bellwether Education Partners provides estimates and analysis of the students who have been unable to participate in virtual learning during the pandemic. While the state-by-state estimates and city profiles may be useful to local reporters, the overall numbers should shock us all: three million students, now left behind.
K-12 schoolsReopening plans in America’s largest public school districtshttps://usafacts.org/articles/how-are-children-going-back-school-americas-225-largest-public-school-districts/9/6/20The nonprofit civic data initiative USAFacts has compiled a dataset of reopening plans in America’s 225 largest public school districts. The dataset classifies reopening plans as online, hybrid, in-person, or other, with information as of August 17.
K-12 schoolsThe COVID Monitor: COVID-19 Reporting in K-12 schoolshttps://experience.arcgis.com/experience/fb52d598982f41faac714b5ebe32e7d1?data_id=dataSource_5-USA_COVID_Websites_for_States%3A58/23/20FinMango, a global nonprofit which has pivoted to help COVID-19 researchers, has partnered with Florida COVID Action, a data project led by whistleblower Rebekah Jones, to track COVID-19 cases in K-12 schools. The project, called the COVID Monitor, has already been compiling reports from media and members of the public since July. It includes about 1,300 schools with confirmed or reported COVID-19 cases so far, 200 of which are in the project’s home state of Florida.
LegislationCOVID Border Accountability Projecthttps://covidborderaccountability.org/index.html12/20/20This interactive map documents travel and immigration bans that countries have introduced in response to COVID-19. It’s compiled by a team of academic researchers, engineers, and other non-academic volunteers, and updated weekly on Wednesdays.
LegislationCOVID-19 Global Travel Restrictions and Airline Informationhttps://data.humdata.org/dataset/covid-19-global-travel-restrictions-and-airline-information12/13/20The Humanitarian Data Exchange is an international repository run by the United Nations Office for the Coordination of Humanitarian Affairs. One of the repository’s COVID-19 datasets displays travel restrictions and airline restrictions for nearly 300 jurisdictions, updated every day.
LegislationCOVID-19 State and County Policy Ordershttps://healthdata.gov/dataset/covid-19-state-and-county-policy-orders11/15/20This dataset includes over 3,000 COVID-19-related policies at the state and county level addressing public health, local economies, and disparities during the pandemic. Data were compiled by students at the Boston University School of Public Health and other student volunteers, and the dataset is housed at the HHS.
LegislationOpen States COVID-19 Legislationhttps://openstates.org/covid19/10/4/20Open States, a public civic engagement project, is compiling a list of legislation related to the COVID-19 pandemic in the U.S. The database currently tracks over 3,000 bills in 46 states.
LegislationThe Pandemic and ICE Use of Detainers in FY 2020https://trac.syr.edu/immigration/reports/627/10/25/20The Transactional Records Access Clearinghouse (or TRAC) at Syracuse University has collected data on U.S. immigration since 2006. The project’s most recent report describes the pandemic’s impact on Immigration and Customs Enforcement (ICE)’s work to detain individuals as a step for apprehending and deporting them.
MortalityExcess deaths associated with COVID-19 (international)https://github.com/TheEconomist/covid-19-excess-deaths-tracker7/26/20The Economist compiles a similar dataset to the CDC, tracking excess deaths in countries and cities around the world. You can read about and see visualizations based on these data here: https://www.economist.com/graphic-detail/2020/07/15/tracking-covid-19-excess-deaths-across-countries
MortalityExcess deaths associated with COVID-19 (U.S.)https://www.cdc.gov/nchs/nvss/vsrr/covid19/excess_deaths.htm7/26/20One dataset which the CDC hasn’t stopped publishing is a tally of the death toll in the U.S., including deaths which may be directly or indirectly related to the pandemic but have not been reported due to insufficient testing. The dataset is updated weekly, and you can see figures broken down by state and different demographic factors.
MortalityThe Human Mortality Databasehttps://www.mortality.org/10/11/20This database includes detailed population and mortality data for 41 countries. In response to the COVID-19 pandemic, the team behind the database has started compiling weekly death counts, which can be used for excess death calculations; they have compiled counts for 34 countries so far.
OtherHHS celebrity trackerhttps://www.politico.com/f/?id=00000175-72c2-dc1a-a5f7-fae72f29000011/1/20This week, POLITICO’s Dan Diamond released an HHS document called the “PSA Celebrity Tracker,” which health officials were using to determine which of America’s favorite people may be useful in an ad campaign encouraging the nation to be less negative about COVID-19. (Here’s more context from POLITICO on the tracker, https://www.politico.com/news/2020/10/29/coronavirus-ad-campaign-rebrand-433578)
OutbreaksCOVID-19 at the White House Contact Trackerhttps://public.tableau.com/profile/peter.james.walker#!/vizhome/COVID-19attheWhiteHouse-ContactTracking/OverviewDash10/4/20This dashboard, called the COVID-19 At The White House Contact Tracker, is attempting to trace over 200 contacts in connection with the President and his staff. The team behind it includes Benjy Renton, independent reporter on COVID-19 in higher education, Peter Walker, data visualization lead at the COVID Tracking Project, and Jesse O’Shea, MD, infectious disease expert at Emory University. The Contact Tracker is an incredible public service. In its current form, the dashboard lists 235 White House contacts who should get tested for COVID-19, along with their positions, test results (if known), symptoms (if they test positive), and the date of their most recent test. You can also view the data as a timeline, based on each person’s last contact with the President, and as a map based on the Rose Garden ceremony, the debate, and two other potential spreading events.
10/25 update: The team behind a crowdsourced White House contact tracer is now tracking cases connected to Vice President Mike Pence.
OutbreaksCOVID-19 in Congresshttps://www.govtrack.us/covid-1911/29/20GovTrack.us. a project which normally documents bills and resolutions in the U.S. Congress, is currently tracking how COVID-19 has spread through the national legislature. The tracker currently includes 87 legislators who have entered quarantine, tested positive, or came into contact with someone who had been diagnosed with the disease.
OutbreaksMass Incarceration, COVID-19, and Community Spreadhttps://www.prisonpolicy.org/reports/covidspread.html12/20/20The nonprofit Prison Policy Initiative has published a new report showing how prisons impacted COVID-19 case rates in 2020. One major finding: rural counties with more incarcerated people per square mile had more COVID-19 cases, especially at higher percentiles.
OutbreaksSARS-CoV-2 Superspreading Eventshttps://covid19settings.blogspot.com/p/blog-page.html10/11/20Superspreading events, or instances in which many people are infected with the novel coronavirus at once, have been identified as a major force behind the spread of COVID-19. This database includes over 1,400 superspreading events from around the world, with information on each event’s timing, location, inside/outside setting, and more.
Public healthCOVID-19 and Impacted Communities: A Media Communications Guidehttps://static1.squarespace.com/static/5e6fd0a65abcc54f238eae48/t/5fac65381cc5cc66221535bb/1605133628034/COVID19+Media+Communications+Guide+Final+(11.08).pdf?fbclid=IwAR1MPsXiFYypijD-piH_hD8arCmLz7EPRXGiWYeKsBP0O8jcbLFXGxDLegE11/22/20This is another communications tool, from the New York COVID-19 Working Group. The guide includes best practices for explaining key terms, advice on framing stories, how to streotypical narratives about minority communities, and more.
Public healthEviction Labhttps://evictionlab.org/11/1/20Researchers from Princeton University run this source by reviewing formal eviction records in 48 states and the District of Columbia. Although the source’s most recent state-level dataset is as of 2016, the group is also tracking COVID-19-related evictions in real time for a select group of cities. Houston, TX, at the top of the list, seen over 13,000 new eviction filings since March. https://evictionlab.org/eviction-tracking/
Public healthPublic health departments, underfunded and under threathttps://github.com/khnews/2020-underfunded-under-threat-data8/2/20This week, Kaiser Health News (KHN) data reporter Hannah Recht released the dataset behind KHN and The Associated Press’s recent feature on how local public health departments in the U.S. have been left unprepared to face COVID-19. The dataset includes six files examining spending and staffing at public health departments across the country. https://khn.org/news/us-public-health-system-underfunded-under-threat-faces-more-cuts-amid-covid-pandemic/
Public healthThe White House’s Red Zone Reportshttps://publicintegrity.org/health/coronavirus-and-inequality/white-house-coronavirus-red-zone-reports-covid/8/23/20Each week, the White House Coronavirus Task Force sends reports to U.S. governors about the state of the pandemic, including county-level data on cases and tests. The reports are not made public, but the Center for Public Integrity is collecting and releasing many of them. As of August 23, the Center’s document repository includes one report on all 50 states (from July 14) and 13 state-specific reports.
12/13 update: The Center has posted a new national (all 50 states) report: https://beta.documentcloud.org/documents/20420661-all_states_11_29_2020
Risk assessmentCOVID-19 Event Risk Assessment Planning Toolhttps://covid19risk.biosci.gatech.edu/?fbclid=IwAR3SEtUitKm6LD3fU3tqsraNIPuiA8l_fmq_dMqOsmJIGwedcJtM1hJ9edI8/9/20If you’d like to see the likely infection rate in your area, check out the COVID-19 Event Risk Assessment Planning Tool developed by researchers at the Georgia Institute of Technology and Applied Bioinformatics Laboratory. Select a state and an event size, and the tool will tell you how likely it is that someone sick with COVID-19 is at this event. For example, at a 50-person event in New York: 2.2% risk. At a 50-person event in Florida: 21.3% risk.
Risk assessmentCOVID-19 Risk Levels Dashboardhttps://globalepidemics.org/key-metrics-for-covid-suppression/10/11/20A new map from the Harvard Global Health Institute and other public health institutions allows users to see the COVID-19 risk for every U.S. county. These risk levels are calculated based on daily cases per 100,000 population (7-day rolling average).
10/25 update: This dashboard by the Harvard Global Health Institute and other public health institutions now includes COVID-19 risk breakdowns at the congressional district level. Toggling back and forth between the county and congressional district options allows one to see that, when risk is calculated by county, a few regions of the U.S. are in the “green”; at the congressional district level, this is not true for a single area.
Risk assessmentMIT COVID-19 Indoor Safety Guidelineshttps://indoor-covid-safety.herokuapp.com/10/4/20Another air transmission resource allows users to calculate the risk levels for different indoor spaces, based on a model by MIT researchers Martin Bazant and John Bush.
Science of COVID-19Dear Pandemichttps://dearpandemic.org/9/20/20This source describes itself as “a website where bona fide nerdy girls post real info on COVID-19.” It operates as a well-organized FAQ page on the science of COVID-19, run by an all-female team of researchers and clinicians.
Science of COVID-19FAQs on Protecting Yourself from COVID-19 Aerosol Transmissionhttps://docs.google.com/document/d/1fB5pysccOHvxphpTmCG_TGdytavMmc1cUumn8m0pwzo/preview?pru=AAABdRhBOUk*R0XLr1vCiGvAvCiNGQnBMA#10/4/20This pubic document was compiled by a group of scientists and engineers who study aerosol transmission. Answered questions range from “How long can the virus stay in the air indoors?” to “What is the best type of mask?”
Science of COVID-19NIOSH-Approved N-19 Respiratorshttps://www.cdc.gov/niosh/npptl/topics/respirators/disp_part/N95list1-a.html9/6/20This CDC list includes thousands of surgical N-95 respirators approved by the National Institute for Occupational Safety and Health (NIOSH); it’s intended as a source for healthcare workers. As a recent article in Salon points out, the list includes over 600 valved models, despite recent guidances instructing the public to avoid valved masks. https://www.salon.com/2020/08/22/cdc-warned-the-public-against-wearing-valved-facemasks--while-recommending-them-to-health-workers/
Science of COVID-19SARS-CoV-2 and COVID-19 Data Hubhttps://twitter.com/ErinSandersNP/status/133036037601016627511/22/20Erin Sanders, MSN, a nurse practitioner and contact tracer, has compiled a list of data on the novel coronavirus. The list includes clinical data, transmission data, and genomic data, among other medical and epidemiological topics.
Science of COVID-19Search trends on COVID-19 symptomshttps://blog.google/technology/health/using-symptoms-search-trends-inform-covid-19-research10/4/20Researchers can now access a Google Search dataset of search trends related to over 400 COVID-19 symptoms and related health conditions, such as fever, cough, and difficulty breathing.
Science of COVID-196-month consequences of COVID-19 in patients discharged from hospital (Huang et al., The Lancet)https://www.thelancet.com/journals/lancet/article/PIIS0140-6736%2820%2932656-8/fulltext1/17/21I don’t usually feature scientific papers here, but this new study is important. It’s the biggest paper so far on COVID-19 long haulers, those patients who struggle with the disease for months after their diagnosis (or after not getting a diagnosis at all). This study followed about 1,700 patients over 6 months.
Science of COVID-19Global.health COVID-19 datasethttps://global.health/1/17/21Global.health describes itself as a “global data repository and visualization platform that enables open access to real-time epidemiological anonymized line list data.” Its COVID-19 dataset—which promises information on 5 million anonymized cases—is not yet published, but is definitely a source to look out for.
TestingCMS county-level testing datasethttps://data.cms.gov/stories/s/COVID-19-Nursing-Home-Data/bkwz-xpvg9/13/20In early September, the Center for Medicare & Medicaid Services (CMS) started publishing test positivity rates for every U.S. county. The dataset is now updated weekly (I think) and includes total test numbers as well, accumulated over 14-day periods. I've covered this dataset extensively and visualize the data in Tableau: https://public.tableau.com/profile/betsy.ladyzhets#!/vizhome/COVID-19testpositivitybycounty_16006135390530/Countytestpositivityrates-CMScategories
TestingCOVID-19 Community Profile Reportshttps://beta.healthdata.gov/National/COVID-19-Community-Profile-Report/gqxm-d9w912/20/20For months, public health advocates have called on the federal government to release in-depth data reports that are compiled internally by the White House Coronavirus Task Force. These reports include detailed information on cases, tests, and deaths at the state, county, and city levels. This past Friday, the Department of Health and Human Services (HHS) began releasing all such national COVID-19 reports and the data behind them. For more detail, see: https://coviddatadispatch.com/2020/12/20/hhs-releases-long-awaited-national-profile-reports/
TestingCOVID-19 Testing Communications Toolkithttps://www.covidtestingtoolkit.org/11/22/20The Brown School of Public Health has compiled a resource to help public health communicators encourage COVID-19 testing. The toolkit includes evidence-based tutorials, handouts, and an image library, all of which are free for public use.
TestingCOVID-19 testing siteshttps://public.tableau.com/profile/kai.hallberg#!/vizhome/COVIDHotSpotTestSiteMap/COVIDHotSpotTestSiteMap?publish=yes8/2/20The healthcare company Castlight has built a comprehensive database of COVID-19 testing sites in the U.S., down to the ZIP Code level. Castlight’s Tableau dashboard allows users to explore this database by county and compare the number of available test sites with current case counts. This dataset was cited in a recent 538 article on testing disparities. https://fivethirtyeight.com/features/white-neighborhoods-have-more-access-to-covid-19-testing-sites/
TestingDaily testing needshttps://app.powerbi.com/view?r=eyJrIjoiNzM4ZTg2ZjQtZmY5Mi00ZjIzLWIxY2ItZTZjNGYyODllZGExIiwidCI6ImMxMzZlZWMwLWZlOTItNDVlMC1iZWFlLTQ2OTg0OTczZTIzMiIsImMiOjF9&utm_source=Dean%20Jha&utm_campaign=28ae5f7076-EMAIL_CAMPAIGN_2020_10_03_12_18_COPY_01&utm_medium=email&utm_term=0_e4fcd685bb-28ae5f7076-22447688211/1/20A new tool from the Brown School of Public Health helps users calculate how many tests are needed for key essential groups, both for the nation overall and state-by-state. The tool is intended for public health leaders and policymakers who are starting to scale up as antigen tests become more widely available. For example, New York would need 37,300 tests a day to screen all college and university students.
TestingFDA Emergency Use Authorizations (EUAs)https://www.fda.gov/medical-devices/coronavirus-disease-2019-covid-19-emergency-use-authorizations-medical-devices/vitro-diagnostics-euas10/18/20The page lists every diagnostic, antibody, and management test which have been approved for COVID-19 patients. New tests are added every week. You can read about the distinction between an EUA and full approval here. https://www.raps.org/news-and-articles/news-articles/2020/4/why-fdas-issuance-of-euas-are-not-approvals-and-wh
VaccinesBloomberg's COVID-19 Vaccination Trackerhttps://www.bloomberg.com/graphics/covid-vaccine-tracker-global-distribution/12/20/20Bloomberg has counted 211,000 Pfizer doses in the U.S., as of December 19, by compiling numbers from state websites, press conferences, and interviews.
VaccinesCDC COVID Data Tracker: Vaccinationshttps://covid.cdc.gov/covid-data-tracker/#vaccinations12/27/20Mere hours after I published last week’s newsletter questioning when the federal government would release a national count of how many Americans had been vaccinated, the CDC began posting just that. The CDC COVID Data Tracker now includes both a count of how many vaccine doses have been distributed and a count of how many people have received their first dose. The count includes both Pfizer and Moderna’s vaccines, and incorporates reporting from states, local public health agencies, and federal entities including the Bureau of Prisons, Veterans Administration, and Indian Health Services. More detailed geographic and demographic data are not yet available from the CDC.
VaccinesCDC list of state immunization registrieshttps://www.cdc.gov/vaccines/programs/iis/contacts-locate-records.html12/6/20The CDC has promised to set up a national dashboard similar to its flu registry, but until then, we must rely once again on state data. This CDC list of state immunization registries should be a useful starting point for any local reporters hoping to get a jump start on vaccine data. You’d better believe that I will be spending a lot of time with these registries in future issues.
VaccinesCOVID-19 Vaccine Advance Market Commitmentshttps://launchandscalefaster.org/COVID-19#Interactive%20tables%20and%20charts%20-%20COVID-19%20Vaccine%20Advance%20Market%20Commitments12/6/20For vaccine coverage outside the U.S., see this map of procurement data from the Launch & Scale Speedometer. This research group from the Duke Global Health Innovation Center has compiled the total vaccine doses purchased by over 30 nations. The dashboard also estimates the share of each nation’s population it could be able to cover with advanced vaccine purchases. Canada is highest on the scale at 601%; the nation’s extra doses will likely be donated to other countries.
VaccinesCOVID-19 Vaccine Allocation Dashboardhttps://public.tableau.com/profile/benjamin.renton#!/vizhome/COVID-19VaccineAllocationDashboard/Dashboard112/6/20How many vaccine doses are actually going to each state? To answer this question, see the new COVID-19 Vaccine Allocation Dashboard from Benjy Renton. Renton is compiling information from local news sources on dose distributions from Pfizer and Moderna’s early shipments. Remember that both of these vaccines require two doses per person.
VaccinesKFF COVID-19 Vaccine Monitorhttps://www.kff.org/coronavirus-covid-19/report/kff-covid-19-vaccine-monitor-december-2020/12/20/20This week, the Kaiser Family Foundation released its COVID-19 Vaccine Monitor, an ongoing project to track public perception of and experiences with vaccination. The latest survey from this monitor shows that 71% of Americans would “definitely or probably” get a vaccine for COVID-19 if it was determined to be safe and freely available.
VaccinesOur World in Data: COVID-19 Vaccinationshttps://ourworldindata.org/covid-vaccinations12/27/20As of December 26, the open-source data repository Our World in Data is compiling vaccination counts from 10 countries: the U.S., the U.K., China, Russia, Israel, Canada, Bahrain, Chile, Mexico, and Costa Rica. So far, the U.S. has administered the most doses at 1.9 million, while Bahrain has administered the most doses when adjusted for population, at 3 doses for every 100 people.
VaccinesState COVID-19 Vaccine Data Dashboard Planshttps://airtable.com/shr0q2XPwuxzVQ4Eh/tblsQt56W99TG4ebp12/20/20According to ongoing analysis by the COVID Tracking Project, 15 states are reporting some form of vaccination data as of December 19. For links to all of these states’ dashboards and reports, see CTP’s annotations.
VaccinesState COVID-19 vaccine planshttps://www.kff.org/report-section/states-are-getting-ready-to-distribute-covid-19-vaccines-what-do-their-plans-tell-us-so-far-state-plans/11/22/20A new report from the Kaiser Family Foundation explores how state public health departments are planning to distribute COVID-19 vaccines once they become available. The report includes common themes and concerns across all 50 state plans, as well as links to the plans themselves.
https://www.kff.org/report-section/states-are-getting-ready-to-distribute-covid-19-vaccines-what-do-their-plans-tell-us-so-far-state-plans/
VaccinesVaccine Allocation Planner for COVID-19https://covid19vaccineallocation.org/12/6/20How many people are actually in those high-priority groups in each state? To answer that question, see the Vaccine Allocation Planner for COVID-19, a new data tool from the Surgo Foundation, Ariadne Labs, and other collaborators. For each state, the tool uses population estimates from the Census, the CDC, and other sources to show how many healthcare workers, first responders, teachers, people with severe health conditions, and other high-risk individuals will need to be vaccinated. The tool is automatically set to calculate each state’s available doses as a population-adjusted share of 10 million, but users can adjust it to see how different scenarios may play out.
VaccinesThe COVID-19 “Vaccination Line”: An Update on State Prioritization Planshttps://www.kff.org/coronavirus-covid-19/issue-brief/the-covid-19-vaccination-line-an-update-on-state-prioritization-plans/1/17/21The Kaiser Family Foundation has published an update on state vaccine prioritization plans, including both topline statistics and detailed annotations for each state.
VaccinesCOVID-19 Vaccine Communication Handbookhttps://hackmd.io/@scibehC19vax/home1/17/21The COVID-19 Vaccine Communication Handbook is a new resource from communication initiative SciBeh aimed to help journalists, healthcare workers, and other communicators talk about COVID-19 vaccines and challenge misinformation.
VaccinesCurrently Reported COVID-19 Vaccine Metrics (by the COVID Tracking Project)https://cvshealth.com/sites/default/files/cvs-health-covid-19-vaccination-data.pdf1/17/21Alice Goldfarb, Kara Schechtman, Charlotte Minsky, and other Project volunteers compiled detailed annotations on the vaccine metrics reported by each state.
VaccinesCVS COVID-19 Vaccination Datahttps://airtable.com/shralapyljNvZ48VS/tblBMblhXdMGuM2Ui1/17/21CVS has published a state-by-state dataset of long-term care facility vaccinations administered by this pharmacy chain. The COVID Tracking Project reports that Walgreens may release a similar dataset.
VaccinesUS COVID-19 Vaccination Trackinghttp://www.vaccinetracking.us/1/24/21This is a new vaccination dashboard focused on demographics, developed by researchers at Georgetown University’s Bansal Lab. The dashboard compiles data on vaccination by race, ethnicity, sex, and gender from state reporting. Users can also hover over counties to see what share of the county’s population has been vaccinated, based on county or state data. Here’s a Twitter thread from lead researcher Shweta Bansal on the dashboard’s methodology and findings so far. https://twitter.com/bansallab/status/1351292235367772165
Vulnerable communitiesCDC's Social Vulnerability Indexhttps://www.atsdr.cdc.gov/placeandhealth/svi/data_documentation_download.html11/29/20Social vulnerability, as the CDC defines it, measures a community’s ability to recover from events that are hazardous to human health. These events can include tornados, chemical spills, and—of course—pandemics. CDC researchers have calculated the social vulnerability of every Census tract in the U.S. based on 15 social, economic, and environmental factors such as poverty, lack of vehicle access, and crowded housing.
Vulnerable communitiesCOVID-19 Community Vulnerability Indexhttps://precisionforcovid.org/ccvi11/29/20In the vaccine section above, I discussed the CDC’s Social Vulnerability Index, which charts populations that are more vulnerable to health disaster. The Surgo Foundation’s COVID-19 Community Vulnerability Index builds on the CDC’s research with additional, COVID-specific sets of metrics based on epidemiological and healthcare-related factors.
Vulnerable communitiesCOVID-19 in ICE detention centershttps://github.com/vera-institute/ice-detention-covid11/1/20Since March 24, researchers from the Vera Institute of Justice have been compiling data from Immigration and Customs Enforcement (ICE) on COVID-19 cases and testing in immigrant detention centers. The researchers note that ICE replaces previously reported numbers whenever its dataset is updated, making it difficult to track COVID-19 in these facilities over time.
Vulnerable communitiesLost on the frontlinehttps://www.theguardian.com/us-news/ng-interactive/2020/aug/11/lost-on-the-frontline-covid-19-coronavirus-us-healthcare-workers-deaths-database8/16/20This week, Kaiser Health News and The Guardian released an interactive database honoring American healthcare workers who have died during the COVID-19 pandemic. 167 workers are included in the database so far, and hundreds more are under investigation. Reading the names and stories of these workers is a small way to remember those we have lost.
Vulnerable communitiesThe Long-Term Care COVID Tracker, by the COVID Tracking Projecthttps://covidtracking.com/data/longtermcare8/16/20Residents of nursing homes, assisted living facilities, and other long-term care facilities account for 43% of COVID-19 deaths in the U.S. A new dataset from the COVID Tracking Project compiles these sobering numbers from state public health departments. As of September 6, the full dataset is out, including historical data going back to May 21 and extensive notes on how each state is reporting this crucial information
Vulnerable communitiesCOVID-19 survey of Medicare beneficiarieshttps://www.cms.gov/research-statistics-data-systems/mcbs-public-use-file/medicare-current-beneficiary-survey-fall-2020-covid-19-data-snapshot1/17/21This week, the Centers for Medicare & Medicaid Services published results of a survey of Medicare beneficiaries, focused on their experiences with COVID-19. The data include American seniors’ perceptions of vaccines, perceptions of COVID-19 safety, care experiences, and more.

To access this list in a Google spreadsheet, make a copy of the document at this link.