./us_foreign_aid_implementing

18 rows where Country Code = "COL" and Fiscal Year = 2001

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Managing Agency ID, Managing Agency Acronym, Managing Agency Name, Transaction Type ID, Transaction Type Name, 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
1333 1333 1 USAID U.S. Agency for International Development COL Colombia 2 Obligations 2001 5531611 9079519
1357 1357 1 USAID U.S. Agency for International Development COL Colombia 3 Disbursements 2001 22737843 37321615
9031 9031 2 STATE Department of State COL Colombia 2 Obligations 2001 59868362 98267193
9055 9055 2 STATE Department of State COL Colombia 3 Disbursements 2001 57376866 94177681
20085 20085 5 AGR Department of Agriculture COL Colombia 2 Obligations 2001 2658898 4364283
23058 23058 6 HHS Department of Health and Human Services COL Colombia 2 Obligations 2001 50000 82069
23076 23076 6 HHS Department of Health and Human Services COL Colombia 3 Disbursements 2001 50000 82069
26959 26959 7 DOD Department of Defense COL Colombia 2 Obligations 2001 191246000 313908824
26980 26980 7 DOD Department of Defense COL Colombia 3 Disbursements 2001 191246000 313908824
37327 37327 11 DOL Department of Labor COL Colombia 2 Obligations 2001 800000 1313110
47583 47583 17 TDA Trade and Development Agency COL Colombia 2 Obligations 2001 768134 1260806
47601 47601 17 TDA Trade and Development Agency COL Colombia 3 Disbursements 2001 768134 1260806
49888 49888 18 IAF Inter-American Foundation COL Colombia 2 Obligations 2001 1595 2618
49909 49909 18 IAF Inter-American Foundation COL Colombia 3 Disbursements 2001 1595 2618
52612 52612 31 NAVY Department of the Navy COL Colombia 2 Obligations 2001 574500 942977
52616 52616 31 NAVY Department of the Navy COL Colombia 3 Disbursements 2001 574500 942977
52924 52924 32 AF Department of the Air Force COL Colombia 2 Obligations 2001 2364935 3881775
52928 52928 32 AF Department of the Air Force COL Colombia 3 Disbursements 2001 2364935 3881775

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