USAID Development Credit Authority Guarantee Data: Loan Transactions

The USAID Loan Guarantee Transactions API is available on Data.gov

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 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.

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. USAID guarantees encourage private lenders to extend financing to underserved borrowers in new sectors and regions.

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

API URL:

http://explore.data.gov/resource/7swc-ittd.json

 

Response Format:

json, xml

 

Type:

HTTP GET

 

Authentication:

None required

 

Example Request

  1. Business Size and Primary Sector
  2. http://explore.data.gov/resource/7swc-ittd.json?business_size=1--5&business_sector=agriculture
  3. Country and Women Owned
  4. http://explore.data.gov/resource/7swc-ittd.json?country=Ecuador&womanowned=TRUE
  5. Country and First Time Borrower
  6. http://explore.data.gov/resource/7swc-ittd.json?country=Jamaica&firsttimeborrower=TRUE

Column IDs:

Guarantee Number
guarantee_number
Transaction ID
transaction_id
Country
country
Loan Amount (USD)
loan_amount_usd
Currency of Loan
currency_of_loan
Loan Start Date
loan_start_date
Loan End Date
loan_end_date
Business Sector
business_sector
Business Size
business_size
WomanOwned
womanowned
FirstTimeBorrower
firsttimeborrower
Adm1Name
adm1name
Admin1 Code
admin1_code
Place Name
place_name
Lat_PlaceName
lat_placename
Lon_PlaceName
lon_placename
Location Admin 1
location_admin_1
Crowd
Crowd

 

Data Parameters, Type, and Examples

Parameter Type Sample Values
guarantee_number digit and letter series 112-DCA-10-01B, 617-DCA-05-M1-LPG-002 (MSME), DCA617A020003
transaction_id digit series 252965, 252948
country text Kenya, Uganda, India
loan_amount_usd digit series (financial amount) 7600, 1,123.5955, 58593.75
currency_of_loan text series ZAMBIA-KWACHA, UNITED STATES - DOLLAR, MONGOLIA - TUGRIK
loan_start_date numerical date in consistant format 2/1/2011, 6/22/2011, 6/11/2009
loan_end_date numerical date in consistant format 2/3/2018, 2/3/2018, 6/7/2006
business_sector text series from list of predefined options Agriculture, Trade/Commerce, Manufacturing
business_size categories of numerical ranges N/A, 1--5, 6--10, 11--50, 51--100, >100
womanowned TRUE or FALSE TRUE, FALSE
firsttimeborrower TRUE or FALSE TRUE or FALSE
adm1name text Agdas, Piura, Bali
admin1_code admin1_code AJ04, HA11, MKD6
place_name text and numerical digits Zacapa, Region 10,Western
lat_placename digits for latitude 39.084722, .35, 18.566667
lon_placename digits for longitude 107.630833, 48.501111, -70.7
location_admin_1 crosspoint digits for full location (-3.05, -79.05), (17.964543, -77.245152)
Crowd TRUE or FALSE TRUE or FALSE

Descriptions of each value can be found on the data dictionary for this dataset: https://explore.data.gov/api/assets/7D4DBCA0-DA66-4EC2-9FAC-37D565C7BBF6

Interact with the Data: