API Explorer

IBRD Loans Summary by Status

Data as of Oct 31, 2024

The International Bank for Reconstruction and Development (IBRD) loans are public and publicly guaranteed debt extended by the World Bank Group. IBRD loans are made to, or guaranteed by, countries that are members of IBRD. IBRD may also make loans to IFC. IBRD lends at market rates. Data are in U.S. dollars calculated using historical rates. This dataset contains the latest available snapshot of the Statement of Loans. The World Bank complies with all sanctions applicable to World Bank transactions.

Important Note

We recommend users to adopt API service option only for datasets exceeding a million records. For other datasets, kindly use the JSON link available on the "Actions and Tools" section which enables extraction of all the records at once.

Parameters

Parameter	Description	API FIELD NAME	Data Type
Loan Status	Status of the loan.	loan_status	STRING
Original Principal Amount (US$)	The original US dollar amount of the loan that is committed and approved.	original_principal_amount	NUMBER
Cancelled Amount (US$)	The portion of the undisbursed balance which has been cancelled (i.e. no longer available for future disbursement). Cancellations include terminations (where approved loan agreements were never signed).	cancelled_amount	NUMBER
Undisbursed Amount (US$)	The amount of a loan commitment that is still available to be drawn down. These currency amounts have been converted to US dollars at the exchange rates applicable at the End of Period date.	undisbursed_amount	NUMBER
Disbursed Amount (US$)	The amount that has been disbursed from a loan commitment in equivalent US dollars calculated at the exchange rate on the value date of the individual disbursements.	disbursed_amount	NUMBER
Repaid to IBRD (US$)	Total principal amounts paid or prepaid to IBRD in US dollars, calculated at the exchange rate on the value date of the individual repayments.	repaid_to_ibrd	NUMBER
Due to IBRD (US$)	Where the exchange adjustment is shown separately, this is the amount disbursed and outstanding expressed as a stock of debt in historical US Dollars. Otherwise, this is the amount due and outstanding as of the End of Period date.	due_to_ibrd	NUMBER
Dataset ID	ID of the associated Dataset		STRING
Top	Number of records to fetch		NUMBER
Skip	Skip the records from the ascending order		NUMBER

Please Note:

This API will support up to a maximum of 1000 records per request / page.
The date format for all date fields should be DD-MMM-YYYY.
Selection will allow for multiple parameters E.g (Country = India|Afghanistan).
The filters for blank and non-blank should be IS NULL and IS NOT NULL E.g (Country = IS NULL, Country = IS NOT NULL)

Dataset Identifier

DS01535

Data Provided By

World Bank Group

Owner

Finances One

Date Created

Jun 3, 2024

Last Updated

Nov 28, 2024

Licensing and Attribution

License

Creative Commons Attribution 4.0 International

Additional Information

Type

Time Series

Row Label

Loan,Guarantee

Source

World Bank Group

Periodicity

Month

Granularity

Other

Provenance

official

Update Frequency

Monthly

Economy Coverage

World

Range Column

end_of_period, board_approval_date

General Access Options

Query tool,API,Mobile App,Bulk download

Language

English

Update Schedule

By 10th business day of each month

Data As Of

Oct 31, 2024

Data Last Updated

Nov 28, 2024

Metadata Last Updated

Nov 14, 2024

Scope

Institution

IBRD

Topics

CategoryLoans and Credits

Tags

JavaScript makes it super simple to fetch from an API endpoint.

fetch('https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json')
    .then(response => {
        if (!response.ok) {
            throw new Error('');
        }
        return response.json();
    })
    .then(data => {
        // Do something with the response data
        // console.log(data);
    })
    .catch(error => {
        console.error('Error:', error);
    });

Python for easily work with data.

import requests
url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json'
try:
    response = requests.get(url)
    response.raise_for_status()  # Raise an exception for 4XX and 5XX status codes
    data = response.json()  # Parse the JSON response
    print(data)  # Print the response data
except requests.RequestException as e:
    print(f'Error: {e}')

PowerShell code to extract data.

$url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json'
try {
    $response = Invoke-RestMethod -Uri $url -Method Get
    # Print the response
    Write-Output $response
} catch {
    # Print error message if request fails
    Write-Error "Error: $_"
}

The following snippet brings data into your application.

require 'net/http'
url = URI('https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json')
begin
response = Net::HTTP.get_response(url)
if response.is_a?(Net::HTTPSuccess)
    puts response.body
else
    puts "Error: #{response.code} - #{response.message}"
end
rescue StandardError => e
puts "Error: #{e.message}"
end

Below code that makes usage with .NET more natural.

using System;
using System.Net.Http;
using System.Threading.Tasks;
class Program
{
    static async Task Main(string[] args)
    {
        var response = await new HttpClient().GetStringAsync("https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json");
        Console.WriteLine(response);
    }
}

JAVA for easily work with data.

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
public class Main {
    public static void main(String[] args) throws Exception {
        URL url = new URL("https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json");
        HttpURLConnection connection = (HttpURLConnection) url.openConnection();
        connection.setRequestMethod("GET");
        BufferedReader reader = new BufferedReader(new InputStreamReader(connection.getInputStream()));
        String line;
        StringBuffer response = new StringBuffer();
        while ((line = reader.readLine()) != null) {
            response.append(line);
        }
        reader.close();
        System.out.println(response.toString());
    }
}

The following snippet brings data into your application.

shell "curl -X GET https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json"

PHP code to brings the data.

<?php
// Specify the URL you want to send the GET request to
$url = "https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json";
// Initialize cURL session
$curl = curl_init();
// Set the cURL options
curl_setopt($curl, CURLOPT_URL, $url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
// Execute cURL session
$response = curl_exec($curl);
// Close cURL session
curl_close($curl);
// Print the response
echo $response;
?>

Copy and paste the following to import this dataset into Stata.

clear
. import delimited "https://datacatalogapi.worldbank.org/dexapps/fone/api/view?viewId=DS01535&top=100&type=json"

API Explorer

IBRD Loans Summary by Status

Please Note:

Request URL

Response Body

Response Code