skip to main content
10.1145/3472813.3473205acmotherconferencesArticle/Chapter ViewAbstractPublication PagesicmhiConference Proceedingsconference-collections
research-article

Development of a Rapid Prototyping COVID-19 Geographic Information System and the Influence of Testing Centers on Data Visualization

Published: 26 October 2021 Publication History

Abstract

Federal, state, and local governments have been tracking the spread of the COVID-19 pandemic, an infectious disease caused by a coronavirus. As a result of this pandemic, a consistent stream of health data has been produced that tracks the state of health for the seven billion plus people in the world each day, much of which has been publicly released. This open-source data can be used to analyze, visualize, and explain the spread of COVID-19. Here, a COVID-19 information system was created with the business intelligence software Tableau utilizing big data analysis techniques to contribute to general knowledge about the global pandemic. At a state level, data was collected from the big data initiative, the Covid Tracking Project. At the county level, if not provided in a downloadable format, the data was transcribed into a comma-separated values (CSV) file format and used for analysis. Data collection, cleaning, merging, and filtering was a time consuming and tedious task. The COVID-19 pandemic and increased amount of data collection has highlighted the need to perform rapid data analysis and visualizations. Tableau was used for the rapid prototyping of information system. The available data was decentralized and showed the lack of consistency and lack of nation-wide standardization in collecting COVID-19 data. Uncertainties in the data could be reduced through emphasizing how not all states release the same information, as well as efforts for transparency with how published statistics are calculated. The work aims to draw attention to the need for standardized data collection and the viability of using software such as Tableau for the creation of rapid visualizations.

References

[1]
Center for Disease Control and Prevention. 2020. Severe acute respiratory syndrome (sars). https://www.cdc.gov/sars/index.html.
[2]
2020. Our data. The COVID Tracking Project. https://covidtracking.com/data.
[3]
2020. We're changing the way you think about data. Tableau Software. https://www.tableau.com.
[4]
2020. Provisional death counts for coronavirus disease (covid- 19). Center for Disease Control and Prevention. https://www.cdc.gov/nchs/nvss/vsrr/covid19/index.htm.
[5]
2020. Coronavirus resource center. John Hopkins University of Medicine. https://coronavirus.jhu.edu/.
[6]
2020. Alabama's covid-19 data and surveillance dashboard. Alabama Department of Public Health: Division of Infectious Diseases & Outbreaks. https://alpublichealth.maps.arcgis.com/apps/opsdashboard/index.html#/6d2771faa9da4a2786a509d82c8cf0f7.
[7]
2020. Covid-19 testing. New York State. https://coronavirus.health.ny.gov/covid-19-testing.
[8]
2020. Testing. Delaware.gov. https://coronavirus.delaware.gov/testing.
[9]
2020. Coronavirus locations: covid-19 map by county and state. USA Facts. https://usafacts.org/visualizations/coronavirus-covid-19-spread-map/.
[10]
2020. Technical notes. Center for Disease Control and Pre- vention. https://www.cdc.gov/nchs/nvss/vsrr/covid19/technotes.htm.
[11]
Rob Stein. 2020. U.s. coronavirus testing still falls short. how's your state doing? https://www.npr.org/sections/health-shots/2020/05/07/851610771/u-s-coronavirus-testing-still-falls-short-hows-your-state-doing.
[12]
2020. Shiny from rstudio. RStudio. https://shiny.rstudio.com/.
[13]
2020. Dash enterprise. Data Studio. https://datastudio.google.com/u/0/.
[14]
Samantha Katcher, Josephine Lyons, and Mia Price. 2020.Covid-19 information system. https://github.com/ITWSXInformatics/COVID19InformationSystem.
[15]
2020. Top 20 visualization dashboards for mapping covid-19. Analytics Vidhya. https://www.analyticsvidhya.com/blog/2020/07/top-20covid-19-dashboard/.
[16]
2020. Health information privacy. U.S. Department of Health & Human Services. https://www.hhs.gov/hipaa/index.html.
[17]
2020. Covid-19. California Department of Public Health. https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Immunization/ncov2019.aspx#.
[18]
2020. Covid-19 dashboard. Ohio Department of Health, (2020). https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards.

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
ICMHI '21: Proceedings of the 5th International Conference on Medical and Health Informatics
May 2021
347 pages
ISBN:9781450389846
DOI:10.1145/3472813
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 26 October 2021

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. COVID-19
  2. Geographic health information system
  3. Health informatics
  4. Information system
  5. Rapid prototyping
  6. Tableau
  7. Visualization

Qualifiers

  • Research-article
  • Research
  • Refereed limited

Conference

ICMHI 2021

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • 0
    Total Citations
  • 62
    Total Downloads
  • Downloads (Last 12 months)18
  • Downloads (Last 6 weeks)1
Reflects downloads up to 16 Jan 2025

Other Metrics

Citations

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

HTML Format

View this article in HTML Format.

HTML Format

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media