./us_foreign_aid_implementing

7 rows where Fiscal Year = 2020 and Managing Agency Acronym = "DOT"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country Name, Transaction Type ID, Transaction Type Name

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
43469 43469 15 DOT Department of Transportation BRB Barbados 3 Disbursements 2020 20148 23319
43505 43505 15 DOT Department of Transportation COL Colombia 3 Disbursements 2020 11336 13120
43602 43602 15 DOT Department of Transportation JAM Jamaica 3 Disbursements 2020 5180 5995
43707 43707 15 DOT Department of Transportation SSN Sub-Saharan Africa Region 3 Disbursements 2020 89190 103228
43715 43715 15 DOT Department of Transportation THA Thailand 3 Disbursements 2020 12154 14067
43737 43737 15 DOT Department of Transportation WLD World 2 Obligations 2020 1129220 1306949
43748 43748 15 DOT Department of Transportation WLD World 3 Disbursements 2020 282017 326404

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