./us_foreign_aid_implementing

73 rows where Fiscal Year = 2021 and Managing Agency Acronym = "MCC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name

Link rowid ▼ Managing Agency ID Managing Agency Acronym Managing Agency Name Country Code Country Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
16096 16096 3 MCC Millennium Challenge Corporation BEN Benin 2 Obligations 2021 17351772 19414579
16116 16116 3 MCC Millennium Challenge Corporation BEN Benin 3 Disbursements 2021 108474415 121370045
16136 16136 3 MCC Millennium Challenge Corporation BFA Burkina Faso 2 Obligations 2021 2129958 2383171
16156 16156 3 MCC Millennium Challenge Corporation BFA Burkina Faso 3 Disbursements 2021 3160625 3536368
16176 16176 3 MCC Millennium Challenge Corporation CIV Cote d'Ivoire 2 Obligations 2021 3922049 4388309
16186 16186 3 MCC Millennium Challenge Corporation CIV Cote d'Ivoire 3 Disbursements 2021 27032428 30246086
16206 16206 3 MCC Millennium Challenge Corporation CPV Cabo Verde 2 Obligations 2021 45510 50922
16225 16225 3 MCC Millennium Challenge Corporation CPV Cabo Verde 3 Disbursements 2021 150199 168055
16234 16234 3 MCC Millennium Challenge Corporation CS-KM Kosovo 2 Obligations 2021 1583033 1771225
16243 16243 3 MCC Millennium Challenge Corporation CS-KM Kosovo 3 Disbursements 2021 10079991 11278311
16249 16249 3 MCC Millennium Challenge Corporation ETH Ethiopia 2 Obligations 2021 470611 526558
16253 16253 3 MCC Millennium Challenge Corporation ETH Ethiopia 3 Disbursements 2021 528885 591759
16271 16271 3 MCC Millennium Challenge Corporation GEO Georgia 2 Obligations 2021 313803 351108
16291 16291 3 MCC Millennium Challenge Corporation GEO Georgia 3 Disbursements 2021 577104 645711
16311 16311 3 MCC Millennium Challenge Corporation GHA Ghana 2 Obligations 2021 9081134 10160715
16331 16331 3 MCC Millennium Challenge Corporation GHA Ghana 3 Disbursements 2021 108518874 121419782
16338 16338 3 MCC Millennium Challenge Corporation GMB Gambia 2 Obligations 2021 107431 120202
16345 16345 3 MCC Millennium Challenge Corporation GMB Gambia 3 Disbursements 2021 23269 26036
16357 16357 3 MCC Millennium Challenge Corporation GTM Guatemala 2 Obligations 2021 347583 388904
16369 16369 3 MCC Millennium Challenge Corporation GTM Guatemala 3 Disbursements 2021 4165658 4660878
16420 16420 3 MCC Millennium Challenge Corporation IDN Indonesia 2 Obligations 2021 10185426 11396286
16435 16435 3 MCC Millennium Challenge Corporation IDN Indonesia 3 Disbursements 2021 953224 1066541
16439 16439 3 MCC Millennium Challenge Corporation IND India 2 Obligations 2021 0 0
16453 16453 3 MCC Millennium Challenge Corporation JOR Jordan 2 Obligations 2021 -88095 -98568
16470 16470 3 MCC Millennium Challenge Corporation KEN Kenya 2 Obligations 2021 621415 695291
16477 16477 3 MCC Millennium Challenge Corporation KEN Kenya 3 Disbursements 2021 345447 386516
16483 16483 3 MCC Millennium Challenge Corporation KIR Kiribati, Republic of 2 Obligations 2021 413599 462769
16501 16501 3 MCC Millennium Challenge Corporation LBR Liberia 2 Obligations 2021 -15987430 -17888043
16515 16515 3 MCC Millennium Challenge Corporation LBR Liberia 3 Disbursements 2021 24872462 27829341
16531 16531 3 MCC Millennium Challenge Corporation LKA Sri Lanka 2 Obligations 2021 -10623709 -11886673
16561 16561 3 MCC Millennium Challenge Corporation LSO Lesotho 2 Obligations 2021 2329692 2606650
16580 16580 3 MCC Millennium Challenge Corporation LSO Lesotho 3 Disbursements 2021 3973128 4445465
16599 16599 3 MCC Millennium Challenge Corporation MAR Morocco 2 Obligations 2021 2959688 3311541
16618 16618 3 MCC Millennium Challenge Corporation MAR Morocco 3 Disbursements 2021 116375678 130210631
16635 16635 3 MCC Millennium Challenge Corporation MDA Moldova 2 Obligations 2021 556994 623210
16651 16651 3 MCC Millennium Challenge Corporation MDA Moldova 3 Disbursements 2021 324698 363300
16689 16689 3 MCC Millennium Challenge Corporation MLI Mali 2 Obligations 2021 -42 -47
16720 16720 3 MCC Millennium Challenge Corporation MNG Mongolia 2 Obligations 2021 322735581 361102956
16739 16739 3 MCC Millennium Challenge Corporation MNG Mongolia 3 Disbursements 2021 30460097 34081245
16759 16759 3 MCC Millennium Challenge Corporation MOZ Mozambique 2 Obligations 2021 741890 830087
16778 16778 3 MCC Millennium Challenge Corporation MOZ Mozambique 3 Disbursements 2021 687306 769014
16798 16798 3 MCC Millennium Challenge Corporation MWI Malawi 2 Obligations 2021 5155067 5767910
16814 16814 3 MCC Millennium Challenge Corporation MWI Malawi 3 Disbursements 2021 2327336 2604008
16832 16832 3 MCC Millennium Challenge Corporation NAM Namibia 2 Obligations 2021 -136042 -152216
16850 16850 3 MCC Millennium Challenge Corporation NAM Namibia 3 Disbursements 2021 403265 451206
16863 16863 3 MCC Millennium Challenge Corporation NER Niger 2 Obligations 2021 4077923 4562710
16880 16880 3 MCC Millennium Challenge Corporation NER Niger 3 Disbursements 2021 79009815 88402640
16916 16916 3 MCC Millennium Challenge Corporation NPL Nepal 2 Obligations 2021 2441348 2731579
16928 16928 3 MCC Millennium Challenge Corporation NPL Nepal 3 Disbursements 2021 7158135 8009106
16945 16945 3 MCC Millennium Challenge Corporation PHL Philippines 2 Obligations 2021 -29048 -32502
16961 16961 3 MCC Millennium Challenge Corporation PHL Philippines 3 Disbursements 2021 3907 4372
16993 16993 3 MCC Millennium Challenge Corporation SEN Senegal 2 Obligations 2021 513070052 574064723
17013 17013 3 MCC Millennium Challenge Corporation SEN Senegal 3 Disbursements 2021 10519696 11770295
17019 17019 3 MCC Millennium Challenge Corporation SLB Solomon Islands 2 Obligations 2021 224618 251322
17025 17025 3 MCC Millennium Challenge Corporation SLB Solomon Islands 3 Disbursements 2021 299983 335646
17037 17037 3 MCC Millennium Challenge Corporation SLE Sierra Leone 2 Obligations 2021 -2465378 -2758469
17048 17048 3 MCC Millennium Challenge Corporation SLE Sierra Leone 3 Disbursements 2021 12423371 13900280
17067 17067 3 MCC Millennium Challenge Corporation SLV El Salvador 2 Obligations 2021 -5639677 -6310130
17086 17086 3 MCC Millennium Challenge Corporation SLV El Salvador 3 Disbursements 2021 31478182 35220362
17090 17090 3 MCC Millennium Challenge Corporation SSN Sub-Saharan Africa Region 2 Obligations 2021 189588 212126
17091 17091 3 MCC Millennium Challenge Corporation SSN Sub-Saharan Africa Region 3 Disbursements 2021 34882 39031
17110 17110 3 MCC Millennium Challenge Corporation TGO Togo 2 Obligations 2021 34132846 38190618
17119 17119 3 MCC Millennium Challenge Corporation TGO Togo 3 Disbursements 2021 375021 419603
17132 17132 3 MCC Millennium Challenge Corporation TLS Timor-Leste 2 Obligations 2021 1635843 1830315
17142 17142 3 MCC Millennium Challenge Corporation TLS Timor-Leste 3 Disbursements 2021 3737543 4181864
17152 17152 3 MCC Millennium Challenge Corporation TUN Tunisia 2 Obligations 2021 2459253 2751614
17161 17161 3 MCC Millennium Challenge Corporation TUN Tunisia 3 Disbursements 2021 2187633 2447700
17180 17180 3 MCC Millennium Challenge Corporation TZA Tanzania 2 Obligations 2021 400941 448605
17199 17199 3 MCC Millennium Challenge Corporation TZA Tanzania 3 Disbursements 2021 621575 695470
17241 17241 3 MCC Millennium Challenge Corporation WLD World 2 Obligations 2021 144011954 161132351
17262 17262 3 MCC Millennium Challenge Corporation WLD World 3 Disbursements 2021 138223598 154655864
17278 17278 3 MCC Millennium Challenge Corporation ZMB Zambia 2 Obligations 2021 360909 403816
17293 17293 3 MCC Millennium Challenge Corporation ZMB Zambia 3 Disbursements 2021 125697 140641

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "./us_foreign_aid_implementing" (
"Managing Agency ID" INTEGER,
  "Managing Agency Acronym" TEXT,
  "Managing Agency Name" TEXT,
  "Country Code" TEXT,
  "Country Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);