./us_foreign_aid_implementing

5 rows where Fiscal Year = 2022, Managing Agency Name = "Department of the Air Force" and Transaction Type Name = "Obligations"

✎ 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
52944 52944 32 AF Department of the Air Force EEE Central and Eastern Europe Region 2 Obligations 2022 68200 71320
52963 52963 32 AF Department of the Air Force EUN Europe Region 2 Obligations 2022 49943 52228
53129 53129 32 AF Department of the Air Force NGA Nigeria 2 Obligations 2022 63563 66470
53240 53240 32 AF Department of the Air Force SSN Sub-Saharan Africa Region 2 Obligations 2022 42870 44831
53279 53279 32 AF Department of the Air Force WLD World 2 Obligations 2022 251723 263239

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
);