./us_foreign_aid_implementing

13 rows where Fiscal Year = 2022, Managing Agency Name = "Department of Justice" and Transaction Type Name = "Obligations"

✎ View and edit SQL

This data as json, CSV (advanced)

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
35990 35990 10 DOJ Department of Justice COL Colombia 2 Obligations 2022 680783 711925
36115 36115 10 DOJ Department of Justice ECU Ecuador 2 Obligations 2022 -2892 -3024
36232 36232 10 DOJ Department of Justice GHA Ghana 2 Obligations 2022 104067 108828
36273 36273 10 DOJ Department of Justice GTM Guatemala 2 Obligations 2022 97018 101455
36306 36306 10 DOJ Department of Justice HND Honduras 2 Obligations 2022 95861 100245
36456 36456 10 DOJ Department of Justice KEN Kenya 2 Obligations 2022 148667 155469
36566 36566 10 DOJ Department of Justice MEX Mexico 2 Obligations 2022 2192 2292
36655 36655 10 DOJ Department of Justice NGA Nigeria 2 Obligations 2022 208135 217656
36718 36718 10 DOJ Department of Justice PAN Panama 2 Obligations 2022 96176 100577
36747 36747 10 DOJ Department of Justice PER Peru 2 Obligations 2022 230758 241315
36808 36808 10 DOJ Department of Justice PRY Paraguay 2 Obligations 2022 107666 112591
36916 36916 10 DOJ Department of Justice SLV El Salvador 2 Obligations 2022 118657 124086
36980 36980 10 DOJ Department of Justice THA Thailand 2 Obligations 2022 20018 20934

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