./us_foreign_aid_implementing
36 rows where Fiscal Year = 2016, Managing Agency Name = "Department of Homeland Security" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 42336 | 42336 | 14 | DHS | Department of Homeland Security | AFG | Afghanistan | 3 | Disbursements | 2016 | 212151 | 263345 |
| 42424 | 42424 | 14 | DHS | Department of Homeland Security | BHR | Bahrain | 3 | Disbursements | 2016 | 248352 | 308281 |
| 42496 | 42496 | 14 | DHS | Department of Homeland Security | BWA | Botswana | 3 | Disbursements | 2016 | 7638 | 9481 |
| 42506 | 42506 | 14 | DHS | Department of Homeland Security | CHL | Chile | 3 | Disbursements | 2016 | 35596 | 44186 |
| 42524 | 42524 | 14 | DHS | Department of Homeland Security | COL | Colombia | 3 | Disbursements | 2016 | 32562 | 40419 |
| 42542 | 42542 | 14 | DHS | Department of Homeland Security | CRI | Costa Rica | 3 | Disbursements | 2016 | 402128 | 499163 |
| 42606 | 42606 | 14 | DHS | Department of Homeland Security | EGY | Egypt | 3 | Disbursements | 2016 | 368079 | 456898 |
| 42611 | 42611 | 14 | DHS | Department of Homeland Security | ENS | Eastern Asia Region | 3 | Disbursements | 2016 | 41976 | 52106 |
| 42627 | 42627 | 14 | DHS | Department of Homeland Security | EUN | Europe Region | 3 | Disbursements | 2016 | 450732 | 559497 |
| 42665 | 42665 | 14 | DHS | Department of Homeland Security | GHA | Ghana | 3 | Disbursements | 2016 | 22441 | 27856 |
| 42685 | 42685 | 14 | DHS | Department of Homeland Security | GTM | Guatemala | 3 | Disbursements | 2016 | 287333 | 356668 |
| 42694 | 42694 | 14 | DHS | Department of Homeland Security | HKG | China (Hong Kong, S.A.R., P.R.C.) | 3 | Disbursements | 2016 | 62809 | 77966 |
| 42741 | 42741 | 14 | DHS | Department of Homeland Security | HUN | Hungary | 3 | Disbursements | 2016 | 55104 | 68401 |
| 42757 | 42757 | 14 | DHS | Department of Homeland Security | IDN | Indonesia | 3 | Disbursements | 2016 | 111972 | 138991 |
| 42770 | 42770 | 14 | DHS | Department of Homeland Security | IND | India | 3 | Disbursements | 2016 | 191205 | 237346 |
| 42793 | 42793 | 14 | DHS | Department of Homeland Security | JAM | Jamaica | 3 | Disbursements | 2016 | 12289 | 15254 |
| 42817 | 42817 | 14 | DHS | Department of Homeland Security | JOR | Jordan | 3 | Disbursements | 2016 | 698089 | 866542 |
| 42843 | 42843 | 14 | DHS | Department of Homeland Security | KEN | Kenya | 3 | Disbursements | 2016 | 1209704 | 1501612 |
| 42857 | 42857 | 14 | DHS | Department of Homeland Security | KGZ | Kyrgyzstan | 3 | Disbursements | 2016 | 92026 | 114232 |
| 42886 | 42886 | 14 | DHS | Department of Homeland Security | LKA | Sri Lanka | 3 | Disbursements | 2016 | 3334 | 4139 |
| 42955 | 42955 | 14 | DHS | Department of Homeland Security | MEX | Mexico | 3 | Disbursements | 2016 | 681130 | 845491 |
| 42993 | 42993 | 14 | DHS | Department of Homeland Security | MNS | Middle East and North Africa Region | 3 | Disbursements | 2016 | 460457 | 571567 |
| 43004 | 43004 | 14 | DHS | Department of Homeland Security | MYS | Malaysia | 3 | Disbursements | 2016 | 59413 | 73750 |
| 43067 | 43067 | 14 | DHS | Department of Homeland Security | PAN | Panama | 3 | Disbursements | 2016 | 452489 | 561678 |
| 43082 | 43082 | 14 | DHS | Department of Homeland Security | PER | Peru | 3 | Disbursements | 2016 | 62000 | 76961 |
| 43100 | 43100 | 14 | DHS | Department of Homeland Security | PHL | Philippines | 3 | Disbursements | 2016 | 256087 | 317882 |
| 43192 | 43192 | 14 | DHS | Department of Homeland Security | SGP | Singapore | 3 | Disbursements | 2016 | 101305 | 125750 |
| 43213 | 43213 | 14 | DHS | Department of Homeland Security | SLV | El Salvador | 3 | Disbursements | 2016 | 391261 | 485674 |
| 43229 | 43229 | 14 | DHS | Department of Homeland Security | SSN | Sub-Saharan Africa Region | 3 | Disbursements | 2016 | 1310440 | 1626655 |
| 43264 | 43264 | 14 | DHS | Department of Homeland Security | THA | Thailand | 3 | Disbursements | 2016 | 205347 | 254898 |
| 43315 | 43315 | 14 | DHS | Department of Homeland Security | TUR | Turkey | 3 | Disbursements | 2016 | 48825 | 60607 |
| 43348 | 43348 | 14 | DHS | Department of Homeland Security | UKR | Ukraine | 3 | Disbursements | 2016 | 386072 | 479234 |
| 43377 | 43377 | 14 | DHS | Department of Homeland Security | VNM | Vietnam | 3 | Disbursements | 2016 | 171991 | 213494 |
| 43383 | 43383 | 14 | DHS | Department of Homeland Security | WHN | Western Hemisphere Region | 3 | Disbursements | 2016 | 710011 | 881339 |
| 43398 | 43398 | 14 | DHS | Department of Homeland Security | WLD | World | 3 | Disbursements | 2016 | 1474255 | 1830000 |
| 43419 | 43419 | 14 | DHS | Department of Homeland Security | ZAF | South Africa | 3 | Disbursements | 2016 | 109263 | 135629 |
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 );