COVID-19 Data Dispatch Source ListThis 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.
|Census||Household Pulse Survey by the U.S. Census||https://www.census.gov/programs-surveys/household-pulse-survey/data.html||8/16/20||From 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.
|Census||Census COVID-19 Demographic and Economic Resources||https://covid19.census.gov/||12/6/20||My 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.|
|Charity/aid||Charity Navigator||https://www.charitynavigator.org/||8/30/20||Charity 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/aid||Mutual Aid Disaster Relief||https://mutualaiddisasterrelief.org/collective-care/||9/20/20||This 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.|
|Demographic||The COVID Racial Data Tracker, by the COVID Tracking Project||https://covidtracking.com/race||7/26/20||COVID-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 (firstname.lastname@example.org).|
|Demographic||Colors of COVID||https://thecolorsofcovid.com/||9/6/20||This 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.|
|Demographic||GenderSci Lab’s US Gender/Sex Covid-19 Data Tracker||https://www.genderscilab.org/gender-and-sex-in-covid19||9/13/20||The 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.|
|Demographic||The COVID Tracking Project’s City Dataset||https://docs.google.com/spreadsheets/u/1/d/e/2PACX-1vRg-dB5Pjt-zN38BZNoCdOk_RJ_MyYFAl3QIkK5fKSddUy44DUgJwZuhjCz8KPMpiFKRwhoIwfs0NbZ/pubhtml||11/15/20||For 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.
|Economy/funding||COVID-19 relief tracker||https://covidtracker.pogo.org/||12/6/20||The 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/funding||Searchable database of federal COVID-19 purchases||https://projects.propublica.org/coronavirus-contracts/||12/13/20||Since 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/funding||Searchable database of PPP data||https://searchppp.com/||12/13/20||On 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/funding||Yelp Data Reveals Pandemic’s Impact on Local Economies||https://www.yelpeconomicaverage.com/covid-19-anniversary.html||3/21/21||The 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.|
|Economy/funding||Unemployment Insurance Data Explorer||https://tcf-ui-data.shinyapps.io/ui-data-explorer/||5/30/21||This tool from progressive think tank The Century Foundation allows users to explore, visualize, and download data on unemployment insurance distributed during the pandemic. The tool includes data broken out by state and goes back in time to 1971—valuable for historical analysis.|
|Economy/funding||Fiscal accountability for COVID-19 data||https://internationalbudget.org/covid/||6/13/21||The International Budget Partnership, a global nonprofit working to improve government budgets, has produced a report and interactive website analyzing accountability measures that international governments have—and have not—implemented as part of emergency COVID-19 responses. Notably, out of 120 countries surveyed, none have “substantive” accountability and only four have “adequate” accountability.|
|Healthcare system||COVID Care Map||https://www.covidcaremap.org/||8/23/20||Dave 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 system||Federal allocation of remdesivir||https://www.phe.gov/emergency/events/COVID19/investigation-MCM/Pages/commercial-allocation-table.aspx||8/23/20||This 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 system||America’s Health Rankings’ Senior Report||https://assets.americashealthrankings.org/app/uploads/ahr-senior-report_2019_final.pdf||9/6/20||America’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 system||COVIDcast||https://covidcast.cmu.edu/?sensor=doctor-visits-smoothed_adj_cli&level=county&date=20200909&signalType=value&encoding=color&mode=overview||9/13/20||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.
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.
|Healthcare system||HHS Protect Public Data Hub||https://protect-public.hhs.gov/||11/1/20||For 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 system||Allocating Regeneron’s treatment||https://www.phe.gov/emergency/events/COVID19/investigation-MCM/cas_imd/Pages/allocation.aspx||12/6/20||On 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 system||COVID-19 Reported Patient Impact and Hospital Capacity by Facility||https://healthdata.gov/dataset/covid-19-reported-patient-impact-and-hospital-capacity-facility||12/20/20||On 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 system||Hospital facilities visualization by the COVID Tracking Project||https://covidtracking.com/data/hospital-facilities||1/10/21||Last 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 system||Therapeutics distribution (from HHS)||https://protect-public.hhs.gov/pages/therapeutics-distribution||1/10/21||The 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 system||Hospital discharge summaries (from the Healthcare Cost and Utilization Project)||https://www.hcup-us.ahrq.gov/reports/trendtables/summarytrendtables.jsp||1/10/21||This 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 system||Pulse of the Purchaser 2021 Report||https://higherlogicdownload.s3.amazonaws.com/NAHPC/3d988744-80e1-414b-8881-aa2c98621788/UploadedFiles/tQU7KFiSHKQTawzsmxyG_Pulse%20of%20the%20Purchaser%202021%20results%20FINAL.pdf||4/4/21||This 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 system||State COVID-19 Hospitalization Data Annotations, by the COVID Tracking Project||https://covidtracking.com/analysis-updates/releasing-our-annotations-on-state-hospitalizations-data||4/11/21||This 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.
|Healthcare system||COVID-19 hospitalizations and ED visits by race/ethnicity (CDC MMWR)||https://www.cdc.gov/mmwr/volumes/70/wr/mm7015e2.htm?s_cid=mm7015e2_w|
|4/18/21||This week, the CDC published Morbidity and Mortality Weekly Reports on racial and ethnic disparities in COVID-19 hospitalizations and emergency department visits. The reports continue to hammer home this pandemic’s disproportionate impact on non-white Americans. In all major regions of the country, Hispanic/Latino COVID-19 patients were more likely to be hospitalized than those of other ethnicities; and in 13 states with ED visit data, Hispanic/Latino, Black, and Indigenous patients experienced the highest rates of hospital visits for the disease.|
|Healthcare system||Post-COVID Care Centers||https://www.survivorcorps.com/pccc||5/2/21||Post-COVID Care Centers, or PCCCs, are clinics where long COVID patients can receive treatment. They’re staffed by a growing group of multidisciplinary doctors and medical researchers seeking to understand this prolonged condition. The long COVID advocacy network Survivor Corps has compiled this database of PCCCs by state; 17 out of 50 states don’t yet have any such centers.|
|Healthcare system||Cases and deaths among healthcare workers (CDC)||https://covid.cdc.gov/covid-data-tracker/#health-care-personnel||5/30/21||A new addition to the CDC COVID Data Tracker this week: a tab reporting cases and deaths in doctors, nurses, and other healthcare personnel. The CDC is reporting both totals and new cases/deaths by week, though the data here likely represent only a fraction of the true counts of healthcare workers infected during the pandemic. Notably, the total death toll is only about 1,600—less than half of the healthcare worker deaths reported by The Guardian and KHN’s “Lost on the Frontline” project.|
|Higher ed||COVID-19 Testing in US Colleges||https://docs.google.com/spreadsheets/d/10I8bVkLzvrmXJsb5N-8JSFpWw5vBwDKYzyOVAI4viKo/edit#gid=1514440859||8/23/20||Sina 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 ed||The College Crisis Initiative||https://collegecrisis.shinyapps.io/dashboard/||8/23/20||Davidson 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 ed||College/University COVID-19 Dashboards||https://docs.google.com/spreadsheets/d/e/2PACX-1vQsCbJGsSWSGw_T44-OAkW0DBOWjLdpXBO2s5fINRGJWjAOzAAFhEo-0Y-H8fmrlAd7gOpg48q4zx0N/pubhtml||8/30/20||For 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 ed||College COVID-19 Outbreak Watchlist||https://public.tableau.com/profile/benjamin.renton#!/vizhome/CollegeCovid-19OutbreakWatchlist/CollegeCovid-19OutbreakWatchlist||9/6/20||Education 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 ed||We Rate Covid Dashboards||https://www.ratecoviddashboard.com/||9/13/20||Two 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 ed||NYT College and University COVID-19 counts||https://github.com/nytimes/covid-19-data/tree/master/colleges||10/11/20||The 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 ed||The Buffalo News’ trackers of COVID-19 cases in college athletics||https://docs.google.com/spreadsheets/d/16iV64rAhzjDeQIdyUiLe2rfkBefYZBLrt0quuCg8BHg/edit#gid=0|
|12/20/20||CDD 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 ed||PreventCOVIDU study examines vaccine effectiveness in college students||https://preventcovidu.org/about-us/||3/28/21||At 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.|
|Higher ed||Colleges requiring COVID-19 vaccinations (Chronicle)||https://www.chronicle.com/blogs/live-coronavirus-updates/heres-a-list-of-colleges-that-will-require-students-to-be-vaccinated-against-covid-19?cid=gen_sign_in||5/2/21||A growing number of colleges and universities are aiming to protect their students, professors, and staff by requiring COVID-19 vaccinations for those coming to campus next fall. The Chronicle of Higher Education has identified 190 such institutions as of April 30, and is continually updating its list. (Note: You need to sign up with a free account to view the page.)|
|Journalism||The CoronaVirusFacts Alliance Database||https://www.poynter.org/ifcn-covid-19-misinformation/||8/2/20||Since 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.|
|Journalism||COVID-19 Cutback Tracker||https://www.cjr.org/widescreen/covid-cutback-tracker.php||9/13/20||Researchers 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.|
|Journalism||Journalism and the Pandemic Survey||https://www.icfj.org/our-work/journalism-and-pandemic-survey||10/18/20||The 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/|
|K-12 schools||District Budget Decisions||https://edunomicslab.org/district-budget-decisions-labor-implications/||8/23/20||Edunomics 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 schools||The COVID Monitor: COVID-19 Reporting in K-12 schools||https://experience.arcgis.com/experience/fb52d598982f41faac714b5ebe32e7d1?data_id=dataSource_5-USA_COVID_Websites_for_States%3A5||8/23/20||FinMango, 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 schools||K-12 school closures, quarantines, and/or deaths||https://app.smartsheet.com/b/publish?EQBCT=00a2d3fbe4184e75b06f392fc66dca13||8/30/20||Alisha 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 schools||Reopening plans in America’s largest public school districts||https://usafacts.org/articles/how-are-children-going-back-school-americas-225-largest-public-school-districts/||9/6/20||The 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 schools||COVID-19 in Wisconsin schools||https://projects.jsonline.com/topics/coronavirus/schools/coronavirus-in-wisconsin-schools-search-covid-19.html||9/20/20||Wisconsin 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 schools||COVID-19 School Response Dashboard||https://statsiq.co1.qualtrics.com/public-dashboard/v0/dashboard/5f62eaee4451ae001535c839#/dashboard/5f62eaee4451ae001535c839?pageId=Page_1ac6a6bc-92b6-423e-9f7a-259a18648318||10/4/20||Clearly, 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 schools||Missing in the Margins: Estimating the Scale of the COVID-19 Attendance Crisis||https://bellwethereducation.org/publication/missing-margins-estimating-scale-covid-19-attendance-crisis||10/25/20||This 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 schools||Leading in Crisis briefs||https://www.cpre.org/leading-crisis||11/29/20||A 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 schools||Burbio's K-12 School Opening Tracker||https://cai.burbio.com/school-opening-tracker/||2/28/21||Burbio, 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.
|K-12 schools||U.S. School Closure & Distance Learning Database||https://www.nature.com/articles/s41562-021-01087-8||3/21/21||Two 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 schools||School Survey Dashboard from the Institute of Education Statistics||https://ies.ed.gov/schoolsurvey/||3/28/21||As 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.
|Legislation||Open States COVID-19 Legislation||https://openstates.org/covid19/||10/4/20||Open 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.|
|Legislation||The Pandemic and ICE Use of Detainers in FY 2020||https://trac.syr.edu/immigration/reports/627/||10/25/20||The 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.|
|Legislation||COVID-19 State and County Policy Orders||https://healthdata.gov/dataset/covid-19-state-and-county-policy-orders||11/15/20||This 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.|
|Legislation||COVID-19 Global Travel Restrictions and Airline Information||https://data.humdata.org/dataset/covid-19-global-travel-restrictions-and-airline-information||12/13/20||The 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.|
|Legislation||COVID Border Accountability Project||https://covidborderaccountability.org/index.html||12/20/20||This 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.|
|Mortality||Excess deaths associated with COVID-19 (international)||https://github.com/TheEconomist/covid-19-excess-deaths-tracker||7/26/20||The 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|
|Mortality||Excess deaths associated with COVID-19 (U.S.)||https://www.cdc.gov/nchs/nvss/vsrr/covid19/excess_deaths.htm||7/26/20||One 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.|
|Mortality||The Human Mortality Database||https://www.mortality.org/||10/11/20||This 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.|
|Mortality||CDC Provisional Mortality Data for 2020||https://www.cdc.gov/mmwr/volumes/70/wr/mm7014e1.htm?s_cid=mm7014e1_w||4/4/21||This 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.|
|Mortality||Excess deaths in the U.S. (Kieran Healy)||https://kieranhealy.org/blog/archives/2021/02/24/excess-deaths-february-update/||5/2/21||Kieran Healy, sociology professor at Duke University, recently updated his chart gallery on excess deaths in the U.S. during 2020, using CDC data. All states saw significantly higher death rates in 2020 compared to 2015-2019 (except for North Carolina, which has incomplete data due to reporting delays). New York City has the highest death rate by far at over 30%.|
|Mortality||Excess deaths by U.S. county||https://data.cdc.gov/NCHS/Provisional-COVID-19-Death-Counts-in-the-United-St/kn79-hsxy||5/23/21||Excess deaths, or those deaths that occur above a region’s past baseline, are a common metric for examining the true toll of COVID-19. In addition to reporting excess deaths by U.S. states and demographic categories, the CDC’s National Center for Health Statistics (NCHS) also reports this information by county. A group of researchers (Stokes et al.) recently analyzed these county-level data and found that U.S. COVID-19 deaths may be underestimated by about 20%; their findings were published this week in PLOS Medicine.
|Other||HHS celebrity tracker||https://www.politico.com/f/?id=00000175-72c2-dc1a-a5f7-fae72f290000||11/1/20||This 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)|
|Other||OpenSky COVID-19 Flight Dataset||https://zenodo.org/record/4419079#.YBbkSuhKhnI||1/31/21||Martin 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|
|Other||Documenting COVID-19||https://documentingcovid19.io/||3/7/21||This 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.|
|Other||COVID-19 diverse sources||https://airtable.com/shrHzKsbzpL6nVjtU/tblCkKUyTtxqhVYZW||3/28/21||NPR 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.|
|Other||Searching for COVID-19||https://searchingcovid19.com/||4/18/21||This interactive series of data visualizations allows users to explore top COVID-19-related Google search queries since January 20, 2020. The charts focus on “How to __” and “What is/are __” questions, such as, “how to make hand sanitizer?” You can also sort by country and U.S. state. The project is a collaboration between research and design firm Schema Design, Google News, and Axios.|
|Other||Johns Hopkins Pandemic Data Initiative||https://coronavirus.jhu.edu/pandemic-data-initiative||5/23/21||The Johns Hopkins Coronavirus Resource Center is one of the most widely-cited sources of COVID-19 data, providing detailed and up-to-date information for both the U.S. and the world. But the resource center’s scientists “have struggled to work with COVID-19 data that is inconsistent, incomplete, and insufficient,” writes JHU data lead Beth Blauer in a blog post. A new section of the resource center will explore data inconsistencies and highlight possible solutions.|
|Other||Dr. Fauci’s emails||https://www.documentcloud.org/documents/20793561-leopold-nih-foia-anthony-fauci-emails||6/6/21||This week, the federal government put out one of its most vital information releases of the pandemic thus far: a trove of Dr. Anthony Fauci’s emails. The emails, requested by journalists at BuzzFeed and the Washington Post via public records requests, cover hundreds of messages sent to or from the esteemed infectious disease expert in the early months of the pandemic. BuzzFeed has published about 3,200 emails in raw, unfiltered form.|
|Outbreaks||COVID-19 at the White House Contact Tracker||https://public.tableau.com/profile/peter.james.walker#!/vizhome/COVID-19attheWhiteHouse-ContactTracking/OverviewDash||10/4/20||This 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.
|Outbreaks||SARS-CoV-2 Superspreading Events||https://covid19settings.blogspot.com/p/blog-page.html||10/11/20||Superspreading 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.|
|Outbreaks||COVID-19 in Congress||https://www.govtrack.us/covid-19||11/29/20||GovTrack.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.|
|Outbreaks||Mass Incarceration, COVID-19, and Community Spread||https://www.prisonpolicy.org/reports/covidspread.html||12/20/20||The 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.|
|Outbreaks||GAO analysis of COVID-19 in nursing homes||https://www.gao.gov/products/gao-21-367||5/23/21||The Government Accountability Office, an organization that does research and audits on behalf of Congress, has a new report out this week on the devastating COVID-19 outbreaks that took place in nursing homes. The GAO researched about 13,000 facilities, using CDC data from May 2020 to January 2021. 94% of the nursing homes in the study faced at least one COVID-19 outbreak, with the majority of outbreaks (85%) lasting five weeks or more.|
|Public health||Public health departments, underfunded and under threat||https://github.com/khnews/2020-underfunded-under-threat-data||8/2/20||This 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 health||The White House’s Red Zone Reports||https://publicintegrity.org/health/coronavirus-and-inequality/white-house-coronavirus-red-zone-reports-covid/||8/23/20||Each 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 health||Eviction Lab||https://evictionlab.org/||11/1/20||Researchers 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 health||COVID-19 and Impacted Communities: A Media Communications Guide||https://static1.squarespace.com/static/5e6fd0a65abcc54f238eae48/t/5fac65381cc5cc66221535bb/1605133628034/COVID19+Media+Communications+Guide+Final+(11.08).pdf?fbclid=IwAR1MPsXiFYypijD-piH_hD8arCmLz7EPRXGiWYeKsBP0O8jcbLFXGxDLegE||11/22/20||This 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 health||Covid Performance Index||https://interactives.lowyinstitute.org/features/covid-performance/||1/31/21||How 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 health||The Accountability Project||https://publicaccountability.org/||2/28/21||A 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.
|Public health||Federal COVID-19 Chart Gallery (Peter Walker)||https://public.tableau.com/views/FederalCOVID-19ChartGallery/0_Gallery?:language=en&:display_count=y&:origin=viz_share_link||4/4/21||Peter 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 assessment||COVID-19 Event Risk Assessment Planning Tool||https://covid19risk.biosci.gatech.edu/?fbclid=IwAR3SEtUitKm6LD3fU3tqsraNIPuiA8l_fmq_dMqOsmJIGwedcJtM1hJ9edI||8/9/20||If 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 assessment||MIT COVID-19 Indoor Safety Guidelines||https://indoor-covid-safety.herokuapp.com/||10/4/20||Another 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.|
|Risk assessment||COVID-19 Risk Levels Dashboard||https://globalepidemics.org/key-metrics-for-covid-suppression/||10/11/20||A 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 assessment||RTI COVID-19 Data Insights Tool||https://www.rti.org/insights/covid-19-immunity-tracking||4/25/21||This new data tool from RTI International provides county-level COVID-19 insights. The tool uses publicly available case data from Johns Hopkins and other sources to estimate infection risk, share of the population with some degree of immunity, and other metrics. You need to provide a name and email in order to access the tool.|
|Risk assessment||COVID-19 risk levels for kid-related activities||https://yourlocalepidemiologist.substack.com/p/navigating-kid-related-activities||6/13/21||This one isn’t a data source, per se, but I thought readers might find it helpful. A team of epidemiologists, immunologists, and public health scientists—including Katelyn Jetelina of Your Local Epidemiologist—compiled this detailed guide for families with unvaccinated children. The guide aims to help parents and families navigate their risk levels this summer.|
|Science of COVID-19||NIOSH-Approved N-19 Respirators||https://www.cdc.gov/niosh/npptl/topics/respirators/disp_part/N95list1-a.html||9/6/20||This 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-19||Dear Pandemic||https://dearpandemic.org/||9/20/20||This 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-19||FAQs on Protecting Yourself from COVID-19 Aerosol Transmission||https://docs.google.com/document/d/1fB5pysccOHvxphpTmCG_TGdytavMmc1cUumn8m0pwzo/preview?pru=AAABdRhBOUk*R0XLr1vCiGvAvCiNGQnBMA#||10/4/20||This 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-19||Search trends on COVID-19 symptoms||https://blog.google/technology/health/using-symptoms-search-trends-inform-covid-19-research||10/4/20||Researchers 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-19||SARS-CoV-2 and COVID-19 Data Hub||https://twitter.com/ErinSandersNP/status/1330360376010166275||11/22/20||Erin 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-19||6-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/fulltext||1/17/21||I 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-19||Global.health COVID-19 dataset||https://global.health/||1/17/21||Global.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.
|Science of COVID-19||COVID-19 Neuro Databank||https://med.nyu.edu/departments-institutes/population-health/divisions-sections-centers/biostatistics/research/nih-neurodatabank-neurobiobank||1/31/21||The 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-19||CoVariants||https://covariants.org/||2/21/21||This 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.
|Science of COVID-19||NIH COVID-19 treatment guidelines||https://www.covid19treatmentguidelines.nih.gov/||2/28/21||In 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-19||Coronavirus variant data from USA TODAY||https://github.com/USATODAY/covid-variants/||3/7/21||The 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-19||Helix COVID-19 Surveillance Dashboard||https://www.helix.com/pages/helix-covid-19-surveillance-dashboard||3/14/21||Helix, 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-19||Pfizer COVID-19 Clinical Trials||https://www.pfizer.com/science/find-a-trial/search/COVID-19||4/4/21||An 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-19||mRNA sequence for the Moderna vaccine||https://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.pdf||4/4/21||A 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.
|Science of COVID-19||Coronavirus variant lineages (PANGO)||https://cov-lineages.org/lineage_description_list.html||5/30/21||I came across this source a few days ago while researching variant lineages, prompted by a question on Twitter. Phylogenetic Assignment of Named Global Outbreak Lineages (or PANGO Lineages, for short) is a software tool developed by a lab in the U.K. that allows users to submit and analyze coronavirus sequences. The specific page I’ve linked here provides a comprehensive, searchable list of all the coronavirus variants that scientists have identified. Very useful if you need to search up an older or less-well-known variant.|
|Testing||COVID-19 testing sites||https://public.tableau.com/profile/kai.hallberg#!/vizhome/COVIDHotSpotTestSiteMap/COVIDHotSpotTestSiteMap?publish=yes||8/2/20||The 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/|
|Testing||CMS county-level testing dataset||https://data.cms.gov/stories/s/COVID-19-Nursing-Home-Data/bkwz-xpvg||9/13/20||In 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|
|Testing||FDA Emergency Use Authorizations (EUAs)||https://www.fda.gov/medical-devices/coronavirus-disease-2019-covid-19-emergency-use-authorizations-medical-devices/vitro-diagnostics-euas||10/18/20||The 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|
|Testing||Daily testing needs||https://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-224476882||11/1/20||A 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.|
|Testing||COVID-19 Testing Communications Toolkit||https://www.covidtestingtoolkit.org/||11/22/20||The 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.|
|Testing||COVID-19 Community Profile Reports||https://beta.healthdata.gov/National/COVID-19-Community-Profile-Report/gqxm-d9w9||12/20/20||For 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/|
|Vaccines||State COVID-19 vaccine plans||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/||11/22/20||A 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.
|Vaccines||CDC list of state immunization registries||https://www.cdc.gov/vaccines/programs/iis/contacts-locate-records.html||12/6/20||The 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.|
|Vaccines||Launch & Scale Speedometer: COVID-19 vaccine commitments||https://launchandscalefaster.org/COVID-19#Interactive%20tables%20and%20charts%20-%20COVID-19%20Vaccine%20Advance%20Market%20Commitments||12/6/20||For 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.|
|Vaccines||COVID-19 Vaccine Allocation Dashboard||https://public.tableau.com/profile/benjamin.renton#!/vizhome/COVID-19VaccineAllocationDashboard/Dashboard1||12/6/20||How 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.|
|Vaccines||Vaccine Allocation Planner for COVID-19||https://covid19vaccineallocation.org/||12/6/20||How 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.|
|Vaccines||Bloomberg's COVID-19 Vaccine Tracker||https://www.bloomberg.com/graphics/covid-vaccine-tracker-global-distribution/||12/20/20||Bloomberg 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.
|Vaccines||KFF COVID-19 Vaccine Monitor||https://www.kff.org/coronavirus-covid-19/report/kff-covid-19-vaccine-monitor-december-2020/||12/20/20||This 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.|
|Vaccines||State COVID-19 Vaccine Data Dashboard Plans||https://airtable.com/shr0q2XPwuxzVQ4Eh/tblsQt56W99TG4ebp||12/20/20||According 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.|
|Vaccines||CDC COVID Data Tracker: Vaccinations||https://covid.cdc.gov/covid-data-tracker/#vaccinations||12/27/20||Mere 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.|
|Vaccines||Our World in Data: COVID-19 Vaccinations||https://ourworldindata.org/covid-vaccinations||12/27/20||As 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.|
|Vaccines||The COVID-19 “Vaccination Line”: An Update on State Prioritization Plans||https://www.kff.org/coronavirus-covid-19/issue-brief/the-covid-19-vaccination-line-an-update-on-state-prioritization-plans/||1/17/21||The Kaiser Family Foundation has published an update on state vaccine prioritization plans, including both topline statistics and detailed annotations for each state.|
|Vaccines||COVID-19 Vaccine Communication Handbook||https://hackmd.io/@scibehC19vax/home||1/17/21||The 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.|
|Vaccines||Currently Reported COVID-19 Vaccine Metrics (by the COVID Tracking Project)||https://cvshealth.com/sites/default/files/cvs-health-covid-19-vaccination-data.pdf||1/17/21||Alice Goldfarb, Kara Schechtman, Charlotte Minsky, and other Project volunteers compiled detailed annotations on the vaccine metrics reported by each state.|
|Vaccines||CVS COVID-19 Vaccination Data||https://airtable.com/shralapyljNvZ48VS/tblBMblhXdMGuM2Ui||1/17/21||CVS 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.|
|Vaccines||US COVID-19 Vaccination Tracking||http://www.vaccinetracking.us/||1/24/21||This 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|
|Vaccines||COVAX Global Supply Forecast||https://www.gavi.org/sites/default/files/covid/covax/COVAX%20Supply%20Forecast.pdf||1/31/21||Another 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.|
|Vaccines||Subnational COVID-19 vaccination data||https://github.com/sociepy/covid19-vaccination-subnational||2/14/21||Barcelona-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.|
|Vaccines||The 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/21||The 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.|
|Vaccines||First Month of COVID-19 Vaccine Safety Monitoring (CDC MMWR)||https://www.cdc.gov/mmwr/volumes/70/wr/mm7008e3.htm?s_cid=mm7008e3_w||2/21/21||This 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.|
|Vaccines||VaccineFinder||https://vaccinefinder.org/||2/28/21||As 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.
|Vaccines||VaccinateCA API||https://docs.vaccinateca.com/reference||3/7/21||California 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.|
|Vaccines||AHCJ resource on COVID-19 vaccine results||https://healthjournalism.org/blog/2021/04/new-data-resource-lists-research-on-infection-prevention-from-covid-19-vaccines/||5/2/21||The Association for Health Care Journalists has added a section to its Medical Studies repository for studies on how well COVID-19 vaccines protect against infection. Tara Haelle, AHCJ’s medical core topic leader, compiled the studies; “The list is not necessarily exhaustive, but it includes the studies I was able to track down so far,” she writes in a blog post about this update.|
|Vaccines||Vaccine consent laws by state||https://www.vaxteen.org/consent-laws-by-state||5/23/21||As the Pfizer vaccine is now available to children ages 12 to 15, a lot of teenagers out there may want to know if they can get vaccinated without parental permission. The site VaxTeen provides these kids with information on the consent laws in every state, as well as a guide for talking to your parents about vaccines and other resources.|
|Vaccines||COVID-19 Vaccine Rollout across US Congressional Districts||https://geographicinsights.iq.harvard.edu/vaccineuscongress||6/13/21||This dashboard, from the Harvard Center for Population and Development Studies, breaks down the U.S. vaccine rollout by a geography I haven’t yet seen: Congressional districts. The interactive maps highlight the partisan nature of this vaccine rollout—as POLITICO reporters pointed out in an article citing the tracker, “All but one of the 39 congressional districts where at least 60 percent of residents have received a coronavirus shot are represented by Democrats.”
|Vaccines||COVID-19 Vaccine Incentives||https://www.vaccines.gov/incentives.html||6/6/21||So many companies are now offering rewards to inspire vaccinations in their customers and employees, it might be hard to keep track. Luckily, the federal government is keeping track for you; this page on Vaccines.gov provides a comprehensive list. (I am particularly excited about the United Airlines “Your Shot to Fly” Sweepstakes.)|
|Vaccines||Community health center vaccinations (from KFF)||https://www.kff.org/coronavirus-covid-19/issue-brief/are-health-centers-facilitating-equitable-access-to-covid-19-vaccinations-a-june-2021-update/||6/6/21||A new brief from the Kaiser Family Foundation demonstrates the value of community health centers in vaccinating vulnerable populations. From January through May, people of color made up nearly two-thirds of those receiving their first doses at these centers, KFF reports.|
|Vulnerable communities||Lost on the frontline||https://www.theguardian.com/us-news/ng-interactive/2020/aug/11/lost-on-the-frontline-covid-19-coronavirus-us-healthcare-workers-deaths-database||8/16/20||This 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.
|Vulnerable communities||The Long-Term Care COVID Tracker, by the COVID Tracking Project||https://covidtracking.com/data/longtermcare||8/16/20||Residents 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 communities||COVID-19 in ICE detention centers||https://github.com/vera-institute/ice-detention-covid||11/1/20||Since 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 communities||CDC's Social Vulnerability Index||https://www.atsdr.cdc.gov/placeandhealth/svi/data_documentation_download.html||11/29/20||Social 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 communities||COVID-19 Community Vulnerability Index||https://precisionforcovid.org/ccvi||11/29/20||In 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 communities||COVID-19 survey of Medicare beneficiaries||https://www.cms.gov/research-statistics-data-systems/mcbs-public-use-file/medicare-current-beneficiary-survey-fall-2020-covid-19-data-snapshot||1/17/21||This 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 communities||Anti-Asian Hate Incidents||https://secureservercdn.net/184.108.40.206/a1w.90d.myftpupload.com/wp-content/uploads/2021/02/Press-Statement-re_-Bay-Area-Elderly-Incidents-2.9.2021-1.pdf||2/14/21||Stop 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 communities||COVID-19’s impact on LGBTQ+ communities||https://journalistsresource.org/home/covid-19-lgbtq-research/||2/28/21||The 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 communities||COVID-19 related deaths by occupation, England and Wales||https://www.ons.gov.uk/peoplepopulationandcommunity/healthandsocialcare/causesofdeath/bulletins/coronaviruscovid19relateddeathsbyoccupationenglandandwales/deathsregisteredbetween9marchand28december2020||3/14/21||The 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 communities||The Impact of the COVID-19 Pandemic on LGBT People||https://www.kff.org/coronavirus-covid-19/poll-finding/the-impact-of-the-covid-19-pandemic-on-lgbt-people/||3/14/21||This 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 communities||Data Reporting & Quality Scorecard from the UCLA Law COVID-19 Behind Bars Data Project||https://uclacovidbehindbars.org/blog/scorecard||3/21/21||The 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 communities||Counties 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_w||3/28/21||The 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 communities||Food Insecurity in the United States||http://map.feedingamerica.org/||4/11/21||Nonprofit 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.|
|Vulnerable communities||NYT Prisons and Jails COVID-19 counts||https://github.com/nytimes/covid-19-data/blob/master/prisons/facilities.csv||4/25/21||This week, the New York Times published data from the newsroom’s effort tracking COVID-19 cases and deaths in U.S. prisons and jails. The data include both inmates and correctional officers, covering over 2,800 facilities. You can read more about the dataset in this Twitter thread:
|Vulnerable communities||Health Equity Tracker||https://healthequitytracker.org/exploredata||5/30/21||When the COVID Tracking Project (including the COVID Racial Data Tracker) ceased data collection in March, it became much more difficult to compare COVID-19 case counts by race and ethnicity across states. A new project from the Morehouse School of Medicine fills that gap—and does much more. The Tracker incorporates data from the CDC, the Census, and other sources to provide comprehensive information on which communities have been hardest hit by the COVID-19 pandemic. Read more about it in this STAT article: https://www.statnews.com/2021/05/26/health-equity-tracker-disparities-data-covid19/|
|Vulnerable communities||Health Equity Data (from the CDC)||https://covid.cdc.gov/covid-data-tracker/#health-equity-data||6/6/21||The CDC has reorganized its COVID Data Tracker to include a new dashboard section specifically focused on health equity. The section includes demographic trends for cases, deaths, and vaccinations, with breakdowns for race and ethnicity, urban/rural status, disabilities, incarcerated people, 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.