./us_foreign_aid_country
507 rows where Region ID = 3 and Transaction Type ID = 3
This data as json, CSV (advanced)
Suggested facets: Country Code, Country Name, Income Group Acronym, Income Group Name, Fiscal Year
| Link | rowid ▼ | Country Code | Country Name | Region ID | Region Name | Income Group Acronym | Income Group Name | Transaction Type ID | Transaction Type Name | Fiscal Year | current_amount | constant_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 456 | 456 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2002 | 425000 | 686785 |
| 457 | 457 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2004 | 54000 | 83578 |
| 458 | 458 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2005 | 442532 | 664695 |
| 459 | 459 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2006 | 805355 | 1171609 |
| 460 | 460 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2007 | 2459823 | 3482609 |
| 461 | 461 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2008 | 492188 | 682667 |
| 462 | 462 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2009 | 28389 | 38977 |
| 463 | 463 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2010 | 1185121 | 1613154 |
| 464 | 464 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2011 | 1405948 | 1876084 |
| 465 | 465 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2012 | 754587 | 988966 |
| 466 | 466 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2013 | 745575 | 959744 |
| 467 | 467 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2014 | 681235 | 861210 |
| 468 | 468 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2015 | 3505908 | 4386683 |
| 469 | 469 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2016 | 2165459 | 2687994 |
| 470 | 470 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2017 | 1151470 | 1405601 |
| 471 | 471 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2018 | 993793 | 1186778 |
| 472 | 472 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2019 | 159890 | 187471 |
| 473 | 473 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2020 | 406434 | 470403 |
| 474 | 474 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2021 | 236544 | 264665 |
| 475 | 475 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2022 | 749613 | 783904 |
| 476 | 476 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2023 | 911831 | 911831 |
| 477 | 477 | ARE | United Arab Emirates | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2024 | 535662 | 521729 |
| 1777 | 1777 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2001 | 6249690 | 10258166 |
| 1778 | 1778 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2002 | 38881310 | 62830838 |
| 1779 | 1779 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2003 | 94579915 | 149959347 |
| 1780 | 1780 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2004 | 25250300 | 39080817 |
| 1781 | 1781 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2005 | 26437873 | 39710485 |
| 1782 | 1782 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2006 | 16891121 | 24572747 |
| 1783 | 1783 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2007 | 23443948 | 33191865 |
| 1784 | 1784 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2008 | 4795499 | 6651365 |
| 1785 | 1785 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2009 | 9492259 | 13032504 |
| 1786 | 1786 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2010 | 20825009 | 28346442 |
| 1787 | 1787 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2011 | 47807722 | 63794150 |
| 1788 | 1788 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2012 | 11088685 | 14532915 |
| 1789 | 1789 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2013 | 14613986 | 18811867 |
| 1790 | 1790 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2014 | 11593741 | 14656668 |
| 1791 | 1791 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2015 | 10240564 | 12813302 |
| 1792 | 1792 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2016 | 9549777 | 11854192 |
| 1793 | 1793 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2017 | 1581613 | 1930677 |
| 1794 | 1794 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2018 | 914557 | 1092154 |
| 1795 | 1795 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2019 | 23382083 | 27415719 |
| 1796 | 1796 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2020 | 18512913 | 21426671 |
| 1797 | 1797 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2021 | 9317101 | 10424736 |
| 1798 | 1798 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2022 | 5506773 | 5758686 |
| 1799 | 1799 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2023 | 5998255 | 5998255 |
| 1800 | 1800 | BHR | Bahrain | 3 | Middle East and North Africa | HIC | High Income Country | 3 | Disbursements | 2024 | 303145 | 295260 |
| 5374 | 5374 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2001 | 407993 | 669674 |
| 5375 | 5375 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2002 | 3329738 | 5380739 |
| 5376 | 5376 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2003 | 3695561 | 5859426 |
| 5377 | 5377 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2004 | 4000414 | 6191588 |
| 5378 | 5378 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2005 | 2447189 | 3675753 |
| 5379 | 5379 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2006 | 1550195 | 2255181 |
| 5380 | 5380 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2007 | 2977721 | 4215847 |
| 5381 | 5381 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2008 | 9804940 | 13599467 |
| 5382 | 5382 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2009 | 9052562 | 12428817 |
| 5383 | 5383 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2010 | 9932163 | 13519395 |
| 5384 | 5384 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2011 | 10513759 | 14029458 |
| 5385 | 5385 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2012 | 12557639 | 16458139 |
| 5386 | 5386 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2013 | 12306281 | 15841268 |
| 5387 | 5387 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2014 | 9249762 | 11693441 |
| 5388 | 5388 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2015 | 9922545 | 12415387 |
| 5389 | 5389 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2016 | 9349981 | 11606188 |
| 5390 | 5390 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2017 | 21976989 | 26827319 |
| 5391 | 5391 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2018 | 6049012 | 7223672 |
| 5392 | 5392 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2019 | 18433324 | 21613253 |
| 5393 | 5393 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2020 | 6074815 | 7030937 |
| 5394 | 5394 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2021 | 6379185 | 7137551 |
| 5395 | 5395 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2022 | 3128584 | 3271707 |
| 5396 | 5396 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2023 | 6246102 | 6246102 |
| 5397 | 5397 | DZA | Algeria | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2024 | 2990320 | 2912536 |
| 5966 | 5966 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2001 | 2128251295 | 3493285404 |
| 5967 | 5967 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2002 | 2334061910 | 3771762468 |
| 5968 | 5968 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2003 | 1966371933 | 3117742847 |
| 5969 | 5969 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2004 | 2132280870 | 3300209525 |
| 5970 | 5970 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2005 | 1905613447 | 2862289073 |
| 5971 | 5971 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2006 | 1682576622 | 2447767011 |
| 5972 | 5972 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2007 | 1992251586 | 2820623389 |
| 5973 | 5973 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2008 | 1745626686 | 2421186776 |
| 5974 | 5974 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2009 | 2007837498 | 2756683386 |
| 5975 | 5975 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2010 | 1592104537 | 2167129797 |
| 5976 | 5976 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2011 | 1451075574 | 1936300786 |
| 5977 | 5977 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2012 | 1485334095 | 1946690275 |
| 5978 | 5978 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2013 | 1577776268 | 2030993861 |
| 5979 | 5979 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2014 | 679588525 | 859127711 |
| 5980 | 5980 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2015 | 1446503211 | 1809908215 |
| 5981 | 5981 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2016 | 1306735756 | 1622058479 |
| 5982 | 5982 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2017 | 303943867 | 371024274 |
| 5983 | 5983 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2018 | 1156767556 | 1381399069 |
| 5984 | 5984 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2019 | 1518627077 | 1780605209 |
| 5985 | 5985 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2020 | 1452972136 | 1681656475 |
| 5986 | 5986 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2021 | 1533319686 | 1715603415 |
| 5987 | 5987 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2022 | 1374502343 | 1437381144 |
| 5988 | 5988 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2023 | 1446730157 | 1446730157 |
| 5989 | 5989 | EGY | Egypt | 3 | Middle East and North Africa | LMIC | Lower Middle Income Country | 3 | Disbursements | 2024 | 233654472 | 227576801 |
| 9098 | 9098 | IRN | Iran | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2001 | 35000 | 57449 |
| 9099 | 9099 | IRN | Iran | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2002 | 201250 | 325213 |
| 9100 | 9100 | IRN | Iran | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2003 | 285229 | 452239 |
| 9101 | 9101 | IRN | Iran | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2004 | 4446737 | 6882378 |
| 9102 | 9102 | IRN | Iran | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2005 | 4373709 | 6569442 |
| 9103 | 9103 | IRN | Iran | 3 | Middle East and North Africa | UMIC | Upper Middle Income Country | 3 | Disbursements | 2006 | 2280267 | 3317271 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "./us_foreign_aid_country" ( "Country Code" TEXT, "Country Name" TEXT, "Region ID" INTEGER, "Region Name" TEXT, "Income Group Acronym" TEXT, "Income Group Name" TEXT, "Transaction Type ID" INTEGER, "Transaction Type Name" TEXT, "Fiscal Year" TEXT, "current_amount" INTEGER, "constant_amount" INTEGER );