./us_foreign_aid_implementing

8 rows where Country Code = "THA" and Managing Agency ID = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name, Fiscal Year, current_amount, constant_amount

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
52864 52864 31 NAVY Department of the Navy THA Thailand 2 Obligations 2016 157000 194885
52865 52865 31 NAVY Department of the Navy THA Thailand 2 Obligations 2018 159682 190691
52866 52866 31 NAVY Department of the Navy THA Thailand 2 Obligations 2019 969203 1136400
52867 52867 31 NAVY Department of the Navy THA Thailand 2 Obligations 2020 493408 571066
52868 52868 31 NAVY Department of the Navy THA Thailand 3 Disbursements 2016 157000 194885
52869 52869 31 NAVY Department of the Navy THA Thailand 3 Disbursements 2018 159682 190691
52870 52870 31 NAVY Department of the Navy THA Thailand 3 Disbursements 2019 969203 1136400
52871 52871 31 NAVY Department of the Navy THA Thailand 3 Disbursements 2020 493408 571066

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