./us_foreign_aid_implementing

13 rows where Country Name = "Philippines" and Managing Agency ID = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount, constant_amount

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
36765 36765 10 DOJ Department of Justice PHL Philippines 2 Obligations 2008 35571 49337
36766 36766 10 DOJ Department of Justice PHL Philippines 2 Obligations 2009 26126 35870
36767 36767 10 DOJ Department of Justice PHL Philippines 2 Obligations 2010 107350 146122
36768 36768 10 DOJ Department of Justice PHL Philippines 2 Obligations 2011 91156 121638
36769 36769 10 DOJ Department of Justice PHL Philippines 2 Obligations 2012 49972 65493
36770 36770 10 DOJ Department of Justice PHL Philippines 2 Obligations 2013 44652 57478
36771 36771 10 DOJ Department of Justice PHL Philippines 2 Obligations 2014 -2910 -3678
36772 36772 10 DOJ Department of Justice PHL Philippines 3 Disbursements 2008 35571 49337
36773 36773 10 DOJ Department of Justice PHL Philippines 3 Disbursements 2009 26126 35870
36774 36774 10 DOJ Department of Justice PHL Philippines 3 Disbursements 2010 107312 146071
36775 36775 10 DOJ Department of Justice PHL Philippines 3 Disbursements 2011 91156 121638
36776 36776 10 DOJ Department of Justice PHL Philippines 3 Disbursements 2012 25490 33407
36777 36777 10 DOJ Department of Justice PHL Philippines 3 Disbursements 2013 41742 53733

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