In honor of Hans Rosling, who passed away last week, I decided to create a Gapminder plot for the Philippines. So here are the provinces of our country, plus Metro Manila, mapped in terms of health and wealth. (Note: Loading with Plotly may take some time)
How to use
Drag the slider to switch years from 2001 to 2015. You can also access the panel above in order to zoom-in/out, pan, or select a subset of data. If you get lost, simply click the “Autoscale” button and the “Reset Axis” button. Furthermore, you can check the data and the Python scripts I used in my Github!
- The expenses were plotted in a logarithmic scale.
- Dinagat Islands officially became a province by the end of 2006, although the rulings flipped (and flopped) by 2010 and 2011. One can then see how it changed financially from 2006 to 2007. Prior to that year, data for Dinagat Islands was taken from Surigao del Norte.
- Population data is only available for the years 2000, 2010, and 2015. Linear regression was implemented to fill the missing years.
- Similarly, life expectancy data is only available for the years 1997 to 2012 in three-year intervals. Linear regression was also implemented to fill the missing years.
- Kudos to Department of Finance for having their LGU-level data available and organized.
- Expenses were treated as an “indicator” of wealth 
- Update: Expenses were adjusted using the price index (CPI) in order to take inflation into account.
- Bureau of Local Government Finance, Department of Finance, Republic of the Philippines (2017). LGU Fiscal Data
- Malik, Khalid (2013). “2012-2013 Philippine Human Development Report” Human Development Network (HDN)
- Philippine Statistics Authority (2015). “2015 Census of Population”
- World Bank (2017). “Measuring Living Standards, Household Consumption and Wealth Indices” in Quantitative Techniques for Health Equity Analysis: Technical Note 14
- World Bank (2017). “Consumer Price Index: Philippines”
- Thompson, G. (2009). “Statistical Literacy Guide: How to adjust for inflation” in Library House of Commons, UK Parliament.
Also, here’s another implementation of Gapminder PH by Dr. Reina Reyes, check it out here.