./us_foreign_aid_implementing

16 rows where Country Name = "India" and Managing Agency ID = 12

✎ 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
38600 38600 12 DOC Department of Commerce IND India 2 Obligations 2005 3300 4957
38601 38601 12 DOC Department of Commerce IND India 2 Obligations 2007 5000 7079
38602 38602 12 DOC Department of Commerce IND India 2 Obligations 2008 79342 110048
38603 38603 12 DOC Department of Commerce IND India 2 Obligations 2009 123000 168875
38604 38604 12 DOC Department of Commerce IND India 2 Obligations 2010 184788 251528
38605 38605 12 DOC Department of Commerce IND India 2 Obligations 2012 741700 972078
38606 38606 12 DOC Department of Commerce IND India 2 Obligations 2013 373000 480144
38607 38607 12 DOC Department of Commerce IND India 2 Obligations 2018 12000 14330
38608 38608 12 DOC Department of Commerce IND India 3 Disbursements 2005 3300 4957
38609 38609 12 DOC Department of Commerce IND India 3 Disbursements 2008 79342 110048
38610 38610 12 DOC Department of Commerce IND India 3 Disbursements 2009 123000 168875
38611 38611 12 DOC Department of Commerce IND India 3 Disbursements 2010 184788 251528
38612 38612 12 DOC Department of Commerce IND India 3 Disbursements 2012 468265 613713
38613 38613 12 DOC Department of Commerce IND India 3 Disbursements 2013 171037 220168
38614 38614 12 DOC Department of Commerce IND India 3 Disbursements 2015 73000 91340
38615 38615 12 DOC Department of Commerce IND India 3 Disbursements 2018 2300 2747

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