![MathJax Logo](/templates/jsp/_style2/_tandf/pb2/images/math-jax.gif)
ABSTRACT
COVID-19 surveillance across the United States is essential to tracking and mitigating the pandemic, but data representing cases and deaths may be impacted by attribute, spatial, and temporal uncertainties. COVID-19 case and death data are essential to understanding the pandemic and serve as key inputs for prediction models that inform policy-decisions; consistent information across datasets is critical to ensuring coherent findings. We implement an exploratory data analytic approach to characterize, synthesize, and visualize spatial-temporal dimensions of uncertainty across commonly used datasets for case and death metrics (Johns Hopkins University, the New York Times, USAFacts, and 1Point3Acres). We scrutinize data consistency to assess where and when disagreements occur, potentially indicating underlying uncertainty. We observe differences in cumulative case and death rates to highlight discrepancies and identify spatial patterns. Data are assessed using pairwise agreement (Cohen’s kappa) and agreement across all datasets (Fleiss’ kappa) to summarize changes over time. Findings suggest highest agreements between CDC, JHU, and NYT datasets. We find nine discrete type-components of information uncertainty for COVID-19 datasets reflecting various complex processes. Understanding processes and indicators of uncertainty in COVID-19 data reporting is especially relevant to public health professionals and policymakers to accurately understand and communicate information about the pandemic.
Introduction
As Boggs (Citation1949) wrote in his call for an “Atlas of Ignorance” in 1949; “[i]n using well-made maps there is often a delusion of adequacy and completeness.” Uncertainty in geographic information science is a complex topic, as it impacts both spatial information and the production of knowledge (Couclelis, Citation2003) as well as geographic definitions, the explanation of geographic phenomena, the complexity of spatial systems, geosimulation, the representation of spatial knowledge, subjectivity in spatial phenomena, and planning (Fusco et al., Citation2017). Multiple frameworks have emerged to frame or categorize dimensions of uncertainty in this respect (Buttenfield, Citation1993; Gahegan & Ehlers, Citation2000; Thomson et al., Citation2005) and highlight key challenges in visualizing uncertainty for decision making and analysis (see review by MacEachren, Citation2015; MacEachren et al., Citation2005). While much focus has been placed on the technical aspects of uncertainty (i.e. data quality or validity; visual techniques of communicating uncertainty), scholars have also emphasized that the unknown and uncertain aspects of data-generating processes are central to forging our knowledge of any given phenomenon. With the COVID-19 pandemic of 2020, uncertainty in information and knowledge proved critical not just to understanding the transmission processes of this novel virus, but also the public health management and epidemiological evaluation of COVID-19 at multiple scales. Spatial data were central to these efforts, fueling thousands of decision-making dashboards and modeling efforts. The existing research on COVID-19 is a conglomeration of different pandemic models and maps which both rely on different surveillance data as well as different methodological assumptions.
From the start of the pandemic through December 2020, the Centers for Disease Control and Prevention (CDC) only provided state-level data for the number of COVID-19 cases and associated deaths across the United States (CDC, Citation2020a). Because most states in the US are geographically vast with wide population variations and nuanced epidemiological landscapes, finer resolution data are essential. After March 2020, datasets containing national county-level COVID-19 case and death counts aggregated from jurisdictional public health authorities and media reports emerged from multiple third party organizations including 1Point3Acres; New York Times; Johns Hopkins University, and USAFacts. In this context, multiple organizations, both formal and informal groups, surveyed the local pandemic by reporting county-level COVID-19 cases and deaths on a daily basis. In addition to USAFacts, volunteers of 1Point3Acres launched a crowdsourced data project in which they collect and disseminate county-level COVID-19 data. The New York Times assumed a major role in monitoring the spread of this pandemic, providing daily updates on COVID-19 cases and deaths at the county-level. Combining data from these sources and beyond, a group from Johns Hopkins University also released a county-scale daily report on COVID-19 cases and deaths. Importantly, each organization has applied varied data collection and processing methodologies, resulting in inconsistencies in the daily case and death numbers associated with COVID-19. The CDC would later refer readers to USAFacts to learn more about their data collection strategies and methodological decisions (CDC, Citation2020b), but also recognized that discrepancies exist between national, state-, county,- and city-level data pertaining to COVID-19 and encouraged readers to refer to local sources in cases of any discrepancy.
There was no single, institutional and thereby authoritative source of COVID-19 data until December 2020, when the CDC began to post daily data and enable historical access to records. Meanwhile, the modeling, mapping, and evaluation of COVID-19 persisted using a variety of data available. Given the varying nature of these datasets, epidemiologists, public health officials, and other analysts creating pandemic analyses, predictions, and surveillance programs face the dilemma of which source to choose for visual, analytical, and prescriptive pandemic models. Unsurprisingly, researchers rely on different datasets, and most do not provide clear justification for these decisions or an explanation for how these decisions may influence their analytical results. Although the current lack of thorough discussion on datasets and their implications is understandable given rapidly changing data and time sensitivity of such analyses, this shortage of analysis on datasets does raise questions about the consistency among these various predictions regarding COVID-19 cases and deaths.
Several research groups noticed the discrepancies in data between different datasets. One ongoing project considers differences of daily total U. S. cases and deaths reported by the four sources, namely New York Times, Johns Hopkins University, USAFacts, and COVID Tracking Project at The Atlantic, finding that although there are very strong correlations between data reported by different organizations, discrepancies exist (Smith, Citation2020). Notably the New York Times has been consistently reporting more cases and more deaths compared with other three since March 2020, and the reasons behind this requires further investigations. Wang et al. (Citation2020) compared the same four major datasets and observed a 7-day cyclical pattern at the state level in both cases and deaths reporting. This finding was integrated into the anomaly detection and repairing package the group developed. Yet, these approaches do not make the uncertainty of COVID-19 data explicit, or take into account spatial or temporal aspects of the data as a fundamental aspect of uncertainty – not only in COVID-19 spatial information, but also our understanding of the data generating processes that produce it.
When considering how uncertainty could be addressed, Tobler’s First Law of Geography (that near things are more similar than distal things) may be applicable and useful as a systematic, fundamental approach. Errors tend to have strong, positive autocorrelation in reality, and the discrepancies we observe tend to highlight state boundaries and result from statewide reporting practice differences. Thus, when considering multiple COVID-19 datasets, it is critical to examine not just similarity between datasets as a whole, but also where and when the similarities or differences persist. The datasets involved share aspects of provenance – county level health departments are critical data providers but errors are shared across datasets, and statewide discrepancies related to testing and reporting practices persist. Thus, the uncertainty errors for COVID-19 data reflect both spatial and temporal autocorrelation attributes, and the datasets observed interrelate in their propagation of these errors as datasets reference each other in an effort to construct more comprehensive data. MacEachren et al. (Citation2005) highlight these dimensions as the attribute, positional, and temporal categories of uncertainty, with most uncertainty research only considering the first and occasionally second components (Kinkeldey et al., Citation2014). Our research aims to operationalize these dimensions and identify spatio-temporal uncertainty in the included COVID-19 data. We define uncertainty as a complex concept with attribute, spatial, and temporal dimensions that generate a lack of certainty over information. Rather than determine data accuracy, which is not possible with current publicly available COVID data, we are most interested in discrepancy and disagreement between study datasets. We offer concrete methods for researchers and analysts to identify dimensions of uncertainty across a range of possible applications, and propose solutions to better contextualize COVID data in light of this uncertainty.
Methods
To detangle some aspects of uncertainty in the spatial information and data generating processes producing spatial data, we take an Exploratory Spatial Data Analysis approach to investigate attribute, spatial, and temporal discrepancies among county-level datasets of COVID-19. To isolate the varied dimensions of uncertainty, we begin by assessing spatial variation in cumulative case and death rate differences across dataset pairs. Next, we explore the county-level agreement of datasets through the course of the pandemic by utilizing Cohen’s kappa and Fleiss’ kappa classifier agreement statistics. Finally, we plot the changes in dataset agreement over time to highlight which conditions of the pandemic may have created data conditions for higher or lower agreement. We conclude by providing recommendations for researchers and public health officials on best practices in interpretation of COVID-19 related research.
Our study evaluates the agreement and differences between five major COVID-19 case and death datasets: CDC (Citation2020b); USAFacts (USAF) (US COVID-19 Cases and Deaths by State, Citation2021); 1Point3Acres (1P3A) (1Point3Acres COVID 19 Data, Citation2021); New York Times (NYT) (“New York Times COVID 19 Data,” Citation2021); and Johns Hopkins University (JHU) (Dong et al., Citation2020). These datasets are widely utilized across academic, professional, and technology practices. JHU’s Lancet article, the official citation for the dataset, has over 4500 citations at time of writing (Google, Citation2021) and numerous geospatial and temporal analyses utilize these datasets for analysis in the US context (Desjardins et al., Citation2020; Hohl et al., Citation2020; Paul et al., Citation2020) and globally (Martines et al., Citation2021). Google Maps includes NYT, JHU, and additional datasets as an available map overlay (Navigate Safely with New COVID Data in Google Maps, Citation2020).
While no final, canonical dataset has been established for data regarding the COVID-19 pandemic in the United States, we assume the CDC data to be reasonably authoritative. When the COVID Tracking Project, a popular aggregator, ceased new data collection in March of 2021, it directed users to the CDC’s resources for case and death data (Gilmour, Citation2021), further suggesting the CDC’s data resources are becoming a tentative standard. We use CDC data as the reference dataset against which the remaining “third party” datasets will be compared. USAFacts, NYT, and JHU were obtained from open source and open data repositories, CDC data was queried from the public CDC Covid Data Tracker website data endpoint API, and 1P3A data was provided through a closed-access API. Data access URLs are available in Appendix A.
Each of these data are reported at both state and county level. Datasets included have certain geography modifications: NYT, JHU, and 1P3A data aggregate New York City area counties (eg. Kings, Queens, etc.) as a single area; in 1P3A and JHU data in Utah are reported with non-county geographies; Puerto Rico and outlying territories are not consistently included; and certain areas of Alaska are not included in NYT data. All datasets have been modified to aggregate NYC counties, and only geographies present in all datasets are included in this study (n = 3105); Puerto Rico, Utah, and certain areas of Alaska have been excluded for reporting consistency. Data from the CDC, NYT, JHU, and USAFacts start time-series reporting on January 22nd, 2020, and 1P3A reports time-series starting on January 21, 2020. At time of writing, all datasets are updated daily with new data. Very early data present issues of missing data (e.g. many counties possess null values, days missing from time-series, etc.) and are highly sensitive data due to low counts of observed cases and deaths (a small numbers problem).
Exploratory data analysis
An initial exploratory data analysis was conducted on the available data for four pairwise comparisons between CDC and each of JHU, NYT, USAFacts, and 1P3A data. For this preliminary analysis, we explored the percentage differences between daily 7-day rolling averages of new cases between third party datasets and CDC data as a baseline to identify potential patterns. The percentage difference is calculated as:
where is the percent difference between the CDC and a third party rolling average for a particular day in a particular county, D is the CDC nationwide daily 7-day rolling average, and D’ is the third party nationwide daily 7-day rolling average. compares the percent differences for available data.
Beyond initial data scarcity through mid-March 2020, dataset differences appear to arrive in surges and present larger differences starting around November 2020. 1P3A and USAFacts appear to contain more frequent positive and negative surges, although NYT also shows variations. Johns Hopkins University data, after stabilizing in March/April 2020, appears to have relatively fewer deviations from the CDC data baseline. At some points in time, datasets in appear to experience similar temporal variations from CDC data taken as a baseline (e.g. in November 2020 three datasets report lower figures than CDC). transforms the data to absolute values of difference, rather than signed differences, and calculates the mean of percent differences for the four datasets, calculated as:
Figure 2. Heatmap of mean absolute percent difference of daily 7-day rolling averages compared to CDC data and by-county, by-day differences.
![Figure 2. Heatmap of mean absolute percent difference of daily 7-day rolling averages compared to CDC data and by-county, by-day differences.](/cms/asset/2e759169-64b6-409c-a841-a22ab1bb9808/tcag_a_1975311_f0002_c.jpg)
’s heatmap visualizes the number of counties on each day by mean absolute percent difference from CDC rounded to the nearest ¼ of a percent, and log-scaled colored based on the number of counties in that range.
highlights the complexity in diagnosing and summarizing differences in geospatial time-series data across multiple datasets. Many counties appear in the lowest 10–15% of difference toward the bottom of the graph. Horizontal stripes represent repeated different intervals of case reporting likely due in part to a combination of small numbers problems and rounding errors. For instance, CDC data rounds to the nearest tens place decimal for 7-day case averages, so a 1 case increase in other data represents a~43% difference: CDC would report 0.1 as the 7-day case average vs 0.142857 … from all others. This preliminary analysis highlights concerns with using percentage based comparisons where small number problems and rounding issues may produce ostensibly larger differences and the need to utilize statistics that better summarize consistency across multiple datasets. Despite these artifacts in the data, we can observe apparent increases in absolute percent difference from November 2020 through January 2021 that suggest the “stable” period of data collection still faced many issues. For simplicity and to focus our assessment on the relatively stable periods of pandemic data collection, our study examines data between March 8th, 2020 through April 15th, 2021, providing a range of daily 7-day averages from March 15, 2020 to April 15, 2021. The following sections outline our data processing and approach to comparison methods.
Data preprocessing
CDC data are provided as daily 7-day rolling averages. For example, the 7-day rolling average reported on 4/15/2021 is the sum of cases reported from 4/9/2021 to 4/15/2021 inclusive divided by seven. Each new day of data shifts the start and end dates by one day. All third party data were prepared into time-series tables with rows representing the 3105 US counties included in this study and columns cumulative cases and deaths for dates from March 8, 2020 through April 15, 2021; this date range provides coverage for CDC reporting windows of daily 7-day rolling averages March 15, 2020 to April 15, 2021. Data, pre-processed into time-series tables, were accessed through the US Covid Atlas’ github repository (Li et al., Citation2020). 1P3A data were accumulated from daily new values into cumulative sums. Separate tables were generated for COVID-19 cases and reported COVID-19 deaths. For all third party datasets, daily 7-day rolling averages of new cases and deaths were calculated from the cumulative. The sums of these daily 7-day rolling averages for the 3105 counties included in this analysis for each dataset are presented in . As CDC data are only available as averages and not integral, rounding or edge errors may occur, and so the averaging process is replicated across all study datasets.
Table 1. Cumulative sums of daily 7-day rolling averages and raw cumulative values from 3/15/2020 to 4/15/2021 for selected US counties (N = 3105).
Comparison methods
To better understand the differences between the five selected datasets, this study compares: (1) differences in cumulative case and death rates normalized to county population; (2) time-series agreement of pairwise data and all datasets together for daily rolling averages of new cases and new deaths; and (3) county-level agreement of weekly rolling averages of new cases and new deaths. Respectively, these methods aim to explore spatial heterogeneity in reporting discrepancies across datasets, elucidate dataset-wide changes in agreement over time, and identify spatial patterns in county-specific data agreement.
To synthesize the differences between these datasets into a more legible metric, agreement between dataset pairs is calculated using a kappa coefficient (Cohen, Citation1960), which is a measure often used in social sciences to evaluate agreement between two classifiers. In short, Cohen’s kappa helps to highlight the difference in agreement between two classifiers based on how much agreement we would expect to see, contrasted with what agreement is observed. Cohen’s kappa is calculated as follows:
where represents the agreement between two classifiers,
represents the observed agreement between the two classifiers, and
represents the expected agreement between the two classifiers if they were to assign values at random given their observed distribution. Our programmatic implementation of Cohen’s kappa utilizes the Python package ScienceKit Learn’s Metrics Classification Module (Scikit-Learn/Scikit-Learn, Citation2011). In our application of Cohen’s kappa, we use this measure to compare the daily 7-day rolling averages of new cases and new deaths normalized to the county population. This measure focuses on the state of the pandemic at each daily snapshot, smoothed only as much as needed for data integrity. Calculating Cohen’s kappa relies on classification of data into categories or bins to assess agreement. To do this, we calculate decile bins based on CDC case and death rates for each day included in the study, then classify all dataset values based on those bins. We can then evaluate agreement between each dataset pairs and across all datasets using these decile bin classifications. As we assume the CDC dataset to be the authoritative one, we used the CDC dataset as the reference group in our comparison.
To evaluate the five datasets together, we employ Fleiss’ kappa (Fleiss, Citation1971), which allows for multiple classifiers to be evaluated simultaneously. Similar to Cohen’s kappa, this measure estimates a coefficient that reflects how much agreement is observed between classifiers contrasted with the expected classification agreement. Fleiss’ kappa is calculated as:
where is the agreement between all classifiers,
is the observed agreement across all classifiers, and
is the expected agreement of classification if all classifiers chose randomly, based on their distribution of assigned classifications. Our implementation of Fleiss’ kappa utilizes statsmodels’ inter rater module implementation (Appendix F).
While these two statistics provide a concise metric for evaluating agreement, they are not without limitations. As any binning methodology uses thresholds to categorize data, there is a limitation in this methodology as counties on the edge between bins may be sensitive to small fluctuations in changes. Additionally, kappa statistics are applied to categorical variables; consequently, a bin mismatch of bins 1 and 10 would be viewed the same as a disagreement of 5 and 6, for example. To account for this potential shortcoming, Appendix D demonstrates the same measures but using an average Euclidean distance between binning categories for both time series and spatial variations.
Once classified into decile bins, the agreement between the five datasets on each day were calculated. Since the direction of comparison (e.g. CDC – NYT vs NYT – CDC) produces the same output, 10 unique pairwise comparisons are generated for each day. The median values over time suggest how closely these datasets tended to agree during the course of the pandemic. Additionally, to identify potential spatial heterogeneity in agreement, we calculated Fleiss’ kappa for each county across the time-series data available. As with the first agreement analysis, we classified values from all datasets based on equal count decile breaks generated from CDC data. Then, each county’s decile bins over time were compared using Fleiss’ kappa for the duration of the study date range, 3/15/2020 to 4/15/2021.
Comparing how the datasets agreed over time for each county highlights where datasets consistently classified the intensity of the pandemic. Initial exploration also examined kappa values for total counts rather than per population rates; however, because total count decile bins tended to be much broader, agreement was less sensitive to changes and certain geographies remained in the same bin for the duration of the study dates. For instance, many cities sat in the top decile for the duration of the pandemic, as their total counts were always much higher. CDC data are also distributed as per 100,000 population rates, and so we will use this metric for analysis.
Sensitivity analysis
We explored two dimensions in our sensitivity analysis to validate data methods. To evaluate how sensitive the results are to classification needed for kappa coefficients, we examined the data using Pearson’s correlation and Spearman’s correlation coefficients, comparing the results generated against the Fleiss’ kappa agreement methodologies. Specifically, we compared spatial and temporal trends for basic pairwise Pearson’s correlation and Spearman’s correlation coefficient of daily snapshot and county time-series data. While these statistics cannot compare the five datasets simultaneously, the pairwise comparisons can be compared over time, and an average of correlations mapped to illustrate spatial heterogeneity. The temporal and spatial variation observed in visual analysis of the figures and maps was sufficiently similar to proceed with methods utilizing Cohen’s kappa and Fleiss’ kappa as described above; further results from this sensitivity analysis are available in Appendix B.
Additionally, daily 7-day and 14-day rolling averages were computed and compared to the 7-day averages to observe if significant differences emerged between datasets given a larger reporting window. As a larger window of data is included for a daily average, fidelity and detail to emerging trends may be smoothed and lost, and our findings from this analysis suggest minimal differences in agreement between daily 7-day and 14-day averages of new cases. Further results from these findings are available in Appendix C.
Results
Cumulative cases and deaths reported
The first analysis compares pairwise results between datasets for cumulative COVID-19 case and death rates reported. shows the cumulative COVID-19 case rate as a sum of daily 7-day rolling averages per 100,000 people in each county. Maps in these matrix figures use a diverging color scale to identify spatial variation in where different datasets report higher or lower rates. In this scale, green represents the target (x-axis) dataset reporting higher rates whereas purple represents the source (y-axis) dataset reporting higher rates. Lighter colors symbolize smaller differences, and gray colored counties indicate areas within ±1 case or death per 100,000 people, accounting for small variations due to rolling average calculation.
Figure 3. Matrix of cumulative case differences, calculated as the sum of daily 7-day rolling averages of new cases from 3/15/2020 to 4/15/2021. The color bins for these maps are fixed across the maps and approximate quintile breaks in either diverging direction. Geographic boundaries used are a modified version of Topojson’s US Atlas county boundaries (Topojson, Citation2021).
![Figure 3. Matrix of cumulative case differences, calculated as the sum of daily 7-day rolling averages of new cases from 3/15/2020 to 4/15/2021. The color bins for these maps are fixed across the maps and approximate quintile breaks in either diverging direction. Geographic boundaries used are a modified version of Topojson’s US Atlas county boundaries (Topojson, Citation2021).](/cms/asset/cbff97ad-70b4-407d-8432-ecc0eccb76d0/tcag_a_1975311_f0003_c.jpg)
A few consistent patterns across datasets become apparent when examining rows and columns together: CDC appears to report higher numbers in South Carolina and Alabama; 1P3A appears to report higher numbers in Wisconsin, Missouri, and New Jersey than other datasets, but reports lower rates in Iowa; USAFacts reports lower rates in Georgia than other datasets. Between the third party datasets, many states appear in gray, suggesting consistent cumulative case rates for the period observed. For each pairwise comparison, with the exception of the JHU-NYT data pair, state-wide differences stand out in the most extreme bins (more/less than ±150), suggesting that data from those entire states are treated differently by different datasets. Of the comparisons with CDC data, JHU and NYT data appear to have the fewest obvious state-wide differences, with CDC reporting higher numbers in Alabama and South Carolina and JHU and NYT data both reporting higher cases in New Jersey. This apparent agreement will be observed as well in the kappa coefficients used below, and time-series analysis will suggest that these three datasets have, over time, converged to express the closest agreement and smallest discrepancies of the five datasets explored in this analysis.
While CDC data comparisons also highlight state-wide differences, we also observe less stark and more spatially heterogeneous patterns, particularly in a vertical band from the western side of Texas, continuing north through Kansas, Nebraska, and the Dakotas (). Counties in this particular region appear to have case numbers both above and below CDC estimates, often in close geographic proximity. One possible explanation for these discrepancies is an error in reporting based on county of residence vs county of occurrence, where cases may be attributed to the county where the case was detected, rather than the home county of the patient. This may possibly manifest on the map as some counties with better testing resources reporting more cases and less-resourced counties “sending” cases to them, but further research on testing infrastructures in this region is needed to confirm this possible explanation. Provisional CDC and National Center for Health Statistics (NCHS) datasets begin to disambiguate county of residence and occurrence data (National Center for Health Statistics [NCHS], Citation2021b, Citation2021a); however, not all sources clearly define this characteristic of the data.
Figure 4. Spatial variation observed across all third party datasets comparisons with CDC data, consistently appearing across counties in a north-south band between Texas and the Dakotas.
![Figure 4. Spatial variation observed across all third party datasets comparisons with CDC data, consistently appearing across counties in a north-south band between Texas and the Dakotas.](/cms/asset/eb442a31-2936-4396-9c04-f2e51b0b91de/tcag_a_1975311_f0004_c.jpg)
illustrates the cumulative COVID-19 deaths as a sum of daily 7-day rolling averages per 100,000 people in each county using the same method as for cases in . The spatial variation observed in these maps suggest some similarities in the patterns of differences for COVID-19 deaths as we observe in cases between CDC and third party datasets: CDC data have broad, heterogeneous discrepancies between third party datasets across a majority of the country where third party data tend to generally agree with notable state-level differences and the same vertical band from Western Texas through Dakotas emerges as a region of data uncertainty. Visual analysis by columns and rows suggests additional patterns: third party datasets report higher death rates in most of Ohio than reported in CDC data; 1P3A data are lower than other datasets in Wyoming; NYT reports lower deaths rates in most of Kansas than others.
Figure 5. Matrix of cumulative death differences, calculated as the sum of daily 7-day rolling averages of new deaths from 3/15/2020 to 4/15/2021.
![Figure 5. Matrix of cumulative death differences, calculated as the sum of daily 7-day rolling averages of new deaths from 3/15/2020 to 4/15/2021.](/cms/asset/ec36d216-5855-4c15-a044-b49e084adeb0/tcag_a_1975311_f0005_c.jpg)
In the first column comparing differences to CDC data, a large portion of the map suggests that CDC data reports fewer deaths than the third party datasets. This is summarized in the death rates to date shown in , where all third party datasets report roughly 15,000 deaths more than CDC data; for comparison, the third party datasets analysis have a range of roughly 8600 difference between the highest and lowest estimates. Additionally, none of these estimates consider excess deaths, which may have estimates far greater than the figures reported here; provisional data are emerging (NCHS, Citation2021c, Citation2021d).
To synthesize these geographic findings into a single metric and compare agreement across the five datasets included, in the next section we will analyze dataset agreement using Cohen’s kappa and Fleiss’ kappa statistics as described in the methods section.
Dataset agreement
We measure data agreement using kappa coefficients to compare decile bin classifications of counties for each daily 7-day rolling average rate of new cases and deaths. For each day of available data, a matrix of kappa coefficients comparing each of the five datasets was generated alongside a Fleiss’ kappa to reflect agreement of all datasets on that day. By assessing each daily rolling average as a snapshot, we can explore time-series agreement and then summarize the minimum, maximum, and median days of agreement. Additionally, by extracting decile binnings for the five datasets for a single county, we can assess how closely the time-series data for a specific county have been in agreement and analyze spatial variation. Kappa statistics range from −1 (perfect disagreement) to +1 (perfect agreement) and can generally be interpreted as evaluating slight agreement with scores from 0 to 0.2, fair agreement from 0.2 to 0.4, moderate from 0.4 to 0.6, substantial agreement from 0.6 to 0.8, and almost perfect agreement above 0.8–1. (Landis & Koch, Citation1977). To summarize Cohen's kappa agreements, present the minimum, maximum, and median values of dataset agreement across all days observed.
Table 2. Case data agreement matrix of minimum, median, and maximum daily values of pairwise data comparisons for daily 7-day rolling averages from 3/15/2020 to 4/15/2021.
Table 3. Death data agreement matrix of minimum, median, and maximum daily values of pairwise data comparisons for daily 7-day rolling averages from 3/15/2020 to 4/15/2021.
Overall, agreement on decile binning is generally quite high, with the Fleiss’ kappa agreement across all datasets ranging from .751 cases/.784 deaths to .908 cases/.923 deaths, and a median of .861 cases/.877 deaths. This means that each daily kappa agreement remained at or above a substantial level of agreement, with a median day of data observed well within the almost perfect category. Pairwise agreements never dropped below a 0.6 Cohen’s kappa value, again suggesting that agreement was always at least substantial.
For agreement on case data, we observe the highest levels of kappa values between NYT/JHU datasets (min .776/median .914/max .969) and JHU/CDC datasets (.713/.893/.953). Agreements between NYT/USAFacts and JHU/USAFacts are also high, in addition to 1P3A/JHU. Median agreement between CDC and USAFacts (.819), NYT (.835), and 1P3A (.822) are among the lowest median kappa values observed; USAFacts has the lowest minimum bounds across all database agreements, ranging from .608 (CDC) to .655 (JHU). Overall, these agreements are quite high, and the lowest bounds still remain in the substantial category of agreement. More detailed box plots matrices for case and death Cohen’s kappa agreements are available in Appendix E.
Agreement on death data is similar, and pairwise Cohen’s kappa values are generally the same or higher with a few exceptions. As compared to case data agreement, CDC data pairs with JHU, NYT, and 1P3A data are lower, but slightly higher with USAFacts. The agreement on death data between the third part datasets is higher across minimum, maximum, and median relationships in most cases. Aside from the perfect agreement (kappa value of 1) achieved between CDC and USAFacts early in the observed data, the highest observed median agreement is between USAFacts and NYT (.924), followed by NYT/JHU (.912) and NYT/1P3A (.910). As with case data, overall agreement remains high, and even the lower bounds between CDC and third party datasets still represent substantial agreement.
Agreement over time
present findings from the time-series Cohen’s kappa and Fleiss’ kappa coefficients for cases and deaths, respectively. While certain pairwise agreements appear to increase over time, surprisingly, agreements between datasets for the most part did not improve over time. Starting in June and progressing over the remainder of 2020 into early 2021, we observe Fleiss’ kappa agreement declining between datasets, falling below a threshold of 0.8 from almost perfect agreement to substantial agreement. A large dip in agreement during mid-November 2020 may reflect the massive surge in cases across the United States in the upper Midwest. With the exception of two data pairs, NYT/JHU and JHU/CDC, we observed high temporal variability of pairwise dataset agreement, particularly beginning in mid-November 2020.
Figure 6. Time-series plot of pairwise Cohen’s kappa agreements between datasets and Fleiss’ kappa agreement across all datasets for COVID-19 case data.
![Figure 6. Time-series plot of pairwise Cohen’s kappa agreements between datasets and Fleiss’ kappa agreement across all datasets for COVID-19 case data.](/cms/asset/0cd4e05e-8ad7-4ad2-a2cc-19ddecb6837a/tcag_a_1975311_f0006_c.jpg)
Figure 7. Time-series plot of pairwise agreements between datasets and Fleiss’ agreement across all datasets for COVID-19 death data.
![Figure 7. Time-series plot of pairwise agreements between datasets and Fleiss’ agreement across all datasets for COVID-19 death data.](/cms/asset/9d60699a-0737-4b73-97c9-b53f118ea031/tcag_a_1975311_f0007_c.jpg)
Temporal trends in death data are significantly less variable and tend to be more consistent over time. A similar trend of declining Fleiss’ kappa agreement across all datasets is observed beginning late June 2020 and continuing through November 2020. Again, this decline may be related to increasing pandemic impact across the country at that time. All four CDC data pairs remain below third party data agreement and below Fleiss’ kappa agreement for a majority of the study period. Agreement between NYT and JHU datasets again emerges as the most closely aligned pair observed beginning in March of 2021.
Spatial variation in agreement
Variations in these pairwise comparisons and Fleiss’ kappa coefficient illustrate periods of the pandemic that experienced the highest and lowest levels of temporal agreement. In a similar manner, to explore the spatial dimension of agreement we calculate decile bins for each county included in the study using the CDC data, classify each day’s values in those bins, and then evaluate agreement via a single Fleiss’ kappa value at the county level. (See .) In contrast with the daily 7-day rolling averages in the time-series plots () in which each new data snapshot shifts the window by one day, these maps evaluate data by shifting the window by one week, thus avoiding dependent values in the series. As observed with spatial variation for cumulative cases and deaths, some patterns along state lines appear to characterize Fleiss’ kappa agreement: overall Fleiss’ kappa agreement is lower in Iowa, Missouri, Kansas, Nebraska, Massachusetts, and Alabama; agreements in Pennsylvania, Florida, Connecticut, and Vermont are generally higher. We observe a few apparent regional trends, but spatial variation exists strongly along and within state lines. Iowa, Missouri, Nebraska, and Kansas, all having relatively low rates of agreements observed in their counties, are bordered by states with county-level kappa values tending toward middle or upper quintiles of observed agreement; Illinois, Minnesota, and Oklahoma all have relatively high case data agreement across many counties. Similarly, a number of southeastern states, Alabama, Georgia, and the Carolinas have low agreement, but are bordered by Florida, Mississippi, Tennessee, and Virginia – all with counties characterized by higher agreement of case data.
Figure 8. Map of county-level Fleiss’ kappa agreement of case data between datasets from 3/15/2020 to 4/15/2021.
![Figure 8. Map of county-level Fleiss’ kappa agreement of case data between datasets from 3/15/2020 to 4/15/2021.](/cms/asset/620f1e31-7f9e-436e-9802-70f858894574/tcag_a_1975311_f0008_c.jpg)
Figure 9. Map of county-level Fleiss’ kappa agreement of death data between datasets from 3/15/2020 to 4/15/2021.
![Figure 9. Map of county-level Fleiss’ kappa agreement of death data between datasets from 3/15/2020 to 4/15/2021.](/cms/asset/13ab6681-8f51-4880-8f63-91fa0979992d/tcag_a_1975311_f0009_c.jpg)
Spatial differences in death data agreement are similarly apparent along state borders, but states that tended to have lower agreements on case data do not necessarily always have low death data agreement as well: Massachusetts has relatively low case data agreement but high death data agreement; several states with moderate or higher case agreements have lower death data agreement as observed in Ohio, New York, and Illinois; several states present high agreement across both metrics such as Pennsylvania, Florida, Connecticut, and much of Tennessee; several states present low agreement across both metrics such as Missouri, Kansas, and much of Washington. As observed in mapping case data agreement, spatial heterogeneity within states does not present clear patterns, and most states have a mix of county-level values across multiple quintile bins.
Compared with the first analysis of cumulative data, there appear to be fewer regional trends observed in the Fleiss’ kappa agreement maps, but state differences are clearly present along boundaries. Reasons for state-bounded differences in agreement may reside in issues of data reporting frequency, testing programs, data pipeline and communication issues, and state-specific data vetting and cleaning procedures on the part of the data aggregators. Future research may be able to test and validate these hypotheses, as well as work to typologize county data uncertainty with considerations of pandemic response robustness and access, public health landscape, and intersectional race, age, gender, and class considerations that may contribute to delayed- or undercounting.
Discussion
Summary of findings
We used three main approaches to identify dimensions of uncertainty: cumulative data to explore geographic differences of reported cases and deaths, time-series data snapshots to uncover changes in data agreement over time, and county-specific time-series data to identify areas where datasets have agreed or disagreed most. Trends were evaluated across each approach for consistency, denoting unique dimensions of uncertainty. Our analysis of cumulative case discrepancies compared pairwise data normalized to population and found discrepancies appearing strongly along state boundaries; discrepancies between datasets were observed in South Carolina, Georgia, and Alabama and an apparent vertical band of inconsistent counties western Texas to the Dakotas. CDC data tended to have more widespread disagreement with third party data (Johns Hopkins University, New York Times, USAFacts, and 1Point3Acres), which tended to have large areas of the country within ±1 case or death. Of all data mapped, NYT and JHU data appear to have the fewest discrepancies. Cumulative death data analysis showed variations in other areas, with Wyoming, Ohio, and parts of Illinois and New York highlighted as apparent discrepancies; the vertical band of uncertain data in the middle of the country remains. Overall, CDC data reported fewer deaths than third party datasets. The second analysis examined trends and changes in how datasets tended to agree, using Cohen’s kappa to compare pairwise data agreement and Fleiss’ kappa to compare all five datasets together. For both case and death datasets over time, agreement has tended to decline over time, particularly after November 2020; this observation may be due in part to larger case volumes and the intense period of the pandemic in late 2020 in the United States. Case data agreement is particularly volatile, although in later months data pairs of NYT/JHU and JHU/CDC have started to emerge as closer in agreement. Death data shows growing agreement of the NYT/JHU data pair, and CDC data pairs of death data tended to be lower than all other relationships. The final analysis extracted weekly data for each county from the five datasets included and compares the agreement for that county over the duration of the pandemic. Trends similar to cumulative case and death data appear along state boundaries, as well as variation within states. For cases, Georgia, Alabama, Missouri, Kansas, Nebraska and much of Washington are observed with low agreement; for deaths, New York, Wyoming, Kansas, and much of Washington were observed with low agreement. Florida, Pennsylvania, and Connecticut are among the states with reasonably consistent data agreement.
These findings highlight different dimensions through which uncertainty can be observed in spatio-temporal datasets, and our study highlights the extent of volatility, variation, and complexity that is often present. Across our analysis of spatial, temporal, and cumulative measures, marked differences were observed, but considered as a whole and considered in context of kappa interpretation scales, much of the data in our study generally tended to be in substantial agreement. To make the dimensions of uncertainty in COVID-19 information more explicit, we categorize the key findings across MacEachern’s conditions of uncertainty (MacEachren et al., Citation2005) that considers three components of information (space, time, and attribute) paired with nine uncertainty types (accuracy/error, precision, completeness, consistency, lineage, currency/timing, credibility, subjectivity, and interrelatedness). Previous work demonstrated that incorporating these typologies to characterize uncertainty is useful to users and development work (Roth, Citation2009). In total, nine component-types of uncertainty were uncovered with an ESDA analytic approach: (1) accuracy/error in the time dimension; (2) completeness in the spatial dimension (ex. Utah); (3) consistency in the spatial dimension (ex. NYC boroughs); (4, 5) lineage in the spatial and temporal dimension (ex. provenance of data, how it may overlap sources); (6) credibility in the attribute dimension (ex. journalist and volunteers versus the CDC); and (7–9) interrelatedness across spatial, temporal, and attribute dimensions.
Understanding processes of uncertainty
The results above diagnose and highlight spatial and temporal patterns of uncertainty observed across the five included datasets. For practical applications of these data, these results suggest where and when data uncertainty may be elevated, and supply methods to analyze future datasets. However, it is important to understand and break down the processes that produced this uncertainty in the first place, to better expose root causes of uncertainty and how these datasets differ. In so doing, future data practices from both data aggregators and official data providers may better manage uncertainty before data publication and use. To understand the data pipeline and where these processes diverge temporally, we dig into the documentation of each dataset and outline typical data pipelines in , highlighting potential divergence in each step of the data pipeline across datasets. If COVID-19 cases occur on May 2nd, data reporting supply case data to county and state level datasets, aggregated to national county-level files through data scraping, manual updates, and various automated processes, usually on the next day. Aggregation is followed by quality assurance and quality improvement (QA/QI) processes, correcting for geographic boundary issues, redistribution of unassigned cases, and handling special cases (eg. cruise ship data). Each unique jurisdiction may have its own unique reporting issues related to timeliness and accuracy: for detailed data history from JHU, see the readme file under the csse_covid_19_data folder of the Github data repository; for more on the history of the NYT COVID-19 data, see the Github commit history on their data repository (see links in Appendix A).
Figure 10. Diagram of data pipeline for COVID-19 responsive aggregation and retrospective aggregation datasets.
![Figure 10. Diagram of data pipeline for COVID-19 responsive aggregation and retrospective aggregation datasets.](/cms/asset/9c1cc65c-70e2-4bfc-ae48-111c21b7eeae/tcag_a_1975311_f0010_c.jpg)
For New York Times data, additional on-site reporting and confirmation with public health officials (“Nytimes/COVID-19-Data,” Citation2020/2021) provides ongoing validation; for 1Point3Acres data, county data are supplemented with media and social media case reports, which were particularly important in the early days of the pandemic (Yang et al., Citation2020). JHU data aggregates and reconciles a number of different datasets together, although it is unclear the precise details of this process. For USAFacts and JHU, this data pipeline outputs daily updates, and New York Times releases periodic updates multiple times per day (“Nytimes/COVID-19-Data,” Citation2020/2021). These data reflect responsive aggregation, which emphasizes and publishes data in near-real time. This data pipeline differs from CDC data releases, which we label here as retrospective aggregation, due to the fact that county-level data only became available from CDC sources starting in late December. After that point, CDC updated county-level data 2–3 per week and generally 2–5 days behind real time data. CDC data on the Covid Data Tracker website uses a combination of sources and data validation processes that are not fully known (CDC & CDC, Citation2021). Additionally, it is important to note that official provisional datasets from the National Center for Health Statistics (NCHS) use different validation methods, particularly for death data based on death certificates rather than county or state death reports (CDC & CDC, Citation2021).
The differences in these data pipelines manifest as part of the uncertainty observed across temporal and spatial dimensions. Additional dataset characteristics also reveal the differences in these processes. For instance, temporal decreases in cumulative values suggest some form of correction or reassignment of cases, and are common particularly in JHU and NYT data; however, CDC data show relatively few instances of decreasing cumulative values, suggesting that reassignments and corrections may be likely incorporated into data prior to publication. Differences in data sourcing, case and death assignment, validation, corrections, and timeliness are summarized below in . The last row of the table identifies some of the possible conditions of uncertainty (MacEachren et al., Citation2005) that may be introduced in each stage of the data pipeline.
Table 4. Summary of dataset sources, locality assignment, validation, and correction processes, and timeliness.
These dimensions of uncertainty do not explicitly characterize the quality of data, but rather help us to understand where greater uncertainty in our understanding of the pandemic’s impact exists and where data pipelines can be improved for future public health efforts. As Goodchild (Citation2020) urges, exploring the phenomena driving uncertainty in data or geographic understanding is crucial. Efforts to document the provenance behind these COVID-19 datasets and their similarities or differences are central to this exploration. All crowdsourced datasets pulled from local health department websites in some form or other, whereas the CDC used a different reporting strategy unique to their internal process; this may provide some insight into the differentiations, but also poses new questions about how variation in reporting impacts outcomes data. Spatially, some regions are more carefully delineated when the crowdsourcing organization is an expert in the area, like the NYT dataset. On the other hand, entire states with wide variations in reporting, like Missouri, could uncover unique challenges reflecting political and/or technological realities. Temporally, there are distinct cycles to reporting COVID-19 across various health department jurisdictions, as well as the multiple crowdsources and federal organizations that extract that information accordingly. Key issues that may produce disagreement thus include discrepancies include data doubling-up on reported cases followed by corrections (producing nonmonotonically correct data), delays in data releases from public health departments or administrations resulting in large data spikes, and potential challenges of cases consistently being attributed to a county of residence or county of occurrence – particularly in rural areas, where crossing a county border for testing or treatment may not be unusual.
The findings of this work are consistent with previous research that identified discrepancies between COVID-19 datasets, but with strong (attribute-level) correlations (Smith, Citation2020), as well as identifying the same 7-day cyclical patterns at the state level (Wang et al., Citation2020). Extending an analysis of uncertainty past attribute levels of data agreement, we also found distinct spatial and temporal patterning that are integral to understanding the nuances behind varying but complementary data generating processes. This is in line with calls to highlight the multiple dimensions of uncertainty in data as called for by (MacEachren et al., Citation2005) and again by Goodchild (Citation2020). This work also highlights the complexities of communicating uncertainty from incomplete or disputed knowledge, a core challenge when planning for uncertain futures (Spiegelhalter et al., Citation2011). Capturing temporal aspects of uncertainty is difficult to integrate in mapping (Boggs, Citation1949), especially when needed in a way that is useful for planning and mitigation efforts. This work extends the field forward in that respect by integrating a visual analytic approach to first understanding dimensions of uncertainty in data (that may reflect complex underlying processes) and subsequently discerning a distinct, meaningful, and consistent form of communicating the uncertainty as a dimension of the data. The final kappa index can be communicated and explored as its own variable across time in spatiotemporal web applications like the US Covid Atlas, and/or it can also be included as an additional metric or indicator to provide insight at a county-level scale of analysis.
Small numbers problem
As observed in our preliminary exploratory analysis, small numbers of cases can produce large variations in assessed consistency, particularly when taken as ratios or percentages. Relatedly, where 7-day case or death averages remain low, rounding errors present in CDC data potentially amplify assessed inconsistency. Excluding early data from the time-series examined and utilizing the quantile classification utilized in our analysis helps to mitigate these issues. The state of the pandemic in the US continues to evolve as do data publication practices and standards. Changing case and death rates may introduce temporal or spatial periods of low counts and introduce new small numbers problems in assessing data consistency across dataset providers. Future researchers and practitioners dealing with low count data should carefully consider how datasets may introduce uncertainty related to small numbers problems or rounding errors.
Limitations and implications for future research
Looking to future data products, needs, and uses, what can we do better to manage uncertainty in data observation, aggregation, and communication pipelines? Gardner et al. (Gardner et al., Citation2021) call for better open data standards and systems to avoid the discrepancies and uncertainty we face in available COVID-19 data, specifically identifying issues and potential strategies to mitigate: (1) variable and metric definition and reporting timeliness; (2) data source/set disagreement; (3) differences in reporting format or medium; (4) changes in data over time, such as corrections; and (5) concerns of privacy and personally identifiable information. Such standards that aim to address modern data needs, such as the Mobility Data Standard (Open Mobility Foundation, Citation2020), integrate data across infrastructures to support interoperability between companies, jurisdictions, and individuals. But data fragmentation and discrepancies are likely to persist, and the need for methods to diagnose and manage uncertainty remain. The dimensions of uncertainty we highlight across the datasets and processes align with some criteria used to assess reliability and validity of data, such as time, space, measurement errors, bias, and representativeness (National Academies of Sciences, Engineering and Medicine, Citation2020). The need for decision-making in the face of uncertain and imperfect data will persist in the future. Our analysis contributes three main strategies for uncovering dimensions of uncertainty, and future research may expand this toolbox and operationalize these metrics for different uses. An array of methods may be appropriate depending on the depth, scale, and needs of research, policy, and data demands. For public health uses, real-time, if coarse, metrics can highlight areas with discrepancy or disagreement and trigger further review. Finer metrics employing big data techniques, in-depth modeling, and multidimensional correlation or dimension reduction may yield insights for longer-term research processes. Between these two extremes, numerous approaches to how we understand uncertainty and what we do with that knowledge exist. These practical methods build on our conceptual understanding of uncertainty to provide applied ways to diagnose and understand dimensions of uncertainty across datasets.
There are limitations on this study that hinder its ability to be conclusive regarding data uncertainty in the pandemic. For one, the dust has not yet settled: at time of writing, we are still in the midst of the pandemic. This means many datasets are still preliminary or provisional data releases, particularly the CDC data (NCHS, Citation2021b, Citation2021a). Because of reporting differences in geographies, we were not able to include all geographies of the United States (Utah, parts of Alaska), and Puerto Rico was not included in some datasets altogether. Additionally, this study only examines the COVID-19 data ecosystem within the United States, but data uncertainty is a global issue; further, we selected five prominent or widely incorporated datasets, but many more exist. Lastly, the kappa metrics employed may introduce sensitivity to counties on the edges of binning decile classification, and it may unfairly convert observed agreement into a binary agreement or disagreement rather than a continuous scale. Despite these limitations, the five datasets, present across over 3100 counties, provide a robust data universe to explore and assess. Each of the datasets have their own editorial and methodological approaches to producing data, and the kappa statistics observed in this study provide an understandable metric to chart disagreement and uncertainty across time-series geospatial data. For these reasons and despite these limitations, we feel the merit in this study can be used to help identify recommendations for assessing uncertainty more actively as data emerges, communicate that uncertainty, and work toward data that more accurately represent the communities described.
County data remain the finest resolution available country-wide, but even this scale presents issues. As with any data representing aerial data aggregated into layer geographies, COVID-19 case and death data is limited by the Modifiable Areal Unit Problem (MAUP) and ecological fallacy (Piantadosi et al., Citation1988; Wong, Citation2009), exacerbated by the aggregation of counties around New York City into a single geography. This problem presents two issues characterized as the “scale problem” where different aggregation sizes produce different findings, and the “zoning problem” where similarly-scaled but differently-located geographic units again impact research findings (Fotheringham & Wong, Citation1991). Finer data, such as at the tract or zip code level, could provide useful resources to better understand sensitivity of case and death data to the geographic unit.
Conclusion
As the kappa and cumulative difference measures can be easily computed in real time and output to simple, comprehensible metrics, we encourage regional and national data product services, news organizations, and public administrations to consider utilizing metrics of agreement and uncertainty to more transparently report on the state of pandemic and future public health data. While it will always be important to explore the most recent data available – even if flawed or incomplete – identifying and communicating uncertainty in data may help to temper expectations and mitigate backlash as understanding of situations evolves with new information, better data, and a clearer narrative of the current situation.
Areas highlighted as observed with high discrepancies in cumulative data and low case and death rate agreement may warrant further scrutiny when used for research purposes and further review of the causes behind these data inconsistencies. The relative consistency of the CDC data, particularly for cases, emphasizes the need for federal agencies to serve as clearinghouses for data in real time. At the same time, the disagreement raised by journalistically researched datasets, including the New York Times, and crowdsourced datasets, such as 1Point3Acres, emphasizes the potential importance of multiple perspectives that may help identify where official data fall short, and fill gaps to ensure communities on the margins are not left unaccounted for. In short: at time of writing, NYT and JHU appear to be the closest in agreement for cases, and NYT data, updated several times a day, tends to be the most timely. CDC case data appear to likely represent the best choice for historic analysis, so long as daily 7-day average values are adequate for the given analysis. CDC data also provides coverage based on unmodified US County geographies (as opposed to merged New York City counties and alternate Utah geographies). For COVID-19 related death data, USAFacts, JHU, and NYT data appear similar in agreement. Forthcoming provisional datasets on deaths from the National Center for Health Statistics (NCHS) may possess greater accuracy potentially due in part to the use of death certificates rather than public health reporting, and these data may be useful for historical analysis but possess limited timeliness. 1Point3Acres, with crowdsourced information, may possess unique advantages in early reporting of data, but for the most part it has lower disagreement coefficients with other datasets to date.
In spite of imperfect COVID-19 data agreement, policy-makers, communities, and individuals still require and deserve informed decision-making. CDC’s data are the most institutionally grounded of data examined and ostensibly becoming a de facto reference dataset, but uncertainty remains. Data are representations of reality, subject to the same processes of obfuscation and discernment. Each dataset may have its own distinctions in time and space, and where we find general divergence in agreement, additional care of uncertainty is needed. In uncovering and documenting the differences between datasets, it becomes even more clear that we “need more GIScience thinking in COVID-19 research” as suggested by Roskenktranz et al. (Citation2021). Maps or analytic models on their own do not tell the full picture, but of course GIScientists (should) have known that always to be the case. Even with existing limitations of coarse resolution health outcomes (county scale), and discrepancies between datasets, we can use the knowledge produced from these endeavors to drive new questions about underlying mechanisms to better support pandemic planning and mitigation.
Supplemental Material
Download Zip (32.1 MB)Acknowledgments
This research was made possible by the open source and open access efforts of the New York Times, Johns Hopkins University, and continuing public access of data from the CDC and USAFacts. Thanks to 1Point3Acres for continued data use permissions.
Disclosure statement
No potential conflict of interest was reported by the author(s).
Supplementary material
Supplemental data for this article can be accessed here.
Data availability and code availability statement
Data used at time of writing and code notebook for this analysis are available at https://github.com/geoda/covid-uncertainty. An interactive version of key figures in this paper are available at https://observablehq.com/@uscovidatlas/data-uncertainty-national-us-covid-data. For further exploration of individual data differences for particular counties over time, please explore the interactive code notebook available at https://colab.research.google.com/drive/1iRKtRsNf-tBYJN6Jx_0bYgQpVY0p3onj.
Additional information
Funding
References
- Banerjee, S. (2020, September 23). Navigate safely with new COVID data in Google Maps. Google. https://blog.google/products/maps/navigate-safely-new-covid-data-google-maps/
- Boggs, S. W. (1949). An atlas of ignorance: A needed stimulus to honest thinking and hard work. Proceedings of the American Philosophical Society, 93(3), 253–258. https://www.jstor.org/stable/3143475
- Buttenfield, B. P. (1993). Representing data quality. Cartographica: The International Journal for Geographic Information and Geovisualization, 30(2–3), 1–7. https://doi.org/10.3138/232H-6766-3723-5114
- Centers for Disease Control and Preventio, & CDC. (2021, April 14). Cases, data, and surveillance. https://www.cdc.gov/coronavirus/2019-ncov/covid-data/faq-surveillance.html
- Centers for Disease Control and Prevention. (2020a, March 28). Cases in U.S. | CDC. https://web.archive.org/web/20200320000652/https://www.cdc.gov/coronavirus/2019-ncov/cases-updates/cases-in-us.html
- Centers for Disease Control and Prevention. (2020b, March 28). CDC COVID data tracker. https://covid.cdc.gov/covid-data-tracker/#datatracker-home
- Cohen, J. (1960). A coefficient of agreement for nominal scales. Educational and Psychological Measurement, 20(1), 37–46. https://doi.org/10.1177/001316446002000104
- Couclelis, H. (2003). The certainty of uncertainty: GIS and the limits of geographic knowledge. Transactions in GIS, 7(2), 165–175. https://doi.org/10.1111/1467-9671.00138
- CSSEGISandData. (2021). CSSEGISandData/COVID-19. ( Original work published 2020). https://github.com/CSSEGISandData/COVID-19
- Desjardins, M. R., Hohl, A., & Delmelle, E. M. (2020). Rapid surveillance of COVID-19 in the United States using a prospective space-time scan statistic: Detecting and evaluating emerging clusters. Applied Geography (Sevenoaks, England), 118, 102202. https://doi.org/10.1016/j.apgeog.2020.102202
- Dong, E., Du, H., & Gardner, L. (2020). An interactive web-based dashboard to track COVID-19 in real time. The Lancet Infectious Diseases, 20(5), 533–534. https://doi.org/10.1016/S1473-3099(20)30120-1
- Fleiss, J. L. (1971). Measuring nominal scale agreement among many raters. Psychological Bulletin, 76(5), 378–382. https://doi.org/10.1037/h0031619
- Fotheringham, A. S., & Wong, D. W. S. (1991). The modifiable areal unit problem in multivariate statistical analysis. Environment and Planning A: Economy and Space, 23(7), 1025–1044. https://doi.org/10.1068/a231025
- Fusco, G., Caglioni, M., Emsellem, K., Merad, M., Moreno, D., & Voiron-Canicio, C. (2017). Questions of uncertainty in geography. Environment and Planning A: Economy and Space, 49(10), 2261–2280. https://doi.org/10.1177/0308518X17718838
- Gahegan, M., & Ehlers, M. (2000). A framework for the modelling of uncertainty between remote sensing and geographic information systems. ISPRS Journal of Photogrammetry and Remote Sensing, 55(3), 176–188. https://doi.org/10.1016/S0924-2716(00)00018-6
- Gardner, L., Ratcliff, J., Dong, E., & Katz, A. (2021). A need for open public data standards and sharing in light of COVID-19. The Lancet Infectious Diseases, 21(4), e80. https://doi.org/10.1016/S1473-3099(20)30635-6
- Gilmour, J. (2021, May 28). Analysis & updates | Federal COVID data 101: How to find data. The COVID Tracking Project. https://covidtracking.com/analysis-updates/federal-covid-data-101-how-to-find-data
- Goodchild, M. F. (2020). How well do we really know the world? Uncertainty in GIScience. Journal of Spatial Information Science, 20, 97–102. https://doi.org/10.5311/JOSIS.2020.20.664
- Google. (2021, June 3). Ensheng Dong—Google Scholar. https://scholar.google.com/citations?user=xQhOXE0AAAAJ&hl=en&oi=sra
- Hohl, A., Delmelle, E. M., Desjardins, M. R., & Lan, Y. (2020). Daily surveillance of COVID-19 using the prospective space-time scan statistic in the United States. Spatial and Spatio-Temporal Epidemiology, 34, 100354. https://doi.org/10.1016/j.sste.2020.100354
- Kinkeldey, C., MacEachren, A. M., & Schiewe, J. (2014). How to assess visual communication of uncertainty? A systematic review of geospatial uncertainty visualisation user studies. The Cartographic Journal, 51(4), 372–386. https://doi.org/10.1179/1743277414Y.0000000099
- Landis, J. R., & Koch, G. G. (1977). The measurement of observer agreement for categorical data. Biometrics, 33(1), 159–174. https://doi.org/10.2307/2529310
- Li, X., Lin, Q., Kolak, M., Martin, R., Yang, S., Menghaney, M., Israel, A., Wang, R., Anguiano, V., Abbott, E., Halpern, D., & Sihan-Mao. (2020). GeoDaCenter/covid: Beta ( beta) [ Computer software]. Zenodo. https://doi.org/10.5281/ZENODO.4081869
- MacEachren, A. M. (2015). Visual analytics and uncertainty: Its not about the data (pp. 5). EuroVis Workshop on Visual Analytics (EuroVA) https://doi.org/10.2312/eurova.20151104
- MacEachren, A. M., Robinson, A., Hopper, S., Gardner, S., Murray, R., Gahegan, M., & Hetzler, E. (2005). Visualizing geospatial information uncertainty: What we know and what we need to know. Cartography and Geographic Information Science, 32(3), 139–160. https://doi.org/10.1559/1523040054738936
- Martines, M. R., Ferreira, R. V., Toppa, R. H., Assunção, L. M., Desjardins, M. R., & Delmelle, E. M. (2021). Detecting space–time clusters of COVID-19 in Brazil: Mortality, inequality, socioeconomic vulnerability, and the relative risk of the disease in Brazilian municipalities. Journal of Geographical Systems, 23(1), 7–36. https://doi.org/10.1007/s10109-020-00344-0
- National Academies of Sciences, Engineering, and Medicine. (2020). Evaluating data types: A guide for decision makers using data to understand the extent and spread of COVID-19. National Academies Press. https://doi.org/10.17226/25826
- National Center for Health Statistics. (2021a). AH county of occurrence provisional COVID-19 deaths counts | Data | Centers for Disease Control and Prevention. https://data.cdc.gov/NCHS/AH-County-of-Occurrence-Provisional-COVID-19-Death/6vqh-esgs
- National Center for Health Statistics. (2021b). AH county of residence provisional COVID-19 deaths counts | Data | Centers for Disease Control and Prevention. https://data.cdc.gov/NCHS/AH-County-of-Residence-Provisional-COVID-19-Deaths/75vb-d79q
- National Center for Health Statistics. (2021c). AH excess deaths by sex, age, and race | Data | Centers for Disease Control and Prevention. https://data.cdc.gov/NCHS/AH-Excess-Deaths-by-Sex-Age-and-Race/m74n-4hbs
- National Center for Health Statistics. (2021d). Excess deaths associated with COVID-19 | Data | Centers for Disease Control and Prevention. https://data.cdc.gov/NCHS/Excess-Deaths-Associated-with-COVID-19/xkkf-xrst
- New York Times COVID 19 data. (2021). New York Times. https://github.com/nytimes/covid-19-data
- Nytimes/COVID-19-data. (2021). The New York Times. ( Original work published 2020). https://github.com/nytimes/covid-19-data
- Open Mobility Foundation. (2020). About MDS | Open Mobility Foundation. https://www.openmobilityfoundation.org/about-mds/
- Paul, R., Arif, A. A., Adeyemi, O., Ghosh, S., & Han, D. (2020). Progression of COVID‐19 from urban to rural areas in the United States: A spatiotemporal analysis of prevalence rates. The Journal of Rural Health, 36(4), 591–601. https://doi.org/10.1111/jrh.12486
- Pedregosa, F., Varoquaux, G., Gramfort, A., Michel, V., Thirion, B., Grisel, O., Blondel, M., Prettenhofer, P., Weiss, R., Dubourg, V., Vanderplas, J., Passos, A., Cournapeau, D., Brucher, M., Perrot, M., & Duchesnay, E. (2011). Scikit-learn: Machine Learning in Python. Journal of Machine Learning Research, 12, 2825–2830.
- Piantadosi, S., Byar, D. P., & Green, S. B. (1988). The ecological fallacy. American Journal of Epidemiology, 127(5), 893–904. https://doi.org/10.1093/oxfordjournals.aje.a114892
- 1Point3Acres. (2021). 1Point3Acres COVID 19 data. https://coronavirus.1point3acres.com/
- Rosenkrantz, L., Schuurman, N., Bell, N., & Amram, O. (2021). The need for GIScience in mapping COVID-19. Health & Place, 67, 102389. https://doi.org/10.1016/j.healthplace.2020.102389
- Roth, R. E. (2009). A qualitative approach to understanding the role of geographic information uncertainty during decision making. Cartography and Geographic Information Science, 36(4), 315–330. https://doi.org/10.1559/152304009789786326
- Seabold, S., & Perktold, J. (2019). Statsmodels: Econometric and statistical modeling with python. In 9th Python in Science Conference. https://github.com/statsmodels/statsmodels
- Smith, J. (2020). Comparison of COVID-19 case and death counts in the United States reported by four online trackers: January 22–May 31, 2020. MedRxiv. 2020.06.20.20135764. https://doi.org/10.1101/2020.06.20.20135764
- Spiegelhalter, D., Pearson, M., & Short, I. (2011). Visualizing uncertainty about the future. Science, 333(6048), 1393–1400. https://doi.org/10.1126/science.1191181
- Thomson, J., Hetzler, E., MacEachren, A., Gahegan, M., & Pavel, M. (2005). A typology for visualizing uncertainty. Visualization and Data Analysis, 5669, 146–157. https://doi.org/10.1117/12.587254
- Topojson. (2021). Topojson/us-atlas [ Shell]. ( Original work published 2013). https://github.com/topojson/us-atlas
- USAFacts. (2021, February 19). Detailed methodology and sources: COVID-19 data. https://usafacts.org/articles/detailed-methodology-covid-19-data/
- USAFacts. (2021, April 22). US COVID-19 cases and deaths by state. USAFacts.Org. /visualizations/coronavirus-covid-19-spread-map/
- Wang, G., Gu, Z., Li, X., Yu, S., Kim, M., Wang, Y., Gao, L., & Wang, L. (2020). Comparing and integrating US COVID-19 data from multiple sources with anomaly detection and repairing. https://arxiv.org/abs/2006.01333v4
- Wong, D. (2009). The Modifiable Areal Unit Problem (MAUP). In A. Fotheringham & P. Rogerson (Eds.), The SAGE handbook of spatial analysis (pp. 104–123). SAGE Publications, Ltd. https://doi.org/10.4135/9780857020130.n7
- Yang, T., Shen, K., He, S., Li, E., Sun, P., Chen, P., Zuo, L., Hu, J., Mo, Y., Zhang, W., Zhang, H., Chen, J., & Guo, Y. (2020). CovidNet: To bring data transparency in the era of COVID-19. ArXiv:2005.10948 [Cs, q-Bio]. http://arxiv.org/abs/2005.10948