Team Stooqs

https://www.youtube.com/watch?v=0A6RkVDZrAw

github.com/Scriptpoint/Covid

How we address this problem:

In the span of 1 year and 8 months, 219 million people got affected by the COVID-19 virus amongst them 4.55 million did not survive. This unpalatable truth left the world in shock and also demonstrated the need for a sustainable solution. Rudimentarily everyone thought vaccines will be our ultimate savior but researches show that vaccines are only effective for a limited period and have limited efficacy. So the only enduring solution is awareness paired with vaccines, proper treatment, and following the COVID-19 guidelines.

Project summary:

Our project is mainly distributed in two parts. The first part, which deals with awareness, has informative quizzes, basic health guidelines, COVID-19 statistics, symptom-based COVID detection with questionnaires, etc. Here the user will get to know if all the information which he knows about the disease is correct or not as well as the implications of the health guideline. COVID statistics will be helpful in understanding analyzing the situation while detection questionnaires will let a person know when to visit a doctor or get admitted.

Helping the affected population with hospital information as well as successful vaccine registration is the main source of the second part. Hospital information, such as seat vacancies, ICU bed vacancies will be shown and updated regularly which will eliminate the hassle of finding a hospital seat or ICU bed. Furthermore, plasma, blood, oxygen supply information will be provided for the patient who might need it. On the other hand, registration for vaccination according to priority (age, critical diseases, situation) will be done by the application. Each user will get a serial number and a tentative date for vaccination.

Importance:

If all the aforementioned processes run simultaneously it will in terms increase the knowledge about the virus among mass people and vaccination and proper treatment will be manifested in decreasing death tolls.

Benefits:

• Readily found hospital data can ease the hospital search process for the patients.
• Plasma, blood, and oxygen for the patients will be more accessible through the application.
• Proper health guidelines according to category (children, adults, adults with diseases, etc.) will be more accurate and helpful.
• Proper guideline maintenance will result in less infection.
• Potential patients will know when to visit a doctor through a questionnaire.
• Daily statistics will reveal a lot more about the current situation and research can be conducted using these data.
• Vaccine registration process time will be decreased. And the process will become a lot smoother. 
• Volunteers can be added to the system by the application who will help in vaccination and educate people to accentuate vaccination.

Methodology:

Users can use the Cov-In MOD 21 web app Search engine to view the statistical data of new, active, critical, recovered, and death cases of Covid19 across the globe and stay updated. In light of the event of excess traffic on the internet, our users can use the automated Covid vaccination slot finder. In addition to that, the telegram bot of Cov-In MOD 21 sends automated notifications of vaccination slots, thus users will not have to constantly remain in search of slots on the internet. The end-user chatbot is a helping hand to those who want to fetch quick results for the details of the hospital near them with vacant ICU or Non-ICU beds. Here you just have to talk to the bot and the bot will give you the complete details about the hospital including the contact number, Hospital name, location, vacant beds, etc.

Search Engine:

The Search engine is a Django project taking datasets in JSON format from the Rapid API site’s custom Covid 19 API. The output is then put in the Streamlight app library using python.

Slot Notifier:

This modular code is nothing a small python module taking the data from https://cdn-api.co-vin.in/api/v2/appointment/sessions/public/findByDistrict?district_id={}&date={} and is changeable.

Telegram Bot:

Workings of the bot are as follows-

• Create Bot and Group
• Ping Cowin API and Fetch Data
• Push Message to Telegram Group
• Run Script Periodically

Covid Management:

• Clean aesthetic User Interface, which changes dynamically as per the status of patient changes
• In the bed availability grid, the red color indicates that the bed is occupied else available
• It is one of the two pages available for the public to view
• Here you can add a patient for storing it to the DB.
• The patient's relative contact details are also taken to check if the relative has contacted the COVID virus
• Available bed numbers are only shown
• Information filled here will make changes in the dashboard dynamically
• Since there are relatively more COVID patients than any other viruses/diseases, a checklist for COVID symptoms only is present
• Here you can search patients wrt to name, bed no. the doctor assigned, and status
• You can also find the update button to update the patient details.
• This is where the actual updates for individual patients are done
• Seat Management.
• Equipment Management.
• Oxygen Management.
• Doctor Management.
• Daily Patient Routine Checkups.
• Hospital capacity, including information on ICU capacity and available ventilators
• Staffing levels, including any shortages
• How many patients are coming into the hospital with confirmed or suspected COVID-19 cases
• Many other relevant details that public health officials need to properly coordinate COVID responses
• Through the RASA toolkit, our chatbot helps in locating the hospitals with the available facilities on the google map.

Project Architechture:

Technologies and libraries used:

 IDE:

• PyCharm 

Framework:

• Django

Open Source ToolKit:

• Rasa

Database:

• SqlLite3
• Streamlight Cache

Mentionable Python Libraries:

• Streamlight
• pygame
• requests
• html2text
• textblob
• Pandas
• Plotly

Datasets:

API Used Sources:

https://api.covid19api.com/world/total

https://api.covid19api.com/countries

https://documenter.getpostman.com/view/10808728/SzS8rjbc?version=latest#81447902-b68a-4e79-9df9-1b371905e9fa

https://cdn-api.co-vin.in/api/v2/appointment/sessions/public/calendarByPin?pincode={}&date={}

https://www.covidbedmbmc.in/HospitalInfo/show

https://coronabeds.jantasamvad.org/all-covid-icu-beds.html

https://covid-193.p.rapidapi.com/statistics

Project Insight and inspiration:

There have been various projects regarding Covid Pandemic throughout the last 16 months and to take an example of such “The Arogya Setu” App of our neighboring country is a product used by 20.56 crore people have seen quite the success. Yet some chief problems became the inspiration of our project for the Space Challenge; such as:

• The Persistent effort that is required to get slots over the internet due to lack of data update in due time.
• The lack of resources like ICU beds, Ventilators are not shown to the masses properly, and therefore, they are not directed to the appropriate geolocation as per their status and medical condition.
• The Lack of Smart and Information services in Underdeveloped and rural areas.

Due to such inconveniences, we as a team came together to create a smart but not so complex solution to the problem, keeping it simple to tackle the above issues head-on with our modular scripts comprising of an Informative search engine, an automated slot notifier, and a notifier over the social media along with a web application of online medical covid management system with proper accountability of resources providing a chatbot for further ease.

Problems Faced:

Firstly our rasa project although integrated with python faces difficulty to run on the latest version of python 3.9 and therefore it is recommended to run the chatbot script over python 3.8 with NumPy module 1.18

Secondly, as the application is web-based and gathers data from renowned sites in the JSON format using API, it is an inconvenience if the API stops working and is unable to fetch data in the event of unpredictable traffic or a site shutdown. 

Achievements:

• Lessening waiting time for vaccination after registration.
• Real-time hospital beds and ICU beds availability check.

API Used Sources:

https://api.covid19api.com/world/total

https://api.covid19api.com/countries

https://documenter.getpostman.com/view/10808728/SzS8rjbc?version=latest#81447902-b68a-4e79-9df9-1b371905e9fa

https://cdn-api.co-vin.in/api/v2/appointment/sessions/public/calendarByPin?pincode={}&date={}

https://www.covidbedmbmc.in/HospitalInfo/show

https://coronabeds.jantasamvad.org/all-covid-icu-beds.html

https://covid-193.p.rapidapi.com/statistics

Covid Tracker:

https://covid-193.p.rapidapi.com/statistics

https://api.covid19api.com/world/total

https://api.covid19api.com/countries

Covid Slot Notifier:

https://cdn-api.co-vin.in/api/v2/appointment/sessions/public/calendarByPin?pincode={}&date={}

Covid Dashboard Management:

https://documenter.getpostman.com/view/10808728/SzS8rjbc?version=latest#81447902-b68a-4e79-9df9-1b371905e9fa

https://www.covidbedmbmc.in/HospitalInfo/show

https://coronabeds.jantasamvad.org/all-covid-icu-beds.html

Hello! We are Team Stooqs. Our journey started in September when we first heard about Nasa Space Apps Challenge.

The starting of our journey was a bit confusing as there were so many categories. It took exactly 3days to decide on which category we will be working on. And at last, we fixed our aim to work on the Covid-19 category. We drew inspiration from a variety of online resources that discussed the outbreak.

Furthermore, collaborating on everyone's work while working remotely is quite difficult. Even yet, we managed to finish everything on time and learnt a lot about persistence, patience, and hard work along the way.

Javatpoint- https://www.javatpoint.com/python-tutorial

Geocoding documentation- https://developers.google.com/maps/documentation/geocoding/overview?hl=en_GB

Earth-engine installation guides- https://developers.google.com/earth-engine/guides/python_install

Earth-engine API -https://github.com/google/earthengine-api/tree/master/python

Developers app guides- https://developers.google.com/earth-engine/guides/apps

Earth engine developers guides- https://developers.google.com/earth-engine/guides

#Covid, #ICU, #availability, #TeamStooqs, #Vaccination, #safety, #quizz, #awareness, #web, #app, #CovidAwareness-ReinventingTheWheel, #prevention, #massAwareness, #python, #application

This project has been submitted for consideration during the Judging process.