./us_foreign_aid_implementing

10 rows where Fiscal Year = 2020 and Managing Agency Acronym = "FTC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country Name, Transaction Type ID, Transaction Type Name, 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
51873 51873 20 FTC Federal Trade Commission IDN Indonesia 2 Obligations 2020 2347 2716
51882 51882 20 FTC Federal Trade Commission IDN Indonesia 3 Disbursements 2020 2347 2716
51891 51891 20 FTC Federal Trade Commission IND India 2 Obligations 2020 9959 11526
51902 51902 20 FTC Federal Trade Commission IND India 3 Disbursements 2020 9959 11526
51947 51947 20 FTC Federal Trade Commission MYS Malaysia 2 Obligations 2020 2347 2716
51948 51948 20 FTC Federal Trade Commission MYS Malaysia 3 Disbursements 2020 2347 2716
51964 51964 20 FTC Federal Trade Commission PER Peru 2 Obligations 2020 253 293
51974 51974 20 FTC Federal Trade Commission PER Peru 3 Disbursements 2020 253 293
52051 52051 20 FTC Federal Trade Commission WLD World 2 Obligations 2020 19710 22812
52055 52055 20 FTC Federal Trade Commission WLD World 3 Disbursements 2020 19710 22812

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