./us_foreign_aid_implementing

6 rows where Fiscal Year = 2007, Managing Agency Name = "Department of Justice" and Transaction Type Name = "Disbursements"

✎ 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
36355 36355 10 DOJ Department of Justice IDN Indonesia 3 Disbursements 2007 64650 91532
36546 36546 10 DOJ Department of Justice MDA Moldova 3 Disbursements 2007 107299 151914
36626 36626 10 DOJ Department of Justice MWI Malawi 3 Disbursements 2007 1130864 1601072
37042 37042 10 DOJ Department of Justice TZA Tanzania 3 Disbursements 2007 11134 15763
37056 37056 10 DOJ Department of Justice UGA Uganda 3 Disbursements 2007 32803 46442
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
);