KivaSort

Hide field partners with incomplete data

ID	Name	Portfolio Yield	Profitability	Currency Exchange Loss Rate	Total Amount Raised	Loans Posted	Delinquency Rate	Default Rate	Rating	Average Loan Size Percent Per Capita Income	Loans At Risk Rate	Status	Start Date	Country	URL

What is it?

A table of Kiva's field partners (the microfinance organizations which administer loans made possible by Kiva) which may be sorted and filtered.

Motivation

I created KivaSort to complement an essay I wrote called Some thoughts on Kiva's interest rates.

Most of Kiva's field partners collect interest on the loans they disburse. The rates of interest vary, but they are sometimes very high despite the fact that much of the risk and cost is offloaded to Kiva and Kiva's generous users. Identifying field partners with high (or low) interest would be easiest if they could all be sorted by their "Portfolio Yield" (average interest rates) and "Profitability" (return on assets) metrics. The higher those rates, the higher the interest will tend to be on loans from those lenders. Providing the ability to sort the list of Kiva's field partners in such a way is the main motivating force behind the creation of KivaSort.

Kiva provides a table of field partners on their web site, but it has limited sorting options (it cannot be sorted by portfolio yield, for example). Kiva does provide nice APIs for their various services, which KivaSort uses.

Further reading

• Some thoughts on Kiva's interest rates
• "What’s Wrong With Kiva’s Portfolio Yield Statistic?" by Hugh Sinclair
• Seduced and Betrayed: Exposing the Contemporary Microfinance Phenomenon Edited by Milford Bateman and Kate Mclean (Santa Fe: School for Advanced Research Press, 2017) is the most complete single-volume criticism of microfinance that I know of.

See also

• Kiva.org's table of field partners
• KivaLens.org - KivaLens has now been rewritten in JavaScript and runs well in all modern browsers. Unlike KivaSort, it is a full-featured Kiva app geared toward heavy lenders who wish to carefully vet their borrowers. Like KivaSort, it allows Kiva's list of field partners to be filtered by various criteria.
• Kiva Tools - Kiva Tools is another little app I discovered after creating KivaSort which allows Kiva field partners to be searched and sorted.

Hints on Using KivaSort

By default, KivaSort lists field partners ordered primarily by "Portfolio Yield" so that field partners with low interest rates will be near the top. But note that expensive loans do not necessarily indicate usurious loans (at least not more usurious than other lenders); some locations have legitimately high costs associated with administering loans due to such factors as social instability, inflation, and lack of infrastructure. In that respect, a high "Profitability" metric may be the best way to identify highly exploitative lenders — although a consistently negative "Profitability" may indicate a non-sustainable field partner.

Hopefully the various controls for filtering, sorting, and exporting the table data are self-explanatory. Here are a few tips:

• Click a column header to sort in ascending order. Click again to sort in descending order.
• Hold down shift and click column headers to sort by multiple columns simultaneously.
• Columns that do not fit on the screen can be displayed as sub-rows by clicking the green icon in the first column.
• Type a [partial] word in the "Search" box to filter the table down to only rows containing the search term(s) in any column.
• Every column has a filter widget (search box, slider, etc.) which can be used to filter the table based on the data in that particular column.
• The "Column visibility" button can be used to hide columns.
• The "Export" button allows you to copy the table data to the clipboard or download it as a CSV-formatted file. Only the non-hidden columns will included in the exported data
• The "Reload" button will re-fetch the most current data from Kiva and refresh the table's contents with it.
• Uncheck the "Hide field partners with incomplete data" to show field partners who do not have some data (such as Portfolio Rate). Missing data is displayed as "-" in the table.

Open Source

The KivaSort web site is completely open source. If you'd like to view or contribute to the project, please take a look at the public git repository:

• https://github.com/cristoper/kivasort.americancynic.net
• JQuery-KivaSort - a JQuery plugin which fetches field partner data from Kiva and wraps it in a sortable DataTable. This plugin is based on the DataTables jQuery plugin which does all of the hard work of making an HTML table dynamic.

Who?

KivaSort.americancynic.net and the KivaSort JQuery plugin were created and are maintained by chris burkhardt <[email protected]>.

I write small, Free software and radical social commentary. If you found KivaSort helpful, please consider making a small contribution to further my work on this and similar projects.

• PayPal: donate to [email protected]