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. Click on the left of an entry to see expanded details.
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.
Economy/fundingYelp Data Reveals Pandemic’s Impact on Local Economieshttps://www.yelpeconomicaverage.com/covid-19-anniversary.html3/21/21The public review site Yelp recently published results of an analysis tying listings on the site to trends in business openings and closings. It’s actually pretty interesting—almost 500,000 small businesses have actually opened in the past year, including about 76,000 restaurant and food businesses.
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
Healthcare systemPulse of the Purchaser 2021 Reporthttps://higherlogicdownload.s3.amazonaws.com/NAHPC/3d988744-80e1-414b-8881-aa2c98621788/UploadedFiles/tQU7KFiSHKQTawzsmxyG_Pulse%20of%20the%20Purchaser%202021%20results%20FINAL.pdf4/4/21This new report from the National Alliance of Healthcare Purchaser Coalitions examines how employer attitudes to healthcare have shifted during the COVID-19 pandemic. The report presents results from a survey of 151 major employers, representing diverse industries and sizes; it includes attitudes towards COVID-19 vaccines, telehealth, equity, and other healthcare topics.
Healthcare systemState COVID-19 Hospitalization Data Annotations, by the COVID Tracking Projecthttps://covidtracking.com/analysis-updates/releasing-our-annotations-on-state-hospitalizations-data4/11/21This week, the COVID Tracking Project released a snapshot of extensive research into how U.S. states are reporting their currently hospitalized COVID-19 patients. The research has informed comparisons between Project data and federal data which demonstrated the quality of the HHS hospitalization dataset. You can access these annotations, along with information on cases, tests, and deaths, at the Project’s Data Annotations page.
https://covidtracking.com/about-data/data-annotations
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.
Higher edPreventCOVIDU study examines vaccine effectiveness in college studentshttps://preventcovidu.org/about-us/3/28/21At the White House COVID-19 briefing this Friday, Dr. Fauci described a new clinical trial that kicked off this past week. 12,000 college students, age 18-26, at 22 universities across the country, will be followed over the 5 months. Half of the students are receiving Moderna vaccine doses now, while the other half will serve as a control group (and get vaccinated later). All students will get tested daily—and, in a unique move for vaccine studies, about 25,000 of these students’ close contacts will also get tested daily. The study is designed to determine if the Moderna vaccine prevents coronavirus infection and transmission. See the list of participating universities at the link.
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.
K-12 schoolsBurbio's K-12 School Opening Trackerhttps://cai.burbio.com/school-opening-tracker/2/28/21Burbio, a digital platform for community events, is actively monitoring over 1,200 school districts to determine which schools are currently using virtual, in-person, and hybrid models. The sample size includes the 200 largest districts in the U.S. and other districts with a mix of sizes and geographies, in order to reflect local decision-making across the U.S. See more methodology details here.
https://about.burbio.com/methodology/
K-12 schoolsU.S. School Closure & Distance Learning Databasehttps://www.nature.com/articles/s41562-021-01087-83/21/21Two researchers from the Columbia University Center on Poverty and Social Policy used anonymized cell phone data to compile a database tracking attendance changes at over 100,000 U.S. schools during the pandemic. Their results: school closures are more common in schools where more students have lower math scores, are students of color, have experienced homelessness, or are eligible for free/reduced price lunches. The data are publicly available here. https://osf.io/tpwqf/
K-12 schoolsSchool Survey Dashboard from the Institute of Education Statisticshttps://ies.ed.gov/schoolsurvey/3/28/21As part of the Biden Administration’s commitment to reopening K-12 schools across the country, the federal government is now collecting data on how students are receiving education—and releasing those data on a monthly basis. This dashboard draws from surveys of a nationally represented sample including 7,000 rural, suburban, and urban schools, focusing on fourth-graders and eighth-graders. We don’t have data on COVID-19 cases, tests, or enrollment numbers, and several major states are missing, but this is a good start! For more on these data, read Lauren Camera in U.S. News.
https://www.usnews.com/news/education-news/articles/2021-03-24/data-reveal-significant-racial-disparities-in-school-reopening
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.
MortalityCDC Provisional Mortality Data for 2020https://www.cdc.gov/mmwr/volumes/70/wr/mm7014e1.htm?s_cid=mm7014e1_w4/4/21This past Wednesday, the CDC released death counts for 2020. As we’ve discussed before, mortality data tend to be reported with a lag compared to other types of public health numbers due to the complex processes involved with tallying up death certificates. About 3.3 million deaths occurred overall in 2020, according to these new data; this was a 16% increase from 2019. COVID was the third leading cause of death that year, accounting for 345,000 lives lost.
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)
OtherOpenSky COVID-19 Flight Datasethttps://zenodo.org/record/4419079#.YBbkSuhKhnI1/31/21Martin Strohmeier, a computer scientist at Oxford University, and other collaborators have compiled a dataset of flight data related to the COVID-19 pandemic. According to a blog post published in late December, Strohmeier plans to update the dataset once a month. https://opensky-network.org/community/blog/item/6-opensky-covid-19-flight-dataset
OtherDocumenting COVID-19https://documentingcovid19.io/3/7/21This repository is one of several great resources brought to my attention during this past week’s NICAR conference. It’s a database of documents related to the pandemic, obtained through state open-records laws and the Freedom of Information Act (FOIA). 246 records are available as of February 26.
OtherCOVID-19 diverse sourceshttps://airtable.com/shrHzKsbzpL6nVjtU/tblCkKUyTtxqhVYZW3/28/21NPR journalists from the organization’s Source of the Week project have compiled this database of COVID-19 experts from diverse backgrounds. The database is divided into 13 major categories, including virology, disease origin, health policy, racial/ethnic health disparities, and more.
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
Public healthCovid Performance Indexhttps://interactives.lowyinstitute.org/features/covid-performance/1/31/21How do different countries rank in their management of the pandemic? This index, from think tank the Lowy Institute, attempts to answer that question by comparing infection rates, death rates, and testing for 98 countries with available data. New Zealand, Vietnam, and Taiwan are at the top of the list; the U.S. ranks #94.
Public healthThe Accountability Projecthttps://publicaccountability.org/2/28/21A repository of public data run by the Investigative Reporting Workshop, the Accountability Project reached 1 billion records last week. The Project includes several COVID-19-related datasets, including a dataset of Paycheck Protection Program loans and data on hospitals and nursing homes.
https://publicaccountability.org/dataset-search/#dataset=358
https://www.publicaccountability.org/datasets/home/#collection8
Public healthFederal COVID-19 Chart Gallery (Peter Walker)https://public.tableau.com/views/FederalCOVID-19ChartGallery/0_Gallery?:language=en&:display_count=y&:origin=viz_share_link4/4/21Peter Walker, former data visualization co-lead for the COVID Tracking Project, has put together a new Tableau gallery using data from the CDC COVID Tracker and HHS Protect. The gallery includes many chart formats that CTP fans may recognize, such as national views, four-pane views, and regional comparisons. More charts are coming!
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.
2/28/21 update: Back in January, I wrote about Global.health, a data science initiative aiming to bring anonymized case data to researchers on a global scale. The initiative’s COVID-19 dataset is now online, including over 10 million individual case records from dozens of countries. If you’d like to better understand why this dataset is a pretty big deal, read this article in Nature or this one in STAT.
https://www.nature.com/articles/d41586-021-00490-5
https://www.statnews.com/2021/02/24/global-health-covid19-data-records/
Science of COVID-19COVID-19 Neuro Databankhttps://med.nyu.edu/departments-institutes/population-health/divisions-sections-centers/biostatistics/research/nih-neurodatabank-neurobiobank1/31/21The National Institutes of Health has started a new database to keep track of neurological symptoms associated with COVID-19. The database will be fully anonymized, and it’ll be accessible for scientists who want to better understand neurological complications with the disease. For more information, see this press release from the NIH. https://www.nih.gov/news-events/news-releases/nih-launches-database-track-neurological-symptoms-associated-covid-19
Science of COVID-19CoVariantshttps://covariants.org/2/21/21This new resource from virus tracker Dr. Emma Hodcroft provides an overview of SARS-CoV-2 variants and mutations. You can explore how variants have spread across different parts of the world through brightly colored charts. The resource is powered by GISAID, Nextstrain, and other sequencing data; follow Dr. Hodcroft on Twitter for regular updates.
https://twitter.com/firefoxx66
Science of COVID-19NIH COVID-19 treatment guidelineshttps://www.covid19treatmentguidelines.nih.gov/2/28/21In one of the White House COVID-19 press briefings this week, Dr. Fauci referenced this National Institutes of Health (NIH) website intended to provide both physicians and researchers with the latest guidance on how to treat COVID-19 patients. The website acts as a living medical document, featuring an interactive table of contents and a text search tool. Follow @NIHCOVIDTxGuide on Twitter for updates.
Science of COVID-19Coronavirus variant data from USA TODAYhttps://github.com/USATODAY/covid-variants/3/7/21The CDC doesn’t publish a time series of its counts of COVID-19 cases caused by variants. So, USA TODAY journalists have set up a program to scrape these data whenever the CDC publishes an update and store the data in a CSV, including variant counts for every U.S. state. The time series goes back to early January.
Science of COVID-19Helix COVID-19 Surveillance Dashboardhttps://www.helix.com/pages/helix-covid-19-surveillance-dashboard3/14/21Helix, a population genomics company, is one of the leading private partners in the CDC’s effort to ramp up SARS-CoV-2 sequencing efforts in the U.S. The company is reporting B.1.1.7 cases identified in select states, along with data on a mutation called S gene target failure (or SGTF) that scientists have found to be a major identification point in distinguishing B.1.1.7 from other strains.
Science of COVID-19Pfizer COVID-19 Clinical Trialshttps://www.pfizer.com/science/find-a-trial/search/COVID-194/4/21An interactive, searchable map from Pfizer lets you look up vaccine trials around the world. For each trial, you can see the location, the trial’s phase, who’s eligible to join, and a link out to more information on ClinicalTrials.gov. Trials are happening in the U.S., the U.K., Spain, and Japan.
Science of COVID-19mRNA sequence for the Moderna vaccinehttps://github.com/NAalytics/Assemblies-of-putative-SARS-CoV2-spike-encoding-mRNA-sequences-for-vaccines-BNT-162b2-and-mRNA-1273/blob/main/Assemblies%20of%20putative%20SARS-CoV2-spike-encoding%20mRNA%20sequences%20for%20vaccines%20BNT-162b2%20and%20mRNA-1273.docx.pdf4/4/21A group of scientists at Stanford used small amounts of Moderna vaccine left after all doses were extracted from vials to sequence the mRNA in that vaccine, then posted the sequence publicly on GitHub. The full sequence takes up two pages. You can read more about the scientists’ work and their decision to post the sequence in Motherboard.
https://www.vice.com/en/article/7k9gya/stanford-scientists-reverse-engineer-moderna-vaccine-post-code-on-github
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 Vaccine 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.
2/21/21 update: The Bloomberg team made two major updates this week. First, they added a demographic vertical, which includes race and ethnicity data for the U.S. overall and for 27 states that are reporting these data. This vertical will be updated weekly. Second, the team made all of their data available on GitHub! I, for one, am quite excited to dig through the historical figures.
https://www.bloomberg.com/graphics/covid-vaccine-tracker-global-distribution/us-vaccine-demographics.html
https://github.com/BloombergGraphics/covid-vaccine-tracker-data
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.
VaccinesLaunch & Scale Speedometer: COVID-19 vaccine 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
VaccinesCOVAX Global Supply Forecasthttps://www.gavi.org/sites/default/files/covid/covax/COVAX%20Supply%20Forecast.pdf1/31/21Another global data source is this report from COVAX, an initiative from the World Health Organization and Gavi, the Coalition for Epidemic Preparedness. The report provides summaries of the global vaccine supply, including both existing contracts and those under negotiation.
VaccinesSubnational COVID-19 vaccination datahttps://github.com/sociepy/covid19-vaccination-subnational2/14/21Barcelona-based data scientist Lucas Rodés-Guirao has compiled vaccination data at subnational levels (or, states and regions) for 20 different countries. The dataset includes the U.S. as well nations in Europe and South America; it’s sourced from public data released by national public health agencies.
VaccinesThe Next Phase of Vaccine Distribution: High-Risk Medical Conditions (from KFF)https://www.kff.org/policy-watch/the-next-phase-of-vaccine-distribution-high-risk-medical-conditions/2/21/21The latest analysis brief from the Kaiser Family Foundation looks at how individuals with high-risk medical conditions are being prioritized for vaccine distribution in each state. KFF researchers compared each state’s prioritization plans to the CDC’s list of conditions that “are at increased risk” or “may be at an increased risk” for severe illness due to COVID-19; the analysis reflects information available as of February 16.
VaccinesFirst Month of COVID-19 Vaccine Safety Monitoring (CDC MMWR)https://www.cdc.gov/mmwr/volumes/70/wr/mm7008e3.htm?s_cid=mm7008e3_w2/21/21This past Friday, the CDC released a Morbidity and Mortality Weekly Report with data from the first month of safety monitoring, using the agency’s Vaccine Adverse Event Reporting System (or VAERS). Out of the 13.8 million vaccine doses administered during this period, about 7,000 adverse events were reported—and only 640 were classified as serious. Check the full report for figures on common side effects and enrollment in the CDC’s new v-safe monitoring program.
VaccinesVaccineFinderhttps://vaccinefinder.org/2/28/21As of Wednesday, Americans can use this national tool to find COVID-19 vaccine appointments. Just put in your ZIP code and select a radius (1 mile, 10 miles, 50 miles, etc.), and the tool will show you providers nearby. For each provider, the tool provides contact information—and, crucially, whether this location actually has vaccines in stock. Unlike many other federal dashboards, VaccineFinder isn’t a new tool; it was developed during the H1N1 flu outbreak in 2009. STAT’s Katie Palmer provides more history and context on the site here.
https://www.statnews.com/2021/02/24/cdc-vaccinefinder-covid19-locations/
VaccinesVaccinateCA APIhttps://docs.vaccinateca.com/reference3/7/21California readers, this one’s for you. The community-driven project VaccinateCA, aimed at helping Californians get vaccinated, has made its underlying data available for researchers. The API includes data on vaccination sites and their availability across the state.
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.
4/11/21 update: Now, you can read the profiles of hundreds more. 3,607 deaths have been recorded in total. KHN and The Guardian closed their joint investigation this week, and public health leaders and policymakers are now calling on the federal government to continue this crucial work.
https://khn.org/news/article/biden-track-us-health-care-worker-covid-deaths/
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.
Vulnerable communitiesAnti-Asian Hate Incidentshttps://secureservercdn.net/104.238.69.231/a1w.90d.myftpupload.com/wp-content/uploads/2021/02/Press-Statement-re_-Bay-Area-Elderly-Incidents-2.9.2021-1.pdf2/14/21Stop AAPI Hate, a national coalition documenting anti-Asian hate and discrimination during the COVID-19 pandemic, has released a new report with data on 2020 incidents. According to the report, Stop AAPI Hate has received 2,800 firsthand accounts of anti-Asian hate from 47 states and D.C. since the organization started collecting reports in mid-March.
Vulnerable communitiesCOVID-19’s impact on LGBTQ+ communitieshttps://journalistsresource.org/home/covid-19-lgbtq-research/2/28/21The Journalist’s Resource at Harvard Kennedy School has compiled a list of recent research on how the coronavirus pandemic impacted LGBTQ+ Americans. In many cases, the pandemic furthered disproportionate poverty and poor health outcomes in this community; they shouldn’t be ignored in COVID-19 coverage.
Vulnerable communitiesCOVID-19 related deaths by occupation, England and Waleshttps://www.ons.gov.uk/peoplepopulationandcommunity/healthandsocialcare/causesofdeath/bulletins/coronaviruscovid19relateddeathsbyoccupationenglandandwales/deathsregisteredbetween9marchand28december20203/14/21The U.S. doesn’t publish any data connecting COVID-19 cases or deaths to occupations, but the U.K. data falls along similar lines to what we’d expect to see here: essential workers have been hit hardest. Men in “elementary occupations,” a class of jobs that require some physical labor, and women in service and leisure occupations have the highest death rates.
Vulnerable communitiesThe Impact of the COVID-19 Pandemic on LGBT Peoplehttps://www.kff.org/coronavirus-covid-19/poll-finding/the-impact-of-the-covid-19-pandemic-on-lgbt-people/3/14/21This brief from the Kaiser Family Foundation addresses a key data gap in the U.S.; the national public health agencies and most states do not publish any data on how the pandemic has specifically hit the LGBTQ+ community. KFF surveys found that a larger share of LGBTQ+ adults have experienced job loss and negative health impacts in the past year, compared to non-LGBTQ+ adults.
Vulnerable communitiesData Reporting & Quality Scorecard from the UCLA Law COVID-19 Behind Bars Data Projecthttps://uclacovidbehindbars.org/blog/scorecard3/21/21The researchers and volunteers at UCLA have been tracking COVID-19 in prisons, jails, and other detention facilities since March 2020. This new scorecard, described on the project’s blog, reflects the quality of data available from state correctional agencies, the Federal Bureau of Prisons, Immigrations and Customs Enforcement, and other government sources. No state or federal institution on the list scores an A; the vast majority score Fs.
Vulnerable communitiesCounties with High COVID-19 Incidence and Relatively Large Racial and Ethnic Minority Populations (CDC MMWR)https://www.cdc.gov/mmwr/volumes/70/wr/mm7013e1.htm?s_cid=mm7013e1_w3/28/21The CDC continues adding to the overwhelming body of evidence pointing to disproportionately high COVID-19 impacts for people of color in the U.S. This report, released last Wednesday, identified counties across the U.S. that had both large minority populations and high COVID-19 case counts (relative to their populations) between April and December 2020. Different racial/ethnic groups have had different trajectories, but by mid-December, almost all counties in the U.S. had high case numbers thanks to the overwhelming winter surge.
Vulnerable communitiesFood Insecurity in the United Stateshttp://map.feedingamerica.org/4/11/21Nonprofit hunger relief organization Feeding America has compiled and mapped data showing how the pandemic has impacted food insecurity in the U.S. You can search for a specific state, county, or local food bank to see food-insecure population estimates, average meal costs, food stamp program eligibility, and more.

Click on a row to see expanded annotations on that source.

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