./us_foreign_aid_implementing

40 rows where Country Name = "India" and Managing Agency ID = 7

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
28384 28384 7 DOD Department of Defense IND India 2 Obligations 2001 3063386 5028204
28385 28385 7 DOD Department of Defense IND India 2 Obligations 2002 1812000 2928129
28386 28386 7 DOD Department of Defense IND India 2 Obligations 2003 1000000 1585531
28387 28387 7 DOD Department of Defense IND India 2 Obligations 2004 1354000 2095636
28388 28388 7 DOD Department of Defense IND India 2 Obligations 2005 8584000 12893427
28389 28389 7 DOD Department of Defense IND India 2 Obligations 2006 1762000 2563310
28390 28390 7 DOD Department of Defense IND India 2 Obligations 2007 2115000 2994410
28391 28391 7 DOD Department of Defense IND India 2 Obligations 2008 1647300 2284808
28392 28392 7 DOD Department of Defense IND India 2 Obligations 2009 1625659 2231967
28393 28393 7 DOD Department of Defense IND India 2 Obligations 2010 1334495 1816479
28394 28394 7 DOD Department of Defense IND India 2 Obligations 2011 3212314 4286478
28395 28395 7 DOD Department of Defense IND India 2 Obligations 2012 372571 488294
28396 28396 7 DOD Department of Defense IND India 2 Obligations 2013 534507 688045
28397 28397 7 DOD Department of Defense IND India 2 Obligations 2014 3728096 4713014
28398 28398 7 DOD Department of Defense IND India 2 Obligations 2015 4066547 5088186
28399 28399 7 DOD Department of Defense IND India 2 Obligations 2016 535479 664693
28400 28400 7 DOD Department of Defense IND India 2 Obligations 2017 1627427 1986601
28401 28401 7 DOD Department of Defense IND India 2 Obligations 2018 1767830 2111123
28402 28402 7 DOD Department of Defense IND India 2 Obligations 2019 4174382 4894505
28403 28403 7 DOD Department of Defense IND India 2 Obligations 2020 13593518 15733012
28404 28404 7 DOD Department of Defense IND India 3 Disbursements 2001 3063386 5028204
28405 28405 7 DOD Department of Defense IND India 3 Disbursements 2002 1812000 2928129
28406 28406 7 DOD Department of Defense IND India 3 Disbursements 2003 1000000 1585531
28407 28407 7 DOD Department of Defense IND India 3 Disbursements 2004 1354000 2095636
28408 28408 7 DOD Department of Defense IND India 3 Disbursements 2005 8482417 12740847
28409 28409 7 DOD Department of Defense IND India 3 Disbursements 2006 1449224 2108292
28410 28410 7 DOD Department of Defense IND India 3 Disbursements 2007 1880728 2662729
28411 28411 7 DOD Department of Defense IND India 3 Disbursements 2008 1885304 2614919
28412 28412 7 DOD Department of Defense IND India 3 Disbursements 2009 1648506 2263335
28413 28413 7 DOD Department of Defense IND India 3 Disbursements 2010 1518741 2067269
28414 28414 7 DOD Department of Defense IND India 3 Disbursements 2011 3227529 4306782
28415 28415 7 DOD Department of Defense IND India 3 Disbursements 2012 328939 431110
28416 28416 7 DOD Department of Defense IND India 3 Disbursements 2013 538879 693673
28417 28417 7 DOD Department of Defense IND India 3 Disbursements 2014 1282213 1620958
28418 28418 7 DOD Department of Defense IND India 3 Disbursements 2015 763933 955856
28419 28419 7 DOD Department of Defense IND India 3 Disbursements 2016 535479 664693
28420 28420 7 DOD Department of Defense IND India 3 Disbursements 2017 1633264 1993726
28421 28421 7 DOD Department of Defense IND India 3 Disbursements 2018 1761994 2104154
28422 28422 7 DOD Department of Defense IND India 3 Disbursements 2019 4174382 4894505
28423 28423 7 DOD Department of Defense IND India 3 Disbursements 2020 13593518 15733012

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