./us_foreign_aid_implementing

6 rows where Fiscal Year = 2008, Managing Agency Name = "Department of the Army" and Transaction Type Name = "Obligations"

✎ 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
32028 32028 8 ARMY Department of the Army AFG Afghanistan 2 Obligations 2008 485301118 673113368
32070 32070 8 ARMY Department of the Army ARM Armenia 2 Obligations 2008 174200 241615
32093 32093 8 ARMY Department of the Army BHR Bahrain 2 Obligations 2008 18000 24966
32177 32177 8 ARMY Department of the Army EGY Egypt 2 Obligations 2008 4191533 5813662
32286 32286 8 ARMY Department of the Army IRQ Iraq 2 Obligations 2008 1006262639 1395687766
32402 32402 8 ARMY Department of the Army MAR Morocco 2 Obligations 2008 6621780 9184419

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