USAID Development Credit Authority Guarantee Data: Loan Transactions

USAID’s Development Credit Authority (DCA) works with investors, local financial institutions, and development organizations to design and deliver investment alternatives that unlock financing for U.S. Government priorities. USAID guarantees encourage private lenders to extend financing to underserved borrowers in new sectors and regions. This dataset is the complete list of all private loans made under USAID's DCA since it was established in 1999. To protect the personal information of borrowers and bank partners, all strategic and personal identifiable information was removed. For explanations and limitations of the dataset, download the attachment in the metadata.

Getting Started

All communication with the API is done through HTTPS, and errors are communicated through HTTP response codes. Available response types include JSON, XML, and CSV, which are selectable by the "extension" on API requests or by HTTP Accepts headers.

This documentation also includes inline, runable examples. Click on any link that contains a gear symbol next to it to run that example live against the USAID Development Credit Authority Guarantee Data: Loan Transactions API.

App Tokens

All requests should include an app token that identifies your application, and each application should have its own unique app token. A limited number of requests can be made without an app token, but they are subject to much lower throttling limits than request that do include one. If you don't have an app token yet, click the button to the right to sign up for one.

Once you have an app token, you can include it with your request either by using the X-App-Token HTTP header, or by passing it via the $app_token parameter on your URL.

Response Codes

One of the following response codes will be returned with every request:

  1. 200Successful request.
  2. 202Request processing. You can retry your request, and when it's complete, you'll get a 200 instead.
  3. 400Bad request
  4. 401Unauthorized. You're not authorized to access this resource.
  5. 404Not found. The resource requested doesn't exist.
  6. 429Too Many Requests. The client has made too many requests and is currently being rate limited.
  7. 500Server errors. Our bad!

Code Samples

#!/usr/bin/env ruby

require 'net/https'
uri = URI('https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?recall_id=94')

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_PEER

request = Net::HTTP::Get.new(uri.request_uri)
request.add_field('X-App-Token', ARGV[0])

response = http.request(request)
puts response.code
puts response.body
#!/usr/bin/env python

import sys
import requests

r = requests.get('https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?recall_id=94', headers={'X-App-Token': sys.argv[1]})
print r.status_code
print r.text
request = require 'request'
options = uri: 'https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$$app_token=APP_TOKEN&recall_id=94'
request options, (err, response, body) ->  console.log body
#!/bin/sh 

curl --header "X-App-Token: $1" "https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?recall_id=94"

Fields

The following fields are available on the USAID Development Credit Authority Guarantee Data: Loan Transactions API.

guarantee_number

Human Name: Guarantee Number
Type: text

Examples

Retrieve all records with guarantee_number equal to Reserve Amount (Unallocated):

Retrieve all records where guarantee_number is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(guarantee_number, 47.598177,-122.33448, 1000)

transaction_id

Human Name: Transaction Report ID
Type: number

Examples

Retrieve all records with transaction_id equal to 436511:

Retrieve all records where transaction_id is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(transaction_id, 47.598177,-122.33448, 1000)

country

Human Name: Guarantee Country Name
Type: text

Examples

Retrieve all records with country equal to Zimbabwe:

Retrieve all records where country is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(country, 47.598177,-122.33448, 1000)

currency_of_loan

Human Name: Currency Name
Type: text

Examples

Retrieve all records with currency_of_loan equal to ZAMBIA-KWACHA:

Retrieve all records where currency_of_loan is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(currency_of_loan, 47.598177,-122.33448, 1000)

loan_start_date

Human Name: Start Date

Examples

Retrieve all records with loan_start_date equal to 2013-11-30T00:00:00:

Retrieve all records where loan_start_date is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(loan_start_date, 47.598177,-122.33448, 1000)

loan_end_date

Human Name: End Date

Examples

Retrieve all records with loan_end_date equal to 2031-09-27T00:00:00:

Retrieve all records where loan_end_date is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(loan_end_date, 47.598177,-122.33448, 1000)

business_sector

Human Name: Business Sector
Type: text

Examples

Retrieve all records with business_sector equal to Transportation:

Retrieve all records where business_sector is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(business_sector, 47.598177,-122.33448, 1000)

business_size

Human Name: Business Size
Type: text

Examples

Retrieve all records with business_size equal to N/A:

Retrieve all records where business_size is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(business_size, 47.598177,-122.33448, 1000)

womanowned

Human Name: Is Woman Owned?
Type: text

Examples

Retrieve all records with womanowned equal to true:

Retrieve all records where womanowned is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(womanowned, 47.598177,-122.33448, 1000)

firsttimeborrower

Human Name: Is First Time Borrower?
Type: text

Examples

Retrieve all records with firsttimeborrower equal to true:

Retrieve all records where firsttimeborrower is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(firsttimeborrower, 47.598177,-122.33448, 1000)

adm1name

Human Name: City/Town
Type: text

Examples

Retrieve all records with adm1name equal to Zugdidi:

Retrieve all records where adm1name is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(adm1name, 47.598177,-122.33448, 1000)

admin1_code

Human Name: State/Province/Region Name
Type: text

Examples

Retrieve all records with admin1_code equal to Zubin Potok/Zubin Potok:

Retrieve all records where admin1_code is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(admin1_code, 47.598177,-122.33448, 1000)

place_name

Human Name: State/Province/Region Code
Type: text

Examples

Retrieve all records with place_name equal to ZI08:

Retrieve all records where place_name is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(place_name, 47.598177,-122.33448, 1000)

location_admin_1

Human Name: Location
Type: location

Examples

Retrieve all records with location_admin_1 equal to longitude: 6.933333, latitude: 9.25:

Retrieve all records where location_admin_1 is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-loan-transactions.json?$where=within_circle(location_admin_1, 47.598177,-122.33448, 1000)

crowd

Human Name: Is Crowd Sourced?
Type: text