./us_foreign_aid_implementing

5 rows where Fiscal Year = 2013, Managing Agency ID = 31 and Transaction Type Name = "Disbursements"

✎ 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
52571 52571 31 NAVY Department of the Navy BDI Burundi 3 Disbursements 2013 1042412 1341846
52685 52685 31 NAVY Department of the Navy HRV Croatia 3 Disbursements 2013 14897105 19176312
52695 52695 31 NAVY Department of the Navy JOR Jordan 3 Disbursements 2013 2363086 3041884
52890 52890 31 NAVY Department of the Navy UGA Uganda 3 Disbursements 2013 1042410 1341843
52895 52895 31 NAVY Department of the Navy UZB Uzbekistan 3 Disbursements 2013 35721955 45983117

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