Trend analysis of COVID-19 impact on United States and its comparison with rest of the world.
- Bodke, Gauri Pandharinath
- Gopinath, Ashwin
- Saoji, Nikhil Mukesh
- Viswanadha, Srinivas Nishant
- Go to the project directory and run
npm installto install all the dependencies - Run
npm startto start the server - Open
http://localhost:3000/in the browser
Homepage consists of a navigation bar for easy access to the trend queries, 5 cards for 5 trend queries, and a button that sends an AJAX request to the backend to display the total number of rows in the oracle database used for this project. Our database consists of 7 tables, total of 1807433 rows, and is made by combining 4 publicly available datasets as mentioned below:
- COVID-19 Data Lake (https://registry.opendata.aws/aws-covid19-lake/)
- COVID-19 Reported Patient Impact and Hospital Capacity by State Timeseries (https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/g62h-syeh)
- COVID-19 Vaccinations in the United States,Jurisdiction (https://data.cdc.gov/Vaccinations/COVID-19-Vaccinations-in-the-United-States-Jurisdi/unsk-b7fc)
Positivity rate is defined by the ratio of total number of positive cases to the total number of tests done for that particular day.
For each state, it denotes the total number of counties in high transmission risk for each day. Out of the two indicators recommended by CDC, we are using the first indicator only to categorize a county in high transmission risk. For each day, it first calculates the total number of positive cases in the past 7 days. Now, using the population of that county, it finds news cases per 100000 person in the past 7 days. If that ratio is greater than or equal to 100, then that couny is considered as a high transmission risk county.
community-transmission.mp4
Mortality rate is defined by the ratio of total number of COVID-19 deaths to the total number of positive COVID-19 cases.
Hospitalization rate is defined by the ratio of ICU bed occupancy by COVID-19 patients to the total number of ICU beds.
Vacciations trend query represent the total number of vaccine doses given per thousand/million people. On hovering, it shows detailed analysis of percentage of people given at least one doses and fully vaccinated people.
