View in EDS

COVID vaccine data quality, cleaning, and management.

Saved in:
Bibliographic Details
Title: COVID vaccine data quality, cleaning, and management.
Authors: Ayres, Kelly1 (AUTHOR), Zhao, Longwen1 (AUTHOR), Megahed, Fadel M.2 (AUTHOR), Jones-Farmer, L. Allison2 (AUTHOR), Burroughs, Thomas E.3 (AUTHOR), Rigdon, Steven E.1 (AUTHOR) steve.rigdon@slu.edu
Source: Quality Engineering. 2026, Vol. 38 Issue 1, p72-86. 15p.
Subjects: Data quality, Data management, COVID-19, Database design, Vaccination status, Vaccine safety, Data scrubbing
Abstract: When COVID-19 vaccines were introduced in late 2020 and widely distributed in early 2021, states were responsible for collecting and managing the data. In the best situation, states kept accurate records of each person who received the vaccine, including the age and the county of residence. States reported the cumulative number of those vaccinated in each county, although there were substantial numbers of vaccine recipients (within a given state) whose county of residence was unknown. Some states have very low numbers of vaccine recipients with unknown county, while other states reported upwards of 50% "unknown county of residence." At the extreme, Texas did not report the county of residence until October 2021, although they did report the state-wide total. There were a number of states that reported a nearly simultaneous jump in the cumulative number of those vaccinated whose county of residence was known and a drop in the number of "unknowns," likely caused by a retrospective analysis and reallocation of those whose county of residence was unknown. A further problem occurs when the cumulative number of vaccines drops. We describe how we created a database for county-level vaccine data that addresses these data quality issues. [ABSTRACT FROM AUTHOR]
Copyright of Quality Engineering is the property of Taylor & Francis Ltd and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Database: Engineering Source
Description
Abstract:When COVID-19 vaccines were introduced in late 2020 and widely distributed in early 2021, states were responsible for collecting and managing the data. In the best situation, states kept accurate records of each person who received the vaccine, including the age and the county of residence. States reported the cumulative number of those vaccinated in each county, although there were substantial numbers of vaccine recipients (within a given state) whose county of residence was unknown. Some states have very low numbers of vaccine recipients with unknown county, while other states reported upwards of 50% "unknown county of residence." At the extreme, Texas did not report the county of residence until October 2021, although they did report the state-wide total. There were a number of states that reported a nearly simultaneous jump in the cumulative number of those vaccinated whose county of residence was known and a drop in the number of "unknowns," likely caused by a retrospective analysis and reallocation of those whose county of residence was unknown. A further problem occurs when the cumulative number of vaccines drops. We describe how we created a database for county-level vaccine data that addresses these data quality issues. [ABSTRACT FROM AUTHOR]
ISSN:08982112
DOI:10.1080/08982112.2025.2567562