./us_foreign_aid_implementing

6 rows where Fiscal Year = 2006 and Managing Agency Name = "Department of the Navy"

✎ 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
52615 52615 31 NAVY Department of the Navy COL Colombia 2 Obligations 2006 2718768 3955190
52619 52619 31 NAVY Department of the Navy COL Colombia 3 Disbursements 2006 2718768 3955190
52663 52663 31 NAVY Department of the Navy GRC Greece 2 Obligations 2006 31182600 45363604
52669 52669 31 NAVY Department of the Navy GRC Greece 3 Disbursements 2006 31182600 45363604
52791 52791 31 NAVY Department of the Navy PAK Pakistan 2 Obligations 2006 4166500 6061312
52797 52797 31 NAVY Department of the Navy PAK Pakistan 3 Disbursements 2006 4166500 6061312

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