COVID-19 Dashboard

Abstract

Applying a digital strategy is proven to be one way to reduce the infection rate of COVID-19. As a fundamental part of it, database is capable to create a data repository to predict uncertain impacts of the pandemic. The research proposed a database design for project C-Beta that emphasized on creating an ideal system to record and monitor the daily health condition of people with COVID-19. Mainly, the research adopted Connolly and begg principles of Database Software Development Life Cycle. As a result, the database design activities produced blueprints in the forms of data dictionary, ERD, and user views. The database design delivered in the research included with several features namely user verification, restricted research membership, and flexibility in survey creation. Based on analysis and design phase, C-Beta provides a method to collect data for COVID-19 clinical study. Researchers who utilize C-Beta is able to manage multiple surveys and extract all collected records at the same time.

Introduction

I. INTRODUCTION

1. The burden the COVID-19 novel coronavirus has placed on the world is enormous.
2. There’s a great thirst for information and clarity.so that everyone can better understand how the outbreak impacts the world and their region.
3. We see that as a community effort. We invite the global community of engineers and data scientists to add data to this public dashboard that will cover  not just the direct impact of the coronavirus on public health, but other aspect of society as well.
4. We want to help everyone better understand the impact of COVID-19 anywhere around the world.

II. PROBLEM  STATEMENT

1. We are not able to see the data of covid-19 statewise. So, many people are facing problem to know the data.
2. Many people are not aware of number of cases .From graph they can see how rapidly cases are increasing.

III. OBJECTIVES

1. Creating a web interface for Users to see live covid updates of the country. To create a web interface which stores the data of the last seven days and displays it in an organized manner.
2. Displaying the state wise covid19 data with various types of graphs to visualize the data.
3. The point of the organization will be to give individuals the details identified with COVID19 and educate them with the data from the specialists and other authority assets so they can forestall themselves structure the pandemic circumstance.

IV. IMPLEMENTION

1. Our project proposes to build a dashboard which help us to check the number of covid cases in India
2. With pie chart and graph we show how many cases are increased or decreased everyday
3. Everyday  covid data is updated in the website

V. METHODOLOGY

A. Front-End And Back-End Tool Details

1. Hyper Text Mark-up Language
2. Cascading Style Sheet
3. JavaScript

B. Back-End Tool

1. Django
2. Python
3. SQL Server

VI. SOFTWARE DESCRIPTION

A. Front End Design

1. HTML (HyperText Mark-up Language): HTML is a standard mark-up language for creating web pages and web applications with Cascading Style Sheet (CSS) and JavaScript, it forms a triad of corner stone technologies of the World Wide Web.
2.  CSS (Cascading Style Sheet): CSS is a style sheet language used for describing the presentation of a document written in a mark-up language like HTML. CSS is a cornerstone technology of the World Wide Web, alongside HTML and JavaScript.
3. Django: Django is Python-based free and open-source web framework, which follows the model-template-view (MVT) architectural pattern. In Django, Python is used throughout, even for settings files and data models.

B. Screen Layout Design

1. HTML <form> TAG: The HTML <form> element represents a document section that contains interactive controls to submit information to a web server. It is possible to use the :valid and :invalid CSS pseudo-classes to style a <form>element. The HTTP method that the browser uses to submit the form.
2. Post: Corresponds to the HTTP POST method; form data are included in the body of the form and sent to the server.
3. Get: Corresponds to the HTTP GET method; form data is appended to the action attribute URI with a '?' as separator, and the resulting URI is sent to the server. This method is used when the form has no side-effects and contains only ASCII characters. This value can be overridden by a form method attribute on a <button> or <input> element.
4. Action: The URI of a program that processes the form information. This value can be overridden by a form action attribute on a <button> or <input> element.
5. HTML <input> TAG: The HTML <input> element is used to create interactive controls for web-based forms in order to accept data from the user. An <input> work varies considerably depending on the value of its type attribute; hence the different types are covered in their own separate reference pages. If this attribute is not specified, the default type adopted type is text.

C. Connectivity To Mysql Database

We need our MySQL server address (if the database is on the same server as the web server it will most likely be localhost or 127.0.0.1), username, password and database name. The connectivity is done using mysql-connector-python. The connection is done each time when the admin wants to retrieve anything from the database, or add something to the database. All in all, whenever the admin wants to perform an operation wherein the database is involved, the connection is required. The below code must be written inside the file Settings.py.

  DATABASES = {         

 'default': {      

 'ENGINE': 'django.db.backends.mysql',         

'NAME': 'dbms_project',        

'HOST': '127.0.0.1',       

 'PORT': '3306',        

'USER': 'root',        

'PASSWORD': '123456789',   

}

}

VII. MAJOR MODULES

A. Index.html

This is the main page of the project . Where a user can see the last updated data of Covid19 of India . The page has various data like total active cases, total death ,total infected and total recovered cases .

Not only the total data can be seen but also the change since 24 hrs can be seen . The data is taken from the  Ministry of Health and Family welfare site . In this page you can  also see the state wise covid19 update .

B.  India.html / State.html

In this page a user can see the covid  update of a particular state by typing the state name in the search bar displayed in the Index.html page. After the user searches for a state which is a valid name  then they will be redirected to this page in which they can see the record of past seven days with various user friendly graphs and  a tabular arrangement of covid data of the state .

If the user clicks on covid India on the index page then they will be redirected to India.html page where they can see the detailed information of past seven days with graphs .

C.  Awareness.html

In this page various awareness is mentioned related to covid 19. Things to do to control the spread of the virus . How to protect yourself from the virus and all sorts of safety methods are mentioned VIII. RESULTS

It will provide the details of state wise data of covid 19 and awareness among the users

IX. ACKNOWLEDGEMENT

We would like to express our heartfelt gratitude and respect to all those who guided us in the completion of this project. We would also like extend our heartfelt gratitude to our guide Prof.B. Sudha   for her constant support and guidance.

Conclusion

The volume of data increases dramatically over time Especially data generated on global pandemic caused by covid 19.such a volume of data requiring utilizing big data analytics tools along with AI techniques to make sense of pandemic and control its spread in a timely manner .finally we highlighted and discussed a number of further research and application to assist stakeholder such as government , MoHs , hospitals,, patients and responsible authorities to make decisions and predict the future .. These challenges include healthcare data security and patient privacy issues.

References

[1] Ministry of health and family welfare [2] WHO [3] Worldometer

Copyright

Copyright © 2022 Abhinav Anand, Ayush Kumar, Kumar Shardul Vikram, MD Isfahan Shariff, Sudha B. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.