./us_foreign_aid_implementing

5 rows where Fiscal Year = 2023 and Managing Agency Acronym = "EPA"

✎ 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
52454 52454 29 EPA Environmental Protection Agency NCN North and Central America Region 2 Obligations 2023 3250000 3250000
52457 52457 29 EPA Environmental Protection Agency NCN North and Central America Region 3 Disbursements 2023 115215 115215
52498 52498 29 EPA Environmental Protection Agency SSN Sub-Saharan Africa Region 2 Obligations 2023 325000 325000
52540 52540 29 EPA Environmental Protection Agency WLD World 2 Obligations 2023 11528548 11528548
52560 52560 29 EPA Environmental Protection Agency WLD World 3 Disbursements 2023 8845315 8845315

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