./us_foreign_aid_implementing

4 rows where Managing Agency Name = "United States Institute of Peace" 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
52194 52194 25 USIP United States Institute of Peace IRQ Iraq 3 Disbursements 2004 3000000 4643210
52195 52195 25 USIP United States Institute of Peace IRQ Iraq 3 Disbursements 2005 5000000 7510151
52196 52196 25 USIP United States Institute of Peace IRQ Iraq 3 Disbursements 2006 1540000 2240350
52197 52197 25 USIP United States Institute of Peace IRQ Iraq 3 Disbursements 2007 500000 707898

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