./us_foreign_aid_implementing

4 rows where Fiscal Year = 2008, Managing Agency Name = "Environmental Protection Agency" 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
52279 52279 29 EPA Environmental Protection Agency ASN Asia Region 2 Obligations 2008 200000 277400
52321 52321 29 EPA Environmental Protection Agency CHN China (P.R.C.) 2 Obligations 2008 110000 152570
52421 52421 29 EPA Environmental Protection Agency MEX Mexico 2 Obligations 2008 100000 138700
52525 52525 29 EPA Environmental Protection Agency WLD World 2 Obligations 2008 24745600 34322183

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