SELECT "economy", TRIM(LEADING 'yr' FROM "year") "year", "interest_rate"
FROM (
UNPIVOT @worldbank.world_development_indicators.fr_inr_rinr
ON COLUMNS (* EXCLUDE "economy")
INTO
NAME "year"
VALUE "interest_rate"
)
Results limited to the first 500 rows.
economy | year | interest_rate |
---|---|---|
ABW | 1987 | 6.47543427271753 |
ABW | 1988 | 6.91818005864427 |
ABW | 1989 | 6.26423401893797 |
ABW | 1990 | 4.5666408556276 |
ABW | 1991 | 4.79112520734837 |
ABW | 1992 | 6.52813758772899 |
ABW | 1993 | 5.03292510547116 |
ABW | 1994 | 4.05692612365099 |
ABW | 1995 | 6.98825052743605 |
ABW | 1996 | 6.89090544941648 |
ABW | 1997 | 6.31195251913281 |
ABW | 1998 | 4.173555703149 |
ABW | 1999 | 10.7168994077419 |
ABW | 2000 | 10.9174500760991 |
ABW | 2001 | 15.885948876168 |
ABW | 2002 | 6.57378500312943 |
ABW | 2003 | 7.42457507462851 |
ABW | 2004 | 6.60450953637949 |
ABW | 2005 | 5.64637297616821 |
ABW | 2006 | 5.81310509823675 |
ABW | 2007 | 4.97600231726435 |
ABW | 2008 | 5.9825479431511 |
ABW | 2009 | 8.84604657019821 |
ABW | 2010 | 11.6661307585963 |
ABW | 2011 | 4.80197433814387 |
ABW | 2012 | 8.20087500684476 |
ABW | 2013 | 10.7097087655441 |
ABW | 2014 | 3.21386882031282 |
ABW | 2015 | 0.15792476968271 |
ABW | 2016 | 7.98285170979736 |
ABW | 2017 | 9.78928665665114 |
ABW | 2018 | 2.45304531465618 |
ABW | 2019 | -0.299776140992784 |
ABW | 2020 | 7.82593470132022 |
ABW | 2021 | 11.8970840161137 |
ABW | 2022 | 2.85265433875112 |
ABW | 2023 | -0.852277920562397 |
AFG | 2006 | 10.0468971030039 |
AFG | 2007 | -3.58511111025937 |
AFG | 2008 | 12.5579601438018 |
AFG | 2009 | 17.5429289286094 |
AFG | 2010 | 11.3640937418183 |
AFG | 2011 | -1.24150600982001 |
AFG | 2012 | 7.17438724753763 |
AFG | 2013 | 9.78449593859924 |
AFG | 2014 | 14.3516893380043 |
AFG | 2015 | 12.2525481629518 |
AFG | 2016 | 17.5839381624543 |
AFG | 2017 | 12.1411782956513 |
AGO | 1995 | -84.0950001791546 |
AGO | 1996 | -93.5134588840176 |
AGO | 1997 | -29.522706549011 |
AGO | 1998 | 4.04755887747496 |
AGO | 1999 | -72.5785001611618 |
AGO | 2000 | -60.7813270387995 |
AGO | 2001 | -5.03293321688833 |
AGO | 2002 | -33.5534010972108 |
AGO | 2003 | 1.12848545105309 |
AGO | 2004 | 36.6376310182372 |
AGO | 2005 | 17.800888578278 |
AGO | 2006 | 2.04511437899832 |
AGO | 2007 | 12.83731631715 |
AGO | 2008 | -5.72372430776723 |
AGO | 2009 | 38.9777135532961 |
AGO | 2010 | -7.35379345431236 |
AGO | 2011 | -9.8763568407953 |
AGO | 2012 | 8.76470624625945 |
AGO | 2013 | 12.6108021772518 |
AGO | 2014 | 12.3805297698054 |
AGO | 2015 | 21.1441815303596 |
AGO | 2016 | -4.92200309730116 |
AGO | 2017 | -5.55269798180705 |
AGO | 2018 | -5.84400335337447 |
AGO | 2019 | 0.09091878728126 |
AGO | 2020 | 8.02865685308567 |
AGO | 2021 | -13.9893722418114 |
AGO | 2022 | 5.63414289470528 |
AGO | 2023 | -0.59401372733354 |
ALB | 1986 | 3.50195315750929 |
ALB | 1987 | 1.00030915479634 |
ALB | 1988 | 1.00058436844594 |
ALB | 1989 | 0.996284184948068 |
ALB | 1990 | 1.43757004142398 |
ALB | 1991 | -25.4690910605039 |
ALB | 1992 | -63.7871204806729 |
ALB | 1993 | -42.573513957233 |
ALB | 1994 | -8.96318218802336 |
ALB | 1995 | 8.80174501595399 |
ALB | 1996 | -10.2869748423574 |
ALB | 1997 | 19.2994943065822 |
ALB | 1999 | 19.110289294822 |
ALB | 2000 | 15.5754116055596 |
ALB | 2001 | 15.2617073910542 |
ALB | 2002 | 11.2464777871879 |
ALB | 2003 | 8.62387425855812 |
ALB | 2004 | 8.34605448112112 |
ALB | 2005 | 9.4555054819425 |
ALB | 2006 | 10.2087615799994 |
ALB | 2007 | 9.30474143806301 |
ALB | 2008 | 8.55052487389148 |
ALB | 2009 | 10.0007474139424 |
ALB | 2010 | 7.97103659621924 |
ALB | 2011 | 9.88846223555399 |
ALB | 2012 | 9.73611207346728 |
ALB | 2013 | 9.51039749125922 |
ALB | 2014 | 6.32455753333484 |
ALB | 2015 | 7.27249242163997 |
ALB | 2016 | 7.41372325944537 |
ALB | 2017 | 4.70106853289222 |
ALB | 2018 | 2.88052489157228 |
ALB | 2019 | 5.2229818174808 |
ALB | 2020 | 6.0772727041326 |
ALB | 2021 | 2.49145230404806 |
ALB | 2022 | -3.05375879949315 |
ALB | 2023 | 0.269282388635442 |
ARG | 2010 | -8.56602872006595 |
ARG | 2011 | -7.77340523607891 |
ARG | 2012 | -6.74819555440488 |
ARG | 2013 | -5.48583918237899 |
ARG | 2014 | -11.6006987702161 |
ARG | 2015 | -1.31470878459509 |
ARG | 2016 | -7.00603984304116 |
ARG | 2017 | 0.455892832330463 |
ARG | 2018 | 4.56440909873515 |
ARG | 2019 | 12.1039696489828 |
ARG | 2020 | -7.63517421630372 |
ARG | 2021 | -11.8618379621172 |
ARG | 2022 | -10.2880388707095 |
ARG | 2023 | -16.7714229097284 |
ARM | 1995 | -24.9130577387047 |
ARM | 1996 | 39.1051682810329 |
ARM | 1997 | 30.9943494018688 |
ARM | 1998 | 34.1346115887574 |
ARM | 1999 | 38.7736674369924 |
ARM | 2000 | 33.3984630599644 |
ARM | 2001 | 21.7821520799662 |
ARM | 2002 | 18.347069280194 |
ARM | 2003 | 15.5169875894729 |
ARM | 2004 | 11.6248159998918 |
ARM | 2005 | 14.3161459394903 |
ARM | 2006 | 11.3814924574335 |
ARM | 2007 | 12.6947444611314 |
ARM | 2008 | 10.4349146525184 |
ARM | 2009 | 15.8708814402684 |
ARM | 2010 | 10.6076357898925 |
ARM | 2011 | 12.9197578932998 |
ARM | 2012 | 11.2811932906832 |
ARM | 2013 | 12.2168430436348 |
ARM | 2014 | 13.7812486601176 |
ARM | 2015 | 16.1800096730379 |
ARM | 2016 | 17.0423595080455 |
ARM | 2017 | 11.9973399575166 |
ARM | 2018 | 9.73397739946579 |
ARM | 2019 | 10.9595785635957 |
ARM | 2020 | 9.63911034033596 |
ARM | 2021 | 4.5475881609954 |
ARM | 2022 | 3.45742932246251 |
ARM | 2023 | 9.45938580104027 |
ATG | 1982 | -0.526173848662356 |
ATG | 1983 | 5.88616892514923 |
ATG | 1984 | 6.98579263147035 |
ATG | 1985 | 2.97554962334484 |
ATG | 1986 | 3.29614031786762 |
ATG | 1987 | 1.20138937158079 |
ATG | 1988 | -2.97069647546934 |
ATG | 1989 | 5.25133100377403 |
ATG | 1990 | 8.36603602578817 |
ATG | 1991 | 9.25592387810004 |
ATG | 1992 | 9.49057537614492 |
ATG | 1993 | 10.1255139300131 |
ATG | 1994 | 9.22636483064334 |
ATG | 1995 | 9.3642098121068 |
ATG | 1996 | 8.55485681206744 |
ATG | 1997 | 9.21867581648869 |
ATG | 1998 | 9.26514825221011 |
ATG | 1999 | 9.86270666208393 |
ATG | 2000 | 10.5266388027486 |
ATG | 2001 | 9.34477885578616 |
ATG | 2002 | 9.96639466647376 |
ATG | 2003 | 13.3698345180625 |
ATG | 2004 | 9.39382906753031 |
ATG | 2005 | 6.41705016085212 |
ATG | 2006 | 9.65795814844011 |
ATG | 2007 | 5.81085125987591 |
ATG | 2008 | 5.43428699446918 |
ATG | 2009 | 8.85616847973957 |
ATG | 2010 | 9.245397047585 |
ATG | 2011 | 10.1777539162852 |
ATG | 2012 | 9.94528503724867 |
ATG | 2013 | 9.43050390180585 |
ATG | 2014 | 8.14853263915961 |
ATG | 2015 | 6.85576261673454 |
ATG | 2016 | 10.0904449048304 |
ATG | 2017 | 8.96995435447502 |
ATG | 2018 | 7.40806266963248 |
ATG | 2019 | 7.83657471966319 |
ATG | 2020 | 6.82913040505919 |
ATG | 2021 | 2.36242763396273 |
ATG | 2022 | 0.766250064542456 |
ATG | 2023 | 1.8066629756626 |
AUS | 1961 | 2.20692560793712 |
AUS | 1962 | 5.57982238394124 |
AUS | 1963 | 3.27642329508568 |
AUS | 1964 | 1.73296815471744 |
AUS | 1965 | 2.26055172547563 |
AUS | 1966 | 2.62118103356919 |
AUS | 1967 | 0.487603778344423 |
AUS | 1968 | 3.25731288075123 |
AUS | 1969 | 1.06790565029591 |
AUS | 1970 | 1.68731275314161 |
AUS | 1971 | 1.96215712359951 |
AUS | 1972 | 0.783718135678352 |
AUS | 1973 | -1.50501371908559 |
AUS | 1974 | -6.01710688667416 |
AUS | 1975 | -5.3386262414954 |
AUS | 1976 | -3.59867289743742 |
AUS | 1977 | -1.3854596473304 |
AUS | 1978 | 1.05215865048983 |
AUS | 1979 | 0.451577604708986 |
AUS | 1980 | -0.0339976167630712 |
AUS | 1981 | 2.10778189553925 |
AUS | 1982 | 1.41656486243981 |
AUS | 1983 | 2.05079757234455 |
AUS | 1984 | 3.37186563739584 |
AUS | 1985 | 7.39005351900863 |
AUS | 1986 | 7.93307034879721 |
AUS | 1987 | 7.52262378999285 |
AUS | 1988 | 6.44657903484019 |
AUS | 1989 | 6.61567133718071 |
AUS | 1990 | 9.67021678165599 |
AUS | 1991 | 10.0917039098626 |
AUS | 1992 | 8.97161508999743 |
AUS | 1993 | 8.47577209698829 |
AUS | 1994 | 7.9873226320194 |
AUS | 1995 | 8.02710491201081 |
AUS | 1996 | 6.83246606980178 |
AUS | 1997 | 5.81980195509809 |
AUS | 1998 | 5.48539696215229 |
AUS | 1999 | 6.06248171482023 |
AUS | 2000 | 5.03740890642031 |
AUS | 2001 | 2.11307506534252 |
AUS | 2002 | 3.42486719047131 |
AUS | 2003 | 3.52180969420429 |
AUS | 2004 | 3.69816487828225 |
AUS | 2005 | 3.30636818947589 |
AUS | 2006 | 2.37563825344262 |
AUS | 2007 | 3.0573409972652 |
AUS | 2008 | 4.14895231279179 |
AUS | 2009 | 1.02111732802342 |
AUS | 2010 | 6.05552716660896 |
AUS | 2011 | 1.44585192040902 |
AUS | 2012 | 5.07761464495177 |
AUS | 2013 | 6.35316102456067 |
AUS | 2014 | 4.4816194821113 |
AUS | 2015 | 6.23777334791279 |
AUS | 2016 | 6.12460674928936 |
AUS | 2017 | 1.53619552626779 |
AUS | 2018 | 3.32958805124833 |
AUS | 2019 | 1.57806683471944 |
AZE | 1998 | 21.017984953084 |
AZE | 1999 | 16.9546089911586 |
AZE | 2000 | 6.36757302509518 |
AZE | 2001 | 16.7690790545171 |
AZE | 2002 | 12.6244058764035 |
AZE | 2003 | 7.94230043681975 |
AZE | 2004 | 5.92029158128701 |
AZE | 2005 | 2.00903640930593 |
AZE | 2006 | 5.89581519410153 |
AZE | 2007 | -1.56862426696238 |
AZE | 2008 | -6.27259265102829 |
AZE | 2009 | 47.9010578481619 |
AZE | 2010 | 6.30070170030242 |
AZE | 2011 | -2.88597938752249 |
AZE | 2012 | 15.0296068894244 |
AZE | 2013 | 17.6862204009871 |
AZE | 2014 | 19.3916777101463 |
AZE | 2015 | 28.9454418522707 |
AZE | 2016 | 1.48583383570765 |
AZE | 2017 | 0.318577982868449 |
AZE | 2018 | 4.691769977505 |
AZE | 2019 | 17.5649086189187 |
AZE | 2020 | 26.5368212837468 |
AZE | 2021 | -4.24616359058951 |
AZE | 2022 | -16.5226749771746 |
AZE | 2023 | 25.5211682288753 |
BDI | 1978 | -0.451262623705508 |
BDI | 1979 | -11.2032255104271 |
BDI | 1980 | -3.76686094686617 |
BDI | 1981 | 19.2292447866872 |
BDI | 1982 | 5.98831967000174 |
BDI | 1983 | 5.23492170067308 |
BDI | 1984 | -4.4500633974039 |
BDI | 1985 | 6.59678082210115 |
BDI | 1986 | 16.9803375465518 |
BDI | 1987 | 15.9633910730591 |
BDI | 1988 | 8.22173811135184 |
BDI | 1989 | -2.40262500458507 |
BDI | 1990 | 5.99714246808453 |
BDI | 1991 | 8.34847759842348 |
BDI | 1992 | 7.83342951672532 |
BDI | 1993 | 5.59112035265415 |
BDI | 1994 | 7.0908334336198 |
BDI | 1995 | -0.727268464698452 |
BDI | 1998 | 3.54367365832104 |
BDI | 1999 | 0.245048218192701 |
BDI | 2000 | -16.6791975356856 |
BDI | 2001 | 2.73290368762483 |
BDI | 2002 | 18.2520363062058 |
BDI | 2003 | 5.61440230161237 |
BDI | 2004 | 4.51452118694419 |
BDI | 2005 | -0.333712699963746 |
BDI | 2006 | 13.8331873120086 |
BDI | 2007 | 7.91511085222448 |
BDI | 2008 | -6.19483253957242 |
BDI | 2009 | 3.27455750170274 |
BDI | 2010 | 3.5541539819574 |
BDI | 2011 | 4.49248695285009 |
BDI | 2012 | 0.0226856189418669 |
BDI | 2013 | 6.6643715965697 |
BDI | 2014 | 9.84057048451342 |
BDI | 2015 | -4.93706084453044 |
BDI | 2016 | 13.1373077077255 |
BDI | 2017 | 3.00359677995969 |
BDI | 2018 | 18.1576757569898 |
BDI | 2019 | 13.5659023946464 |
BDI | 2020 | 5.87779867369766 |
BDI | 2021 | 4.00087067669464 |
BDI | 2022 | -5.54308023795669 |
BDI | 2023 | -0.131115723919914 |
BEN | 2005 | 3.59609815466937 |
BEN | 2006 | 2.5881456183227 |
BEN | 2007 | 4.3445629753372 |
BEN | 2008 | -1.36233108364526 |
BEN | 2009 | 2.37742857428905 |
BEN | 2010 | 4.19549019095698 |
BEN | 2011 | 1.46803081679031 |
BEN | 2012 | -2.46960852040217 |
BEN | 2013 | 3.83659295370063 |
BEN | 2014 | 5.5999917955037 |
BEN | 2015 | 4.26633438639015 |
BEN | 2016 | 4.58009973405583 |
BEN | 2017 | 7.32902771803383 |
BEN | 2018 | 6.05230816342888 |
BEN | 2019 | 7.11416977822067 |
BEN | 2020 | 3.55709341440007 |
BEN | 2021 | 4.55750151392328 |
BFA | 2005 | 4.94407010067677 |
BFA | 2006 | 5.43552158413382 |
BFA | 2007 | 2.20437671811626 |
BFA | 2008 | -3.82524863007166 |
BFA | 2009 | 2.51157897500392 |
BFA | 2010 | 1.28514116887426 |
BFA | 2011 | -1.3885289905265 |
BFA | 2012 | -0.741639727368065 |
BFA | 2013 | 7.57802019961703 |
BFA | 2014 | 5.99591815146962 |
BFA | 2015 | 7.54593907323847 |
BFA | 2016 | 2.62240552190937 |
BFA | 2017 | 5.02421161425245 |
BFA | 2018 | 5.62891377347395 |
BFA | 2019 | 6.1439206172505 |
BFA | 2020 | 0.0675375097350463 |
BFA | 2021 | 6.13021813204196 |
BGD | 1976 | 33.7950583515742 |
BGD | 1977 | 13.861562262757 |
BGD | 1978 | -12.269219666905 |
BGD | 1979 | -2.09486764748523 |
BGD | 1980 | -5.98813218230924 |
BGD | 1981 | 1.12798479968249 |
BGD | 1982 | 1.16377387984429 |
BGD | 1983 | 2.43947329768085 |
BGD | 1984 | 3.02081321608222 |
BGD | 1985 | -6.2119269152058 |
BGD | 1986 | 4.37450569364977 |
BGD | 1987 | 3.35321767891823 |
BGD | 1988 | 6.83736162270725 |
BGD | 1989 | 6.00688829655354 |
BGD | 1990 | 7.8032155756163 |
BGD | 1991 | 11.7189873524357 |
BGD | 1992 | 11.0503571312982 |
BGD | 1993 | 13.7409692658164 |
BGD | 1994 | 9.12576468789762 |
BGD | 1995 | 5.45528455877529 |
BGD | 1996 | -5.16455193045819 |
BGD | 1997 | 8.8533210419986 |
BGD | 1998 | 7.8256481093584 |
BGD | 1999 | 8.97864304812787 |
BGD | 2000 | 8.99820323770434 |
BGD | 2001 | 9.25695571842855 |
BGD | 2002 | 8.38969935744544 |
BGD | 2003 | 5.88445428042499 |
BGD | 2004 | 5.58235561080853 |
BGD | 2005 | 5.76426911966502 |
BGD | 2006 | 5.46699380857848 |
BGD | 2007 | 5.7891114361705 |
BGD | 2008 | 4.66174256991608 |
BGD | 2009 | 6.14653833234923 |
BGD | 2010 | 4.73612356896119 |
BGD | 2011 | 5.06419768574575 |
BGD | 2012 | 5.3433326587313 |
BGD | 2013 | 5.98869390231371 |
BGD | 2014 | 6.88586627746747 |
BGD | 2015 | 5.51264431590569 |
BGD | 2016 | -13.6421356407858 |
BGD | 2017 | 4.27653989369391 |
BGD | 2018 | 3.63430365848223 |
BGD | 2019 | 5.68956371493223 |
BGD | 2020 | 4.2891862514626 |
BGD | 2021 | 3.07621573507077 |
BGD | 2022 | 1.9724805729144 |
BGD | 2023 | 0.629461237622801 |
BGR | 1992 | 9.06847543134924 |
BGR | 1993 | 17.0524850892292 |
BGR | 1994 | 17.261174977305 |
BGR | 1995 | -23.9850694232532 |
BGR | 1996 | 139.963711232831 |
BGR | 1997 | -69.1063589894178 |
BGR | 1998 | -14.8320472516921 |
BGR | 1999 | 9.85227625600933 |
BGR | 2000 | 3.69017836396426 |
BGR | 2001 | 4.70518374367318 |
BGR | 2002 | 5.16085377785747 |
BGR | 2003 | 6.2178221679987 |
BGR | 2004 | 3.11585389047119 |
BGR | 2005 | 1.93887023447479 |
BGR | 2006 | 2.00086233757088 |
BGR | 2007 | -0.948808133796198 |
BGR | 2008 | 2.55123092492009 |
BGR | 2009 | 7.11672374989339 |
BGR | 2010 | 10.3015197969987 |
BGR | 2011 | 4.25643907358051 |
BGR | 2012 | 8.50741184532138 |
BGR | 2013 | 8.965006039723 |
BGR | 2014 | 6.83027957403434 |
BGR | 2015 | 4.37223769632351 |
BGR | 2016 | 2.97072370154384 |
BGR | 2017 | 0.597670418786322 |
BGR | 2018 | 0.679071463804736 |
BGR | 2019 | -0.652136208064892 |
BGR | 2020 | -0.00422201137831966 |
BGR | 2021 | -2.66479476528815 |
BGR | 2022 | -10.5008398914837 |
BGR | 2023 | -3.28394425747554 |
BHR | 1986 | 31.8990788938976 |
BHR | 1987 | 6.79616154339312 |
BHR | 1988 | 5.67650698131262 |
BHR | 1989 | 4.26721428921831 |
BHR | 1990 | 3.41972663043074 |
BHR | 1991 | 11.4748696151444 |
BHR | 1992 | 15.8180449521602 |
BHR | 1993 | 14.2943018205998 |
BHR | 1994 | 3.15013960937877 |
BHR | 1995 | 10.4967012426128 |
BHR | 1996 | 12.0998243544461 |
BHR | 1997 | 11.1609441639776 |
BHR | 1998 | 20.2848637906505 |
BHR | 1999 | 8.84268072364891 |
BHR | 2000 | -2.37890672244412 |
BHR | 2001 | 14.5455946650751 |
BHR | 2002 | 4.82736149404232 |
BHR | 2003 | -0.283027354056302 |
BHR | 2004 | -2.78109322103354 |
BHR | 2005 | -5.19902924913244 |
BHR | 2006 | -0.796745563030568 |
BHR | 2007 | -0.156120281991366 |
BHR | 2008 | -2.82101981381698 |
BHR | 2009 | 24.061967721618 |
BHR | 2010 | -4.24924584453932 |
BHR | 2011 | -2.46162141459636 |
BHR | 2012 | 3.01266280675138 |
BHR | 2013 | 5.40813959591411 |
BHR | 2014 | 7.41558701492672 |
BHR | 2015 | 15.2531776895774 |
BHS | 1976 | 6.94438712573368 |
BHS | 1977 | 7.63923723601807 |
BHS | 1978 | 7.09268100384856 |
BHS | 1979 | 0.525916092569516 |
BHS | 1980 | 0.751287393264862 |
BHS | 1981 | -5.68308500706424 |
BHS | 1982 | 7.04469060143084 |
BHS | 1983 | 4.73974026328542 |
BHS | 1984 | 7.58791859967344 |
BHS | 1985 | 1.72652925214658 |
BHS | 1986 | 4.38524365032919 |
BHS | 1987 | 2.26450422140818 |
BHS | 1988 | 7.40576480245897 |
BHS | 1989 | 7.05883981138421 |
BHS | 1990 | 3.73669961161005 |
BHS | 1991 | 6.28283688115539 |
BHS | 1992 | 4.02073544299569 |
BHS | 1993 | 8.38172804190316 |
BHS | 1994 | 4.59138662110409 |
BHS | 1995 | 5.90021921872135 |
BHS | 1996 | 5.70956037432645 |
BHS | 1997 | -38.3765361322397 |
BHS | 1998 | 3.59157439480759 |
BHS | 1999 | 1.35688264456125 |
BHS | 2000 | 5.03087234206615 |
BHS | 2001 | 5.62697758445409 |
BHS | 2002 | 1.96182798147075 |