home / 2025-02-03_foreign-assistance

./us_foreign_aid_implementing

20 rows where Fiscal Year = 2023 and Managing Agency Name = "Department of Justice"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Country Code, Country Name, Transaction Type ID, Transaction Type Name

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
35991 35991 10 DOJ Department of Justice COL Colombia 2 Obligations 2023 544372 544372
36006 36006 10 DOJ Department of Justice COL Colombia 3 Disbursements 2023 527901 527901
36077 36077 10 DOJ Department of Justice DOM Dominican Republic 2 Obligations 2023 208225 208225
36088 36088 10 DOJ Department of Justice DOM Dominican Republic 3 Disbursements 2023 208125 208125
36116 36116 10 DOJ Department of Justice ECU Ecuador 2 Obligations 2023 212223 212223
36130 36130 10 DOJ Department of Justice ECU Ecuador 3 Disbursements 2023 210847 210847
36274 36274 10 DOJ Department of Justice GTM Guatemala 2 Obligations 2023 301146 301146
36286 36286 10 DOJ Department of Justice GTM Guatemala 3 Disbursements 2023 285884 285884
36307 36307 10 DOJ Department of Justice HND Honduras 2 Obligations 2023 176273 176273
36320 36320 10 DOJ Department of Justice HND Honduras 3 Disbursements 2023 162388 162388
36567 36567 10 DOJ Department of Justice MEX Mexico 2 Obligations 2023 149818 149818
36581 36581 10 DOJ Department of Justice MEX Mexico 3 Disbursements 2023 149819 149819
36719 36719 10 DOJ Department of Justice PAN Panama 2 Obligations 2023 197674 197674
36732 36732 10 DOJ Department of Justice PAN Panama 3 Disbursements 2023 183789 183789
36748 36748 10 DOJ Department of Justice PER Peru 2 Obligations 2023 322713 322713
36764 36764 10 DOJ Department of Justice PER Peru 3 Disbursements 2023 321261 321261
36917 36917 10 DOJ Department of Justice SLV El Salvador 2 Obligations 2023 81090 81090
36927 36927 10 DOJ Department of Justice SLV El Salvador 3 Disbursements 2023 69982 69982
36981 36981 10 DOJ Department of Justice THA Thailand 2 Obligations 2023 300779 300779
36992 36992 10 DOJ Department of Justice THA Thailand 3 Disbursements 2023 311762 311762

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
);
Powered by Datasette · Queries took 4296.058ms