./us_foreign_aid_implementing

42 rows where Country Code = "COL" 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
26959 26959 7 DOD Department of Defense COL Colombia 2 Obligations 2001 191246000 313908824
26960 26960 7 DOD Department of Defense COL Colombia 2 Obligations 2002 120323000 194437763
26961 26961 7 DOD Department of Defense COL Colombia 2 Obligations 2003 193118000 306194496
26962 26962 7 DOD Department of Defense COL Colombia 2 Obligations 2004 282324000 436963239
26963 26963 7 DOD Department of Defense COL Colombia 2 Obligations 2005 256888000 385853552
26964 26964 7 DOD Department of Defense COL Colombia 2 Obligations 2006 231263000 336435161
26965 26965 7 DOD Department of Defense COL Colombia 2 Obligations 2007 216502000 306522839
26966 26966 7 DOD Department of Defense COL Colombia 2 Obligations 2008 173848000 241127433
26967 26967 7 DOD Department of Defense COL Colombia 2 Obligations 2009 184751000 253655996
26968 26968 7 DOD Department of Defense COL Colombia 2 Obligations 2010 185844000 252965846
26969 26969 7 DOD Department of Defense COL Colombia 2 Obligations 2011 161629933 215677371
26970 26970 7 DOD Department of Defense COL Colombia 2 Obligations 2012 59897224 78501763
26971 26971 7 DOD Department of Defense COL Colombia 2 Obligations 2013 61714836 79442477
26972 26972 7 DOD Department of Defense COL Colombia 2 Obligations 2014 46954882 59359804
26973 26973 7 DOD Department of Defense COL Colombia 2 Obligations 2015 49727309 62220302
26974 26974 7 DOD Department of Defense COL Colombia 2 Obligations 2016 73430409 91149582
26975 26975 7 DOD Department of Defense COL Colombia 2 Obligations 2017 72236393 88178966
26976 26976 7 DOD Department of Defense COL Colombia 2 Obligations 2018 46379901 55386366
26977 26977 7 DOD Department of Defense COL Colombia 2 Obligations 2019 7902558 9265824
26978 26978 7 DOD Department of Defense COL Colombia 2 Obligations 2020 2171111 2512824
26979 26979 7 DOD Department of Defense COL Colombia 2 Obligations 2023 2964324 2964324
26980 26980 7 DOD Department of Defense COL Colombia 3 Disbursements 2001 191246000 313908824
26981 26981 7 DOD Department of Defense COL Colombia 3 Disbursements 2002 120323000 194437763
26982 26982 7 DOD Department of Defense COL Colombia 3 Disbursements 2003 193118000 306194496
26983 26983 7 DOD Department of Defense COL Colombia 3 Disbursements 2004 282324000 436963239
26984 26984 7 DOD Department of Defense COL Colombia 3 Disbursements 2005 256888000 385853552
26985 26985 7 DOD Department of Defense COL Colombia 3 Disbursements 2006 231263000 336435161
26986 26986 7 DOD Department of Defense COL Colombia 3 Disbursements 2007 216502000 306522839
26987 26987 7 DOD Department of Defense COL Colombia 3 Disbursements 2008 173848000 241127433
26988 26988 7 DOD Department of Defense COL Colombia 3 Disbursements 2009 184751000 253655996
26989 26989 7 DOD Department of Defense COL Colombia 3 Disbursements 2010 185844000 252965846
26990 26990 7 DOD Department of Defense COL Colombia 3 Disbursements 2011 161411502 215385899
26991 26991 7 DOD Department of Defense COL Colombia 3 Disbursements 2012 59909265 78517544
26992 26992 7 DOD Department of Defense COL Colombia 3 Disbursements 2013 61623145 79324448
26993 26993 7 DOD Department of Defense COL Colombia 3 Disbursements 2014 49185222 62179370
26994 26994 7 DOD Department of Defense COL Colombia 3 Disbursements 2015 49834926 62354956
26995 26995 7 DOD Department of Defense COL Colombia 3 Disbursements 2016 73246893 90921783
26996 26996 7 DOD Department of Defense COL Colombia 3 Disbursements 2017 72128218 88046916
26997 26997 7 DOD Department of Defense COL Colombia 3 Disbursements 2018 46250398 55231715
26998 26998 7 DOD Department of Defense COL Colombia 3 Disbursements 2019 7676212 9000431
26999 26999 7 DOD Department of Defense COL Colombia 3 Disbursements 2020 2225995 2576346
27000 27000 7 DOD Department of Defense COL Colombia 3 Disbursements 2023 2964324 2964324

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