Time Series Data Visualization of COVID-19 in India
Starting from January 30, 2020, to March 25, 2021, India has seen close to 12 Million cases of COVID-19 cases detected in almost over 232 Million tests which were conducted starting from March 19, 2020, till March 25, 2021. During the course of the pandemic, close to 1.6 Lakh people have died. The vaccination drive for the public started on January 16, 2021, which is 14 days short of a year when the first COVID case was detected in India. India as a nation has administered close to 55 Million COVID vaccination including both Dose 1 and Dose 2.
Some Key Facts -
1. The first COVID case was detected on Jan 30, 2021.
2. COVID tests began on March 19, 2020.
3. The new cases were highest in the month of September 2020 which was close to 98000.
4. The new tests conducted were highest in the month in September which was close to 15 Lakhs.
5. The first vaccination for public use took place on March 16, 2021.
6. The new vaccinations administered were highest on March 22, 2021.
7. Maximum new case and deaths were reported during the second quarter of FY 2020 which were close to 66 Million and 81000 respectively.
8. Maximum tests were conducted in the third quarter of FY 2020 which was close to 96 Million.
Observations:
1. While comparing the data of Q3 and Q4, it can be seen that as the number of new cases decreased, it led to a decrease in the COVID test which was being carried out.
2. The testing rate further went down post-January 16, 2021 when the vaccination drive started in India.
3. Till March 8, 2021, daily tests conducted remained constant but the positivity rate had started to increase slowly from the mid of February.
4. In visualizations, we can clearly see a cross over happening on March 10, 2021, when the reported new cases increased significantly even though the test conducted remained more or less at the same levels.
5. Post-March 10, 2021 the severity of was the situation was realised and thereafter there has been aggressive testing carried out across the nation.
6. The % change in vaccination date has remained constant since the beginning.
7. Few outliers can be seen in the graphs which depict that more and more vaccines are administered on Monday as compared to the previous day which in many cases has been either Friday or Sunday.
8. The % change has also gone down on the following Monday depicting that almost equal numbers of vaccine are administered on a daily basis and thereby increasing the pace of vaccination.
Conclusion:
India’s was majorly impacted by COVID-19 in Q2 of FY20. It was the quarter when the lockdown was declared over and gradually the economy was reopening. It was the quarter where the highest number of new cases and deaths were reported. The situation improved in the following quarter where India carried out the maximum number of tests. In Q4 of FY 20, the mass vaccination drive started on January 16, post which the number of tests carried out on daily basis remained the same or decreased. This decrease in testing and announcement of vaccination drive somewhere rumoured a sense of immunity in the public which ultimately led to open violation of COVID-19 protocols. As a result of regular violations, the spread continued while the testing was at the same levels as in Q3. From February 2021 onwards, the positivity rate started to increase slowly and that led to realizing the gravity of the situation that though the vaccination drive has commenced but the chances of being infected haven’t gone down.
The citizens of the country need to realise that although the vaccination drive has begun, with a country of over 1.38 Billion and only 55 Million being vaccinated, the chances of others being exposed to COVID-19 are at the same risk level.
“Vaccination drive is not like a ticket to normal life, it’s just a ray of hope that things will be fine in coming months/year.”
Stay home, stay safe as much as you can and try to follow all the COVID guidelines to get over with this.
Visualization Details:
Visualization Link — Time Series Data Visualization of COVID-19 in India
Dataset — www.kaggle.com
Tools utilized —
1. Microsoft Excel
2. SQL Server Management Studio
3. Power BI
Assumptions —
1. Data points have been plotted considering the applicable permissible Fiscal Year in India which is April — March
2. Visualization and findings are solely based on the dataset the source.
Visualization components –
Filters —
1. Fiscal Year
2. Fiscal Quarter
Key Performance Indicators —
1. New Tests
2. New Cases
3. New Deaths
4. New Vaccinations
Graphs —
1. Area chart for New Cases, Tests and Vaccinations
2. Percentage change in vaccination by date with respect to the previous date
