USAID Development Credit Authority Guarantee Data: Utilization and Claims

Speeches Shim

The USAID Loan Guarantee API is available on Data.gov

Additional notes about the API: A RESTful API with json, xml, and csv access, interactive documentation, API keys, and code samples.

About the Dataset

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.

About USAID’s Development Credit Authority

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.

For more details on USAID’s DCA please visit the Development Credit Authority website.

API URL: http://explore.data.gov/resource/atqm-5nw2.json

Response Format:

json, xml

Type:

HTTP GET

Authentication:

None required

Example Request

  1. Status http://explore.data.gov/resource/atqm-5nw2.json?status=active
  2. County and Fiscal Year
  3. http://explore.data.gov/resource/atqm-5nw2.json?country=Kenya&fiscal_yea...
  4. Fiscal Year and Credit Agreement Type
  5. Fiscal Year and Credit Agreement Type
  6. http://explore.data.gov/resource/atqm-5nw2.json?fiscal_year=2010&credit_agreement_type=Loan%20Portfolio%20Guarantee

Column IDs:

Fiscal Year
fiscal_year
Guarantee Number
guarantee_number
Guaranteed Percentage
guaranteed_percentage
Country
country
Guarantee Start Date
guarantee_start_date
Guarantee End Date
guarantee_end_date
Final Date for Placing Loans under Coverage
final_date_for_placing_loans_under_coverage
Primary Target Sector Code
primary_target_sector_code
Secondary Target Sector Codes
secondary_target_sector_codes
Credit Agreement Type
credit_agreement_type
Status
status
Maximum Cumulative Disbursements
maximum_cumulative_disbursements
Cumulative Utilization
cumulative_utilization
Cumulative Utilization Percentage
cumulative_utilization_percentage
Cumulative Loans
cumulative_loans
Claims
claims
Recoveries
recoveries

Parameter Type Sample Values
fiscal_year four digit year string 1999, 2000, 2001
guarantee_number digit and letter string 49299G001, 674-A99-DCA-001, 5200425DCA01(Terminated)
guaranteed_percentage two digit string with percentage sign 25%, 34%, 50%
country two digit string with percentage sign 25%, 34%, 50%
guarantee_start_date two digit string, forward slash, two digit string, forward slash, four digit string 09/30/2007, 03/07/2006, 11/13/2012
guarantee_end_date two digit string, forward slash, two digit string, forward slash, four digit string 03/03/2020, 05/25/2013, 04/02/2009
final_date_for_placing_loans_under_coverage two digit string, forward slash, two digit string, forward slash, four digit string 04/01/2014, 09/30/2008, 04/02/2009
primary_target_sector_code text string agriculture, energy, microfinance
secondary_target_sector_codes text string agriculture, energy, microfinance
credit_agreement_type text string Loan Guarantee, Loan Portfolio Guarantee, Portable Guarantee, Bond Guarantee
status text string active, expired
maximum_cumulative_disbursements numerical string with dollar sign $9,000,000.00, $8,333,334.00, $0.00
cumulative_utilization numerical string with dollar sign $8,714,417.00, $893,386,00, $0.00
cumulative_utilization_percentage numerical string with percentage sign 96.83%, 1.89%, 100%
cumulative_loans numerical string 1, 40, 1,666
claims numerical string with dollar sign $327,726.00, $0.00
recoveries numerical string with dollar sign $0.00, $12,265.00

Descriptions of each value can be found on the data dictionary for this dataset here.

Interact with the Data: