./us_foreign_aid_implementing

20 rows where Fiscal Year = 2023, Managing Agency Name = "Department of Defense" and Transaction Type Name = "Obligations"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: current_amount, constant_amount

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
25830 25830 7 DOD Department of Defense AFG Afghanistan 2 Obligations 2023 -14177000 -14177000
26590 26590 7 DOD Department of Defense BRB Barbados 2 Obligations 2023 733488 733488
26979 26979 7 DOD Department of Defense COL Colombia 2 Obligations 2023 2964324 2964324
27053 27053 7 DOD Department of Defense CPV Cabo Verde 2 Obligations 2023 80000 80000
27902 27902 7 DOD Department of Defense GHA Ghana 2 Obligations 2023 134800 134800
28698 28698 7 DOD Department of Defense KEN Kenya 2 Obligations 2023 223800 223800
29362 29362 7 DOD Department of Defense MEX Mexico 2 Obligations 2023 5881176 5881176
29636 29636 7 DOD Department of Defense MOZ Mozambique 2 Obligations 2023 -1000 -1000
29808 29808 7 DOD Department of Defense MYS Malaysia 2 Obligations 2023 730770 730770
29869 29869 7 DOD Department of Defense NCN North and Central America Region 2 Obligations 2023 -1000 -1000
29933 29933 7 DOD Department of Defense NGA Nigeria 2 Obligations 2023 293400 293400
30174 30174 7 DOD Department of Defense PAN Panama 2 Obligations 2023 694440 694440
31096 31096 7 DOD Department of Defense SYR Syria 2 Obligations 2023 4100000 4100000
31205 31205 7 DOD Department of Defense THA Thailand 2 Obligations 2023 -134000 -134000
31246 31246 7 DOD Department of Defense TJK Tajikistan 2 Obligations 2023 1166086 1166086
31476 31476 7 DOD Department of Defense TUR Turkey 2 Obligations 2023 13158000 13158000
31530 31530 7 DOD Department of Defense TZA Tanzania 2 Obligations 2023 151800 151800
31611 31611 7 DOD Department of Defense UKR Ukraine 2 Obligations 2023 181113305 181113305
31682 31682 7 DOD Department of Defense UZB Uzbekistan 2 Obligations 2023 521794 521794
31844 31844 7 DOD Department of Defense WLD World 2 Obligations 2023 112748000 112748000

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