home / 2025-02-03_foreign-assistance

./us_foreign_aid_implementing

10 rows where Fiscal Year = 2013 and Managing Agency ID = 29

✎ 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
52326 52326 29 EPA Environmental Protection Agency CHN China (P.R.C.) 2 Obligations 2013 81151 104462
52336 52336 29 EPA Environmental Protection Agency CHN China (P.R.C.) 3 Disbursements 2013 13800 17764
52349 52349 29 EPA Environmental Protection Agency CRI Costa Rica 2 Obligations 2013 50000 64363
52361 52361 29 EPA Environmental Protection Agency EAG Eastern Africa Region 2 Obligations 2013 150000 193088
52379 52379 29 EPA Environmental Protection Agency GBR United Kingdom 3 Disbursements 2013 112000 144172
52426 52426 29 EPA Environmental Protection Agency MEX Mexico 2 Obligations 2013 75000 96544
52438 52438 29 EPA Environmental Protection Agency NAN North America Region 2 Obligations 2013 2550000 3282490
52445 52445 29 EPA Environmental Protection Agency NAN North America Region 3 Disbursements 2013 2550000 3282490
52530 52530 29 EPA Environmental Protection Agency WLD World 2 Obligations 2013 19011033 24471970
52550 52550 29 EPA Environmental Protection Agency WLD World 3 Disbursements 2013 7490410 9642035

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
);
Powered by Datasette · Queries took 377.333ms