./us_foreign_aid_country
91 rows where Income Group Name = "Upper Middle Income Country", Region ID = 5 and Transaction Type ID = 1
This data as json, CSV (advanced)
Suggested facets: Country Code, Country 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2665 | 2665 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2006 | 41760000 | 58386108 |
| 2666 | 2666 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2007 | 64751000 | 88114258 |
| 2667 | 2667 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2008 | 79555000 | 106048070 |
| 2668 | 2668 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2009 | 81494000 | 107539971 |
| 2669 | 2669 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2010 | 77331000 | 101166558 |
| 2670 | 2670 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2011 | 75649000 | 97010983 |
| 2671 | 2671 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2012 | 66979000 | 84346655 |
| 2672 | 2672 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2013 | 55002000 | 68019266 |
| 2673 | 2673 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2014 | 50715231 | 61527640 |
| 2674 | 2674 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2015 | 37291000 | 44728600 |
| 2675 | 2675 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2016 | 26787000 | 31865548 |
| 2676 | 2676 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2017 | 36810000 | 43020726 |
| 2677 | 2677 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2018 | 65323000 | 74593085 |
| 2678 | 2678 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2019 | 39290000 | 44003821 |
| 2679 | 2679 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2020 | 61812000 | 68316528 |
| 2680 | 2680 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2021 | 49807000 | 53258007 |
| 2681 | 2681 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2022 | 41929000 | 41929000 |
| 2682 | 2682 | BWA | Botswana | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2023 | 52520724 | 50094182 |
| 6845 | 6845 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2006 | 231000 | 322969 |
| 6846 | 6846 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2007 | 263000 | 357895 |
| 6847 | 6847 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2008 | 199000 | 265270 |
| 6848 | 6848 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2009 | 366000 | 482976 |
| 6849 | 6849 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2010 | 720000 | 941924 |
| 6850 | 6850 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2011 | 530000 | 679663 |
| 6851 | 6851 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2012 | 212000 | 266972 |
| 6852 | 6852 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2013 | 341000 | 421704 |
| 6853 | 6853 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2014 | 2330000 | 2826752 |
| 6854 | 6854 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2015 | 351000 | 421006 |
| 6855 | 6855 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2016 | 447000 | 531747 |
| 6856 | 6856 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2017 | 641000 | 749152 |
| 6857 | 6857 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2018 | 520000 | 593794 |
| 6858 | 6858 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2020 | 400000 | 442092 |
| 6859 | 6859 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2021 | 398000 | 425576 |
| 6860 | 6860 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2022 | 325000 | 325000 |
| 6861 | 6861 | GAB | Gabon | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2023 | 384000 | 366259 |
| 7603 | 7603 | GNQ | Equatorial Guinea | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2022 | 275000 | 275000 |
| 7604 | 7604 | GNQ | Equatorial Guinea | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2023 | 398000 | 379612 |
| 13506 | 13506 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2006 | 1029000 | 1438682 |
| 13507 | 13507 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2007 | 665000 | 904943 |
| 13508 | 13508 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2008 | 149000 | 198619 |
| 13509 | 13509 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2009 | 178000 | 234890 |
| 13510 | 13510 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2010 | 600000 | 784936 |
| 13511 | 13511 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2011 | 155000 | 198769 |
| 13512 | 13512 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2012 | 115000 | 144820 |
| 13513 | 13513 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2013 | 94000 | 116247 |
| 13514 | 13514 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2014 | 505091 | 612775 |
| 13515 | 13515 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2015 | 244000 | 292665 |
| 13516 | 13516 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2016 | 222000 | 264089 |
| 13517 | 13517 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2017 | 286000 | 334255 |
| 13518 | 13518 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2018 | 204000 | 232950 |
| 13519 | 13519 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2019 | 219000 | 245275 |
| 13520 | 13520 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2020 | 100000 | 110523 |
| 13521 | 13521 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2021 | 87000 | 93028 |
| 13522 | 13522 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2022 | 632000 | 632000 |
| 13523 | 13523 | MUS | Mauritius | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2023 | 200000 | 190760 |
| 13889 | 13889 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2006 | 59747000 | 83534359 |
| 13890 | 13890 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2007 | 93467000 | 127191477 |
| 13891 | 13891 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2008 | 108017000 | 143988366 |
| 13892 | 13892 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2009 | 112047000 | 147857892 |
| 13893 | 13893 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2010 | 102899000 | 134615324 |
| 13894 | 13894 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2011 | 103272000 | 132434246 |
| 13895 | 13895 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2012 | 90945000 | 114527039 |
| 13896 | 13896 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2013 | 32239000 | 39868971 |
| 13897 | 13897 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2014 | 23565000 | 28589022 |
| 13898 | 13898 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2015 | 16834000 | 20191500 |
| 13899 | 13899 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2016 | 19322000 | 22985259 |
| 13900 | 13900 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2017 | 65323000 | 76344551 |
| 13901 | 13901 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2018 | 66926000 | 76423569 |
| 13902 | 13902 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2019 | 69284000 | 77596354 |
| 13903 | 13903 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2020 | 77125000 | 85240928 |
| 13904 | 13904 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2021 | 77257000 | 82609952 |
| 13905 | 13905 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2022 | 79289000 | 79289000 |
| 13906 | 13906 | NAM | Namibia | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2023 | 81853000 | 78071259 |
| 21707 | 21707 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2006 | 224205000 | 313468808 |
| 21708 | 21708 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2007 | 398288000 | 541997059 |
| 21709 | 21709 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2008 | 574266000 | 765505636 |
| 21710 | 21710 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2009 | 544890000 | 719040110 |
| 21711 | 21711 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2010 | 579930000 | 758680499 |
| 21712 | 21712 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2011 | 573559000 | 735522250 |
| 21713 | 21713 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2012 | 542929000 | 683710490 |
| 21714 | 21714 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2013 | 514200000 | 635895178 |
| 21715 | 21715 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2014 | 295133108 | 358055032 |
| 21716 | 21716 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2015 | 323448000 | 387958917 |
| 21717 | 21717 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2016 | 309245000 | 367874767 |
| 21718 | 21718 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2017 | 470975000 | 550439738 |
| 21719 | 21719 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2018 | 586603000 | 669848710 |
| 21720 | 21720 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2019 | 734992000 | 823172736 |
| 21721 | 21721 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2020 | 482533000 | 533310345 |
| 21722 | 21722 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2021 | 403196000 | 431132482 |
| 21723 | 21723 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2022 | 455862773 | 455862773 |
| 21724 | 21724 | ZAF | South Africa | 5 | Sub-Saharan Africa | UMIC | Upper Middle Income Country | 1 | Appropriated and Planned | 2023 | 492546945 | 469790478 |
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 );