This data set contains information on a random sample of 5,000 Kiva loans and their repayment structures.
Each row represents a repayment on the loan. Since loans have multiple repayments (they're paid back in installments) there is quite a bit of repeated information in the dataset. For example, the first loan in the data set is "id = 156". 5 payments have been made on this loan, therefore the first 5 rows of the dataset contains some repetitive information, specifically columns 1 through 34 and 41 and 42 are repeated. Columns 35 through 39 contain information on the specific payment, and hence vary.
A list of variables and their definitions are given below. Most of this information comes from http://build.kiva.org/docs/data.
- id: Loan ID
- description.languages: Language of loan description with levels English (en), Spanish (es), French (fr), Indonesian (id), Russian (ru)
- status: Loan status with levels defaulted, in_repayment, and paid, see http://build.kiva.org/docs/data/loans for what each level means
- funded_amount: Amount of loan which has been purchased by Kiva lenders
- paid_amount: Amount of the loan which has been paid off
- activity: Activity for which loan is requested
- sector: Sector for which loan is requested
- location.country_code: Country code
- location.country: Country name
- location.town: Town name
- location.geo.level: Indicator for whether the latitude and longitude given is for country or town
- partner_id: Field partner ID for local lending institutions, see a complete list at http://api.kivaws.org/v1/partners.json
- borrowers.first_name: First name of borrower
- borrowers.last_name: Last name of borrower
- borrowers.gender: Gender of borrower
- borrowers.pictured: Whether or not the borrower provided a picture
- terms.disbursal_amount: The amount of money distributed to the borrower in the local currency. Comparing this amount to the loan amount shows the currency conversion rate locked in for the loan when it was posted.
- 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.
- terms.disbursal_date: The date at which the funds from the loan were given to the borrowers. Note that it is possible for the money to be disbursed to borrowers before the loan is posted on Kiva.
- terms.loan_amount: The amount of money distributed to the borrower in lender's currency.
- terms.loss_liability.nonpayment: Categorical variable indicating who is liable for loss on a loan due to nonpayment, lender or partner.
- terms.loss_liability.currency_exchange: Categorical variable indicating who is liable for loss on a loan due to currency exchange, partner, shared, or none.
- posted_date: Date when loan was posted on Kiva.
- funded_date: Date when loan was fully funded on Kiva.
- journal_totals.entries: Number of journal entries (updates on the Kiva website) by borrower.
- paid_date: Date when loan was paid back in full by borrower.
- defaulted_date: Date when borrower defaulted on a payment on the loan.
- terms.local_payments.due_date: Date when payment is due to the field partner
- terms.local_payments.amount: Amount (in local currency) due to the field partner
- terms.scheduled_payments.due_date: Date when payment is due to the lender
- terms.scheduled_payments.amount: Amount (in US dollars) due to lenders.
- delinquent: Whether or not loan has become delinquent.
- 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".
- basket_amount: Amount of the loan which lenders have saved in shopping baskets, but has not been confirmed as purchased.
- amount: Payment amount in US dollars
- payment_id: Payment ID
- local_amount: Payment amount in local currency
- processed_date: Date payment is processed
- rounded_local_amount: Rounded local payment amount
- settlement_date: Settlement date of payment
- lat: Latitude of loan location, as indicated by location.geo.level
- lon: Longitude of loan location, as indicated by location.geo.level
Source: http://build.kiva.org/docs/data/snapshots