Baselight
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.

economyyearinterest_rate
ABW19876.47543427271753
ABW19886.91818005864427
ABW19896.26423401893797
ABW19904.5666408556276
ABW19914.79112520734837
ABW19926.52813758772899
ABW19935.03292510547116
ABW19944.05692612365099
ABW19956.98825052743605
ABW19966.89090544941648
ABW19976.31195251913281
ABW19984.173555703149
ABW199910.7168994077419
ABW200010.9174500760991
ABW200115.885948876168
ABW20026.57378500312943
ABW20037.42457507462851
ABW20046.60450953637949
ABW20055.64637297616821
ABW20065.81310509823675
ABW20074.97600231726435
ABW20085.9825479431511
ABW20098.84604657019821
ABW201011.6661307585963
ABW20114.80197433814387
ABW20128.20087500684476
ABW201310.7097087655441
ABW20143.21386882031282
ABW20150.15792476968271
ABW20167.98285170979736
ABW20179.78928665665114
ABW20182.45304531465618
ABW2019-0.299776140992784
ABW20207.82593470132022
ABW202111.8970840161137
ABW20222.85265433875112
ABW2023-0.852277920562397
AFG200610.0468971030039
AFG2007-3.58511111025937
AFG200812.5579601438018
AFG200917.5429289286094
AFG201011.3640937418183
AFG2011-1.24150600982001
AFG20127.17438724753763
AFG20139.78449593859924
AFG201414.3516893380043
AFG201512.2525481629518
AFG201617.5839381624543
AFG201712.1411782956513
AGO1995-84.0950001791546
AGO1996-93.5134588840176
AGO1997-29.522706549011
AGO19984.04755887747496
AGO1999-72.5785001611618
AGO2000-60.7813270387995
AGO2001-5.03293321688833
AGO2002-33.5534010972108
AGO20031.12848545105309
AGO200436.6376310182372
AGO200517.800888578278
AGO20062.04511437899832
AGO200712.83731631715
AGO2008-5.72372430776723
AGO200938.9777135532961
AGO2010-7.35379345431236
AGO2011-9.8763568407953
AGO20128.76470624625945
AGO201312.6108021772518
AGO201412.3805297698054
AGO201521.1441815303596
AGO2016-4.92200309730116
AGO2017-5.55269798180705
AGO2018-5.84400335337447
AGO20190.09091878728126
AGO20208.02865685308567
AGO2021-13.9893722418114
AGO20225.63414289470528
AGO2023-0.59401372733354
ALB19863.50195315750929
ALB19871.00030915479634
ALB19881.00058436844594
ALB19890.996284184948068
ALB19901.43757004142398
ALB1991-25.4690910605039
ALB1992-63.7871204806729
ALB1993-42.573513957233
ALB1994-8.96318218802336
ALB19958.80174501595399
ALB1996-10.2869748423574
ALB199719.2994943065822
ALB199919.110289294822
ALB200015.5754116055596
ALB200115.2617073910542
ALB200211.2464777871879
ALB20038.62387425855812
ALB20048.34605448112112
ALB20059.4555054819425
ALB200610.2087615799994
ALB20079.30474143806301
ALB20088.55052487389148
ALB200910.0007474139424
ALB20107.97103659621924
ALB20119.88846223555399
ALB20129.73611207346728
ALB20139.51039749125922
ALB20146.32455753333484
ALB20157.27249242163997
ALB20167.41372325944537
ALB20174.70106853289222
ALB20182.88052489157228
ALB20195.2229818174808
ALB20206.0772727041326
ALB20212.49145230404806
ALB2022-3.05375879949315
ALB20230.269282388635442
ARG2010-8.56602872006595
ARG2011-7.77340523607891
ARG2012-6.74819555440488
ARG2013-5.48583918237899
ARG2014-11.6006987702161
ARG2015-1.31470878459509
ARG2016-7.00603984304116
ARG20170.455892832330463
ARG20184.56440909873515
ARG201912.1039696489828
ARG2020-7.63517421630372
ARG2021-11.8618379621172
ARG2022-10.2880388707095
ARG2023-16.7714229097284
ARM1995-24.9130577387047
ARM199639.1051682810329
ARM199730.9943494018688
ARM199834.1346115887574
ARM199938.7736674369924
ARM200033.3984630599644
ARM200121.7821520799662
ARM200218.347069280194
ARM200315.5169875894729
ARM200411.6248159998918
ARM200514.3161459394903
ARM200611.3814924574335
ARM200712.6947444611314
ARM200810.4349146525184
ARM200915.8708814402684
ARM201010.6076357898925
ARM201112.9197578932998
ARM201211.2811932906832
ARM201312.2168430436348
ARM201413.7812486601176
ARM201516.1800096730379
ARM201617.0423595080455
ARM201711.9973399575166
ARM20189.73397739946579
ARM201910.9595785635957
ARM20209.63911034033596
ARM20214.5475881609954
ARM20223.45742932246251
ARM20239.45938580104027
ATG1982-0.526173848662356
ATG19835.88616892514923
ATG19846.98579263147035
ATG19852.97554962334484
ATG19863.29614031786762
ATG19871.20138937158079
ATG1988-2.97069647546934
ATG19895.25133100377403
ATG19908.36603602578817
ATG19919.25592387810004
ATG19929.49057537614492
ATG199310.1255139300131
ATG19949.22636483064334
ATG19959.3642098121068
ATG19968.55485681206744
ATG19979.21867581648869
ATG19989.26514825221011
ATG19999.86270666208393
ATG200010.5266388027486
ATG20019.34477885578616
ATG20029.96639466647376
ATG200313.3698345180625
ATG20049.39382906753031
ATG20056.41705016085212
ATG20069.65795814844011
ATG20075.81085125987591
ATG20085.43428699446918
ATG20098.85616847973957
ATG20109.245397047585
ATG201110.1777539162852
ATG20129.94528503724867
ATG20139.43050390180585
ATG20148.14853263915961
ATG20156.85576261673454
ATG201610.0904449048304
ATG20178.96995435447502
ATG20187.40806266963248
ATG20197.83657471966319
ATG20206.82913040505919
ATG20212.36242763396273
ATG20220.766250064542456
ATG20231.8066629756626
AUS19612.20692560793712
AUS19625.57982238394124
AUS19633.27642329508568
AUS19641.73296815471744
AUS19652.26055172547563
AUS19662.62118103356919
AUS19670.487603778344423
AUS19683.25731288075123
AUS19691.06790565029591
AUS19701.68731275314161
AUS19711.96215712359951
AUS19720.783718135678352
AUS1973-1.50501371908559
AUS1974-6.01710688667416
AUS1975-5.3386262414954
AUS1976-3.59867289743742
AUS1977-1.3854596473304
AUS19781.05215865048983
AUS19790.451577604708986
AUS1980-0.0339976167630712
AUS19812.10778189553925
AUS19821.41656486243981
AUS19832.05079757234455
AUS19843.37186563739584
AUS19857.39005351900863
AUS19867.93307034879721
AUS19877.52262378999285
AUS19886.44657903484019
AUS19896.61567133718071
AUS19909.67021678165599
AUS199110.0917039098626
AUS19928.97161508999743
AUS19938.47577209698829
AUS19947.9873226320194
AUS19958.02710491201081
AUS19966.83246606980178
AUS19975.81980195509809
AUS19985.48539696215229
AUS19996.06248171482023
AUS20005.03740890642031
AUS20012.11307506534252
AUS20023.42486719047131
AUS20033.52180969420429
AUS20043.69816487828225
AUS20053.30636818947589
AUS20062.37563825344262
AUS20073.0573409972652
AUS20084.14895231279179
AUS20091.02111732802342
AUS20106.05552716660896
AUS20111.44585192040902
AUS20125.07761464495177
AUS20136.35316102456067
AUS20144.4816194821113
AUS20156.23777334791279
AUS20166.12460674928936
AUS20171.53619552626779
AUS20183.32958805124833
AUS20191.57806683471944
AZE199821.017984953084
AZE199916.9546089911586
AZE20006.36757302509518
AZE200116.7690790545171
AZE200212.6244058764035
AZE20037.94230043681975
AZE20045.92029158128701
AZE20052.00903640930593
AZE20065.89581519410153
AZE2007-1.56862426696238
AZE2008-6.27259265102829
AZE200947.9010578481619
AZE20106.30070170030242
AZE2011-2.88597938752249
AZE201215.0296068894244
AZE201317.6862204009871
AZE201419.3916777101463
AZE201528.9454418522707
AZE20161.48583383570765
AZE20170.318577982868449
AZE20184.691769977505
AZE201917.5649086189187
AZE202026.5368212837468
AZE2021-4.24616359058951
AZE2022-16.5226749771746
AZE202325.5211682288753
BDI1978-0.451262623705508
BDI1979-11.2032255104271
BDI1980-3.76686094686617
BDI198119.2292447866872
BDI19825.98831967000174
BDI19835.23492170067308
BDI1984-4.4500633974039
BDI19856.59678082210115
BDI198616.9803375465518
BDI198715.9633910730591
BDI19888.22173811135184
BDI1989-2.40262500458507
BDI19905.99714246808453
BDI19918.34847759842348
BDI19927.83342951672532
BDI19935.59112035265415
BDI19947.0908334336198
BDI1995-0.727268464698452
BDI19983.54367365832104
BDI19990.245048218192701
BDI2000-16.6791975356856
BDI20012.73290368762483
BDI200218.2520363062058
BDI20035.61440230161237
BDI20044.51452118694419
BDI2005-0.333712699963746
BDI200613.8331873120086
BDI20077.91511085222448
BDI2008-6.19483253957242
BDI20093.27455750170274
BDI20103.5541539819574
BDI20114.49248695285009
BDI20120.0226856189418669
BDI20136.6643715965697
BDI20149.84057048451342
BDI2015-4.93706084453044
BDI201613.1373077077255
BDI20173.00359677995969
BDI201818.1576757569898
BDI201913.5659023946464
BDI20205.87779867369766
BDI20214.00087067669464
BDI2022-5.54308023795669
BDI2023-0.131115723919914
BEN20053.59609815466937
BEN20062.5881456183227
BEN20074.3445629753372
BEN2008-1.36233108364526
BEN20092.37742857428905
BEN20104.19549019095698
BEN20111.46803081679031
BEN2012-2.46960852040217
BEN20133.83659295370063
BEN20145.5999917955037
BEN20154.26633438639015
BEN20164.58009973405583
BEN20177.32902771803383
BEN20186.05230816342888
BEN20197.11416977822067
BEN20203.55709341440007
BEN20214.55750151392328
BFA20054.94407010067677
BFA20065.43552158413382
BFA20072.20437671811626
BFA2008-3.82524863007166
BFA20092.51157897500392
BFA20101.28514116887426
BFA2011-1.3885289905265
BFA2012-0.741639727368065
BFA20137.57802019961703
BFA20145.99591815146962
BFA20157.54593907323847
BFA20162.62240552190937
BFA20175.02421161425245
BFA20185.62891377347395
BFA20196.1439206172505
BFA20200.0675375097350463
BFA20216.13021813204196
BGD197633.7950583515742
BGD197713.861562262757
BGD1978-12.269219666905
BGD1979-2.09486764748523
BGD1980-5.98813218230924
BGD19811.12798479968249
BGD19821.16377387984429
BGD19832.43947329768085
BGD19843.02081321608222
BGD1985-6.2119269152058
BGD19864.37450569364977
BGD19873.35321767891823
BGD19886.83736162270725
BGD19896.00688829655354
BGD19907.8032155756163
BGD199111.7189873524357
BGD199211.0503571312982
BGD199313.7409692658164
BGD19949.12576468789762
BGD19955.45528455877529
BGD1996-5.16455193045819
BGD19978.8533210419986
BGD19987.8256481093584
BGD19998.97864304812787
BGD20008.99820323770434
BGD20019.25695571842855
BGD20028.38969935744544
BGD20035.88445428042499
BGD20045.58235561080853
BGD20055.76426911966502
BGD20065.46699380857848
BGD20075.7891114361705
BGD20084.66174256991608
BGD20096.14653833234923
BGD20104.73612356896119
BGD20115.06419768574575
BGD20125.3433326587313
BGD20135.98869390231371
BGD20146.88586627746747
BGD20155.51264431590569
BGD2016-13.6421356407858
BGD20174.27653989369391
BGD20183.63430365848223
BGD20195.68956371493223
BGD20204.2891862514626
BGD20213.07621573507077
BGD20221.9724805729144
BGD20230.629461237622801
BGR19929.06847543134924
BGR199317.0524850892292
BGR199417.261174977305
BGR1995-23.9850694232532
BGR1996139.963711232831
BGR1997-69.1063589894178
BGR1998-14.8320472516921
BGR19999.85227625600933
BGR20003.69017836396426
BGR20014.70518374367318
BGR20025.16085377785747
BGR20036.2178221679987
BGR20043.11585389047119
BGR20051.93887023447479
BGR20062.00086233757088
BGR2007-0.948808133796198
BGR20082.55123092492009
BGR20097.11672374989339
BGR201010.3015197969987
BGR20114.25643907358051
BGR20128.50741184532138
BGR20138.965006039723
BGR20146.83027957403434
BGR20154.37223769632351
BGR20162.97072370154384
BGR20170.597670418786322
BGR20180.679071463804736
BGR2019-0.652136208064892
BGR2020-0.00422201137831966
BGR2021-2.66479476528815
BGR2022-10.5008398914837
BGR2023-3.28394425747554
BHR198631.8990788938976
BHR19876.79616154339312
BHR19885.67650698131262
BHR19894.26721428921831
BHR19903.41972663043074
BHR199111.4748696151444
BHR199215.8180449521602
BHR199314.2943018205998
BHR19943.15013960937877
BHR199510.4967012426128
BHR199612.0998243544461
BHR199711.1609441639776
BHR199820.2848637906505
BHR19998.84268072364891
BHR2000-2.37890672244412
BHR200114.5455946650751
BHR20024.82736149404232
BHR2003-0.283027354056302
BHR2004-2.78109322103354
BHR2005-5.19902924913244
BHR2006-0.796745563030568
BHR2007-0.156120281991366
BHR2008-2.82101981381698
BHR200924.061967721618
BHR2010-4.24924584453932
BHR2011-2.46162141459636
BHR20123.01266280675138
BHR20135.40813959591411
BHR20147.41558701492672
BHR201515.2531776895774
BHS19766.94438712573368
BHS19777.63923723601807
BHS19787.09268100384856
BHS19790.525916092569516
BHS19800.751287393264862
BHS1981-5.68308500706424
BHS19827.04469060143084
BHS19834.73974026328542
BHS19847.58791859967344
BHS19851.72652925214658
BHS19864.38524365032919
BHS19872.26450422140818
BHS19887.40576480245897
BHS19897.05883981138421
BHS19903.73669961161005
BHS19916.28283688115539
BHS19924.02073544299569
BHS19938.38172804190316
BHS19944.59138662110409
BHS19955.90021921872135
BHS19965.70956037432645
BHS1997-38.3765361322397
BHS19983.59157439480759
BHS19991.35688264456125
BHS20005.03087234206615
BHS20015.62697758445409
BHS20021.96182798147075

Share link

Anyone who has the link will be able to view this.