./us_foreign_aid_implementing

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
25829 25829 7 DOD Department of Defense AFG Afghanistan 2 Obligations 2022 327564000 342548937
28291 28291 7 DOD Department of Defense HTI Haiti 2 Obligations 2022 -183000 -191372
28364 28364 7 DOD Department of Defense IDN Indonesia 2 Obligations 2022 530000 554246
28524 28524 7 DOD Department of Defense ITA Italy 2 Obligations 2022 1528000 1597901
28697 28697 7 DOD Department of Defense KEN Kenya 2 Obligations 2022 51565 53924
28908 28908 7 DOD Department of Defense LBN Lebanon 2 Obligations 2022 3045000 3184298
29361 29361 7 DOD Department of Defense MEX Mexico 2 Obligations 2022 2595990 2714748
29635 29635 7 DOD Department of Defense MOZ Mozambique 2 Obligations 2022 254000 265620
29868 29868 7 DOD Department of Defense NCN North and Central America Region 2 Obligations 2022 1655000 1730711
29932 29932 7 DOD Department of Defense NGA Nigeria 2 Obligations 2022 100000 104575
30466 30466 7 DOD Department of Defense ROU Romania 2 Obligations 2022 637000 666141
31529 31529 7 DOD Department of Defense TZA Tanzania 2 Obligations 2022 70000 73202
31610 31610 7 DOD Department of Defense UKR Ukraine 2 Obligations 2022 5863666171 6131908891
31843 31843 7 DOD Department of Defense WLD World 2 Obligations 2022 176201000 184261597

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