./us_foreign_aid_implementing

9 rows where Fiscal Year = 2008, Managing Agency Name = "Department of Transportation" 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
43423 43423 15 DOT Department of Transportation AFG Afghanistan 2 Obligations 2008 914473 1268375
43467 43467 15 DOT Department of Transportation BRB Barbados 2 Obligations 2008 25000 34675
43471 43471 15 DOT Department of Transportation CAN Canada 2 Obligations 2008 106672 147954
43487 43487 15 DOT Department of Transportation CHN China (P.R.C.) 2 Obligations 2008 190922 264809
43516 43516 15 DOT Department of Transportation CRN Caribbean Region 2 Obligations 2008 87073 120771
43583 43583 15 DOT Department of Transportation IRQ Iraq 2 Obligations 2008 694676 963517
43622 43622 15 DOT Department of Transportation MEX Mexico 2 Obligations 2008 15000 20805
43651 43651 15 DOT Department of Transportation NZL New Zealand 2 Obligations 2008 31500 43691
43731 43731 15 DOT Department of Transportation WLD World 2 Obligations 2008 453000 628312

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