./us_foreign_aid_implementing

7 rows where Fiscal Year = 2010, Managing Agency ID = 8 and Transaction Type ID = 2

✎ 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
32030 32030 8 ARMY Department of the Army AFG Afghanistan 2 Obligations 2010 317828467 432619548
32275 32275 8 ARMY Department of the Army HTI Haiti 2 Obligations 2010 1756304 2390635
32288 32288 8 ARMY Department of the Army IRQ Iraq 2 Obligations 2010 448253488 610150571
32331 32331 8 ARMY Department of the Army JOR Jordan 2 Obligations 2010 1045532 1423150
32403 32403 8 ARMY Department of the Army MAR Morocco 2 Obligations 2010 1196073 1628062
32468 32468 8 ARMY Department of the Army PAK Pakistan 2 Obligations 2010 13891575 18908838
32549 32549 8 ARMY Department of the Army TJK Tajikistan 2 Obligations 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
);