./us_foreign_aid_implementing

12 rows where Fiscal Year = 2007 and Managing Agency Name = "Department of Justice"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country Name, Transaction Type ID, Transaction Type Name

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
36345 36345 10 DOJ Department of Justice IDN Indonesia 2 Obligations 2007 8139786 11524282
36355 36355 10 DOJ Department of Justice IDN Indonesia 3 Disbursements 2007 64650 91532
36539 36539 10 DOJ Department of Justice MDA Moldova 2 Obligations 2007 1871177 2649205
36546 36546 10 DOJ Department of Justice MDA Moldova 3 Disbursements 2007 107299 151914
36623 36623 10 DOJ Department of Justice MWI Malawi 2 Obligations 2007 2219495 3142354
36626 36626 10 DOJ Department of Justice MWI Malawi 3 Disbursements 2007 1130864 1601072
37035 37035 10 DOJ Department of Justice TZA Tanzania 2 Obligations 2007 514251 728075
37042 37042 10 DOJ Department of Justice TZA Tanzania 3 Disbursements 2007 11134 15763
37048 37048 10 DOJ Department of Justice UGA Uganda 2 Obligations 2007 634978 898999
37056 37056 10 DOJ Department of Justice UGA Uganda 3 Disbursements 2007 32803 46442
37063 37063 10 DOJ Department of Justice UKR Ukraine 2 Obligations 2007 1295277 1833849
37071 37071 10 DOJ Department of Justice UKR Ukraine 3 Disbursements 2007 446529 632194

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