The HCUP Visualization of Inpatient Trends in COVID-19 and Other Conditions displays State-specific monthly trends in inpatient stays related to COVID-19 and other conditions, and facilitates comparisons of the number of hospital discharges, the average length of stays, and in-hospital mortality rates across patient/stay characteristics and States. This information is based on the HCUP State Inpatient Databases (SID), starting with 2018 data, plus newer annual and quarterly inpatient data, if and when available.

The purpose of this code is to produce a line graph visualization of COVID-19 data. This Jupyter notebook was built and run on Google Colab. This code will serve mostly as a guide and will need to be adapted where necessary to be run locally. The separate COVID-19 datasets uploaded to this Dataverse can be used with this code. This upload is made up of the IPYNB and PDF files of the code.

Dataset

This dataset was created by Aditya301112

Contents

It contains the following files:

Analytics and Data Visualization for COVID-19 Intelligence.An ArcGIS Blog arcticle that explains how to leverage ready-to-use reports and tutorials to gauge COVID-19 pandemic's impact worldwide._Communities around the world are taking strides in mitigating the threat that COVID-19 (coronavirus) poses. Geography and location analysis have a crucial role in better understanding this evolving pandemic.When you need help quickly, Esri can provide data, software, configurable applications, and technical support for your emergency GIS operations. Use GIS to rapidly access and visualize mission-critical information. Get the information you need quickly, in a way that’s easy to understand, to make better decisions during a crisis.Esri’s Disaster Response Program (DRP) assists with disasters worldwide as part of our corporate citizenship. We support response and relief efforts with GIS technology and expertise.More information...

Note: Reporting of new COVID-19 Case Surveillance data will be discontinued July 1, 2024, to align with the process of removing SARS-CoV-2 infections (COVID-19 cases) from the list of nationally notifiable diseases. Although these data will continue to be publicly available, the dataset will no longer be updated.

Authorizations to collect certain public health data expired at the end of the U.S. public health emergency declaration on May 11, 2023. The following jurisdictions discontinued COVID-19 case notifications to CDC: Iowa (11/8/21), Kansas (5/12/23), Kentucky (1/1/24), Louisiana (10/31/23), New Hampshire (5/23/23), and Oklahoma (5/2/23). Please note that these jurisdictions will not routinely send new case data after the dates indicated. As of 7/13/23, case notifications from Oregon will only include pediatric cases resulting in death.

This case surveillance public use dataset has 19 elements for all COVID-19 cases shared with CDC and includes demographics, geography (county and state of residence), any exposure history, disease severity indicators and outcomes, and presence of any underlying medical conditions and risk behaviors.

Currently, CDC provides the public with three versions of COVID-19 case surveillance line-listed data: this 19 data element dataset with geography, a 12 data element public use dataset, and a 33 data element restricted access dataset.

The following apply to the public use datasets and the restricted access dataset:

• Data elements can be found on the COVID-19 case report form located at www.cdc.gov/coronavirus/2019-ncov/downloads/pui-form.pdf.
• Data are considered provisional by CDC and are subject to change until the data are reconciled and verified with the state and territorial data providers.
• Some data are suppressed to protect individual privacy.
• Datasets will include all cases with the earliest date available in each record (date received by CDC or date related to illness/specimen collection) at least 14 days prior to the creation of the current datasets. This 14-day lag allows case reporting to be stabilized and ensure that time-dependent outcome data are accurately captured.
• Datasets are updated monthly.
• Datasets are created using CDC’s Policy on Public Health Research and Nonresearch Data Management and Access and include protections designed to protect individual privacy.
• For more information about data collection and reporting, please see https://www.cdc.gov/coronavirus/2019-ncov/covid-data/about-us-cases-deaths.html.
• For more information about the COVID-19 case surveillance data, please see https://www.cdc.gov/coronavirus/2019-ncov/covid-data/faq-surveillance.html
  

Overview

The COVID-19 case surveillance database includes individual-level data reported to U.S. states and autonomous reporting entities, including New York City and the District of Columbia (D.C.), as well as U.S. territories and affiliates. On April 5, 2020, COVID-19 was added to the Nationally Notifiable Condition List and classified as “immediately notifiable, urgent (within 24 hours)” by a Council of State and Territorial Epidemiologists (CSTE) Interim Position Statement (Interim-20-ID-01). CSTE updated the position statement on August 5, 2020, to clarify the interpretation of antigen detection tests and serologic test results within the case classification (Interim-20-ID-02). The statement also recommended that all states and territories enact laws to make COVID-19 reportable in their jurisdiction, and that jurisdictions conducting surveillance should submit case notifications to CDC. COVID-19 case surveillance data are collected by jurisdictions and reported voluntarily to CDC.

For more information: NNDSS Supports the COVID-19 Response | CDC.

COVID-19 Case Reports COVID-19 case reports are routinely submitted to CDC by public health jurisdictions using nationally standardized case reporting forms. On April 5, 2020, CSTE released an Interim Position Statement with national surveillance case definitions for COVID-19. Current versions of these case definitions are available at: https://ndc.services.cdc.gov/case-definitions/coronavirus-disease-2019-2021/. All cases reported on or after were requested to be shared by public health departments to CDC using the standardized case definitions for lab-confirmed or probable cases. On May 5, 2020, the standardized case reporting form was revised. States and territories continue to use this form.

Data are Considered Provisional

• The COVID-19 case surveillance data are dynamic; case reports can be modified at any time by the jurisdictions sharing COVID-19 data with CDC. CDC may update prior cases shared with CDC based on any updated information from jurisdictions. For instance, as new information is gathered about previously reported cases, health departments provide updated data to CDC. As more information and data become available, analyses might find changes in surveillance data and trends during a previously reported time window. Data may also be shared late with CDC due to the volume of COVID-19 cases.
• Annual finalized data: To create the final NNDSS data used in the annual tables, CDC works carefully with the reporting jurisdictions to reconcile the data received during the year until each state or territorial epidemiologist confirms that the data from their area are correct.

Access Addressing Gaps in Public Health Reporting of Race and Ethnicity for COVID-19, a report from the Council of State and Territorial Epidemiologists, to better understand the challenges in completing race and ethnicity data for COVID-19 and recommendations for improvement.

Data Limitations

To learn more about the limitations in using case surveillance data, visit FAQ: COVID-19 Data and Surveillance.

Data Quality Assurance Procedures

CDC’s Case Surveillance Section routinely performs data quality assurance procedures (i.e., ongoing corrections and logic checks to address data errors). To date, the following data cleaning steps have been implemented:

• Questions that have been left unanswered (blank) on the case report form are reclassified to a Missing value, if applicable to the question. For example, in the question "Was the individual hospitalized?" where the possible answer choices include "Yes," "No," or "Unknown," the blank value is recoded to "Missing" because the case report form did not include a response to the question.
• Logic checks are performed for date data. If an illogical date has been provided, CDC reviews the data with the reporting jurisdiction. For example, if a symptom onset date in the future is reported to CDC, this value is set to null until the reporting jurisdiction updates the date appropriately.
• Additional data quality processing to recode free text data is ongoing. Data on symptoms, race, ethnicity, and healthcare worker status have been prioritized.

Data Suppression

To prevent release of data that could be used to identify people, data cells are suppressed for low frequency (<11 COVID-19 case records with a given values). Suppression includes low frequency combinations of case month, geographic characteristics (county and state of residence), and demographic characteristics (sex, age group, race, and ethnicity). Suppressed values are re-coded to the NA answer option; records with data suppression are never removed.

Additional COVID-19 Data

COVID-19 data are available to the public as summary or aggregate count files, including total counts of cases and deaths by state and by county. These and other COVID-19 data are available from multiple public locations: COVID Data Tracker; United States COVID-19 Cases and Deaths by State; COVID-19 Vaccination Reporting Data Systems; and COVID-19 Death Data and Resources.

Notes:

March 1, 2022: The "COVID-19 Case Surveillance Public Use Data with Geography" will be updated on a monthly basis.

April 7, 2022: An adjustment was made to CDC’s cleaning algorithm for COVID-19 line level case notification data. An assumption in CDC's algorithm led to misclassifying deaths that were not COVID-19 related. The algorithm has since been revised, and this dataset update reflects corrected individual level information about death status for all cases collected to date.

June 25, 2024: An adjustment

This dataset tracks the updates made on the dataset "HCUP Visualization of Inpatient Trends in COVID-19 and Other Conditions" as a repository for previous versions of the data and metadata.

Dataset

This dataset was created by Dhrumil Gohel

Contents

Data visualizations of the COVID-19 pandemic in the United States often have presented case and death rates by state in separate visualizations making it difficult to discern the temporal relationship between these two epidemiological metrics. By combining the COVID-19 case and death rates into a single visualization we have provided an intuitive format for depicting the relationship between cases and deaths. Moreover, by using animation we have made the temporal lag between cases and subsequent deaths more obvious and apparent. This work helps to inform expectations for the trajectory of death rates in the United States given the recent surge in case rates.

To increase public awareness and disseminate health information, the WHO and health departments worldwide have been visualizing the latest statistics on the spread of COVID-19 to increase awareness and thus reduce its spread. Within various sources, graphs are frequently used to illustrate COVID-19 datasets. Limited research has provided insights into the effect of different graphs on emotional stress and ineffective behavioral strategies from a cross-cultural perspective. The result of current research suggests a graph with a high proportion size of the colored area (e.g., stacked area graph) might increase people's anxiety and social distancing intentions; people in collectivist culture might have a high level of anxiety and social distancing intentions; the effect of different graphs on social distancing intentions is mediated by anxiety experienced. Theoretical contribution and practical implications on health communication were also discussed in this study.

A data visualization representing Indonesia's Covid-19 cases have spiked

Visual map at kumu.io/access2perspectives/covid19-resources

Data set doi: 10.5281/zenodo.3732377 // available in different formats (pdf, xls, ods, csv,)

Correspondence: (JH) info@access2perspectives.com

Objectives

Provide citizens with crucial and reliable information

Encourage and facilitate South South collaboration

Bridging language barriers

Provide local governments and cities with lessons learned about COVID-19 crisis response

Facilitate global cooperation and immediate response on all societal levels

Enable LMICs to collaborate and innovate across distances and leverage locally available and context-relevant resources

Methodology

The data feeding the map at kumu.io was compiled from online resources and information shared in various community communication channels.

Kumu.io is a visualization platform for mapping complex systems and to provide a deeper understanding of their intrinsic relationships. It provides blended systems thinking, stakeholder mapping, and social network analysis.

Explore the map // https://kumu.io/access2perspectives/covid19-resources#global

Click on individual nodes and view the information by country

info hotlines

governmental informational websites, Twitter feeds & Facebook pages

fact checking online resources

language indicator

DIY resources

clinical staff capacity building

etc.

With the navigation buttons to the right, you can zoom in and out, select and focus on specific elements.

If you have comments, questions or suggestions for improvements on this map email us at info@access2perspectives.com

Contribute

Please add data to the spreadsheet at https://tinyurl.com/COVID19-global-response

you can add additional information on country, city or neighbourhood level (see e.g. the Cape Town entry)

Related documents

Google Doc: tinyurl.com/COVID19-Africa-Response

Content

Date generated: Wed Sep 09 2020 10:10:42 GMT-0400 (Eastern Daylight Time) Reported to the CDC since January 21, 2020

Acknowledgements

👍 Thank you to https://covid.cdc.gov/covid-data-tracker/#cases for providing the information of covid-19 cases and deaths.

Inspiration

I wanted to create matplotlib for this

Introduction

The dataset contains COVID-19 statistics for the top countries currently affected by the virus. The data was scraped from two popular sites maintaining daily updates on the spread of COVID-19 - https://www.worldometers.info/ and https://en.wikipedia.org/wiki/COVID-19_pandemic

Contents

There are two kinds of csv files. One type of files are country wise daily statistics on COVID-19 spread. The data for the following countries is available:-

• United States
• Russia
• Brazil
• Pakistan
• Germany
• Peru
• Spain
• Belgium
• Italy
• Belarus
• India
• Qatar
• Mexico
• Turkey
• Sweden
• Saudi Arabia
• Iran
• Canada
• Chile
• China
• France
• Ecuador
• Bangladesh

For each of these countries, the dataset contains the following columns:-

• Date
• total cases
• daily cases
• active cases
• total deaths
• daily deaths

The second type of file is the overall statistics which contains statistics for all the countries affected in the world. This dataset contains the following columns:-

• country name
• total cases
• total recoveries
• total deaths

This data is taken related to COvid-19 indian peopleeffected and is categorised in to 4 attributes,namely conformed active,death,discharge.

The datasets used for this manuscript were derived from multiple sources: Denver Public Health, Esri, Google, and SafeGraph. Any reuse or redistribution of the datasets are subjected to the restrictions of the data providers: Denver Public Health, Esri, Google, and SafeGraph and should consult relevant parties for permissions.1. COVID-19 case dataset were retrieved from Denver Public Health (Link: https://storymaps.arcgis.com/stories/50dbb5e7dfb6495292b71b7d8df56d0a )2. Point of Interests (POIs) data were retrieved from Esri and SafeGraph (Link: https://coronavirus-disasterresponse.hub.arcgis.com/datasets/6c8c635b1ea94001a52bf28179d1e32b/data?selectedAttribute=naics_code) and verified with Google Places Service (Link: https://developers.google.com/maps/documentation/javascript/reference/places-service)3. The activity risk information is accessible from Texas Medical Association (TMA) (Link: https://www.texmed.org/TexasMedicineDetail.aspx?id=54216 )The datasets for risk assessment and mapping are included in a geodatabase. Per SafeGraph data sharing guidelines, raw data cannot be shared publicly. To view the content of the geodatabase, users should have installed ArcGIS Pro 2.7. The geodatabase includes the following:1. POI. Major attributes are locations, name, and daily popularity.2. Denver neighborhood with weekly COVID-19 cases and computed regional risk levels.3. Simulated four travel logs with anchor points provided. Each is a separate point layer.

Analysis of ‘COVID-19 India dataset’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/dhamur/covid19-india-dataset on 28 January 2022.

--- Dataset description provided by original source is as follows ---

 This data set contains the data of covid-19 Conformed, Recovered and Deaths in India. This data is took from the non-governmental organization. 

Website

COVID-19 Daily updates

My Github

Profile Data Set

Data collected from

COVID19-India - The data from 31-Jan-2020 to 31-Oct-2021. Remaining data from

--- Original source retains full ownership of the source dataset ---

The dataset data visualization contains information on where COVID-19 is spreading by tracking new cases found each day and the total number of cases and deaths in the US on the county-level. The data can be dowloaded and visualized on the website.

Data is obtained from COVID-19 Tracking project and NYTimes. Sincere thanks to them for making it available to the public.

Coronaviruses are a large family of viruses which may cause illness in animals or humans. In humans, several coronaviruses are known to cause respiratory infections ranging from the common cold to more severe diseases such as Middle East Respiratory Syndrome (MERS) and Severe Acute Respiratory Syndrome (SARS). The most recently discovered coronavirus causes coronavirus disease COVID-19 - World Health Organization

The number of new cases are increasing day by day around the world. This dataset has information from 50 US states and the District of Columbia at daily level.

LICENSE:

Please refer here

              Apache License 2.0

A permissive license whose main conditions require preservation of copyright and license notices. Contributors provide an express grant of patent rights. Licensed works, modifications, and larger works may be distributed under different terms and without source code. For counties dataset, please refer here

Content us_states_covid19_daily.csv

This dataset has number of tests conducted in each state at daily level. Column descriptions are

date - date of observation state - US state 2 digit code positive - number of tests with positive results negative - number of tests with negative results pending - number of test with pending results death - number of deaths total - total number of tests

Acknowledgements Sincere thanks to COVID-19 Tracking project from which the data is obtained.

Sincere thanks to NYTimes for the counties dataset

There is a nice tableau public dashboard on the data. Images for this dataset is obtained from the same. Thank you.

Inspiration Some of the questions that could be answered are

How is the spread over time to various states Change in number of people tested over time

AbstractThe dataset provided here contains the efforts of independent data aggregation, quality control, and visualization of the University of Arizona (UofA) COVID-19 testing programs for the 2019 novel Coronavirus pandemic. The dataset is provided in the form of machine-readable tables in comma-separated value (.csv) and Microsoft Excel (.xlsx) formats.Additional InformationAs part of the UofA response to the 2019-20 Coronavirus pandemic, testing was conducted on students, staff, and faculty prior to start of the academic year and throughout the school year. These testings were done at the UofA Campus Health Center and through their instance program called "Test All Test Smart" (TATS). These tests identify active cases of SARS-nCoV-2 infections using the reverse transcription polymerase chain reaction (RT-PCR) test and the Antigen test. Because the Antigen test provided more rapid diagnosis, it was greatly used three weeks prior to the start of the Fall semester and throughout the academic year.As these tests were occurring, results were provided on the COVID-19 websites. First, beginning in early March, the Campus Health Alerts website reported the total number of positive cases. Later, numbers were provided for the total number of tests (March 12 and thereafter). According to the website, these numbers were updated daily for positive cases and weekly for total tests. These numbers were reported until early September where they were then included in the reporting for the TATS program.For the TATS program, numbers were provided through the UofA COVID-19 Update website. Initially on August 21, the numbers provided were the total number (July 31 and thereafter) of tests and positive cases. Later (August 25), additional information was provided where both PCR and Antigen testings were available. Here, the daily numbers were also included. On September 3, this website then provided both the Campus Health and TATS data. Here, PCR and Antigen were combined and referred to as "Total", and daily and cumulative numbers were provided.At this time, no official data dashboard was available until September 16, and aside from the information provided on these websites, the full dataset was not made publicly available. As such, the authors of this dataset independently aggregated data from multiple sources. These data were made publicly available through a Google Sheet with graphical illustration provided through the spreadsheet and on social media. The goal of providing the data and illustrations publicly was to provide factual information and to understand the infection rate of SARS-nCoV-2 in the UofA community.Because of differences in reported data between Campus Health and the TATS program, the dataset provides Campus Health numbers on September 3 and thereafter. TATS numbers are provided beginning on August 14, 2020.Description of Dataset ContentThe following terms are used in describing the dataset.1. "Report Date" is the date and time in which the website was updated to reflect the new numbers2. "Test Date" is to the date of testing/sample collection3. "Total" is the combination of Campus Health and TATS numbers4. "Daily" is to the new data associated with the Test Date5. "To Date (07/31--)" provides the cumulative numbers from 07/31 and thereafter6. "Sources" provides the source of information. The number prior to the colon refers to the number of sources. Here, "UACU" refers to the UA COVID-19 Update page, and "UARB" refers to the UA Weekly Re-Entry Briefing. "SS" and "WBM" refers to screenshot (manually acquired) and "Wayback Machine" (see Reference section for links) with initials provided to indicate which author recorded the values. These screenshots are available in the records.zip file.The dataset is distinguished where available by the testing program and the methods of testing. Where data are not available, calculations are made to fill in missing data (e.g., extrapolating backwards on the total number of tests based on daily numbers that are deemed reliable). Where errors are found (by comparing to previous numbers), those are reported on the above Google Sheet with specifics noted.For inquiries regarding the contents of this dataset, please contact the Corresponding Author listed in the README.txt file. Administrative inquiries (e.g., removal requests, trouble downloading, etc.) can be directed to data-management@arizona.edu

Context

This is my first dataset. I've made in view of the outbreak of COVID-19 in the world.

Content

I've used data analytics to predict the confirmed cases in weeks of the year, in India.

Inspiration

I would like to know what are the improvements I can make in my datasets. Feel free to rectify me. Thanks for your suggestions.