./us_foreign_aid_implementing

8 rows where Fiscal Year = 2009 and Managing Agency Name = "Department of the Army"

✎ 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
32029 32029 8 ARMY Department of the Army AFG Afghanistan 2 Obligations 2009 548353866 752868705
32047 32047 8 ARMY Department of the Army AFG Afghanistan 3 Disbursements 2009 548353866 752868705
32094 32094 8 ARMY Department of the Army BHR Bahrain 2 Obligations 2009 568177 780085
32103 32103 8 ARMY Department of the Army BHR Bahrain 3 Disbursements 2009 568177 780085
32287 32287 8 ARMY Department of the Army IRQ Iraq 2 Obligations 2009 386031431 530006248
32300 32300 8 ARMY Department of the Army IRQ Iraq 3 Disbursements 2009 573892868 787932745
32330 32330 8 ARMY Department of the Army JOR Jordan 2 Obligations 2009 855591 1174693
32345 32345 8 ARMY Department of the Army JOR Jordan 3 Disbursements 2009 855591 1174693

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