./us_foreign_aid_country

128 rows where Country Code = "SOM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transaction Type ID, Transaction Type Name

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
17757 17757 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2006 89289000 124838056
17758 17758 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2007 99372000 135227100
17759 17759 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2008 113372000 151126665
17760 17760 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2009 403838000 532907046
17761 17761 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2010 152176000 199080861
17762 17762 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2011 147460000 189100180
17763 17763 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2012 302688000 381174998
17764 17764 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2013 319576000 395209717
17765 17765 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2014 301942000 366315569
17766 17766 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2015 415757000 498678722
17767 17767 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2016 343426000 408536143
17768 17768 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2017 456412000 533419612
17769 17769 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2018 428908000 489774977
17770 17770 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2019 409748000 458907556
17771 17771 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2020 262908000 290574026
17772 17772 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2021 303820000 324870957
17773 17773 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2022 393376000 393376000
17774 17774 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 1 Appropriated and Planned 2023 367927728 350928872
17775 17775 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1954 700000 6283015
17776 17776 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1955 300000 2673066
17777 17777 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1956 100000 868826
17778 17778 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1957 1400000 11721399
17779 17779 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1958 600000 4876298
17780 17780 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1959 3100000 24814229
17781 17781 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1960 3001000 23695477
17782 17782 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1961 4201000 32725978
17783 17783 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1962 15100000 116440745
17784 17784 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1963 8801000 67062302
17785 17785 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1964 4401000 33141893
17786 17786 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1965 7900000 58481080
17787 17787 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1966 5400000 39120356
17788 17788 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1967 16400000 115319586
17789 17789 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1968 5301000 36009632
17790 17790 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1969 3501000 22744390
17791 17791 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1970 3000000 18504800
17792 17792 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1971 301000 1766494
17793 17793 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1975 5200000 23623521
17794 17794 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1976 1600000 6795825
17795 17795 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1976tq 700000 2886791
17796 17796 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1977 843000 3338904
17797 17797 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1978 19016000 70577169
17798 17798 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1979 28826000 98981429
17799 17799 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1980 87312000 275761341
17800 17800 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1981 77329000 222421089
17801 17801 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1982 66223000 178097414
17802 17802 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1983 75298000 194038989
17803 17803 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1984 82679000 205678123
17804 17804 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1985 116728000 280989686
17805 17805 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1986 69832000 164404864
17806 17806 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1987 55199000 127110770
17807 17807 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1988 28583000 63751632
17808 17808 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1989 21341000 45751596
17809 17809 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1990 5757000 11907099
17810 17810 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1991 3682000 7352556
17811 17811 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1992 55609900 108335467
17812 17812 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1993 107975500 205528917
17813 17813 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1994 30542698 56895270
17814 17814 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1995 14777500 26955911
17815 17815 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1996 9449000 16917563
17816 17816 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1997 6038100 10622148
17817 17817 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1998 17669200 30698540
17818 17818 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 1999 14559800 24986854
17819 17819 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2000 13916302 23395718
17820 17820 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2001 26114064 42863304
17821 17821 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2002 33778365 54584657
17822 17822 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2003 31152804 49393723
17823 17823 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2004 29791932 46110069
17824 17824 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2005 45148444 67814328
17825 17825 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2006 103447450 150492551
17826 17826 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2007 136555017 193334155
17827 17827 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2008 300141526 416296737
17828 17828 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2009 448814709 616205283
17829 17829 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2010 156189323 212600696
17830 17830 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2011 273155508 364495983
17831 17831 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2012 469481808 615306455
17832 17832 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2013 451948420 581770987
17833 17833 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2014 402963693 509421895
17834 17834 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2015 252618972 316084436
17835 17835 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2016 277027487 343875791
17836 17836 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2017 589892490 720081762
17837 17837 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2018 742202347 886329894
17838 17838 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2019 762652186 894217190
17839 17839 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2020 823902478 953577083
17840 17840 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2021 789958295 883869928
17841 17841 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2022 1137089455 1189107419
17842 17842 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2023 1181033990 1181033990
17843 17843 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 2 Obligations 2024 546186417 531979392
17844 17844 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2001 12856181 21101976
17845 17845 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2002 27526295 44481529
17846 17846 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2003 33601344 53275956
17847 17847 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2004 35070894 54280516
17848 17848 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2005 37370913 56132235
17849 17849 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2006 80863660 117638265
17850 17850 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2007 88974680 125970064
17851 17851 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2008 218334561 302830360
17852 17852 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2009 389215893 534378401
17853 17853 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2010 97302135 132445036
17854 17854 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2011 178981972 238831740
17855 17855 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2012 352071358 461427420
17856 17856 SOM Somalia 5 Sub-Saharan Africa LIC Low Income Country 3 Disbursements 2013 432935600 557296722

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);