./us_foreign_aid_implementing

10 rows where Fiscal Year = 2019 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, 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
43429 43429 15 DOT Department of Transportation AFG Afghanistan 2 Obligations 2019 11475 13455
43436 43436 15 DOT Department of Transportation AFG Afghanistan 3 Disbursements 2019 11475 13455
43577 43577 15 DOT Department of Transportation IND India 2 Obligations 2019 13394 15705
43580 43580 15 DOT Department of Transportation IND India 3 Disbursements 2019 13394 15705
43595 43595 15 DOT Department of Transportation ISR Israel 2 Obligations 2019 27112 31789
43597 43597 15 DOT Department of Transportation ISR Israel 3 Disbursements 2019 27112 31789
43653 43653 15 DOT Department of Transportation OCN Oceania Region 2 Obligations 2019 55500 65074
43654 43654 15 DOT Department of Transportation OCN Oceania Region 3 Disbursements 2019 55500 65074
43677 43677 15 DOT Department of Transportation PNG Papua New Guinea 2 Obligations 2019 5491 6438
43678 43678 15 DOT Department of Transportation PNG Papua New Guinea 3 Disbursements 2019 5491 6438

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