./us_foreign_aid_implementing
2 rows where Fiscal Year = 2022, Managing Agency Acronym = "DOC" and Transaction Type ID = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
38934 | 38934 | 12 | DOC | Department of Commerce | SAN | Southern Asia Region | 2 | Obligations | 2022 | 40000 | 41830 |
39196 | 39196 | 12 | DOC | Department of Commerce | WLD | World | 2 | Obligations | 2022 | 649699 | 679421 |
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 );