./us_foreign_aid_implementing

17 rows where Fiscal Year = 2019 and Managing Agency Name = "Department of Commerce"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country 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
38263 38263 12 DOC Department of Commerce AZE Azerbaijan 3 Disbursements 2019 87428 102511
38456 38456 12 DOC Department of Commerce EEN Eastern Europe Region 2 Obligations 2019 11 13
38470 38470 12 DOC Department of Commerce EEN Eastern Europe Region 3 Disbursements 2019 178341 209105
38558 38558 12 DOC Department of Commerce GEO Georgia 3 Disbursements 2019 129693 152067
38658 38658 12 DOC Department of Commerce KAZ Kazakhstan 3 Disbursements 2019 159314 186796
38700 38700 12 DOC Department of Commerce KGZ Kyrgyzstan 3 Disbursements 2019 132548 155415
38726 38726 12 DOC Department of Commerce LCN Latin America and Caribbean Region 2 Obligations 2019 300000 351753
38735 38735 12 DOC Department of Commerce LCN Latin America and Caribbean Region 3 Disbursements 2019 300000 351753
38782 38782 12 DOC Department of Commerce MDA Moldova 3 Disbursements 2019 91829 107670
39001 39001 12 DOC Department of Commerce THA Thailand 3 Disbursements 2019 40000 46900
39032 39032 12 DOC Department of Commerce TJK Tajikistan 3 Disbursements 2019 122691 143856
39063 39063 12 DOC Department of Commerce TKM Turkmenistan 3 Disbursements 2019 11343 13299
39122 39122 12 DOC Department of Commerce UKR Ukraine 3 Disbursements 2019 350523 410990
39153 39153 12 DOC Department of Commerce UZB Uzbekistan 3 Disbursements 2019 76426 89609
39193 39193 12 DOC Department of Commerce WLD World 2 Obligations 2019 107400 125928
39212 39212 12 DOC Department of Commerce WLD World 3 Disbursements 2019 541933 635421
39220 39220 12 DOC Department of Commerce WSM Samoa 2 Obligations 2019 13000 15243

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