./us_foreign_aid_implementing

8 rows where Fiscal Year = 2002 and Managing Agency Acronym = "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
32167 32167 8 ARMY Department of the Army DOM Dominican Republic 2 Obligations 2002 741760 1198658
32169 32169 8 ARMY Department of the Army DOM Dominican Republic 3 Disbursements 2002 741760 1198658
32308 32308 8 ARMY Department of the Army ISR Israel 2 Obligations 2002 14487375 23411092
32317 32317 8 ARMY Department of the Army ISR Israel 3 Disbursements 2002 14487375 23411092
32325 32325 8 ARMY Department of the Army JOR Jordan 2 Obligations 2002 78000 126045
32340 32340 8 ARMY Department of the Army JOR Jordan 3 Disbursements 2002 78000 126045
32398 32398 8 ARMY Department of the Army MAR Morocco 2 Obligations 2002 42000 67871
32413 32413 8 ARMY Department of the Army MAR Morocco 3 Disbursements 2002 42000 67871

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