./us_foreign_aid_implementing

5 rows where Fiscal Year = 2001, Managing Agency Name = "Department of the Treasury" and Transaction Type ID = 3

✎ 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
17433 17433 4 TREAS Department of the Treasury ASN Asia Region 3 Disbursements 2001 71841600 117919915
17836 17836 4 TREAS Department of the Treasury EEN Eastern Europe Region 3 Disbursements 2001 37689810 61863589
18396 18396 4 TREAS Department of the Treasury LCN Latin America and Caribbean Region 3 Disbursements 2001 35031345 57500017
19115 19115 4 TREAS Department of the Treasury SSN Sub-Saharan Africa Region 3 Disbursements 2001 105867828 173770146
19443 19443 4 TREAS Department of the Treasury WLD World 3 Disbursements 2001 896024400 1470723390

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