DF2012: Data description for loans.csv
This data set has 97,183 rows and 75 columns, where each row is a unique loan made by the 15,000 lenders and columns contain information on these loans. Main pieces of information, such as loan amount, status, summary statistics on payment schedule and progress can be found here. Supplementary information, such as detailed payment schedule, and exact payments made so far on the loan can be found in loan_schedule.csv and loan_repayments.csv, respectively, which are included as part of the supplementary data. This file may be most useful for examining loan and borrower characteristics and behavior.
| No. | Name | Description |
| 1 | loan_id | Loan id |
| 2 | borrower_name | Name of borrower |
| 3 | borrower_image_id | Image ID of borrower, to see go to http://www.kiva.org/img/fullsize/<borrower_image_id> |
| 4 | status | Loan status, can be fundraising, funded, in_repayment, paid, defaulted, refunded, see http://build.kiva.org/docs/data/loans for a detailed description of what each level means |
| 5 | funded_amount | Amount of loan which has been purchased by Kiva lenders |
| 6 | paid_amount | Amount of the loan which has been paid off |
| 7 | activity | Activity for which loan is requested |
| 8 | sector | Sector for which loan is requested |
| 9 | use | Reason why loan is requested (more detailed free response description than activity and sector) |
| 10 | location.country_code | Country code, coded according to coded according to ISO 3166-1-alpha-2, see http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2 |
| 11 | location.country | Country name |
| 12 | location.town | Town name |
| 13 | location.geo.level | Indicator for whether the latitude and longitude given is for country or town. If country, the geographical center of the country is given by the lat/lon columns. For example, for the US, this is Lebanon, KS, see http://en.wikipedia.org/wiki/Geographic_center_of_the_contiguous_United_.... If town, geographical center of the town is given by the lat/lon columns. If you'd like to do a more precise spatial analysis, you may want to find the latitude and longitude for all towns. |
| 14 | lat | Latitude of loan location, as indicated by location.geo.level |
| 15 | lon | Longitude of loan location, as indicated by location.geo.level |
| 16 | partner_id | Field partner ID for local lending institutions. A description of the role of a field partner can be found at http://www.kiva.org/about/risk/field-partner-role. See a complete list of field partners at http://www.kiva.org/partners. More detailed information on the field partners are given in the partners.csv file. |
| 17 | posted_yr | Year when loan was posted on Kiva. Combining the following variables whose names begin with "posted_" will result in a posted date/time in the form of yyyy-mm-dd-hr-min-sec. |
| 18 | posted_mo | Month when loan was posted on Kiva |
| 19 | posted_day | Day when loan was posted on Kiva |
| 20 | posted_hr | Hour when loan was posted on Kiva |
| 21 | posted_min | Minute when loan was posted on Kiva |
| 22 | posted_sec | Second when loan was posted on Kiva |
| 23 | loan_amount | Total loan amount, in USD |
| 24 | terms.disbursal_amount | The amount of money distributed to the borrower(s), in the local currency. The following variables whose names start with "terms." describe the terms of the loan. |
| 25 | terms.loan_amount | The amount of money distributed to the borrower(s), in USD. This should be equal to loan_amount. |
| 26 | terms.loss_liability.nonpayment | Defines who is liable for loss due to nonpayment of loan, lender or partner. |
| 27 | terms.loss_liability.currency_exchange | Defines who is liable for loss due to currency exchange, lender, partner, or shared. |
| 28 | terms.disbursal_currency | The ISO 4217 code for the currency used to distribute the loan the the borrower. This is usually the local currency for the borrower's country. List of codes can be found at http://en.wikipedia.org/wiki/ISO_4217. |
| 29 | terms.disbursal_yr | Year of loan disbursal. Combining the following variables whose names begin with "terms.disbursal_" will result in a posted date/time in the form of yyyy-mm-dd-hr-min-sec. |
| 30 | terms.disbursal_mo | Month of loan disbursal. |
| 31 | terms.disbursal_day | Day of loan disbursal. |
| 32 | terms.disbursal_hr | Hour of loan disbursal. |
| 33 | terms.disbursal_min | Minute of loan disbursal. |
| 34 | terms.disbursal_sec | Second of loan disbursal. |
| 35 | funded_yr | Date when loan was fully funded on Kiva. Combining the following variables whose names begin with "funded_" will result in a posted date/time in the form of yyyy-mm-dd-hr-min-sec. |
| 36 | funded_mo | Month when loan was fully funded on Kiva. |
| 37 | funded_day | Day when loan was fully funded on Kiva. |
| 38 | funded_hr | Hour when loan was fully funded on Kiva. |
| 39 | funded_min | Min when loan was fully funded on Kiva. |
| 40 | funded_sec | Second when loan was fully funded on Kiva. |
| 41 | paid_yr | Date when loan was paid back in full by borrower. Combining the following variables whose names begin with "paid_" will result in a posted date/time in the form of yyyy-mm-dd-hr-min-sec. |
| 42 | paid_mo | Month when loan was paid back in full by borrower. |
| 43 | paid_day | Day when loan was paid back in full by borrower. |
| 44 | paid_hr | Hour when loan was paid back in full by borrower. |
| 45 | paid_min | Minute when loan was paid back in full by borrower. |
| 46 | paid_sec | Second when loan was paid back in full by borrower. |
| 47 | journal_totals.entries | Number of journal entries. These are updates about the status of the loan, the borrower, or sometimes, the field partner. |
| 48 | delinquent | Whether or not the loan is delinquent. A loan is identified as delinquent if the borrower fails to make a payment to the field partner, or if a field partner fails to make a payment to Kiva (and hence to lender). When this happens loan becomes delinquent and remains in in_repayment status. When a loan remains delinquent 6 months after the end of the loan payment schedule, the loan becomes defaulted. See http://build.kiva.org/docs/data/loans for more information on delinquent and defaulted loans. |
| 49 | video.youtube_id | If a video was posted, its YouTube ID. To see video, go to "http://www.youtube.com/watch?v=" + "video.youtube_id". |
| 50 | currency_exchange_loss_amount | If a currency exchange loss is shared between a partner and the lender, then this value represents the amount in USD lost by the lender due to fluctuations in the value of the local currency against the US dollar. This will result in the paid amount of loan being less than the full loan amount even when the status of the loan is listed as paid. |
| 51 | planned_expiration_yr | Planned expiration year of the loan. Combining the following variables whose names begin with "planned_expiration_" will result in a posted date/time in the form of yyyy-mm-dd-hr-min-sec. |
| 52 | planned_expiration_mo | Planned expiration month of the loan. |
| 53 | planned_expiration_day | Planned expiration day of the loan. |
| 54 | planned_expiration_hr | Planned expiration hour of the loan. |
| 55 | planned_expiration_min | Planned expiration minute of the loan. |
| 56 | planned_expiration_sec | Planned expiration second of the loan. |
| 57 | description | Loan description, lenghty free response. There may be some special characters. |
| 58 | description.en | Indicator for whether there is a description provided in English. |
| 59 | description.fr | Indicator for whether there is a description provided in French. |
| 60 | description.es | Indicator for whether there is a description provided in Spanish. |
| 61 | description.vi | Indicator for whether there is a description provided in Vietnamese. |
| 62 | description.ru | Indicator for whether there is a description provided in Russian. |
| 63 | description.pt | Indicator for whether there is a description provided in Portuguese. |
| 64 | description.id | Indicator for whether there is a description provided in Indonesian. |
| 65 | description.ar | Indicator for whether there is a description provided in Arabic. |
| 66 | borrower_names | If loan is borrowed as a group, names of all borrowers. |
| 67 | borrower_count | Number of borrowers in group. |
| 68 | borrower_m_count | Number of male borrowers in group. |
| 69 | borrower_f_count | Number of female borrowers in group. |
| 70 | borrower_pic_count | Number of borrowers in group with pictures. |
| 71 | scheduled_payments.count | Number of scheduled payments from field partner to borrower. |
| 72 | scheduled_payments.avg_dollar_amount | Average amount of payment from field partner to borrower, in USD. |
| 73 | payments.count | Number of payments made by the borrower to field partner. |
| 74 | payments.dollar_total | Total amount of payments made by the borrower to field partner, in USD. |
| 75 | payments.local_total | Total amount of payments made by the borrower to field partner, in local currency. |
