./us_foreign_aid_implementing

5 rows where Country Code = "UKR", Managing Agency ID = 26 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
52262 52262 26 LIC Open World Leadership Center UKR Ukraine 2 Obligations 2004 324000 501467
52263 52263 26 LIC Open World Leadership Center UKR Ukraine 2 Obligations 2006 1211257 1762104
52264 52264 26 LIC Open World Leadership Center UKR Ukraine 2 Obligations 2008 2192827 3041454
52265 52265 26 LIC Open World Leadership Center UKR Ukraine 2 Obligations 2009 2772181 3806098
52266 52266 26 LIC Open World Leadership Center UKR Ukraine 2 Obligations 2010 2570282 3498599

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