Home Projects COVID-19 Analysis
🦠 Pandemic Analysis Python Data Visualization 2020-2023

Philippine COVID-19 Pandemic Analysis

Comprehensive analysis of 4.1 million confirmed COVID-19 cases in the Philippines: pandemic waves, vaccination rollout, regional impact, and key health metrics.

4.11M
Total Confirmed Cases
66,803
Total Deaths
73.9M
Fully Vaccinated
1.63%
Case Fatality Rate
Time Period
January 2020 - December 2023
Tech Stack
Python Pandas Chart.js HTML/CSS
Key Takeaways

A data-driven look at how the Philippines weathered 4.1 million COVID-19 cases across three years of pandemic waves, vaccination rollout, and regional disparities.

  • The Philippines recorded 4.11 million confirmed cases and 66,803 deaths, with a case fatality rate of 1.63% from 2020 to 2023.
  • 73.9 million Filipinos were fully vaccinated, significantly reducing severe outcomes during later pandemic waves.
  • NCR, CALABARZON, and Central Luzon were the hardest-hit regions, driven by high population density and urbanization.
  • The Delta and Omicron waves in 2021-2022 produced the highest daily case counts, though Omicron had a lower fatality rate due to vaccination coverage.
01

Daily Cases Epidemic Curve

Tracking the trajectory of COVID-19 cases from first detection to endemic transition

📈 Daily New COVID-19 Cases (7-Day Average)

🔴 Peak Day

39,004

January 15, 2022 during the Omicron wave - highest single-day record

🌊 Major Waves

4 Waves

Alpha (Mar 2021), Delta (Sep 2021), Omicron (Jan 2022), and Sub-variant (Aug 2022)

Endemic Phase

<100/day

By late 2023, daily cases dropped below 100, signaling endemic transition

02

Deaths & Case Fatality Rate

Mortality trends and CFR evolution throughout the pandemic

💀 Monthly COVID-19 Deaths
📉 Case Fatality Rate Over Time (%)

📊 Deadliest Month

Sep 2021

Delta variant caused 10,800+ deaths in September 2021 alone - most lethal wave

CFR Decline

1.63%

CFR dropped from ~5% in early 2020 to under 0.5% by 2023 due to vaccination and milder variants

💀 Total Deaths

66,803

Cumulative deaths over the pandemic period, with Delta wave accounting for the largest share

03

Regional Distribution

Geographic spread of COVID-19 cases across Philippine regions

🗺️ Total Cases by Region

🏙️ NCR Dominance

33.2%

Metro Manila accounted for one-third of all cases - dense population and testing access

📍 CALABARZON

16.8%

Second most affected region due to proximity to NCR and industrial zones

🏝️ BARMM Lowest

0.6%

Bangsamoro had fewest cases - limited testing and remote geography

04

Testing & Positivity Rate

COVID-19 testing capacity and positivity trends

🧪 Monthly Tests Conducted (Thousands)
📊 Weekly Positivity Rate (%)

🧪 Total Tests

33.6M

Over 33.6 million tests conducted throughout the pandemic period

📈 Peak Positivity

46.2%

Positivity rate peaked at 46.2% during the January 2022 Omicron surge

🏥 WHO Threshold

5%

WHO recommends below 5% positivity to indicate adequate testing; PH exceeded this during surges

05

Pandemic Wave Identification

Characterizing each major wave by variant, peak, and impact

🌊 Pandemic Waves: Peak Daily Cases by Variant
Wave Dominant Variant Peak Date Peak Daily Cases Deaths in Wave
1st Wave Original/Alpha Apr 2021 15,310 8,200
2nd Wave Delta Sep 2021 26,303 22,400
3rd Wave Omicron BA.1 Jan 2022 39,004 11,600
4th Wave Omicron BA.5 Aug 2022 5,539 3,100

💀 Deadliest Wave

Delta

The Delta wave caused 22,400 deaths - more than all other waves combined

📈 Most Infectious

Omicron

Omicron BA.1 set the record at 39,004 daily cases but had lower severity

Declining Waves

BA.5

The 4th wave peaked at only 5,539 cases, showing growing population immunity

06

Vaccination Coverage by Region

Regional progress toward population immunity targets

💉 Fully Vaccinated Population by Region (%)

🏆 NCR Leading

102.7%

NCR exceeded 100% due to commuter vaccinations counted in workplace LGUs

📊 National Average

67.1%

73.9 million Filipinos fully vaccinated out of 110 million target population

BARMM Lowest

37.2%

Bangsamoro faced vaccine hesitancy and logistical challenges

07

Vaccine Brand Distribution

Breakdown of COVID-19 vaccines administered in the Philippines

💊 Vaccine Doses by Brand
📊 Dose Distribution Share

🥇 Sinovac

38.4%

CoronaVac was the most administered vaccine due to early availability and procurement deals

🥈 Pfizer

27.1%

Preferred for booster doses and healthcare workers due to higher efficacy data

🥉 AstraZeneca

16.8%

COVAX facility deliveries made AZ widely available in provinces

08

ICU & Healthcare Utilization

Hospital capacity strain during pandemic surges

🏥 ICU Bed Utilization Rate by Wave (%)

⚠️ Critical Threshold

85%+ ICU

During the Delta wave (Sep 2021), NCR ICU beds hit 85% capacity, triggering ECQ lockdowns

Omicron Relief

52% ICU

Despite record cases, Omicron caused milder illness - ICU utilization peaked at only 52%

🏥 Bed Expansion

2,300+

Government added over 2,300 ICU beds nationwide during the pandemic response

09

Monthly Year-over-Year Comparison

Comparing monthly case totals across pandemic years

📅 Monthly Cases by Year (Thousands)

📊 2020 Total

474K

First year - limited testing, strict lockdowns, cases concentrated in NCR

📊 2021 Total

2.31M

Worst year by deaths - Delta variant devastated communities before vaccines rolled out

📊 2022 Total

1.28M

Omicron surge in January, then steady decline as population immunity built up

10

Pandemic Timeline & Key Events

Major milestones and policy decisions during the pandemic

📋 Key Pandemic Milestones
Date Event Cumulative Cases
Jan 30, 2020 First confirmed case (Chinese tourist) 1
Mar 16, 2020 Luzon-wide Enhanced Community Quarantine (ECQ) 187
Aug 2, 2020 Cases surpass 100,000 103,185
Mar 1, 2021 First vaccine administered (Sinovac to HCWs) 576,352
Sep 11, 2021 Delta wave peak - 26,303 daily cases 2,193,711
Nov 2021 Alert Level System replaces CQ classifications 2,826,853
Jan 15, 2022 Omicron wave peak - 39,004 daily cases 3,274,826
Jul 2022 70% fully vaccinated target reached 3,717,036
Jul 21, 2023 WHO declares end of global health emergency 4,109,438

📅 Pandemic Duration

3.5 Years

From January 2020 first case to July 2023 WHO declaration - 42 months of pandemic response

🔒 Lockdown Duration

18 Months

The Philippines had one of the longest continuous lockdowns in the world (March 2020 - September 2021)

💉 Vaccine Lag

14 Months

Vaccines arrived 14 months after the first case, one of the last in ASEAN to begin vaccination

11

Vaccination Rollout Timeline

Cumulative vaccination progress from March 2021 onward

💉 Cumulative Fully Vaccinated (Millions)

🚀 Fastest Month

Nov 2021

Peak vaccination month with 12.3 million doses administered - National Vaccination Days

💉 Booster Uptake

22.1M

Only 22.1M received first boosters (30% of fully vaccinated), showing significant booster fatigue

📊 Target Gap

36.1M

36.1 million eligible Filipinos remained unvaccinated, falling short of the 110M target population

12

Age & Sex Distribution of Cases

Who was most affected by COVID-19 in the Philippines?

👥 Cases by Age Group
Cases by Sex

👤 Working Age

62.4%

Ages 20-49 accounted for the majority of confirmed cases

🧓 Elderly Deaths

57.3%

Those 60+ made up only 12% of cases but 57.3% of deaths

Gender Balance

~50/50

Cases were nearly evenly split: 50.8% male, 49.2% female

13

Top Provinces by Total Cases

Most affected provinces and cities during the pandemic

📍 Top 10 Provinces/Cities by Total Cases

🏙️ Metro Manila Cities

6 of Top 10

Quezon City (316K), Manila (215K), and Makati (98K) were the top three. NCR cities dominated due to population density and high testing rates.

🏞️ Provincial Hotspots

Cavite #1

Cavite (189K), Bulacan (154K), and Rizal (138K) - all neighboring NCR - were most affected provinces outside Metro Manila.

📊 Urban-Rural Divide

8:1 Ratio

Urban areas had 8 times the case rate of rural provinces, reflecting both spread patterns and testing disparities.

14

Lockdown Stringency Index

Oxford Stringency Index tracking Philippine government response measures

🔒 Government Response Stringency Index (0-100)

🔴 Strictest Period

96.3

March-May 2020 Luzon ECQ was among the strictest lockdowns globally - 96.3/100 stringency

🟢 Full Reopening

Mar 2023

Face mask mandate lifted in March 2023, marking effective end of pandemic restrictions

📊 Global Ranking

Top 5

The Philippines ranked among the top 5 strictest lockdowns globally in 2020, alongside India and Italy

15

ASEAN COVID-19 Comparison

How the Philippines compared with Southeast Asian neighbors

🌏 Total Cases per Million - ASEAN Countries

📊 Regional Standing

5th in ASEAN

Philippines ranked 5th in cases per million among ASEAN nations - below Malaysia, Singapore, Vietnam, Brunei

💀 Death Rate

3rd Highest

Higher CFR than most neighbors, attributed to healthcare access gaps and late vaccination start

💉 Vaccination Rank

6th in ASEAN

Below Singapore, Malaysia, Brunei, Thailand, and Vietnam in vaccination coverage rates

16

Economic Impact of Lockdowns

GDP contraction and recovery during the pandemic years

💰 Quarterly GDP Growth Rate (%)

Worst Contraction

-16.9%

Q2 2020 saw the worst GDP contraction in Philippine history during the strictest ECQ

Strongest Recovery

+12.0%

Q2 2021 rebounded with 12% growth year-on-year from the low base

📊 Full Recovery

Q2 2022

GDP returned to pre-pandemic levels by mid-2022 with 7.5% annual growth

17

Healthcare Worker Impact

The toll on Philippine frontline healthcare workers

🏥 HCW Cases by Profession

👩‍⚕️ Total HCW Cases

43,200+

Over 43,200 healthcare workers infected during the pandemic

💀 HCW Deaths

164

164 healthcare workers died - the highest in Southeast Asia

👩‍⚕️ Nurses Most Affected

52.3%

Nurses comprised over half of all HCW infections due to direct patient care

🏥 Doctor Infections

12.8%

5,530 doctors were infected, with higher severity rates than other HCW groups

🔬 Med Tech Staff

9.4%

4,061 medical technologists infected from handling COVID-19 test samples

📊 Vaccination Priority

A1 Group

HCWs were the first priority group (A1) for vaccination starting March 1, 2021

18

Key Findings & Summary

Critical insights from the Philippine COVID-19 pandemic data

🌊 Pandemic Trajectory

  • 4 major waves over 3 years (2020-2023)
  • Delta wave was deadliest; Omicron was most infectious
  • Cases peaked at 39,004/day in January 2022
  • Endemic transition by late 2023

💉 Vaccination Impact

  • 73.9M fully vaccinated (67.1% of target)
  • Sinovac most used (38.4%), Pfizer for boosters
  • NCR exceeded 100% coverage
  • Booster fatigue: only 30% got first booster

🗺️ Geographic Disparities

  • NCR had 33% of cases but also highest vaccination
  • BARMM lowest in both cases and vaccination
  • NCR-adjacent provinces heavily affected
  • Rural areas had limited testing access

💰 Socioeconomic Impact

  • GDP contracted 16.9% in Q2 2020
  • Philippines had strictest lockdown in Asia (96.3/100)
  • Healthcare workers bore disproportionate burden
  • Full economic recovery by mid-2022

Data Source & Methodology

This analysis uses publicly available data from the Philippine Department of Health (DOH) Data Drop and Our World in Data.

  • Primary Source: DOH COVID-19 Data Drop (data.gov.ph)
  • Secondary Source: Our World in Data - Philippines dataset
  • Time Period: January 2020 - December 2023
  • Total Records: 4.11 million confirmed cases, 66,803 deaths
  • Vaccination Data: DOH National Vaccination Operations Center

Let's Discuss This Analysis

Interested in public health data analytics or pandemic research collaboration?

Have a dataset you'd like analyzed or need a mini AI project as a starter guide? Send me your suggestions!