./us_foreign_aid_implementing

14 rows where Fiscal Year = 2010 and Managing Agency ID = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country Name, Transaction Type ID, Transaction Type Name, 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
32030 32030 8 ARMY Department of the Army AFG Afghanistan 2 Obligations 2010 317828467 432619548
32048 32048 8 ARMY Department of the Army AFG Afghanistan 3 Disbursements 2010 317828467 432619548
32275 32275 8 ARMY Department of the Army HTI Haiti 2 Obligations 2010 1756304 2390635
32276 32276 8 ARMY Department of the Army HTI Haiti 3 Disbursements 2010 1756304 2390635
32288 32288 8 ARMY Department of the Army IRQ Iraq 2 Obligations 2010 448253488 610150571
32301 32301 8 ARMY Department of the Army IRQ Iraq 3 Disbursements 2010 561137865 763805735
32331 32331 8 ARMY Department of the Army JOR Jordan 2 Obligations 2010 1045532 1423150
32346 32346 8 ARMY Department of the Army JOR Jordan 3 Disbursements 2010 1045532 1423150
32403 32403 8 ARMY Department of the Army MAR Morocco 2 Obligations 2010 1196073 1628062
32418 32418 8 ARMY Department of the Army MAR Morocco 3 Disbursements 2010 1196073 1628062
32468 32468 8 ARMY Department of the Army PAK Pakistan 2 Obligations 2010 13891575 18908838
32477 32477 8 ARMY Department of the Army PAK Pakistan 3 Disbursements 2010 13891575 18908838
32549 32549 8 ARMY Department of the Army TJK Tajikistan 2 Obligations 2010 1654003 2251385
32550 32550 8 ARMY Department of the Army TJK Tajikistan 3 Disbursements 2010 1654003 2251385

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