home / 2025-02-03_foreign-assistance

./us_foreign_aid_implementing

6 rows where Country Name = "India" and Managing Agency ID = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year, 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
43576 43576 15 DOT Department of Transportation IND India 2 Obligations 2009 23786 32657
43577 43577 15 DOT Department of Transportation IND India 2 Obligations 2019 13394 15705
43578 43578 15 DOT Department of Transportation IND India 2 Obligations 2024 450 438
43579 43579 15 DOT Department of Transportation IND India 3 Disbursements 2009 23786 32657
43580 43580 15 DOT Department of Transportation IND India 3 Disbursements 2019 13394 15705
43581 43581 15 DOT Department of Transportation IND India 3 Disbursements 2024 450 438

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