./us_foreign_aid_implementing
7 rows where Fiscal Year = 2023 and Managing Agency Name = "Department of Homeland Security"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 42428 | 42428 | 14 | DHS | Department of Homeland Security | BHS | Bahamas | 3 | Disbursements | 2023 | 6300 | 6300 |
| 42477 | 42477 | 14 | DHS | Department of Homeland Security | BRB | Barbados | 3 | Disbursements | 2023 | 11610 | 11610 |
| 42545 | 42545 | 14 | DHS | Department of Homeland Security | CRN | Caribbean Region | 3 | Disbursements | 2023 | 34891 | 34891 |
| 43147 | 43147 | 14 | DHS | Department of Homeland Security | RWA | Rwanda | 3 | Disbursements | 2023 | 15484 | 15484 |
| 43231 | 43231 | 14 | DHS | Department of Homeland Security | SSN | Sub-Saharan Africa Region | 3 | Disbursements | 2023 | 8059 | 8059 |
| 43385 | 43385 | 14 | DHS | Department of Homeland Security | WHN | Western Hemisphere Region | 3 | Disbursements | 2023 | 14307 | 14307 |
| 43421 | 43421 | 14 | DHS | Department of Homeland Security | ZAF | South Africa | 3 | Disbursements | 2023 | 10248 | 10248 |
Advanced export
JSON shape: default, array, newline-delimited
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 );