IBRD Statement Of Loans - Historical Data

The International Bank for Reconstruction and Development (IBRD) loans.

@kaggle.amirhoseinmousavian_ibrd_statement_of_loans_historical_data

Table List

1 table(26.73 KB)

Zucq Nrc3

@kaggle.amirhoseinmousavian_ibrd_statement_of_loans_historical_data.zucq_nrc3

26.73 KB
1000 rows
33 columns

end_of_period End Of Period	loan_number Loan Number	region Region	country_code Country Code	country Country	borrower Borrower	guarantor_country_code Guarantor Country Code	guarantor Guarantor	loan_type Loan Type	loan_status Loan Status	interest_rate Interest Rate	project_id Project Id	project_name Project Name	original_principal_amount Original Principal Amount	disbursed_amount Disbursed Amount	repaid_to_ibrd Repaid To Ibrd	sold_3rd_party Sold 3rd Party	repaid_3rd_party Repaid 3rd Party	first_repayment_date First Repayment Date	last_repayment_date Last Repayment Date	agreement_signing_date Agreement Signing Date	board_approval_date Board Approval Date	effective_date_most_recent Effective Date Most Recent	closed_date_most_recent Closed Date Most Recent
Sat Apr 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Tue May 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Thu Jun 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Sun Jul 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Wed Aug 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Fri Sep 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Mon Oct 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Wed Nov 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Sat Dec 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)
Tue Jan 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	IBRD00010	EUROPE AND CENTRAL ASIA	FR	France	CREDIT NATIONAL	FR	France	NON POOL	Repaid	4.25	P037383	RECONSTRUCTION	250000000	250000000	38000	249962000	249962000	Sat Nov 01 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 01 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 09 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1947 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE zucq_nrc3 (
  "end_of_period" TIMESTAMP,
  "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,
  "sold_3rd_party" DOUBLE,
  "repaid_3rd_party" DOUBLE,
  "due_3rd_party" DOUBLE,
  "loans_held" DOUBLE,
  "first_repayment_date" TIMESTAMP,
  "last_repayment_date" TIMESTAMP,
  "agreement_signing_date" TIMESTAMP,
  "board_approval_date" TIMESTAMP,
  "effective_date_most_recent" TIMESTAMP,
  "closed_date_most_recent" TIMESTAMP,
  "last_disbursement_date" VARCHAR
);