home / 2025-02-03_foreign-assistance

./us_foreign_aid_implementing

10 rows where Fiscal Year = 2004 and Managing Agency ID = 31

✎ 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
52614 52614 31 NAVY Department of the Navy COL Colombia 2 Obligations 2004 274560 424947
52618 52618 31 NAVY Department of the Navy COL Colombia 3 Disbursements 2004 274560 424947
52624 52624 31 NAVY Department of the Navy DJI Djibouti 2 Obligations 2004 240000 371456
52625 52625 31 NAVY Department of the Navy DJI Djibouti 3 Disbursements 2004 240000 371456
52790 52790 31 NAVY Department of the Navy PAK Pakistan 2 Obligations 2004 8640000 13372446
52796 52796 31 NAVY Department of the Navy PAK Pakistan 3 Disbursements 2004 8640000 13372446
52803 52803 31 NAVY Department of the Navy PAN Panama 2 Obligations 2004 68300 105710
52808 52808 31 NAVY Department of the Navy PAN Panama 3 Disbursements 2004 68300 105710
52897 52897 31 NAVY Department of the Navy YEM Yemen 2 Obligations 2004 7000 10834
52899 52899 31 NAVY Department of the Navy YEM Yemen 3 Disbursements 2004 7000 10834

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 3098.72ms