API Explorer

Trust Funds and FIFs

Afghanistan Reconstruction Trust Fund (ARTF) - Project Allocations and Disbursements - BETA

Data as of Dec 21, 2014

Temporal Coverage: Fiscal year 2002 - 2014


This data represents allocations from the ARTF to specific projects. This dataset is a source for the Monthly Administrator's Report on Financial Status.

Instructions:

We recommend using the API service only for datasets with over a million records. For smaller datasets, please use the JSON link in the "Actions and Tools" section to extract all records at once.

The API supports extraction of up to 1,000 records per request/page. To extract all records, we recommend using the code snippets provided in the Code Snippets tab.

Parameter guidelines:

  • Use DD-MMM-YYYY format for date fields.
  • To filter multiple values, separate them with "|". Example: Country = India|Afghanistan.
  • To filter for blank values, pass "IS NULL". Example: Country = IS NULL.
  • To filter for non-blank values, pass "IS NOT NULL". Example: Country = IS NOT NULL.
Parameters
ParameterValueDescriptionAPI FIELD NAMEData Type
Allocation Amount (in USD)Amount allocated to project from FUND/Trust Fund Program to Trust Fund Grant. Negative amounts refer to cancelations or refunds.allocation_amount_in_usdNUMBER
Application Deadline DateThe date specified in the legal agreement (or extension) after which the Bank will no longer process disbursement request applications from the Borrower.application_deadline_dateDATE
Application Deadline Year- CYCalendar year within which the Application Deadline Date falls.application_deadline_year_cyNUMBER
Application Deadline Year- FYFiscal year within which the Application Deadline Date falls. The fiscal year begins on July 1st of the previous year and runs through June 30th of the designated year.application_deadline_year_fyNUMBER
Application Deadline Year- SYSolar year within which the Application Deadline Date falls.application_deadline_year_syNUMBER
As Of DateAs Of Date represents the date as of which balances are shown in the report.as_of_dateDATE
Closing date (most recent)The date specified in the legal agreement (or extension) after which the Bank may, by notice to the borrower, terminate the right to make withdrawals from the loan account.closing_date_most_recentDATE
Closing Year- CYCalendar year within which the Closing Date falls.closing_year__cyNUMBER
Closing Year- FYFiscal year within which the Closing Date falls. The fiscal year begins on July 1st of the previous year and runs through June 30th of the designated year.closing_year__fyNUMBER
Closing Year - SYSolar year within which the Closing Date falls.closing_year__syNUMBER
Disbursed Amount (in USD)Amount disbursed from project to payee, per Grant disbursement arrangements. Negative amounts refer to cancellations or refunds.disbursed_amount_in_usdNUMBER
Effective dateThe date on which a legal agreement becomes effective, or is expected to become effective.effective_dateDATE
Effective Year- CYCalendar year within which the Effective Date falls.effective_year__cyNUMBER
Effective Year- FYFiscal year within which the Effective Date falls. The fiscal year begins on July 1st of the previous year and runs through June 30th of the designated year.effective_year__fyNUMBER
Effective Year- SYSolar year within which the Effective Date falls.effective_year_syNUMBER
FundFund/Program type.fundSTRING
Project IDA Bank project is referenced by a project ID (Pxxxxxxx). More than one loan, credit, or grant may be associated with one Project ID. Projects with no project ID represent Bank-executed work.project_idSTRING
Project NameShort descriptive project name.project_nameSTRING
Project StatusProject status. Active, or closed. Note: Closed projects may still receive applications through Application Deadline Date.project_statusSTRING
SectorCorresponding Sector/Theme.sectorSTRING
Task Team LeaderTask Team Leader for project.task_team_leaderSTRING
Transaction Posting DateAllocation or Disbursement posting date. An amount (that is not $0.00) in the Allocation Amount or Disbursement column corresponds to the date in Transaction Posting Date column.transaction_posting_dateDATE
Transaction Posting Year - CYCalendar year within which the Posting Date falls.transaction_posting_year__cyNUMBER
Transaction Posting Year - FYFiscal year within which the Posting Date falls. The fiscal year begins on July 1st of the previous year and runs through June 30th of the designated year.transaction_posting_year__fyNUMBER
Transaction Posting Year - SYSolar year within which the Posting Date falls.transaction_posting_year__syNUMBER
Trust Fund Grant NumberTrust Fund grant ID. Projects are identified by this ID.trust_fund_grant_numberSTRING
Trust Fund NumberRefers to Trustee Account. The Trustee Account is the account at the highest level in the Trust Fund hierarchy into which Contributions or other funds are received. Every Trust fund hierarchy has one Trustee Account.trust_fund_numberSTRING
Trustee Fund NameRefers to the Trustee Fund name used in the World Bank system to identify a Trustee Account.trustee_fund_nameSTRING
WindowARTF has three different funding moves: "Investment window" i.e Infrastructure, urban development, HRD etc ; "Recurrent Cost" i.e support operational cost of the grant operation agreement; and "Monitoring Agent fee".windowSTRING
Resource IDID of the associated ResourceSTRING
SelectFields that required E.g (fiscal_year|supplier_country|total_amount)STRING
TopNumber of records to fetchNUMBER
SkipSkip the records from the ascending orderNUMBER

https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&top=100&type=json

No Data Available

DS00992
World Bank Group
May 3, 2013
Apr 17, 2025
Licensing and Attribution
Creative Commons Attribution 4.0 International
Creative Commons Attribution 4.0 International
Additional Information
Time Series
Trust Fund Grant Number, Trust Fund Number
World Bank Group
Day
Other
official
No further updates planned
South Asia
transaction_posting_date, closing_date_most_recent, application_deadline_date
Query tool,API,Bulk download
English
No further updates planned
Dec 21, 2014
Apr 17, 2025
Apr 17, 2025
Scope
Afghanistan
What's in this Dataset?
3,086
29
JavaScript makes it super simple to fetch from an API endpoint.

fetch('https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&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);
});
    

async function fetchAllData(url) {
    let allData = [];
    let hasMoreData = true;
    let top = 1000;
    let skip = 0;
    while (hasMoreData) {
      const response = await fetch(`${url}&top=${top}&skip=${skip}`);
        if (!response.ok) {
            throw new Error('Network response was not ok');
        }
        const res = await response.json();
        allData = allData.concat(res);
        // Check if we received less data than requested, indicating no more data
        if (res.data.length < top) {
            hasMoreData = false;
        } else {
            skip += top;
        }
    }
    return allData;
}
let url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json';   
fetchAllData(`${url}`).then(allData => {
    // Do something with all the data
    // console.log(allData);
})
.catch(error => {
    console.error('Error:', error);
});
Python for easily work with data.

import requests
url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&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}')

import requests
def fetch_all_data():
    base_url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice'
    dataset_id = 'DS00992'
    resource_id = 'RS00922'
    top = 1000
    skip = 0
    all_data = []
    total_count = 0
    page = 1
    while True:
        url = f'{base_url}?datasetId={dataset_id}&resourceId={resource_id}&top={top}&type=json&skip={1000*(page-1)}'
        try:
            response = requests.get(url, timeout=10)
            #print(response)
            response.raise_for_status()  # Raise an exception for 4XX and 5XX status codes
            data = response.json()  # Parse the JSON response

            # Assuming the actual data is in the 'data' key of the response
            if 'data' not in data or not data['data']:  # Exit the loop if no more data is returned
                break

            if page == 1 and 'count' in data:
                total_count = data['count']  # Store the total count from the first response

            all_data.extend(data['data'])  # Add the fetched data to the list
            page += 1  # Increment the page value to get the next set of records
            #print(f'Page: {page}, Status Code: {response.status_code}')
        except requests.RequestException as e:
            print(f'Error: {e}')
            break
    return {'count': total_count, 'data': all_data}
# Fetch all data and print it
all_data = fetch_all_data()
print(all_data)
PowerShell code to extract data.

$url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&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: $_"
}

function Fetch-AllData {
    param (
        [string]$baseUrl
    )
    $allData = @()
    $top = 1000
    $skip = 0
    $hasMoreData = $true
    while ($hasMoreData) {
        $url = "$baseUrl&top=$top&skip=$skip"
        try {
            $response = Invoke-RestMethod -Uri $url -Method Get
            $allData += $response.data

            # Check if we received less data than requested, indicating no more data
            if ($response.data.Count -lt $top) {
                $hasMoreData = $false
            } else {
                $skip += $top
            }
        } catch {
            Write-Error "Error: $_"
            $hasMoreData = $false
        }
    }
    return $allData
}
$baseUrl = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json'
$allData = Fetch-AllData -baseUrl $baseUrl
# Do something with all the data
$allData | ConvertTo-Json | Write-Output
The following snippet brings data into your application.

require 'net/http'
url = URI('https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&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

require 'net/http'
require 'json'
require 'uri'
 
def fetch_all_data(base_url)
  all_data = []
  has_more_data = true
  top = 1000
  skip = 0
  while has_more_data
 
    url = URI("#{base_url}&top=#{top}&skip=#{skip}")
    response = Net::HTTP.get_response(url)
    if response.is_a?(Net::HTTPSuccess)
      begin
        data = JSON.parse(response.body)
        if data.key?('data')
          all_data.concat(data['data'])
          # Check if we received less data than requested, indicating no more data
          if data['data'].length < top
            has_more_data = false
          else
            skip += top
          end
        else
          has_more_data = false
        end
      rescue JSON::ParserError => e
        puts "JSON parsing error: #{e.message}"
        has_more_data = false
      end
    else
      puts "Error: #{response.code} - #{response.message}"
      has_more_data = false
    end
  end
  all_data
rescue StandardError => e
  puts "Error: #{e.message}"
end
base_url = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json'
all_data = fetch_all_data(base_url)
puts all_data
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/apiservice?datasetId=DS00992&resourceId=RS00922&top=100&type=json");
        Console.WriteLine(response);
    }
}

using System;
using System.Collections.Generic;
using System.Net.Http;
using System.Threading.Tasks;
using Newtonsoft.Json.Linq;
class Program
{
    static async Task Main(string[] args)
    {
        string baseUrl = "https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json";
        var allData = await FetchAllData(baseUrl);
        // Do something with all the data
        Console.WriteLine(allData);
    }
    static async Task<JArray> FetchAllData(string baseUrl)
    {
        var allData = new JArray();
        int top = 1000;
        int skip = 0;
        bool hasMoreData = true;
        using (HttpClient client = new HttpClient())
        {
            while (hasMoreData)
            {
                string url = $"{baseUrl}&top={top}&skip={skip}";
                var response = await client.GetStringAsync(url);
                var data = JArray.Parse(JObject.Parse(response)["data"].ToString());
                allData.Merge(data);
                // Check if we received less data than requested, indicating no more data
                if (data.Count < top)
                {
                    hasMoreData = false;
                }
                else
                {
                    skip += top;
                }
            }
        }
        return allData;
    }
}
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/apiservice?datasetId=DS00992&resourceId=RS00922&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());
    }
}

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import org.json.JSONArray;
import org.json.JSONObject;
public class Main {
    public static void main(String[] args) throws Exception {
        String baseUrl = "https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json";
        int top = 1000;
        int skip = 0;
        boolean hasMoreData = true;
        JSONArray allData = new JSONArray();
        while (hasMoreData) {
            String urlWithParams = baseUrl + "&top=" + top + "&skip=" + skip;
            URL url = new URL(urlWithParams);
            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();
            JSONObject jsonResponse = new JSONObject(response.toString());
            JSONArray data = jsonResponse.getJSONArray("data");
            for (int i = 0; i < data.length(); i++) {
                allData.put(data.getJSONObject(i));
            }
            // Check if we received less data than requested, indicating no more data
            if (data.length() < top) {
                hasMoreData = false;
            } else {
                skip += top;
            }
        }
        // Do something with all the data
        System.out.println(allData.toString());
    }
}
The following snippet brings data into your application.

shell "curl -X GET https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&top=100&type=json"

#!/bin/bash
top=1000
skip=0
has_more_data=true
all_data="[]"
while $has_more_data; do
    url="https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json&top=$top&skip=$skip"
    response=$(curl -s -X GET "$url")
    # Extract data from the response
    data=$(echo "$response" | jq '.data')
    # Append the new data to all_data
    all_data=$(echo "$all_data $data" | jq -s '[.[][]]')
    # Check if we received less data than requested, indicating no more data
    data_length=$(echo "$data" | jq 'length')
    if [[ "$data_length" -lt "$top" ]]; then
        has_more_data=false
    else
        skip=$((skip + top))
    fi
done
# Output all the data
echo "$all_data" | jq
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/apiservice?datasetId=DS00992&resourceId=RS00922&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;
?>
            

<?php
function fetchAllData($baseUrl) {
    $allData = [];
    $hasMoreData = true;
    $top = 1000;
    $skip = 0;
 
    while ($hasMoreData) {
        $url = "{$baseUrl}&top={$top}&skip={$skip}";
        $curl = curl_init();
        curl_setopt($curl, CURLOPT_URL, $url);
        curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
        $response = curl_exec($curl);
 
        if (curl_errno($curl)) {
            echo 'Curl error: ' . curl_error($curl);
            curl_close($curl);
            break;
        }
 
        curl_close($curl);
        $data = json_decode($response, true);
 
        if (isset($data['data'])) {
            $allData = array_merge($allData, $data['data']);
            // Check if we received less data than requested, indicating no more data
            if (count($data['data']) < $top) {
                $hasMoreData = false;
            } else {
                $skip += $top;
            }
        } else {
            $hasMoreData = false;
        }
    }
 
    return $allData;
}
 
$baseUrl = 'https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json';
$allData = fetchAllData($baseUrl);
 
print_r($allData);
Copy and paste the following to import this dataset into Stata.

clear
. import delimited "https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&top=100&type=json"

clear
local base_url "https://datacatalogapi.worldbank.org/dexapps/fone/api/apiservice?datasetId=DS00992&resourceId=RS00922&type=json"
local top 1000
local skip 0
local has_more_data 1
tempfile all_data
save `all_data', emptyok
while `has_more_data' {
    local url "`base_url'&top=`top'&skip=`skip'"
    import delimited "`url'", clear
    // Check if we received less data than requested, indicating no more data
    local n = _N
    if `n' < `top' {
        local has_more_data 0
    } else {
        local skip = `skip' + `top'
    }
    append using `all_data'
    save `all_data', replace
}
use `all_data'

GET
https://datacatalogapi.worldbank.org/dexapps/fone/api/metadata?assetId=DS00992