home / 2025-02-03_foreign-assistance

./us_foreign_aid_implementing

2 rows where Fiscal Year = 2022, Managing Agency Acronym = "DOC" and Transaction Type ID = 3

✎ 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
38334 38334 12 DOC Department of Commerce CCN Central America and Caribbean Region 3 Disbursements 2022 133317 139416
39215 39215 12 DOC Department of Commerce WLD World 3 Disbursements 2022 20311 21240

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