./us_foreign_aid_implementing

6 rows where Fiscal Year = 2021 and Managing Agency Acronym = "DFC"

✎ 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
53296 53296 38 DFC U.S. International Development Finance Corporation IRQ Iraq 2 Obligations 2021 979000 1095385
53298 53298 38 DFC U.S. International Development Finance Corporation KEN Kenya 2 Obligations 2021 282104 315641
53303 53303 38 DFC U.S. International Development Finance Corporation PSE West Bank and Gaza 2 Obligations 2021 3529721 3949340
53305 53305 38 DFC U.S. International Development Finance Corporation SEN Senegal 2 Obligations 2021 3890000 4352450
53307 53307 38 DFC U.S. International Development Finance Corporation SSN Sub-Saharan Africa Region 2 Obligations 2021 702370 785869
53311 53311 38 DFC U.S. International Development Finance Corporation WLD World 2 Obligations 2021 2250800 2518379

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