./us_foreign_aid_implementing

170 rows where Fiscal Year = 2017 and Managing Agency Acronym = "DOI"

✎ 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
32586 32586 9 DOI Department of the Interior AGO Angola 2 Obligations 2017 321 392
32631 32631 9 DOI Department of the Interior ARG Argentina 3 Disbursements 2017 74705 91192
32656 32656 9 DOI Department of the Interior ATG Antigua and Barbuda 2 Obligations 2017 135287 165145
32693 32693 9 DOI Department of the Interior BGD Bangladesh 2 Obligations 2017 72899 88987
32710 32710 9 DOI Department of the Interior BGD Bangladesh 3 Disbursements 2017 23100 28198
32734 32734 9 DOI Department of the Interior BHS Bahamas 3 Disbursements 2017 -53605 -65436
32750 32750 9 DOI Department of the Interior BLZ Belize 2 Obligations 2017 112026 136750
32767 32767 9 DOI Department of the Interior BLZ Belize 3 Disbursements 2017 -88161 -107617
32798 32798 9 DOI Department of the Interior BOL Bolivia 3 Disbursements 2017 -49886 -60896
32818 32818 9 DOI Department of the Interior BRA Brazil 2 Obligations 2017 -9900 -12085
32838 32838 9 DOI Department of the Interior BRA Brazil 3 Disbursements 2017 -30400 -37109
32855 32855 9 DOI Department of the Interior BRB Barbados 2 Obligations 2017 31000 37842
32869 32869 9 DOI Department of the Interior BRB Barbados 3 Disbursements 2017 31000 37842
32877 32877 9 DOI Department of the Interior BTN Bhutan 2 Obligations 2017 11647 14217
32886 32886 9 DOI Department of the Interior BTN Bhutan 3 Disbursements 2017 12125 14801
32909 32909 9 DOI Department of the Interior CAF Central African Republic 2 Obligations 2017 15145 18488
32940 32940 9 DOI Department of the Interior CAN Canada 2 Obligations 2017 31952475 39004388
32959 32959 9 DOI Department of the Interior CAN Canada 3 Disbursements 2017 5764903 7037214
32989 32989 9 DOI Department of the Interior CHL Chile 3 Disbursements 2017 -79078 -96529
33010 33010 9 DOI Department of the Interior CHN China (P.R.C.) 2 Obligations 2017 73319 89501
33030 33030 9 DOI Department of the Interior CHN China (P.R.C.) 3 Disbursements 2017 15431 18835
33050 33050 9 DOI Department of the Interior CIV Cote d'Ivoire 2 Obligations 2017 118526 144685
33068 33068 9 DOI Department of the Interior CIV Cote d'Ivoire 3 Disbursements 2017 48521 59230
33089 33089 9 DOI Department of the Interior CMR Cameroon 2 Obligations 2017 517576 631804
33109 33109 9 DOI Department of the Interior CMR Cameroon 3 Disbursements 2017 -1723740 -2104170
33125 33125 9 DOI Department of the Interior CNA Central America Region 2 Obligations 2017 370538 452316
33137 33137 9 DOI Department of the Interior CNA Central America Region 3 Disbursements 2017 -5644 -6890
33158 33158 9 DOI Department of the Interior COD Congo (Kinshasa) 2 Obligations 2017 550422 671901
33179 33179 9 DOI Department of the Interior COD Congo (Kinshasa) 3 Disbursements 2017 -775 -943
33201 33201 9 DOI Department of the Interior COG Congo (Brazzaville) 2 Obligations 2017 145030 177039
33221 33221 9 DOI Department of the Interior COG Congo (Brazzaville) 3 Disbursements 2017 64692 78970
33242 33242 9 DOI Department of the Interior COL Colombia 2 Obligations 2017 51083 62357
33263 33263 9 DOI Department of the Interior COL Colombia 3 Disbursements 2017 -84052 -102602
33278 33278 9 DOI Department of the Interior CPV Cabo Verde 2 Obligations 2017 171639 209520
33292 33292 9 DOI Department of the Interior CPV Cabo Verde 3 Disbursements 2017 171639 209520
33313 33313 9 DOI Department of the Interior CRI Costa Rica 2 Obligations 2017 276079 337010
33334 33334 9 DOI Department of the Interior CRI Costa Rica 3 Disbursements 2017 1790 2186
33352 33352 9 DOI Department of the Interior CRN Caribbean Region 2 Obligations 2017 304542 371754
33368 33368 9 DOI Department of the Interior CRN Caribbean Region 3 Disbursements 2017 -66023 -80594
33391 33391 9 DOI Department of the Interior DOM Dominican Republic 2 Obligations 2017 191910 234264
33409 33409 9 DOI Department of the Interior DOM Dominican Republic 3 Disbursements 2017 -72334 -88298
33422 33422 9 DOI Department of the Interior ECN Eastern and Central Africa Region 2 Obligations 2017 92696 113154
33424 33424 9 DOI Department of the Interior ECN Eastern and Central Africa Region 3 Disbursements 2017 -20000 -24414
33445 33445 9 DOI Department of the Interior ECU Ecuador 2 Obligations 2017 12505 15265
33465 33465 9 DOI Department of the Interior ECU Ecuador 3 Disbursements 2017 -111462 -136061
33483 33483 9 DOI Department of the Interior ESP Spain 2 Obligations 2017 197327 240876
33492 33492 9 DOI Department of the Interior ESP Spain 3 Disbursements 2017 -17430 -21277
33522 33522 9 DOI Department of the Interior FJI Fiji 2 Obligations 2017 36447 44491
33529 33529 9 DOI Department of the Interior FJI Fiji 3 Disbursements 2017 27335 33368
33546 33546 9 DOI Department of the Interior FSM Micronesia, Federated States of 2 Obligations 2017 107524304 131254920
33569 33569 9 DOI Department of the Interior FSM Micronesia, Federated States of 3 Disbursements 2017 79184319 96660298
33591 33591 9 DOI Department of the Interior GAB Gabon 2 Obligations 2017 605407 739019
33610 33610 9 DOI Department of the Interior GAB Gabon 3 Disbursements 2017 587562 717237
33619 33619 9 DOI Department of the Interior GEO Georgia 2 Obligations 2017 27 34
33631 33631 9 DOI Department of the Interior GHA Ghana 2 Obligations 2017 43503 53105
33645 33645 9 DOI Department of the Interior GHA Ghana 3 Disbursements 2017 -9800 -11963
33663 33663 9 DOI Department of the Interior GIN Guinea 2 Obligations 2017 171787 209700
33678 33678 9 DOI Department of the Interior GIN Guinea 3 Disbursements 2017 73740 90014
33688 33688 9 DOI Department of the Interior GNB Guinea-Bissau 2 Obligations 2017 18953 23136
33694 33694 9 DOI Department of the Interior GNB Guinea-Bissau 3 Disbursements 2017 3439 4198
33705 33705 9 DOI Department of the Interior GNQ Equatorial Guinea 2 Obligations 2017 48555 59272
33719 33719 9 DOI Department of the Interior GNQ Equatorial Guinea 3 Disbursements 2017 97541 119069
33748 33748 9 DOI Department of the Interior GTM Guatemala 2 Obligations 2017 370040 451708
33769 33769 9 DOI Department of the Interior GTM Guatemala 3 Disbursements 2017 -73298 -89477
33794 33794 9 DOI Department of the Interior HND Honduras 2 Obligations 2017 225842 275686
33808 33808 9 DOI Department of the Interior HND Honduras 3 Disbursements 2017 166271 202967
33839 33839 9 DOI Department of the Interior IDN Indonesia 2 Obligations 2017 800970 977743
33861 33861 9 DOI Department of the Interior IDN Indonesia 3 Disbursements 2017 107077 130706
33883 33883 9 DOI Department of the Interior IND India 2 Obligations 2017 858958 1048527
33905 33905 9 DOI Department of the Interior IND India 3 Disbursements 2017 72356 88325
33939 33939 9 DOI Department of the Interior JAM Jamaica 3 Disbursements 2017 11796 14399
33947 33947 9 DOI Department of the Interior JPN Japan 2 Obligations 2017 42500 51880
33953 33953 9 DOI Department of the Interior KAZ Kazakhstan 2 Obligations 2017 54 66
33958 33958 9 DOI Department of the Interior KAZ Kazakhstan 3 Disbursements 2017 0 0
33980 33980 9 DOI Department of the Interior KEN Kenya 2 Obligations 2017 490503 598758
34000 34000 9 DOI Department of the Interior KEN Kenya 3 Disbursements 2017 -282479 -344822
34007 34007 9 DOI Department of the Interior KGZ Kyrgyzstan 2 Obligations 2017 15145 18488
34024 34024 9 DOI Department of the Interior KHM Cambodia 2 Obligations 2017 402798 491695
34045 34045 9 DOI Department of the Interior KHM Cambodia 3 Disbursements 2017 -283202 -345705
34080 34080 9 DOI Department of the Interior LAO Laos 2 Obligations 2017 191791 234120
34100 34100 9 DOI Department of the Interior LAO Laos 3 Disbursements 2017 22865 27911
34120 34120 9 DOI Department of the Interior LBR Liberia 2 Obligations 2017 122133 149087
34140 34140 9 DOI Department of the Interior LBR Liberia 3 Disbursements 2017 468487 571883
34154 34154 9 DOI Department of the Interior LCA St. Lucia 3 Disbursements 2017 7373 9000
34190 34190 9 DOI Department of the Interior LCN Latin America and Caribbean Region 3 Disbursements 2017 -110229 -134558
34209 34209 9 DOI Department of the Interior LKA Sri Lanka 2 Obligations 2017 42349 51696
34228 34228 9 DOI Department of the Interior LKA Sri Lanka 3 Disbursements 2017 25000 30518
34236 34236 9 DOI Department of the Interior MAR Morocco 2 Obligations 2017 25000 30518
34244 34244 9 DOI Department of the Interior MAR Morocco 3 Disbursements 2017 1319 1610
34253 34253 9 DOI Department of the Interior MDG Madagascar 2 Obligations 2017 144784 176738
34262 34262 9 DOI Department of the Interior MDG Madagascar 3 Disbursements 2017 53797 65671
34282 34282 9 DOI Department of the Interior MEX Mexico 2 Obligations 2017 2941153 3590268
34304 34304 9 DOI Department of the Interior MEX Mexico 3 Disbursements 2017 -836050 -1020572
34327 34327 9 DOI Department of the Interior MHL Marshall Islands 2 Obligations 2017 70170291 85656875
34350 34350 9 DOI Department of the Interior MHL Marshall Islands 3 Disbursements 2017 57355118 70013393
34365 34365 9 DOI Department of the Interior MLI Mali 2 Obligations 2017 4695 5731
34389 34389 9 DOI Department of the Interior MMR Burma (Myanmar) 2 Obligations 2017 265460 324048
34406 34406 9 DOI Department of the Interior MMR Burma (Myanmar) 3 Disbursements 2017 318874 389247
34423 34423 9 DOI Department of the Interior MOZ Mozambique 2 Obligations 2017 74634 91106
34435 34435 9 DOI Department of the Interior MOZ Mozambique 3 Disbursements 2017 -46999 -57372

Next page

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
);