This is a repository for a personal project of mine that explores maternal mortality data from OurWorldInData.org.
The datasets and SQL code used in the project are included in this repository.
Maternal mortality refers to the risk that a woman dies from a maternal death, which is defined as "a death while pregnant or within 42 days of the termination of the pregnancy, irrespective of the duration and site of the pregnancy, from any cause related to or aggravated by the pregnancy or its management but not from accidental or incidental causes" (source). In this project, I explored worldwide data from 2017 and focused on three metrics typically used in maternal mortality statistics:
- Total Number of Maternal Deaths: The number of women who die from a maternal death, as defined above.
- Maternal Mortality Ratio: The number of women who die from pregnancy-related causes while pregnant or within 42 days of pregnancy termination per 100,000 live births. This metric is the likelihood that a woman will die in a given pregnancy.
- Lifetime Risk of Maternal Death: Defined as the probability that "a 15-year-old girl dies eventually from a pregnancy-related cause assuming that the number of children per woman and the maternal mortality ratio remain at their current levels" (source). This metric is the likelihood that a 15-year-old woman today will die from a maternal death sometime in the future.
All data cleaning and data exploration were done in SQL. The SQL code along with relevant comments can be found in this GitHub repository (direct link to file).
I also created the tables needed for the Tableau dashboard using SQL (the relevant code can be found in the SQL file). I used a different visualization for each of the metrics. The full interactive dashboard can be found on Tableau Public.
Bar Chart of the Total Number of Maternal Deaths by Continent:
Bubble Chart of the Maternal Mortality Ratio by Country and Continent:
Map of the Lifetime Risk of Maternal Death by Country:
