Name: International Reconstruction And Development Bank
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

International Reconstruction And Development Bank

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 historical snapshots of the Statement of Loans including the latest available snapshots. The World Bank complies with all sanctions applicable to World Bank transactions.

Description of columns

End of Period	End of Period Date represents the date as of which balances are shown in the report.
Loan Number	For IBRD loans and IDA credits or grants a loan number consists of the organization prefix (IBRD/IDA) and a five-character label that uniquely identifies the loan within the organization. In IDA, all grant labels start with the letter ‘H’.
---	---
Region	Country lending is grouped into regions based on the current World Bank administrative (rather than geographic) region where project implementation takes place. The Other Region is used for loans to the IFC.
---	---
Country Code	Country Code according to the World Bank country list. Might be different from the ISO country code.
---	---
Country	Country to which loan has been issued. Loans to the IFC are included under the country “World”.
---	---
Borrower	The representative of the borrower to which the Bank loan is made.
---	---
Guarantor Country Code	Country Code of the Guarantor according to the World Bank country list. Might be different from the ISO country code.
---	---
Guarantor	The Guarantor guarantees repayment to the Bank if the borrower does not repay.
---	---
Loan Type	A type of loan/loan instrument for which distinctive accounting and/or other actions need to be performed. See Data Dictionary attached in the About section or Data Dictionary dataset available from the list of all datasets for details.
---	---
Loan Status	Status of the loan. See Data Dictionary attached in the About section or Data Dictionary dataset available from the list of all datasets for status descriptions.
---	---

The rest of the description can be found in this link

her

Tables

Ibrd Statement Of Loans Historical Data

@kaggle.alimohammedbakhiet_international_reconstruction_and_de_80f75687.ibrd_statement_of_loans_historical_data

6.62 MB
667,552 rows
33 columns

CREATE TABLE ibrd_statement_of_loans_historical_data (
  "end_of_period" VARCHAR,
  "loan_number" VARCHAR,
  "region" VARCHAR,
  "country_code" VARCHAR,
  "country" VARCHAR,
  "borrower" VARCHAR,
  "guarantor_country_code" VARCHAR,
  "guarantor" VARCHAR,
  "loan_type" VARCHAR,
  "loan_status" VARCHAR,
  "interest_rate" DOUBLE,
  "currency_of_commitment" VARCHAR,
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "original_principal_amount" DOUBLE,
  "cancelled_amount" DOUBLE,
  "undisbursed_amount" DOUBLE,
  "disbursed_amount" DOUBLE,
  "repaid_to_ibrd" DOUBLE,
  "due_to_ibrd" DOUBLE,
  "exchange_adjustment" DOUBLE,
  "borrower_s_obligation" DOUBLE  -- Borrower\u0027s Obligation,
  "sold_3rd_party" DOUBLE,
  "repaid_3rd_party" DOUBLE,
  "due_3rd_party" DOUBLE,
  "loans_held" DOUBLE,
  "first_repayment_date" VARCHAR,
  "last_repayment_date" VARCHAR,
  "agreement_signing_date" VARCHAR,
  "board_approval_date" VARCHAR,
  "effective_date_most_recent" VARCHAR  -- Effective Date (Most Recent),
  "closed_date_most_recent" VARCHAR  -- Closed Date (Most Recent),
  "last_disbursement_date" VARCHAR
);