./us_foreign_aid_implementing

16 rows where Fiscal Year = 2006 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
32026 32026 8 ARMY Department of the Army AFG Afghanistan 2 Obligations 2006 214239654 311670059
32044 32044 8 ARMY Department of the Army AFG Afghanistan 3 Disbursements 2006 214239654 311670059
32175 32175 8 ARMY Department of the Army EGY Egypt 2 Obligations 2006 12503690 18190030
32190 32190 8 ARMY Department of the Army EGY Egypt 3 Disbursements 2006 12503690 18190030
32201 32201 8 ARMY Department of the Army EST Estonia 2 Obligations 2006 1682527 2447695
32202 32202 8 ARMY Department of the Army EST Estonia 3 Disbursements 2006 1682527 2447695
32210 32210 8 ARMY Department of the Army GEO Georgia 2 Obligations 2006 847500 1232920
32219 32219 8 ARMY Department of the Army GEO Georgia 3 Disbursements 2006 847500 1232920
32284 32284 8 ARMY Department of the Army IRQ Iraq 2 Obligations 2006 468195612 681118321
32297 32297 8 ARMY Department of the Army IRQ Iraq 3 Disbursements 2006 512347453 745349226
32328 32328 8 ARMY Department of the Army JOR Jordan 2 Obligations 2006 345350 502406
32343 32343 8 ARMY Department of the Army JOR Jordan 3 Disbursements 2006 345350 502406
32371 32371 8 ARMY Department of the Army LBN Lebanon 2 Obligations 2006 558640 812695
32379 32379 8 ARMY Department of the Army LBN Lebanon 3 Disbursements 2006 558640 812695
32525 32525 8 ARMY Department of the Army SEN Senegal 2 Obligations 2006 442950 644392
32529 32529 8 ARMY Department of the Army SEN Senegal 3 Disbursements 2006 442950 644392

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