./us_foreign_aid_implementing
2 rows where Fiscal Year = 2022, Managing Agency Acronym = "DOC" and Transaction Type ID = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
38334 | 38334 | 12 | DOC | Department of Commerce | CCN | Central America and Caribbean Region | 3 | Disbursements | 2022 | 133317 | 139416 |
39215 | 39215 | 12 | DOC | Department of Commerce | WLD | World | 3 | Disbursements | 2022 | 20311 | 21240 |
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 );