COVID 19 : PREDICTION OF VULNERABLE AREAS HAVING HIGH RISK OF BECOMING HOSTSPOTS AND PROVIDING NECESSARY STATISTICS DURING COVID-19 PANDEMIC

COVID-19 Pandemic management has become the top priority of Government Institutions globally, which is justifiable seeing the high mortality of the disease which spreads mainly through droplets and aerosols1. In India, Lockdown by National, State and Local level administrations have greatly reduced the spread of the SARS COV-2 Virus. Some areas with a greater proportion of COVID-19 patients have been declared hotspots with increased restrictions on public activities through law enforcement. But quite often delay in identification of these hotspots leads to community transmission of the Virus thus aggravating the problem. A method to identify the areas which are at risk of becoming the next hotspot for the disease is the need of the hour 2. In this Research document we will find the probable risk factors and make an appropriate scale to measure the vulnerability of an area, identified by its Postal code. To help with this a Pan India survey Dataset was taken from Kaggle.com8 which had csv files to ease with Research, with the acquired data we will evaluate the risk factors and make appropriate scale to identify ‘pre-hotspots’. Preprints (www.preprints.org) | NOT PEER-REVIEWED | Posted: 18 May 2020 doi:10.20944/preprints202005.0298.v1 © 2020 by the author(s). Distributed under a Creative Commons CC BY license. OBJECTIVES • The primary objective is to establish a method to help the administration identify vulnerable areas, through their PIN/postal codes. • The secondary objective will be to help local Administration find needy areas for distribution of PPE and medical equipment. METHODOLOGY •  Use of Google forms as a means to conduct a nationwide survey. Input data analyzed through spreadsheets. •  Risk factors to be evaluated and given the necessary importance. •   Example of pre-hotspot being identified through the calculation of total risk and plotted on Google maps. •  Identifying the areas with weak medical infrastructure and deficient supplies and syncing it with Government data. •  Inclusion Criteria for the survey 1. Any Indian Citizen of any age (above 14 years) can take part In the survey. Anyone consenting to the informed consent can take part. •  Exclusion criteria for the survey 1. Anyone below the age of 15 years cannot take the survey. 2. Anyone not completing or entering the wrong data, will have their responses nulled.


OBJECTIVES
• The primary objective is to establish a method to help the administration identify vulnerable areas, through their PIN/postal codes. • The secondary objective will be to help local Administration find needy areas for distribution of PPE and medical equipment. METHODOLOGY • Use of Google forms as a means to conduct a nationwide survey.
Input data analyzed through spreadsheets.
• Risk factors to be evaluated and given the necessary importance.
• Example of pre-hotspot being identified through the calculation of total risk and plotted on Google maps.
• Identifying the areas with weak medical infrastructure and deficient supplies and syncing it with Government data.
• Inclusion Criteria for the survey 1. Any Indian Citizen of any age (above 14 years) can take part In the survey.
Anyone consenting to the informed consent can take part.
• Exclusion criteria for the survey 1. Anyone below the age of 15 years cannot take the survey. 2. Anyone not completing or entering the wrong data, will have their responses nulled.

PRIMARY OBJECTIVE
We will now access the data from the survey Dataset We will ascertain the risk of each Individual submission in the form, and for that we will make a point-based scale (of range 1-10) to calculate the risk associated with each of the factors.(pts=points).
So we will first make the key of calculating the total points.

S.
No.

Question 12 of the survey asks
• "Are You a Doctor, Nurse ,or HealthCare worker who is actively taking care of Coronavirus Infected patients?

(Next Part Of the Survey is only For Medical Professionals taking Care of Coronavirus Patients) *"
This is an Indirect way of asking that does your area/PIN code area has an active Coronavirus infected patient?
And is a very important factor as the presence of the Virus itself is the starter for an outbreak in that area. That is Why it is assigned 2 (pts).Question 13 asks the Healthcare workers whether they have adequate PPE or not,

Chronic disease and age
Age was already asked in the biodata section of the survey in Question 2.
• And age groups were divided into 15-30 age group-This age group mostly consists of Students and Young Working class population, they are almost not at risk of developing serious complications. 0 (pts) 30-50 age group-This age group basically comprises of worker class of society and many a times they have to go out for work, since Government workers are on duty in this pandemic and offices are allowed 33% of work force, they have more interaction but good immunity also. 0.5(pts) 50+ age group-They mostly consist of Working class and retirees, they have weaker immune system and high risk of developing serious complications from the virus. 2(pts) Refer Errors in Data for more Info about the age topic. People with chronic illnesses have higher risk of mortality if they contract the virus, moreover, the extra care needed for the patients, exposes health workers many times to the risk of them getting infected themselves. This group gets 1.5(pts)

PERSONAL PROTECTION
Even During this lockdown normal Citizens need basic amenities and supplies to continue living Normally, and for this Government specifies a time when people can Socialize and shop for these things, Personal protection along with social distancing plays an important role during this period to stop the spread of Viral Infection 2,3,4,5 Chances of getting an Infection greatly reduces by covering our face and hands, and also using Handwash and sanitizers frequently to kill microorganisms on our hands.
Question 6-Asks about Face protection.
Question 7-Asks about hand protection.
Question 8-Asks about Availability and use of Hand Sanitizers and Handwash.
Question 9-Asks about Habit of cleaning Common areas with Disinfectant.
Question 11-Asks the respondent about his/her idea about the probability of them catching the virus after assessing their surroundings. • No Gloves-0.2(pts) Gloves protect while handling hard currency, using phone, etc.
• Non-Availability of Sanitizers/Hand wash-0.6(pts) People touch their face many times a day, so Virus can transfer from hands to mucous coverings of face, Cleaning hands with handwash and sanitizers cleans off and destroys virus particles.
• Not cleaning Common areas, door handles, tables -0.2(pts) Common areas can become contaminated and clearing them with disinfectants like Bleach can kill off virus particles • Self Probability (between 6-10 )-0.5 (pts) *Subject's probability would be based on the news that He / She consumes, Level of protection and awareness of their Neighbourhood and self assess whether they are at risk from anything.

DATA ANALYSIS
Data was analysed using Excel Spreadsheets and Uploaded on Google Spreadsheets for Public Viewing.

DOI: 10.34740/kaggle/dsv/1155383 for Kaggle Dataset
Click to View Data Analysis Spreadsheet on Google Points for each category were calculated and the sum total for each submission was also calculated.
The Risk factor for Designating a place/area as dangerous was set at total points of '2'.
Threshold of '2' was selected because-• Scenario 1-If there is 'presence of virus' then threshold is easily crossed, nonwithstanding other factors.
• Scenario 2-If subject is of old age and has chronic disease then threshold is easily crossed, non-withstanding other factors.
• Scenario 3 -If the subject has a complete lack of personal protection then the threshold is easily crossed, non-withstanding other factors.
• Scenario 4-If the availability of PPE for Medical professionals is not there, moreover the patient is not compliant then the threshold is easily crossed, non-withstanding other factors.

'The Arogya Setu' app launched by the Indian Government
can easily distribute these suveys among the population and collect their information with Geotags.
• Stressing on Hygiene, Social Distancing 10,11 , Disinfection 12,13 and Providing Healthcare workers with protective equipment should be the standard procedure to Fortify an area against an outbreak, above model can indicate areas with deficient healthcare facilities and provide help through local administrations.
• People after getting the feedback of being in a pre hotspot area can take necessary steps to improve their personal protection.
ERRORS IN DATA 1. Contrary to the belief of the reader, if they think that, "How can an area based on Postal Boundaries be designated as pre hotspot on personal practices of an individual?" The individual in this is given a way lesser score points, total lack of any protection of an individual personally would account for only 1.5(pts) which will not pass threshold of '2' unless other factors are at play.
More points Almost '7' are given on the basis of presence of virus, age, and chronic diseases. Informed consent was asked from Each participant of the survey, which I quote here, "The information submitted by participants will be confidential. This survey will ask for you for your PIN/Postal/ZIP code as a Geographical indicator only. if you wish to continue then click 'YES', * the Surveyor has the right to publish your input Data and Findings."

FUNDING
No Funding of any kind was required, nor was any taken.