home / 2025-02-03_foreign-assistance

./us_foreign_aid_dac_sector

3 rows where Fiscal Year = 2003, International Category ID = 4 and Transaction Type Name = "Disbursements"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ International Category ID International Category Name International Sector Code International Sector Name Transaction Type ID Transaction Type Name Fiscal Year current_amount constant_amount
991 991 4 Infrastructure 210 Transport and Storage 3 Disbursements 2003 123728512 196175342
1056 1056 4 Infrastructure 220 Communications 3 Disbursements 2003 29628409 46976743
1109 1109 4 Infrastructure 230 Energy 3 Disbursements 2003 421029845 667555700

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "./us_foreign_aid_dac_sector" (
"International Category ID" INTEGER,
  "International Category Name" TEXT,
  "International Sector Code" INTEGER,
  "International Sector Name" TEXT,
  "Transaction Type ID" INTEGER,
  "Transaction Type Name" TEXT,
  "Fiscal Year" INTEGER,
  "current_amount" INTEGER,
  "constant_amount" INTEGER
);
Powered by Datasette · Queries took 6510.94ms