USAID Development Credit Authority Guarantee Data: Utilization and Claims

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. Whether it’s getting working capital to promising entrepreneurs or input financing to small farmers, DCA seeks to prove the commercial viability of underserved markets so that lending and investment continues long after we exit. The Development Credit Authority (DCA) uses partial credit guarantees to mobilize local financing in developing countries. Guarantee agreements encourage private lenders to extend financing to underserved borrowers in new sectors and regions. By opening up local channels of financing, USAID is empowering entrepreneurs in developing countries at a minimal cost to the U.S. taxpayer. This dataset is the complete list of all USAID partial credit guarantees since DCA was established in 1999. This USAID dataset shows the partial credit guarantees that USAID has issued since the development credit authority program was founded in 1999. The spreadsheet reflects the full facility size of each guarantee, how much was lent under the guarantee, the status of the guarantee (i.e., active or expired) , how much in claims the bank submitted due to losses it incurred for loans placed under the guarantee, and how many loans were placed under coverage of the guarantee. The data also shows the sector and country for each guarantee.

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: Utilization and Claims 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-utilization-and-claims.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-utilization-and-claims.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-utilization-and-claims.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-utilization-and-claims.json?recall_id=94"

Fields

The following fields are available on the USAID Development Credit Authority Guarantee Data: Utilization and Claims API.

fiscal_year

Human Name: Fiscal Year
Type: number

Examples

Retrieve all records with fiscal_year equal to 2013:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(fiscal_year, 47.598177,-122.33448, 1000)

guarantee_number

Human Name: Guarantee Number
Type: text

Examples

Retrieve all records with guarantee_number equal to ProArca DCA 596-0185-0300 ALPG 003:

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-utilization-and-claims.json?$where=within_circle(guarantee_number, 47.598177,-122.33448, 1000)

guaranteed_percentage

Human Name: Guaranteed Percentage
Type: percent

Examples

Retrieve all records with guaranteed_percentage equal to 100:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(guaranteed_percentage, 47.598177,-122.33448, 1000)

country

Human Name: Country
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-utilization-and-claims.json?$where=within_circle(country, 47.598177,-122.33448, 1000)

guarantee_start_date

Human Name: Guarantee Start Date

Examples

Retrieve all records with guarantee_start_date equal to 2013-09-30T00:00:00:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(guarantee_start_date, 47.598177,-122.33448, 1000)

guarantee_end_date

Human Name: Guarantee End Date

Examples

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

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(guarantee_end_date, 47.598177,-122.33448, 1000)

final_date_for_placing_loans_under_coverage

Human Name: Final Date for Placing Loans under Coverage

Examples

Retrieve all records with final_date_for_placing_loans_under_coverage equal to 2026-01-01T00:00:00:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(final_date_for_placing_loans_under_coverage, 47.598177,-122.33448, 1000)

primary_target_sector_code

Human Name: Primary Target Sector Code
Type: text

Examples

Retrieve all records with primary_target_sector_code equal to Water:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(primary_target_sector_code, 47.598177,-122.33448, 1000)

secondary_target_sector_codes

Human Name: Secondary Target Sector Codes
Type: text

Examples

Retrieve all records with secondary_target_sector_codes equal to Water, Agri:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(secondary_target_sector_codes, 47.598177,-122.33448, 1000)

credit_agreement_type

Human Name: Credit Agreement Type
Type: text

Examples

Retrieve all records with credit_agreement_type equal to Portable Guarantee:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(credit_agreement_type, 47.598177,-122.33448, 1000)

status

Human Name: Status
Type: text

Examples

Retrieve all records with status equal to Expired:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(status, 47.598177,-122.33448, 1000)

maximum_cumulative_disbursements

Human Name: Maximum Cumulative Disbursements
Type: money

Examples

Retrieve all records with maximum_cumulative_disbursements equal to 150000000.00:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(maximum_cumulative_disbursements, 47.598177,-122.33448, 1000)

cumulative_utilization

Human Name: Cumulative Utilization
Type: money

Examples

Retrieve all records with cumulative_utilization equal to 80600000.00:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(cumulative_utilization, 47.598177,-122.33448, 1000)

cumulative_utilization_percentage

Human Name: Cumulative Utilization Percentage
Type: percent

Examples

Retrieve all records with cumulative_utilization_percentage equal to 100:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(cumulative_utilization_percentage, 47.598177,-122.33448, 1000)

cumulative_loans

Human Name: Cumulative Loans
Type: number

Examples

Retrieve all records with cumulative_loans equal to 18192:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(cumulative_loans, 47.598177,-122.33448, 1000)

claims

Human Name: Claims
Type: money

Examples

Retrieve all records with claims equal to 1189593.78:

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

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

recoveries

Human Name: Recoveries
Type: money

Examples

Retrieve all records with recoveries equal to 241614.40:

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

https://explore.data.gov/resource/usaid-development-credit-authority-guarantee-data-utilization-and-claims.json?$where=within_circle(recoveries, 47.598177,-122.33448, 1000)