The Data Behind The Dollars

A SQL Look at World Bank Loans

Background

The state of Jammu & Kashmir experienced heavy monsoon rains that led to severe flooding and landslides. The Jhelum and Chenab rivers overflowed their banks and reached dangerous water levels as the rain continued to fall from September 2nd to September 6th, 2014. This event is referred to as the ‘2014 Kashmir floods” and according to the International Recovery Platform led to 287 deaths and impacted about 2 million people.

The following is an SQL analysis of the World Bank’s International Development Association (IDA) project that aimed to support recovery and increase disaster resilience in the pre-determined areas.

The Data

 The data used in this analysis was downloaded from the World Bank’s website which you can access here.

Key Questions

The World Bank’s project involves seven components: “strengthening critical infrastructure, reconstruction of roads and bridges, restoring urban flood management infrastructure, restoring livelihoods, strengthening disaster risk management capacity, contingent emergency response, and implementation support.

My key questions in analyzing this data were:

1.      How much (in $) has the IDA extended to India for this project?

2.      What is the highest amount due to the IDA for this project?

3.      What is the average service rate for this project?

4.      What is the maximum amount that the IDA has extended to India?

5.      How many times did India repay the IDA for this project?

Key Insights

Using SQL, I was able to get the following answers to my questions:

1. The total amount extended to India for this project was: $2,606,094,388.43

2. The highest amount due to the IDA for this project was: $122, 218, 873.56

3. The average service rate for this project was: 2.27

4. The maximum amount given to India for this project was: $147,218,873.56

5.  India has repaid the IDA 89 times for this project

SQL Analysis

This dataset contained 1,119,992 rows and therefore wouldn’t be ideal to analyze in Excel, so I used SQL to conduct this data analysis.

To answer my first question about the total amount of IDA loans to India for this project, I used the following query to get $2,606,094,388.43.

With the total amount given being in the billions, I was curious about the amount owed by India to the IDA and wanted it to be ordered from highest to lowest. I used the query below to see that $122,218,873.56 (x5) was owed to the IDA for the disbursements it gave to India.

Next, I wanted to know what the average service rate was for this project and used the query to get 2.27.

To answer the question about the most amount given to India for this project I used this query to find $147218873.56

I also wanted to know how many times India repaid the IDA and used this query to get 89.

Conclusion

After conducting the analysis you see above,  I was curious about the maximum amount due to the IDA from India regardless of the project and I used this query to get $793,256,127.64.

To end my project, I wanted to see what the top 5 projects in India that the IDA had given loans to and used the query below to identify IN: National Rural Livelihood Projects, IN: SSA III, IN Elementary Education (SSA II), and IN: PMGSY Rural Roads Projects.

Personal Note

I loved being able to learn SQL and sort through the vast amount of World Bank data to understand more about this particular project and am excited to use this tool even more!

If you have any feedback or thoughts, I'd love to hear them as they'll help me grow my data analysis skills. Thank you!

This project was done as part of the DAA Boot Camp Projects. Educational purpose.