<Back

COVID in Mexico

Project created to explore and visualize data related to COVID cases, deaths and vaccines in Mexico.

Data regarding vaccines was obtained from Our World in Data and data about cases and defunctions was obtained in Mexico's government site. Mexico's geodata necessary to create some Tableau visualizations was obtained from INEGI's website.

After collecting the data from both sites, it was formatted and cleaned using Excel, after formatting it was exported to SQL Server and relations between tables were stablished to use joins later on.

After stablishing a small relational database, data was explored using different queries that you can find here. With some ideas in mind after some insights were found, views were created to export queries result's to Excel and then to Tableau to visualize those findings.

Key findigs

Confirmed cases by Federal Entity

Key findings:

  • Entities with the most active cases:
    1. Ciudad de México (1.840.159)
    2. Estado de México (762.720)
    3. Nuevo León (432.091)

Confirmed deaths by Federal Entity

Key findings:

  • Entities with the most deaths:
    1. Estado de México (48.371)
    2. Ciudad de México (43.300)
    3. Jalisco (20.221)

Confirmed cases by week

Key findings:

  • Accumulated cases until August 08, 2023: 7.655.385
  • Week with highest peak of confirmed cases: January 09, 2022 (235.116)

Confirmed deaths by week

Key findings:

  • Accumulated deaths until August 08, 2023: 334.513
  • Week with highest peak of deaths: January 17, 2021 (9.937)

Vaccines effects on deaths

Key findings:

  • There was a drastic reduction on deaths after vaccinations campaigns started. Death rate went lowering from 9.59% to 2.76% when vaccinations campagins started.
  • Until October,2022, there were 97.179.493 with at least one dose of the vaccines. That's about 76% of Mexico's total population.

General conclusions on data

  • Ciudad de México and Estado de México were the most affected entities by COVID.
  • There was 7.655.385 total cases and 334.513 total deaths until the last data consult (August 08, 2023).
  • Even though vaccines didn't stop new waves of infection, death rate went lowering from 9.59% to 2.76%, which confirms the efectiveness of vaccination campaigns.