Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
select setseed(0.1);
create table movie(
  id serial primary key,
  name text);
create table movie_similarity_eav(
  movie_id int references movie(id),
  similar_movie_id int references movie(id),
  similarity float,
  primary key (movie_id,similar_movie_id));

setseed

SELECT 1

CREATE TABLE

CREATE TABLE

insert into movie select n,gen_random_uuid() from generate_series(0,200)_(n);
insert into movie_similarity_eav
select m1.id,
       m2.id,
       random() 
from movie m1,
     movie m2;

INSERT 0 201

INSERT 0 40401

update movie_similarity_eav set similarity=1 where movie_id=similar_movie_id;
create index on movie_similarity_eav(movie_id,similar_movie_id,similarity);

UPDATE 201

CREATE INDEX

vacuum full analyze movie_similarity_eav;

VACUUM

reindex table movie_similarity_eav;

REINDEX

analyze movie_similarity_eav;

ANALYZE

select * from movie_similarity_eav order by 1,2 limit 5;

movie_id
similar_movie_id
similarity

0
0
1

0
1
0.6402839231277071

0
2
0.80326410702165

0
3
0.931589426258701

0
4
0.6259215008930064

SELECT 5

create table movie_similarity_aggregated(
  movie_id int references movie(id) primary key,
  similarity_matrix jsonb);
insert into movie_similarity_aggregated
select movie_id
      ,jsonb_build_object( 'similar_movies'
                          ,jsonb_object_agg( similar_movie_id
                                            ,similarity) )
from movie_similarity_eav
group by 1;

create index on movie_similarity_aggregated using gin(similarity_matrix jsonb_path_ops);

select * from movie_similarity_aggregated order by movie_id limit 5;

CREATE TABLE

INSERT 0 201

CREATE INDEX

movie_id
similarity_matrix

0
{"similar_movies": {"0": 1, "1": 0.6402839231277071, "2": 0.80326410702165, "3": 0.931589426258701, "4": 0.6259215008930064, "5": 0.5672997490122342, "6": 0.8578615329841426, "7": 0.7325563883371855, "8": 0.3600874906707998, "9": 0.5221492089224498, "10": 0.09492404399367715, "11": 0.22107472315621246, "12": 0.4490803777150987, "13": 0.06453374256407374, "14": 0.8927113628939145, "15": 0.15825347615115293, "16": 0.8857178261559, "17": 0.3217950214747862, "18": 0.341082934097217, "19": 0.7137396498968465, "20": 0.5524970803140483, "21": 0.7738742353166534, "22": 0.46432459998807074, "23": 0.8053006786971446, "24": 0.3364291052967978, "25": 0.06559563847002381, "26": 0.40828575492974606, "27": 0.5412830855515973, "28": 0.39693794059956966, "29": 0.46579364610368845, "30": 0.5546101460236379, "31": 0.2062434135136173, "32": 0.32050444369138753, "33": 0.9377223975701177, "34": 0.3219156358444968, "35": 0.7572705109084732, "36": 0.2472547498935156, "37": 0.008352071061640265, "38": 0.7609955796664358, "39": 0.9082676507606964, "40": 0.5942768195056889, "41": 0.7792755549467103, "42": 0.7605817554632119, "43": 0.5284350601706922, "44": 0.20231133411829827, "45": 0.45103644414046085, "46": 0.10378759519045322, "47": 0.7401252978548116, "48": 0.44412098218259577, "49": 0.42178606885400427, "50": 0.84777996889338, "51": 0.9284534965702238, "52": 0.1628978441868476, "53": 0.538111216434358, "54": 0.10872353201869145, "55": 0.430649973471561, "56": 0.5076997974849975, "57": 0.3141784535276304, "58": 0.11039262889227852, "59": 0.5337327160360641, "60": 0.8450456684730074, "61": 0.2125157749150164, "62": 0.3658200275382497, "63": 0.9439324951948684, "64": 0.13982046274132354, "65": 0.7727156010439384, "66": 0.4254127081454253, "67": 0.774440321959625, "68": 0.5845366365124032, "69": 0.4317932981196866, "70": 0.8804686294366224, "71": 0.19494497249216258, "72": 0.9565037077794105, "73": 0.6633587656147757, "74": 0.11063175296563754, "75": 0.8419324317627868, "76": 0.9471737433998897, "77": 0.3594856511497764, "78": 0.5520995470756334, "79": 0.5606043538349021, "80": 0.09698580780402821, "81": 0.4804363155103444, "82": 0.48768639055715424, "83": 0.4099327409232456, "84": 0.5081419329745871, "85": 0.13911763432821767, "86": 0.040627708169777677, "87": 0.22680344303662747, "88": 0.04555192035152533, "89": 0.996691205306764, "90": 0.2582138068393032, "91": 0.5977951473901733, "92": 0.8316611951757016, "93": 0.029430110729057768, "94": 0.06744418837831145, "95": 0.8746504852973174, "96": 0.8771069916735457, "97": 0.9018499375271856, "98": 0.12388311739364699, "99": 0.5713491811165003, "100": 0.47060312642515245, "101": 0.5943886246862606, "102": 0.6202420013561201, "103": 0.8576416212531159, "104": 0.6474693072284965, "105": 0.1383688393260507, "106": 0.0017047082275258862, "107": 0.2442393500528559, "108": 0.8997863796784054, "109": 0.9972348380720784, "110": 0.5647193637163865, "111": 0.5708282420961432, "112": 0.15680856012375188, "113": 0.9049343582816416, "114": 0.4627879836769402, "115": 0.6858517429542306, "116": 0.8388923017648884, "117": 0.6586092764855049, "118": 0.2320829243714464, "119": 0.17220625381853716, "120": 0.5725619096266137, "121": 0.44987522615940057, "122": 0.8706250995612239, "123": 0.5754451925631052, "124": 0.6669023632364008, "125": 0.18265682017977425, "126": 0.5105748249122624, "127": 0.4589352080175655, "128": 0.6711536259624789, "129": 0.6066796065600164, "130": 0.8805669599646411, "131": 0.4745154393500832, "132": 0.4435619071012047, "133": 0.11309360359769016, "134": 0.5582094625951823, "135": 0.04545678476827164, "136": 0.18400068976629336, "137": 0.6684286937583674, "138": 0.9114139796889358, "139": 0.7857108391171712, "140": 0.433546214188659, "141": 0.11081708300759607, "142": 0.7441433069039594, "143": 0.2799492212506425, "144": 0.40329373388078626, "145": 0.8591220215735964, "146": 0.026511375817391603, "147": 0.31587668641681166, "148": 0.009878613034935313, "149": 0.3846165319549504, "150": 0.4680505357339797, "151": 0.31642980121012054, "152": 0.2066655837935092, "153": 0.13199190281785644, "154": 0.6942321763472501, "155": 0.3195208787960011, "156": 0.6553533746336204, "157": 0.35866791930087216, "158": 0.20092884679872713, "159": 0.045511488068457506, "160": 0.8911378115084563, "161": 0.12668797830065026, "162": 0.17657171848741182, "163": 0.08193905473057095, "164": 0.7212212796831847, "165": 0.6607465708464806, "166": 0.6105590888688803, "167": 0.3120773220460975, "168": 0.47772078809639384, "169": 0.16306564480810515, "170": 0.397033099898892, "171": 0.629922602076, "172": 0.14952540138400638, "173": 0.5644458170642463, "174": 0.8487718514646372, "175": 0.22716590958649618, "176": 0.5126382272581662, "177": 0.36532189652455194, "178": 0.07412727327220514, "179": 0.47798056436506675, "180": 0.26807170965547056, "181": 0.31963092803279136, "182": 0.5643802945895948, "183": 0.2107276224435326, "184": 0.6527094946569285, "185": 0.8947120876340162, "186": 0.8826960113641973, "187": 0.1216713624626693, "188": 0.6805827396921877, "189": 0.5102563071539221, "190": 0.7941983106986479, "191": 0.4037594746027313, "192": 0.1400354879038217, "193": 0.8175105938980916, "194": 0.15743804954376373, "195": 0.486052651071639, "196": 0.5686909075418174, "197": 0.21689826080516061, "198": 0.4019006184741889, "199": 0.48165347589769647, "200": 0.8573038483948223}}

1
{"similar_movies": {"0": 0.7534195199719247, "1": 1, "2": 0.8779510855105501, "3": 0.9830930813277112, "4": 0.8418436514817351, "5": 0.04663871662084684, "6": 0.1952877897499996, "7": 0.019828668837614805, "8": 0.9154488854561404, "9": 0.8732227263254189, "10": 0.8143084883070588, "11": 0.28212091785089344, "12": 0.5506028764944795, "13": 0.4408821190489889, "14": 0.8354376189666419, "15": 0.34539160824382953, "16": 0.3033565023091469, "17": 0.7669314540493126, "18": 0.32644290042831825, "19": 0.4230820259018857, "20": 0.02559772987527076, "21": 0.4536823946814461, "22": 0.5827792346850806, "23": 0.4273056335408134, "24": 0.7155873457424502, "25": 0.3320049434896313, "26": 0.11407770692653574, "27": 0.2592859621591195, "28": 0.3338749540895134, "29": 0.1428075495020804, "30": 0.12883998257316986, "31": 0.7358195146379598, "32": 0.7097630969594402, "33": 0.08008324416077084, "34": 0.03416289866580935, "35": 0.28855608058196935, "36": 0.5881731295421964, "37": 0.9024156112592641, "38": 0.20035002829585036, "39": 0.2102962792016898, "40": 0.5060711149501478, "41": 0.9300244500356651, "42": 0.7176346787091317, "43": 0.8079693716712686, "44": 0.9322420947150494, "45": 0.11182063329352965, "46": 0.11866412598579035, "47": 0.31256573590131165, "48": 0.6330706688405048, "49": 0.9214860647274896, "50": 0.7691754696247637, "51": 0.041329887649882435, "52": 0.6935895335867488, "53": 0.8543472288923761, "54": 0.778210827431072, "55": 0.5364874070034231, "56": 0.41671916000094145, "57": 0.07875716375462383, "58": 0.4671506667868308, "59": 0.943439344076688, "60": 0.9834470612311268, "61": 0.04166579572040652, "62": 0.17532037120337818, "63": 0.2808305580177377, "64": 0.739354472989056, "65": 0.3645362003489976, "66": 0.26442053861998804, "67": 0.32192645821404264, "68": 0.39046092338553606, "69": 0.3875910952863566, "70": 0.9094528516611093, "71": 0.3444760577991275, "72": 0.7427523694383902, "73": 0.9215200228045681, "74": 0.2392620210993266, "75": 0.8865822264167273, "76": 0.1427225882336305, "77": 0.47300536695445383, "78": 0.7050948356867479, "79": 0.9831763959419084, "80": 0.0033432507033341885, "81": 0.5805711624505774, "82": 0.2231519406930076, "83": 0.7206259500611119, "84": 0.991493954192866, "85": 0.04125100956074057, "86": 0.9462112499786104, "87": 0.37082255121024166, "88": 0.40292492032510396, "89": 0.07391866285576754, "90": 0.08732318394273175, "91": 0.23795581610172678, "92": 0.19509351829996868, "93": 0.7565045407840303, "94": 0.7129538308840915, "95": 0.5379111262902032, "96": 0.7085911935127329, "97": 0.5854870978525695, "98": 0.0009859731935359939, "99": 0.18758897574408562, "100": 0.37420104533332244, "101": 0.7508097293532883, "102": 0.9124571919722257, "103": 0.318876666646962, "104": 0.7666503906425957, "105": 0.9588897340903639, "106": 0.567871045012488, "107": 0.826581043436508, "108": 0.9516693907043177, "109": 0.7164976991211656, "110": 0.4636976002765125, "111": 0.0728045899739811, "112": 0.0714395582096683, "113": 0.9341942942057786, "114": 0.79737671461877, "115": 0.006731591063005693, "116": 0.6378320299452571, "117": 0.08033653939553642, "118": 0.961002527460247, "119": 0.8604338334810515, "120": 0.03053191172850167, "121": 0.9461420435627361, "122": 0.16389919260307906, "123": 0.768416361244034, "124": 0.12865696246682878, "125": 0.5058340628159379, "126": 0.41706963973330935, "127": 0.3555444783201509, "128": 0.7102742473845953, "129": 0.4456422668176827, "130": 0.9864403916921192, "131": 0.07056539314653199, "132": 0.9385875058921993, "133": 0.17581634953208258, "134": 0.5167484526112738, "135": 0.912328282383938, "136": 0.2574870001630747, "137": 0.2731667297865312, "138": 0.2904095940117062, "139": 0.5720206306275131, "140": 0.6856199137021182, "141": 0.10203597096144046, "142": 0.9345914390470123, "143": 0.11367860238840044, "144": 0.6199800302208722, "145": 0.7417955260048494, "146": 0.9887962053265043, "147": 0.0411505841134332, "148": 0.7417040756288023, "149": 0.0846091644770619, "150": 0.1512521777359106, "151": 0.08091393518063139, "152": 0.21802231535302763, "153": 0.24941286067774993, "154": 0.21559369265195327, "155": 0.5194654302265425, "156": 0.9852181900394243, "157": 0.9195096765066866, "158": 0.35101889243176054, "159": 0.15345249182308907, "160": 0.24048638216764018, "161": 0.6495905265650825, "162": 0.3261019776501062, "163": 0.8890503476101035, "164": 0.6632271904250249, "165": 0.5279966638637785, "166": 0.7289236262614835, "167": 0.13706110814401162, "168": 0.3524365855091045, "169": 0.49336906491522337, "170": 0.447670485499863, "171": 0.07053393328039559, "172": 0.803136892583725, "173": 0.23277801778551233, "174": 0.9277132618992807, "175": 0.734622752154807, "176": 0.838008954724679, "177": 0.22800134686598628, "178": 0.903635592500152, "179": 0.8884830854056578, "180": 0.17561173785389306, "181": 0.5689255009318077, "182": 0.639989074063043, "183": 0.1480505270961625, "184": 0.16497668836257184, "185": 0.45854223189797216, "186": 0.3802971307891716, "187": 0.22881569764791432, "188": 0.18762473425215842, "189": 0.023168444051438364, "190": 0.6992987242619821, "191": 0.572627333296091, "192": 0.4343117294652603, "193": 0.48576455558275144, "194": 0.8014091560193779, "195": 0.320875713429118, "196": 0.14515695597996858, "197": 0.7890344438971375, "198": 0.8789288331143239, "199": 0.743635091696653, "200": 0.8843572140775546}}

2
{"similar_movies": {"0": 0.18985561555013408, "1": 0.33163881720349586, "2": 1, "3": 0.439582003357434, "4": 0.2985690090849298, "5": 0.5171176522172332, "6": 0.36829287866876403, "7": 0.0869759356152735, "8": 0.12259673499715285, "9": 0.7876173236052582, "10": 0.25473290510615376, "11": 0.4935197394660089, "12": 0.6279546281952411, "13": 0.2848247401668067, "14": 0.8421997278972375, "15": 0.6534596351115682, "16": 0.44325208880988787, "17": 0.16409374321302161, "18": 0.30829307072011636, "19": 0.4827614140887597, "20": 0.20585142804515577, "21": 0.1689319089998147, "22": 0.2330024024252748, "23": 0.8876027737924137, "24": 0.05950356731647832, "25": 0.4261257347887879, "26": 0.6002286229092131, "27": 0.5354999205518347, "28": 0.9081780260308434, "29": 0.9572479586848655, "30": 0.5007376310485012, "31": 0.01443487755414119, "32": 0.8595137536366029, "33": 0.10327282947451133, "34": 0.033450450145707133, "35": 0.11979083677508928, "36": 0.04638942327393769, "37": 0.895820910725194, "38": 0.9876889415570687, "39": 0.40482888830757413, "40": 0.03008002451587899, "41": 0.49877331011434944, "42": 0.994876955757855, "43": 0.6137835514412042, "44": 0.6804882412812809, "45": 0.5182201735474121, "46": 0.40868212476083343, "47": 0.9436466551919436, "48": 0.3168030980319385, "49": 0.19598535281673302, "50": 0.02067075941140195, "51": 0.3131676774798906, "52": 0.7106677106526909, "53": 0.015010228981257034, "54": 0.23661118273430404, "55": 0.07433244673999617, "56": 0.7876525419541689, "57": 0.3286634263353998, "58": 0.6212686425572338, "59": 0.7470288433002001, "60": 0.46437892134519587, "61": 0.5079917065238164, "62": 0.5727370197947919, "63": 0.48619808637260786, "64": 0.20864534402628943, "65": 0.5659159146171575, "66": 0.616573471537545, "67": 0.960966239809325, "68": 0.3675671523997954, "69": 0.12911421616101837, "70": 0.33424040128620724, "71": 0.8448068561171642, "72": 0.09080714031700832, "73": 0.23118510775266699, "74": 0.4705705878748965, "75": 0.3978836726606776, "76": 0.4841524026235857, "77": 0.403148330121486, "78": 0.7117337928825911, "79": 0.19312226485206652, "80": 0.4628516209564406, "81": 0.8726391423759308, "82": 0.6128054824908298, "83": 0.6906549906392125, "84": 0.6637786191782173, "85": 0.7289565902255861, "86": 0.8063583342906697, "87": 0.7527331915791395, "88": 0.13727412534514438, "89": 0.13935569932979042, "90": 0.795058628191041, "91": 0.5849816379785804, "92": 0.46456072558702144, "93": 0.3656518621079812, "94": 0.49664996725008415, "95": 0.5845486090368184, "96": 0.40321751571757325, "97": 0.6073360583008351, "98": 0.9921820169262852, "99": 0.7640138843317721, "100": 0.9985089345613372, "101": 0.09729824904118756, "102": 0.4520326431999777, "103": 0.2810173951120123, "104": 0.3728791859970506, "105": 0.7965487671181091, "106": 0.1513722487218483, "107": 0.37338639129161844, "108": 0.7855116840754042, "109": 0.6555816659020277, "110": 0.36139003471561537, "111": 0.2882943320671749, "112": 0.10984698223846556, "113": 0.7267933950910814, "114": 0.04460211234017497, "115": 0.6859375767463252, "116": 0.9765158806696135, "117": 0.5215235090891925, "118": 0.43046851554271703, "119": 0.06473286210470097, "120": 0.7024145739562526, "121": 0.8761416663502897, "122": 0.22050800772491708, "123": 0.6309330532089947, "124": 0.18817779257441725, "125": 0.007362703989580055, "126": 0.5460126053096845, "127": 0.4500348077205132, "128": 0.1908095695076515, "129": 0.652960157072821, "130": 0.28754093142410464, "131": 0.6359921627337071, "132": 0.7798878635658342, "133": 0.6342086661625479, "134": 0.7703789844494306, "135": 0.47225751426827434, "136": 0.9195342021713193, "137": 0.05911842853633842, "138": 0.13335238819135542, "139": 0.6386013051435995, "140": 0.05146471105936068, "141": 0.7701205375157223, "142": 0.726435013874771, "143": 0.7832535338333766, "144": 0.4730283325615874, "145": 0.7902941816129327, "146": 0.32319639784933085, "147": 0.24909924422053975, "148": 0.8064138816031359, "149": 0.24608864519032436, "150": 0.10773284424484397, "151": 0.8972377652089212, "152": 0.062201235539556254, "153": 0.013476215642487466, "154": 0.3054534542111589, "155": 0.9843977929737264, "156": 0.7384083866521538, "157": 0.898690802800099, "158": 0.6788533619635373, "159": 0.35769383032818114, "160": 0.7690079212486862, "161": 0.36102357309567745, "162": 0.36967018329754997, "163": 0.38033680711203277, "164": 0.4869720688772021, "165": 0.07617628188667513, "166": 0.597091451032262, "167": 0.27355951910670084, "168": 0.3323141935460685, "169": 0.31442407962020336, "170": 0.826743950310382, "171": 0.05362976194151381, "172": 0.14567415700623232, "173": 0.4717083620686655, "174": 0.969252554993097, "175": 0.7493622969782674, "176": 0.8287748508914072, "177": 0.8749318003124056, "178": 0.44289149545339246, "179": 0.7311778074258772, "180": 0.353233117515527, "181": 0.22154370493724485, "182": 0.25051918421995123, "183": 0.4663912441705469, "184": 0.3426253947742661, "185": 0.04909451044194513, "186": 0.6003630861769071, "187": 0.22321923759236229, "188": 0.6422373438562041, "189": 0.5426225724527494, "190": 0.17968503599785324, "191": 0.0609656909705214, "192": 0.09514994638648044, "193": 0.8112542952541018, "194": 0.6148301312032483, "195": 0.030698114183083547, "196": 0.454656796107481, "197": 0.11193292632176965, "198": 0.6168644280018636, "199": 0.11959342367919779, "200": 0.08574216394210188}}

3
{"similar_movies": {"0": 0.13765696297504526, "1": 0.9186137595442667, "2": 0.06653644991702579, "3": 1, "4": 0.45485579930562725, "5": 0.3507577550034511, "6": 0.2878327694149121, "7": 0.4584320436360301, "8": 0.342003123755112, "9": 0.04024163791534119, "10": 0.6246002346400303, "11": 0.09294859442950343, "12": 0.9533166499619319, "13": 0.8731741525039973, "14": 0.4593126456387795, "15": 0.3764884231482184, "16": 0.5616460523959952, "17": 0.631230362666187, "18": 0.22422258957138586, "19": 0.9000751702691472, "20": 0.08434416442036108, "21": 0.3667570041365409, "22": 0.9010866197196064, "23": 0.2033895435053048, "24": 0.7200533600584982, "25": 0.08077647404114452, "26": 0.2826467818014513, "27": 0.4491433104574225, "28": 0.25331744571772874, "29": 0.9541265493612237, "30": 0.6462448768625864, "31": 0.4184456131267946, "32": 0.7033292656110506, "33": 0.25809863432053404, "34": 0.07829177002938392, "35": 0.9027940132013452, "36": 0.4949106412764259, "37": 0.2740710161844877, "38": 0.2857722931321247, "39": 0.4763558691997041, "40": 0.33394527040318156, "41": 0.4696493808093387, "42": 0.9209565323445847, "43": 0.046352712447778055, "44": 0.2965022668014443, "45": 0.6021868877931429, "46": 0.17159013500536213, "47": 0.4072453471377433, "48": 0.6701911770324669, "49": 0.006543961099213069, "50": 0.02053816470220604, "51": 0.9935396050391976, "52": 0.929256857636144, "53": 0.6080476351863764, "54": 0.40771925407249565, "55": 0.05671024080935938, "56": 0.43558923483057077, "57": 0.6689020668344059, "58": 0.7247553215097757, "59": 0.8821309696425945, "60": 0.8945667378729261, "61": 0.45176173323688085, "62": 0.6919209655204164, "63": 0.18631983833338994, "64": 0.9885864535118214, "65": 0.9321437602296845, "66": 0.038139067988089526, "67": 0.09691876788307807, "68": 0.6796338166404534, "69": 0.9733334736107822, "70": 0.4884406056217099, "71": 0.06648620899844437, "72": 0.5856293705952988, "73": 0.31719872747900846, "74": 0.8564085630007499, "75": 0.4560747364914388, "76": 0.7991426945867028, "77": 0.15408034839000928, "78": 0.611866679754357, "79": 0.6222555110119807, "80": 0.8253267701864582, "81": 0.34946953242896095, "82": 0.5467116657270701, "83": 0.42900907425460866, "84": 0.9364582545729645, "85": 0.12999443591316417, "86": 0.911114688320924, "87": 0.19729257927688515, "88": 0.015294233644338684, "89": 0.9151293199276671, "90": 0.993751605566408, "91": 0.3436155929106348, "92": 0.8060040548041891, "93": 0.06099126442006986, "94": 0.5916456966833528, "95": 0.5721800613623589, "96": 0.6539781481659144, "97": 0.5778554372880074, "98": 0.5209348763297328, "99": 0.6477603913362044, "100": 0.6725038133375885, "101": 0.10434505933296112, "102": 0.7470074683398609, "103": 0.07386352660915252, "104": 0.6085420072738796, "105": 0.7821201691625825, "106": 0.31386813189136964, "107": 0.17577671377169435, "108": 0.114887967558857, "109": 0.29385749872794475, "110": 0.09144901405182404, "111": 0.08157776056383148, "112": 0.8676676497768032, "113": 0.7094108122920708, "114": 0.8806301061400592, "115": 0.9876585235032491, "116": 0.4179985479134387, "117": 0.26657384890962765, "118": 0.14971408272025877, "119": 0.7898570367754822, "120": 0.7853551645371741, "121": 0.7209502970538766, "122": 0.3524389504296681, "123": 0.40637806150257316, "124": 0.6259569772581921, "125": 0.7637285852794629, "126": 0.5405767013373477, "127": 0.6174040471740496, "128": 0.29252349646979425, "129": 0.14816591445181082, "130": 0.02660841316118634, "131": 0.3477088519393676, "132": 0.891024809136689, "133": 0.21145278258727784, "134": 0.07918308306011701, "135": 0.7197716058297523, "136": 0.5521004396124305, "137": 0.18078961390969406, "138": 0.7884939855352149, "139": 0.0325675052883323, "140": 0.12477398057085409, "141": 0.5474466774306797, "142": 0.9986474974533064, "143": 0.135289855996501, "144": 0.3329137953956989, "145": 0.8290285423347761, "146": 0.18674406347995265, "147": 0.34405185012248096, "148": 0.361863741804054, "149": 0.20244915802569574, "150": 0.2407951922594167, "151": 0.8789135827552192, "152": 0.5813093631789636, "153": 0.2971756683028912, "154": 0.3359162193425764, "155": 0.6713279291985594, "156": 0.01358452879561578, "157": 0.8859599425407949, "158": 0.9575766250373348, "159": 0.9366726815908917, "160": 0.890822087025789, "161": 0.9637522492168229, "162": 0.22527643571688838, "163": 0.46441810904412084, "164": 0.07743800702529868, "165": 0.4094861393707545, "166": 0.9929594776577297, "167": 0.6597369075637838, "168": 0.980123200763038, "169": 0.1348405522893492, "170": 0.9421718575243052, "171": 0.3115290853265267, "172": 0.8439492984147468, "173": 0.37040202546564815, "174": 0.36770896959908983, "175": 0.8412394227048048, "176": 0.18063161532107785, "177": 0.6025918795644056, "178": 0.5239913019988798, "179": 0.6776928325674882, "180": 0.010615597370484897, "181": 0.7802986223520751, "182": 0.05104441133181159, "183": 0.5404749193957648, "184": 0.6833674210148415, "185": 0.2198361270951943, "186": 0.5203160531057749, "187": 0.6032180922807155, "188": 0.19664709776472122, "189": 0.5819546048179856, "190": 0.1805107583025647, "191": 0.44905616533851833, "192": 0.44921939795243904, "193": 0.6560433048103791, "194": 0.855964069579243, "195": 0.5254675998666711, "196": 0.6819355442554744, "197": 0.21079205127321865, "198": 0.775807645693213, "199": 0.72176039567336, "200": 0.26797545144939483}}

4
{"similar_movies": {"0": 0.19829960883275377, "1": 0.6784620438347166, "2": 0.39097663479341804, "3": 0.7317196178103531, "4": 1, "5": 0.062023902607259984, "6": 0.8931305899131832, "7": 0.6065257624842144, "8": 0.4300808039843793, "9": 0.33269392657441643, "10": 0.7780832403860583, "11": 0.3708945425841321, "12": 0.42764396067062793, "13": 0.3711647719828117, "14": 0.37879632264356444, "15": 0.23746590436434611, "16": 0.3762494415445814, "17": 0.16042815977046554, "18": 0.5850675409893547, "19": 0.2411557015442125, "20": 0.6290459767666485, "21": 0.7837065416710058, "22": 0.8338879781739241, "23": 0.5184423882678417, "24": 0.30210620195413584, "25": 0.36948248722927013, "26": 0.06499805959263893, "27": 0.7429812434937662, "28": 0.542077022357339, "29": 0.5167371730329906, "30": 0.1960309390354591, "31": 0.51345831981945, "32": 0.0825628932912863, "33": 0.8470384164232565, "34": 0.1208972598197462, "35": 0.5390496746921405, "36": 0.5328108867931487, "37": 0.5109504232182744, "38": 0.6254204029451189, "39": 0.7123488314004611, "40": 0.6051852257817796, "41": 0.22041089614670972, "42": 0.18453599888968686, "43": 0.4820433173130858, "44": 0.7859168935545087, "45": 0.24993629957990793, "46": 0.585319662070785, "47": 0.6474656533378969, "48": 0.357535191269555, "49": 0.6480298123560941, "50": 0.2060152100780046, "51": 0.12282212458881081, "52": 0.38259949392997217, "53": 0.8045515749018, "54": 0.9580961416947147, "55": 0.8579736582933817, "56": 0.15053581738234523, "57": 0.1828295242844038, "58": 0.1192260925169022, "59": 0.7814543291882856, "60": 0.5535869151856965, "61": 0.7658051404050028, "62": 0.21240598336521588, "63": 0.4908908621816874, "64": 0.07180985893976088, "65": 0.9219515506428635, "66": 0.5544803814471486, "67": 0.4509125560001219, "68": 0.3052997809032034, "69": 0.812358256229055, "70": 0.7032885041837347, "71": 0.48253238787988506, "72": 0.6210431432032901, "73": 0.0993720580457933, "74": 0.463694246999637, "75": 0.7842159841320968, "76": 0.15008359639023627, "77": 0.4179802647911812, "78": 0.38635636475606017, "79": 0.6303757872032592, "80": 0.2631627057988828, "81": 0.4964472054634794, "82": 0.6743199020643769, "83": 0.5137756802377158, "84": 0.37939564474418286, "85": 0.18327539870486453, "86": 0.9829567838566915, "87": 0.7275933878634759, "88": 0.3457431268462561, "89": 0.8854538171601851, "90": 0.175113518014695, "91": 0.6785944643321844, "92": 0.20456247171518083, "93": 0.07683064350115276, "94": 0.12584321470743887, "95": 0.7542069252677055, "96": 0.8646034371823914, "97": 0.22286033926045978, "98": 0.43099953819708126, "99": 0.34544907933591107, "100": 0.1714197499196657, "101": 0.4292648882464065, "102": 0.004430976100663342, "103": 0.25160087345183424, "104": 0.9503714729032531, "105": 0.20329048469552258, "106": 0.5982233842462594, "107": 0.50447936748822, "108": 0.6372608398364659, "109": 0.36569221263117857, "110": 0.34635313763351405, "111": 0.05127812241541441, "112": 0.5491587649784933, "113": 0.7762517591135003, "114": 0.22368899958589128, "115": 0.5106430985903694, "116": 0.708101878425355, "117": 0.013270850147389934, "118": 0.7087840735351587, "119": 0.49806794674333554, "120": 0.16773955723453837, "121": 0.9562379540091546, "122": 0.6639569775395415, "123": 0.29859030799492725, "124": 0.5036465182717655, "125": 0.1137905492490181, "126": 0.5675487822235947, "127": 0.6818278654366765, "128": 0.45507675820918814, "129": 0.409589726696151, "130": 0.40826159722165123, "131": 0.27160072191823903, "132": 0.3846259371806131, "133": 0.9609802257464837, "134": 0.7613069470387352, "135": 0.18862401881473256, "136": 0.8770681421682438, "137": 0.9508072961959606, "138": 0.36688945855102584, "139": 0.16278794625383464, "140": 0.005930535436925677, "141": 0.398208538119212, "142": 0.28807327075608624, "143": 0.22608626052759817, "144": 0.5750430555787223, "145": 0.7082663890707499, "146": 0.5009557940865783, "147": 0.48428880500582205, "148": 0.17485808957238635, "149": 0.9113025326468762, "150": 0.6098625581892847, "151": 0.34579427502373106, "152": 0.6758759873504008, "153": 0.4465666246197122, "154": 0.7111779751002207, "155": 0.38627919700015956, "156": 0.83719775366964, "157": 0.8664237569772566, "158": 0.5311720222743257, "159": 0.4066130351067645, "160": 0.39548113332590296, "161": 0.960089745921521, "162": 0.6340738417761229, "163": 0.9846585784129389, "164": 0.9854460166671697, "165": 0.8611101340168763, "166": 0.8622374637898802, "167": 0.9105119447062995, "168": 0.6370422597396685, "169": 0.08630319353719473, "170": 0.3981637394724997, "171": 0.007150222989983801, "172": 0.5072981991027026, "173": 0.9627323061574999, "174": 0.5454524746104852, "175": 0.2142863163669484, "176": 0.7420869357217132, "177": 0.8372362615612461, "178": 0.8045351668396976, "179": 0.0318061925386135, "180": 0.6030968520882636, "181": 0.9596443301172142, "182": 0.7385072634291607, "183": 0.2891984296104868, "184": 0.3852226283831832, "185": 0.5080309956760898, "186": 0.14036995731966173, "187": 0.9844004553274488, "188": 0.026866447015433614, "189": 0.08227084507744853, "190": 0.01793648977320661, "191": 0.29086758863570794, "192": 0.09135643860889853, "193": 0.7133133405859844, "194": 0.6580413679289023, "195": 0.7160158519933566, "196": 0.2870460948718234, "197": 0.43122550535582227, "198": 0.6941957692187153, "199": 0.9988221443980485, "200": 0.2456368263022104}}

SELECT 5

select movie_id
      ,j.key AS similar_movie_id
      ,j.value::float AS similarity
      ,row_number()over(partition by movie_id order by j.value::float desc) score
from movie_similarity_aggregated,
     jsonb_each(similarity_matrix->'similar_movies')AS j
limit 5;

movie_id
similar_movie_id
similarity
score

0
0
1
1

0
109
0.9972348380720784
2

0
89
0.996691205306764
3

0
72
0.9565037077794105
4

0
76
0.9471737433998897
5

SELECT 5

--type `json` used to preserve key order in an object
select json_build_object( 'movie_id',movie_id,'similar_movies'
                         ,json_object_agg( similar_movie_id
                                          ,similarity order by score) )
from (select movie_id
            ,j.key AS similar_movie_id
            ,j.value::float AS similarity
            ,row_number()over(partition by movie_id order by j.value::float desc) score
      from movie_similarity_aggregated
          ,jsonb_each(similarity_matrix->'similar_movies')AS j)_
where score<=10
group by movie_id
limit 3;

json_build_object

{"movie_id" : 0, "similar_movies" : { "0" : 1, "109" : 0.9972348380720784, "89" : 0.996691205306764, "72" : 0.9565037077794105, "76" : 0.9471737433998897, "63" : 0.9439324951948684, "33" : 0.9377223975701177, "3" : 0.931589426258701, "51" : 0.9284534965702238, "138" : 0.9114139796889358 }}

{"movie_id" : 1, "similar_movies" : { "1" : 1, "84" : 0.991493954192866, "146" : 0.9887962053265043, "130" : 0.9864403916921192, "156" : 0.9852181900394243, "60" : 0.9834470612311268, "79" : 0.9831763959419084, "3" : 0.9830930813277112, "118" : 0.961002527460247, "105" : 0.9588897340903639 }}

{"movie_id" : 2, "similar_movies" : { "2" : 1, "100" : 0.9985089345613372, "42" : 0.994876955757855, "98" : 0.9921820169262852, "38" : 0.9876889415570687, "155" : 0.9843977929737264, "116" : 0.9765158806696135, "174" : 0.969252554993097, "67" : 0.960966239809325, "29" : 0.9572479586848655 }}

SELECT 3

--solidify the order by nesting key-value pairs as objects in an array
select jsonb_build_object( 'movie_id',movie_id,'similar_movies'
                          ,jsonb_agg(jsonb_build_object( similar_movie_id
                                                        ,similarity) 
                                     order by score))
from (select movie_id
            ,j.key AS similar_movie_id
            ,j.value::float AS similarity
            ,row_number()over(partition by movie_id order by j.value::float desc) score
      from movie_similarity_aggregated
          ,jsonb_each(similarity_matrix->'similar_movies')AS j)_
where score<=10
group by movie_id
limit 3;

jsonb_build_object

{"movie_id": 0, "similar_movies": [{"0": 1}, {"109": 0.9972348380720784}, {"89": 0.996691205306764}, {"72": 0.9565037077794105}, {"76": 0.9471737433998897}, {"63": 0.9439324951948684}, {"33": 0.9377223975701177}, {"3": 0.931589426258701}, {"51": 0.9284534965702238}, {"138": 0.9114139796889358}]}

{"movie_id": 1, "similar_movies": [{"1": 1}, {"84": 0.991493954192866}, {"146": 0.9887962053265043}, {"130": 0.9864403916921192}, {"156": 0.9852181900394243}, {"60": 0.9834470612311268}, {"79": 0.9831763959419084}, {"3": 0.9830930813277112}, {"118": 0.961002527460247}, {"105": 0.9588897340903639}]}

{"movie_id": 2, "similar_movies": [{"2": 1}, {"100": 0.9985089345613372}, {"42": 0.994876955757855}, {"98": 0.9921820169262852}, {"38": 0.9876889415570687}, {"155": 0.9843977929737264}, {"116": 0.9765158806696135}, {"174": 0.969252554993097}, {"67": 0.960966239809325}, {"29": 0.9572479586848655}]}

SELECT 3

select jsonb_build_object( 'movie_id',movie_id,'similar_movies'
                          ,jsonb_agg(jsonb_build_object( similar_movie_id
                                                        ,similarity) 
                                     order by similarity desc))
from movie_similarity_eav
group by movie_id
limit 3;

jsonb_build_object

{"movie_id": 0, "similar_movies": [{"0": 1}, {"109": 0.9972348380720784}, {"89": 0.996691205306764}, {"72": 0.9565037077794105}, {"76": 0.9471737433998897}, {"63": 0.9439324951948684}, {"33": 0.9377223975701177}, {"3": 0.931589426258701}, {"51": 0.9284534965702238}, {"138": 0.9114139796889358}, {"39": 0.9082676507606964}, {"113": 0.9049343582816416}, {"97": 0.9018499375271856}, {"108": 0.8997863796784054}, {"185": 0.8947120876340162}, {"14": 0.8927113628939145}, {"160": 0.8911378115084563}, {"16": 0.8857178261559}, {"186": 0.8826960113641973}, {"130": 0.8805669599646411}, {"70": 0.8804686294366224}, {"96": 0.8771069916735457}, {"95": 0.8746504852973174}, {"122": 0.8706250995612239}, {"145": 0.8591220215735964}, {"6": 0.8578615329841426}, {"103": 0.8576416212531159}, {"200": 0.8573038483948223}, {"174": 0.8487718514646372}, {"50": 0.84777996889338}, {"60": 0.8450456684730074}, {"75": 0.8419324317627868}, {"116": 0.8388923017648884}, {"92": 0.8316611951757016}, {"193": 0.8175105938980916}, {"23": 0.8053006786971446}, {"2": 0.80326410702165}, {"190": 0.7941983106986479}, {"139": 0.7857108391171712}, {"41": 0.7792755549467103}, {"67": 0.774440321959625}, {"21": 0.7738742353166534}, {"65": 0.7727156010439384}, {"38": 0.7609955796664358}, {"42": 0.7605817554632119}, {"35": 0.7572705109084732}, {"142": 0.7441433069039594}, {"47": 0.7401252978548116}, {"7": 0.7325563883371855}, {"164": 0.7212212796831847}, {"19": 0.7137396498968465}, {"154": 0.6942321763472501}, {"115": 0.6858517429542306}, {"188": 0.6805827396921877}, {"128": 0.6711536259624789}, {"137": 0.6684286937583674}, {"124": 0.6669023632364008}, {"73": 0.6633587656147757}, {"165": 0.6607465708464806}, {"117": 0.6586092764855049}, {"156": 0.6553533746336204}, {"184": 0.6527094946569285}, {"104": 0.6474693072284965}, {"1": 0.6402839231277071}, {"171": 0.629922602076}, {"4": 0.6259215008930064}, {"102": 0.6202420013561201}, {"166": 0.6105590888688803}, {"129": 0.6066796065600164}, {"91": 0.5977951473901733}, {"101": 0.5943886246862606}, {"40": 0.5942768195056889}, {"68": 0.5845366365124032}, {"123": 0.5754451925631052}, {"120": 0.5725619096266137}, {"99": 0.5713491811165003}, {"111": 0.5708282420961432}, {"196": 0.5686909075418174}, {"5": 0.5672997490122342}, {"110": 0.5647193637163865}, {"173": 0.5644458170642463}, {"182": 0.5643802945895948}, {"79": 0.5606043538349021}, {"134": 0.5582094625951823}, {"30": 0.5546101460236379}, {"20": 0.5524970803140483}, {"78": 0.5520995470756334}, {"27": 0.5412830855515973}, {"53": 0.538111216434358}, {"59": 0.5337327160360641}, {"43": 0.5284350601706922}, {"9": 0.5221492089224498}, {"176": 0.5126382272581662}, {"126": 0.5105748249122624}, {"189": 0.5102563071539221}, {"84": 0.5081419329745871}, {"56": 0.5076997974849975}, {"82": 0.48768639055715424}, {"195": 0.486052651071639}, {"199": 0.48165347589769647}, {"81": 0.4804363155103444}, {"179": 0.47798056436506675}, {"168": 0.47772078809639384}, {"131": 0.4745154393500832}, {"100": 0.47060312642515245}, {"150": 0.4680505357339797}, {"29": 0.46579364610368845}, {"22": 0.46432459998807074}, {"114": 0.4627879836769402}, {"127": 0.4589352080175655}, {"45": 0.45103644414046085}, {"121": 0.44987522615940057}, {"12": 0.4490803777150987}, {"48": 0.44412098218259577}, {"132": 0.4435619071012047}, {"140": 0.433546214188659}, {"69": 0.4317932981196866}, {"55": 0.430649973471561}, {"66": 0.4254127081454253}, {"49": 0.42178606885400427}, {"83": 0.4099327409232456}, {"26": 0.40828575492974606}, {"191": 0.4037594746027313}, {"144": 0.40329373388078626}, {"198": 0.4019006184741889}, {"170": 0.397033099898892}, {"28": 0.39693794059956966}, {"149": 0.3846165319549504}, {"62": 0.3658200275382497}, {"177": 0.36532189652455194}, {"8": 0.3600874906707998}, {"77": 0.3594856511497764}, {"157": 0.35866791930087216}, {"18": 0.341082934097217}, {"24": 0.3364291052967978}, {"34": 0.3219156358444968}, {"17": 0.3217950214747862}, {"32": 0.32050444369138753}, {"181": 0.31963092803279136}, {"155": 0.3195208787960011}, {"151": 0.31642980121012054}, {"147": 0.31587668641681166}, {"57": 0.3141784535276304}, {"167": 0.3120773220460975}, {"143": 0.2799492212506425}, {"180": 0.26807170965547056}, {"90": 0.2582138068393032}, {"36": 0.2472547498935156}, {"107": 0.2442393500528559}, {"118": 0.2320829243714464}, {"175": 0.22716590958649618}, {"87": 0.22680344303662747}, {"11": 0.22107472315621246}, {"197": 0.21689826080516061}, {"61": 0.2125157749150164}, {"183": 0.2107276224435326}, {"152": 0.2066655837935092}, {"31": 0.2062434135136173}, {"44": 0.20231133411829827}, {"158": 0.20092884679872713}, {"71": 0.19494497249216258}, {"136": 0.18400068976629336}, {"125": 0.18265682017977425}, {"162": 0.17657171848741182}, {"119": 0.17220625381853716}, {"169": 0.16306564480810515}, {"52": 0.1628978441868476}, {"15": 0.15825347615115293}, {"194": 0.15743804954376373}, {"112": 0.15680856012375188}, {"172": 0.14952540138400638}, {"192": 0.1400354879038217}, {"64": 0.13982046274132354}, {"85": 0.13911763432821767}, {"105": 0.1383688393260507}, {"153": 0.13199190281785644}, {"161": 0.12668797830065026}, {"98": 0.12388311739364699}, {"187": 0.1216713624626693}, {"133": 0.11309360359769016}, {"141": 0.11081708300759607}, {"74": 0.11063175296563754}, {"58": 0.11039262889227852}, {"54": 0.10872353201869145}, {"46": 0.10378759519045322}, {"80": 0.09698580780402821}, {"10": 0.09492404399367715}, {"163": 0.08193905473057095}, {"178": 0.07412727327220514}, {"94": 0.06744418837831145}, {"25": 0.06559563847002381}, {"13": 0.06453374256407374}, {"88": 0.04555192035152533}, {"159": 0.045511488068457506}, {"135": 0.04545678476827164}, {"86": 0.040627708169777677}, {"93": 0.029430110729057768}, {"146": 0.026511375817391603}, {"148": 0.009878613034935313}, {"37": 0.008352071061640265}, {"106": 0.0017047082275258862}]}

{"movie_id": 1, "similar_movies": [{"1": 1}, {"84": 0.991493954192866}, {"146": 0.9887962053265043}, {"130": 0.9864403916921192}, {"156": 0.9852181900394243}, {"60": 0.9834470612311268}, {"79": 0.9831763959419084}, {"3": 0.9830930813277112}, {"118": 0.961002527460247}, {"105": 0.9588897340903639}, {"108": 0.9516693907043177}, {"86": 0.9462112499786104}, {"121": 0.9461420435627361}, {"59": 0.943439344076688}, {"132": 0.9385875058921993}, {"142": 0.9345914390470123}, {"113": 0.9341942942057786}, {"44": 0.9322420947150494}, {"41": 0.9300244500356651}, {"174": 0.9277132618992807}, {"73": 0.9215200228045681}, {"49": 0.9214860647274896}, {"157": 0.9195096765066866}, {"8": 0.9154488854561404}, {"102": 0.9124571919722257}, {"135": 0.912328282383938}, {"70": 0.9094528516611093}, {"178": 0.903635592500152}, {"37": 0.9024156112592641}, {"163": 0.8890503476101035}, {"179": 0.8884830854056578}, {"75": 0.8865822264167273}, {"200": 0.8843572140775546}, {"198": 0.8789288331143239}, {"2": 0.8779510855105501}, {"9": 0.8732227263254189}, {"119": 0.8604338334810515}, {"53": 0.8543472288923761}, {"4": 0.8418436514817351}, {"176": 0.838008954724679}, {"14": 0.8354376189666419}, {"107": 0.826581043436508}, {"10": 0.8143084883070588}, {"43": 0.8079693716712686}, {"172": 0.803136892583725}, {"194": 0.8014091560193779}, {"114": 0.79737671461877}, {"197": 0.7890344438971375}, {"54": 0.778210827431072}, {"50": 0.7691754696247637}, {"123": 0.768416361244034}, {"17": 0.7669314540493126}, {"104": 0.7666503906425957}, {"93": 0.7565045407840303}, {"0": 0.7534195199719247}, {"101": 0.7508097293532883}, {"199": 0.743635091696653}, {"72": 0.7427523694383902}, {"145": 0.7417955260048494}, {"148": 0.7417040756288023}, {"64": 0.739354472989056}, {"31": 0.7358195146379598}, {"175": 0.734622752154807}, {"166": 0.7289236262614835}, {"83": 0.7206259500611119}, {"42": 0.7176346787091317}, {"109": 0.7164976991211656}, {"24": 0.7155873457424502}, {"94": 0.7129538308840915}, {"128": 0.7102742473845953}, {"32": 0.7097630969594402}, {"96": 0.7085911935127329}, {"78": 0.7050948356867479}, {"190": 0.6992987242619821}, {"52": 0.6935895335867488}, {"140": 0.6856199137021182}, {"164": 0.6632271904250249}, {"161": 0.6495905265650825}, {"182": 0.639989074063043}, {"116": 0.6378320299452571}, {"48": 0.6330706688405048}, {"144": 0.6199800302208722}, {"36": 0.5881731295421964}, {"97": 0.5854870978525695}, {"22": 0.5827792346850806}, {"81": 0.5805711624505774}, {"191": 0.572627333296091}, {"139": 0.5720206306275131}, {"181": 0.5689255009318077}, {"106": 0.567871045012488}, {"12": 0.5506028764944795}, {"95": 0.5379111262902032}, {"55": 0.5364874070034231}, {"165": 0.5279966638637785}, {"155": 0.5194654302265425}, {"134": 0.5167484526112738}, {"40": 0.5060711149501478}, {"125": 0.5058340628159379}, {"169": 0.49336906491522337}, {"193": 0.48576455558275144}, {"77": 0.47300536695445383}, {"58": 0.4671506667868308}, {"110": 0.4636976002765125}, {"185": 0.45854223189797216}, {"21": 0.4536823946814461}, {"170": 0.447670485499863}, {"129": 0.4456422668176827}, {"13": 0.4408821190489889}, {"192": 0.4343117294652603}, {"23": 0.4273056335408134}, {"19": 0.4230820259018857}, {"126": 0.41706963973330935}, {"56": 0.41671916000094145}, {"88": 0.40292492032510396}, {"68": 0.39046092338553606}, {"69": 0.3875910952863566}, {"186": 0.3802971307891716}, {"100": 0.37420104533332244}, {"87": 0.37082255121024166}, {"65": 0.3645362003489976}, {"127": 0.3555444783201509}, {"168": 0.3524365855091045}, {"158": 0.35101889243176054}, {"15": 0.34539160824382953}, {"71": 0.3444760577991275}, {"28": 0.3338749540895134}, {"25": 0.3320049434896313}, {"18": 0.32644290042831825}, {"162": 0.3261019776501062}, {"67": 0.32192645821404264}, {"195": 0.320875713429118}, {"103": 0.318876666646962}, {"47": 0.31256573590131165}, {"16": 0.3033565023091469}, {"138": 0.2904095940117062}, {"35": 0.28855608058196935}, {"11": 0.28212091785089344}, {"63": 0.2808305580177377}, {"137": 0.2731667297865312}, {"66": 0.26442053861998804}, {"27": 0.2592859621591195}, {"136": 0.2574870001630747}, {"153": 0.24941286067774993}, {"160": 0.24048638216764018}, {"74": 0.2392620210993266}, {"91": 0.23795581610172678}, {"173": 0.23277801778551233}, {"187": 0.22881569764791432}, {"177": 0.22800134686598628}, {"82": 0.2231519406930076}, {"152": 0.21802231535302763}, {"154": 0.21559369265195327}, {"39": 0.2102962792016898}, {"38": 0.20035002829585036}, {"6": 0.1952877897499996}, {"92": 0.19509351829996868}, {"188": 0.18762473425215842}, {"99": 0.18758897574408562}, {"133": 0.17581634953208258}, {"180": 0.17561173785389306}, {"62": 0.17532037120337818}, {"184": 0.16497668836257184}, {"122": 0.16389919260307906}, {"159": 0.15345249182308907}, {"150": 0.1512521777359106}, {"183": 0.1480505270961625}, {"196": 0.14515695597996858}, {"29": 0.1428075495020804}, {"76": 0.1427225882336305}, {"167": 0.13706110814401162}, {"30": 0.12883998257316986}, {"124": 0.12865696246682878}, {"46": 0.11866412598579035}, {"26": 0.11407770692653574}, {"143": 0.11367860238840044}, {"45": 0.11182063329352965}, {"141": 0.10203597096144046}, {"90": 0.08732318394273175}, {"149": 0.0846091644770619}, {"151": 0.08091393518063139}, {"117": 0.08033653939553642}, {"33": 0.08008324416077084}, {"57": 0.07875716375462383}, {"89": 0.07391866285576754}, {"111": 0.0728045899739811}, {"112": 0.0714395582096683}, {"131": 0.07056539314653199}, {"171": 0.07053393328039559}, {"5": 0.04663871662084684}, {"61": 0.04166579572040652}, {"51": 0.041329887649882435}, {"85": 0.04125100956074057}, {"147": 0.0411505841134332}, {"34": 0.03416289866580935}, {"120": 0.03053191172850167}, {"20": 0.02559772987527076}, {"189": 0.023168444051438364}, {"7": 0.019828668837614805}, {"115": 0.006731591063005693}, {"80": 0.0033432507033341885}, {"98": 0.0009859731935359939}]}

{"movie_id": 2, "similar_movies": [{"2": 1}, {"100": 0.9985089345613372}, {"42": 0.994876955757855}, {"98": 0.9921820169262852}, {"38": 0.9876889415570687}, {"155": 0.9843977929737264}, {"116": 0.9765158806696135}, {"174": 0.969252554993097}, {"67": 0.960966239809325}, {"29": 0.9572479586848655}, {"47": 0.9436466551919436}, {"136": 0.9195342021713193}, {"28": 0.9081780260308434}, {"157": 0.898690802800099}, {"151": 0.8972377652089212}, {"37": 0.895820910725194}, {"23": 0.8876027737924137}, {"121": 0.8761416663502897}, {"177": 0.8749318003124056}, {"81": 0.8726391423759308}, {"32": 0.8595137536366029}, {"71": 0.8448068561171642}, {"14": 0.8421997278972375}, {"176": 0.8287748508914072}, {"170": 0.826743950310382}, {"193": 0.8112542952541018}, {"148": 0.8064138816031359}, {"86": 0.8063583342906697}, {"105": 0.7965487671181091}, {"90": 0.795058628191041}, {"145": 0.7902941816129327}, {"56": 0.7876525419541689}, {"9": 0.7876173236052582}, {"108": 0.7855116840754042}, {"143": 0.7832535338333766}, {"132": 0.7798878635658342}, {"134": 0.7703789844494306}, {"141": 0.7701205375157223}, {"160": 0.7690079212486862}, {"99": 0.7640138843317721}, {"87": 0.7527331915791395}, {"175": 0.7493622969782674}, {"59": 0.7470288433002001}, {"156": 0.7384083866521538}, {"179": 0.7311778074258772}, {"85": 0.7289565902255861}, {"113": 0.7267933950910814}, {"142": 0.726435013874771}, {"78": 0.7117337928825911}, {"52": 0.7106677106526909}, {"120": 0.7024145739562526}, {"83": 0.6906549906392125}, {"115": 0.6859375767463252}, {"44": 0.6804882412812809}, {"158": 0.6788533619635373}, {"84": 0.6637786191782173}, {"109": 0.6555816659020277}, {"15": 0.6534596351115682}, {"129": 0.652960157072821}, {"188": 0.6422373438562041}, {"139": 0.6386013051435995}, {"131": 0.6359921627337071}, {"133": 0.6342086661625479}, {"123": 0.6309330532089947}, {"12": 0.6279546281952411}, {"58": 0.6212686425572338}, {"198": 0.6168644280018636}, {"66": 0.616573471537545}, {"194": 0.6148301312032483}, {"43": 0.6137835514412042}, {"82": 0.6128054824908298}, {"97": 0.6073360583008351}, {"186": 0.6003630861769071}, {"26": 0.6002286229092131}, {"166": 0.597091451032262}, {"91": 0.5849816379785804}, {"95": 0.5845486090368184}, {"62": 0.5727370197947919}, {"65": 0.5659159146171575}, {"126": 0.5460126053096845}, {"189": 0.5426225724527494}, {"27": 0.5354999205518347}, {"117": 0.5215235090891925}, {"45": 0.5182201735474121}, {"5": 0.5171176522172332}, {"61": 0.5079917065238164}, {"30": 0.5007376310485012}, {"41": 0.49877331011434944}, {"94": 0.49664996725008415}, {"11": 0.4935197394660089}, {"164": 0.4869720688772021}, {"63": 0.48619808637260786}, {"76": 0.4841524026235857}, {"19": 0.4827614140887597}, {"144": 0.4730283325615874}, {"135": 0.47225751426827434}, {"173": 0.4717083620686655}, {"74": 0.4705705878748965}, {"183": 0.4663912441705469}, {"92": 0.46456072558702144}, {"60": 0.46437892134519587}, {"80": 0.4628516209564406}, {"196": 0.454656796107481}, {"102": 0.4520326431999777}, {"127": 0.4500348077205132}, {"16": 0.44325208880988787}, {"178": 0.44289149545339246}, {"3": 0.439582003357434}, {"118": 0.43046851554271703}, {"25": 0.4261257347887879}, {"46": 0.40868212476083343}, {"39": 0.40482888830757413}, {"96": 0.40321751571757325}, {"77": 0.403148330121486}, {"75": 0.3978836726606776}, {"163": 0.38033680711203277}, {"107": 0.37338639129161844}, {"104": 0.3728791859970506}, {"162": 0.36967018329754997}, {"6": 0.36829287866876403}, {"68": 0.3675671523997954}, {"93": 0.3656518621079812}, {"110": 0.36139003471561537}, {"161": 0.36102357309567745}, {"159": 0.35769383032818114}, {"180": 0.353233117515527}, {"184": 0.3426253947742661}, {"70": 0.33424040128620724}, {"168": 0.3323141935460685}, {"1": 0.33163881720349586}, {"57": 0.3286634263353998}, {"146": 0.32319639784933085}, {"48": 0.3168030980319385}, {"169": 0.31442407962020336}, {"51": 0.3131676774798906}, {"18": 0.30829307072011636}, {"154": 0.3054534542111589}, {"4": 0.2985690090849298}, {"111": 0.2882943320671749}, {"130": 0.28754093142410464}, {"13": 0.2848247401668067}, {"103": 0.2810173951120123}, {"167": 0.27355951910670084}, {"10": 0.25473290510615376}, {"182": 0.25051918421995123}, {"147": 0.24909924422053975}, {"149": 0.24608864519032436}, {"54": 0.23661118273430404}, {"22": 0.2330024024252748}, {"73": 0.23118510775266699}, {"187": 0.22321923759236229}, {"181": 0.22154370493724485}, {"122": 0.22050800772491708}, {"64": 0.20864534402628943}, {"20": 0.20585142804515577}, {"49": 0.19598535281673302}, {"79": 0.19312226485206652}, {"128": 0.1908095695076515}, {"0": 0.18985561555013408}, {"124": 0.18817779257441725}, {"190": 0.17968503599785324}, {"21": 0.1689319089998147}, {"17": 0.16409374321302161}, {"106": 0.1513722487218483}, {"172": 0.14567415700623232}, {"89": 0.13935569932979042}, {"88": 0.13727412534514438}, {"138": 0.13335238819135542}, {"69": 0.12911421616101837}, {"8": 0.12259673499715285}, {"35": 0.11979083677508928}, {"199": 0.11959342367919779}, {"197": 0.11193292632176965}, {"112": 0.10984698223846556}, {"150": 0.10773284424484397}, {"33": 0.10327282947451133}, {"101": 0.09729824904118756}, {"192": 0.09514994638648044}, {"72": 0.09080714031700832}, {"7": 0.0869759356152735}, {"200": 0.08574216394210188}, {"165": 0.07617628188667513}, {"55": 0.07433244673999617}, {"119": 0.06473286210470097}, {"152": 0.062201235539556254}, {"191": 0.0609656909705214}, {"24": 0.05950356731647832}, {"137": 0.05911842853633842}, {"171": 0.05362976194151381}, {"140": 0.05146471105936068}, {"185": 0.04909451044194513}, {"36": 0.04638942327393769}, {"114": 0.04460211234017497}, {"34": 0.033450450145707133}, {"195": 0.030698114183083547}, {"40": 0.03008002451587899}, {"50": 0.02067075941140195}, {"53": 0.015010228981257034}, {"31": 0.01443487755414119}, {"153": 0.013476215642487466}, {"125": 0.007362703989580055}]}

SELECT 3

select jsonb_build_object( 'movie_id',movie_id,'similar_movies'
                          ,jsonb_agg(jsonb_build_object( similar_movie_id
                                                        ,similarity) 
                                     order by score))
from (select *,row_number()over(partition by movie_id order by similarity desc) AS score
      from movie_similarity_eav )_
where score<=10
group by movie_id;

jsonb_build_object

{"movie_id": 0, "similar_movies": [{"0": 1}, {"109": 0.9972348380720784}, {"89": 0.996691205306764}, {"72": 0.9565037077794105}, {"76": 0.9471737433998897}, {"63": 0.9439324951948684}, {"33": 0.9377223975701177}, {"3": 0.931589426258701}, {"51": 0.9284534965702238}, {"138": 0.9114139796889358}]}

{"movie_id": 1, "similar_movies": [{"1": 1}, {"84": 0.991493954192866}, {"146": 0.9887962053265043}, {"130": 0.9864403916921192}, {"156": 0.9852181900394243}, {"60": 0.9834470612311268}, {"79": 0.9831763959419084}, {"3": 0.9830930813277112}, {"118": 0.961002527460247}, {"105": 0.9588897340903639}]}

{"movie_id": 2, "similar_movies": [{"2": 1}, {"100": 0.9985089345613372}, {"42": 0.994876955757855}, {"98": 0.9921820169262852}, {"38": 0.9876889415570687}, {"155": 0.9843977929737264}, {"116": 0.9765158806696135}, {"174": 0.969252554993097}, {"67": 0.960966239809325}, {"29": 0.9572479586848655}]}

{"movie_id": 3, "similar_movies": [{"3": 1}, {"142": 0.9986474974533064}, {"90": 0.993751605566408}, {"51": 0.9935396050391976}, {"166": 0.9929594776577297}, {"64": 0.9885864535118214}, {"115": 0.9876585235032491}, {"168": 0.980123200763038}, {"69": 0.9733334736107822}, {"161": 0.9637522492168229}]}

{"movie_id": 4, "similar_movies": [{"4": 1}, {"199": 0.9988221443980485}, {"164": 0.9854460166671697}, {"163": 0.9846585784129389}, {"187": 0.9844004553274488}, {"86": 0.9829567838566915}, {"173": 0.9627323061574999}, {"133": 0.9609802257464837}, {"161": 0.960089745921521}, {"181": 0.9596443301172142}]}

{"movie_id": 5, "similar_movies": [{"5": 1}, {"114": 0.9931098337261908}, {"190": 0.9899706204435221}, {"126": 0.9885396121483894}, {"102": 0.9873192009671834}, {"63": 0.9863436004800594}, {"91": 0.980891430528307}, {"142": 0.9756309897815794}, {"59": 0.9751932226094093}, {"172": 0.9741426133218647}]}

{"movie_id": 6, "similar_movies": [{"6": 1}, {"133": 0.991812795181293}, {"164": 0.9907436655438913}, {"117": 0.9903613754592471}, {"65": 0.9873968745496398}, {"22": 0.9647861991996862}, {"159": 0.9632468195557979}, {"84": 0.963095742311681}, {"1": 0.9572159564036271}, {"90": 0.9515483216704568}]}

{"movie_id": 7, "similar_movies": [{"7": 1}, {"75": 0.9959228830129208}, {"53": 0.9938617403177044}, {"162": 0.9933771971558225}, {"182": 0.9923179108822597}, {"76": 0.983950706134419}, {"16": 0.9810557255491823}, {"70": 0.9764385876239807}, {"112": 0.9729876090549112}, {"38": 0.9720407639922259}]}

{"movie_id": 8, "similar_movies": [{"8": 1}, {"166": 0.9797832171846637}, {"108": 0.978316203975407}, {"113": 0.9756469160028134}, {"116": 0.9637081447638176}, {"66": 0.9632585296923477}, {"91": 0.9622378666660336}, {"3": 0.958843466299228}, {"82": 0.9573537207009433}, {"63": 0.9493658265525091}]}

{"movie_id": 9, "similar_movies": [{"9": 1}, {"126": 0.9966014040743174}, {"34": 0.9891721156627928}, {"46": 0.9874451537246454}, {"56": 0.9867085311712933}, {"82": 0.9824922542010774}, {"133": 0.97580654219135}, {"117": 0.9714899065512077}, {"192": 0.9699894917317913}, {"199": 0.96349758321993}]}

{"movie_id": 10, "similar_movies": [{"10": 1}, {"8": 0.9971001256004348}, {"42": 0.9881295412229529}, {"121": 0.9787935382246211}, {"92": 0.9684821256553959}, {"150": 0.9575642529876636}, {"73": 0.9562643769789017}, {"113": 0.9512019406645194}, {"12": 0.950053632497259}, {"36": 0.9472582975159494}]}

{"movie_id": 11, "similar_movies": [{"11": 1}, {"16": 0.998667626900571}, {"18": 0.9874380338501334}, {"133": 0.9851518927973877}, {"163": 0.9838702810196458}, {"48": 0.9739089040987028}, {"145": 0.9706015619473136}, {"87": 0.965174485469799}, {"170": 0.959096824899869}, {"50": 0.9585233197148539}]}

{"movie_id": 12, "similar_movies": [{"12": 1}, {"15": 0.9977801854063766}, {"59": 0.9972390055477569}, {"6": 0.9797523128929388}, {"110": 0.9684847544748887}, {"155": 0.9640701558124105}, {"44": 0.9610408533808867}, {"91": 0.9607204303397043}, {"83": 0.9493607212178181}, {"37": 0.9443526381097564}]}

{"movie_id": 13, "similar_movies": [{"13": 1}, {"124": 0.9975895704589766}, {"56": 0.9941223166775583}, {"187": 0.9921472881077129}, {"7": 0.9875560652320947}, {"86": 0.97899296967461}, {"114": 0.9764042389956071}, {"104": 0.9751871141096051}, {"98": 0.9739619271034783}, {"132": 0.9613227442062453}]}

{"movie_id": 14, "similar_movies": [{"14": 1}, {"158": 0.9974132757784093}, {"92": 0.9964802597809026}, {"4": 0.9940830933362999}, {"171": 0.9863672492405371}, {"166": 0.9862474715986833}, {"22": 0.9859633675489636}, {"109": 0.9798809762144203}, {"96": 0.9784564036223546}, {"24": 0.9648426308805254}]}

{"movie_id": 15, "similar_movies": [{"15": 1}, {"19": 0.9941866104306836}, {"14": 0.9936224106792311}, {"48": 0.9894915369625787}, {"104": 0.9870948338008565}, {"45": 0.9868660366820592}, {"99": 0.9854336529917134}, {"164": 0.9820457589357798}, {"1": 0.9812462055951847}, {"121": 0.9666226732589704}]}

{"movie_id": 16, "similar_movies": [{"16": 1}, {"198": 0.978002509881005}, {"10": 0.9767428498493751}, {"69": 0.972048035595851}, {"122": 0.9651821641209077}, {"3": 0.9632933428725541}, {"85": 0.9538246320548167}, {"123": 0.9517624346108808}, {"55": 0.9506301967947717}, {"157": 0.9506229127824806}]}

{"movie_id": 17, "similar_movies": [{"17": 1}, {"117": 0.9941860173844654}, {"190": 0.9900900099194174}, {"123": 0.9895649684201067}, {"41": 0.9839849287224718}, {"40": 0.9769698349212939}, {"179": 0.973549423370532}, {"9": 0.9702945942870518}, {"137": 0.969050860870321}, {"140": 0.9681074077775016}]}

{"movie_id": 18, "similar_movies": [{"18": 1}, {"155": 0.9971055236664594}, {"145": 0.9961529437051881}, {"169": 0.9908319937987424}, {"125": 0.9853708907265919}, {"149": 0.9790349977180224}, {"10": 0.9707469724389659}, {"93": 0.9525795924979967}, {"46": 0.9406203235028276}, {"38": 0.9368700705979578}]}

{"movie_id": 19, "similar_movies": [{"19": 1}, {"97": 0.9902035262055096}, {"5": 0.9860277292858346}, {"81": 0.9805154818382618}, {"128": 0.973520809676482}, {"85": 0.9647879289384613}, {"179": 0.9643398199250297}, {"3": 0.9618801383830264}, {"110": 0.9508911885457514}, {"95": 0.940668101028443}]}

{"movie_id": 20, "similar_movies": [{"20": 1}, {"150": 0.9818339302759342}, {"41": 0.9805700157496213}, {"91": 0.9737859626292877}, {"113": 0.9617230656037867}, {"16": 0.9576293191065504}, {"177": 0.9573842029984403}, {"191": 0.9543137644645541}, {"151": 0.9536827884266286}, {"199": 0.9502998879529214}]}

{"movie_id": 21, "similar_movies": [{"21": 1}, {"78": 0.9954132317086124}, {"60": 0.9828338545295481}, {"127": 0.9817200204776324}, {"87": 0.9710225710078648}, {"82": 0.9648252384033165}, {"64": 0.964572120549984}, {"92": 0.9592248682610596}, {"71": 0.9589375118434293}, {"37": 0.9565593014482578}]}

{"movie_id": 22, "similar_movies": [{"22": 1}, {"67": 0.9909417658774053}, {"97": 0.9830506734472721}, {"185": 0.9751813921263366}, {"186": 0.9621243656709673}, {"150": 0.9616576741974996}, {"46": 0.9602989626700993}, {"19": 0.9593738359509358}, {"68": 0.9494397874244687}, {"81": 0.9479926514511738}]}

{"movie_id": 23, "similar_movies": [{"23": 1}, {"32": 0.9986286588502449}, {"120": 0.9949474636477682}, {"75": 0.9931365073104044}, {"66": 0.9907206752928077}, {"45": 0.984510235197599}, {"92": 0.9711247948435286}, {"101": 0.9643590928188899}, {"196": 0.9630489133451317}, {"192": 0.9580553277322492}]}

{"movie_id": 24, "similar_movies": [{"24": 1}, {"120": 0.9910010258547679}, {"12": 0.9868083817383719}, {"108": 0.9841103911244549}, {"176": 0.971279706283176}, {"75": 0.9653278081669097}, {"142": 0.9582826128369013}, {"127": 0.9571845969497024}, {"149": 0.9530633104604762}, {"182": 0.9471291790497183}]}

{"movie_id": 25, "similar_movies": [{"25": 1}, {"43": 0.9983423455712042}, {"116": 0.9945222509689764}, {"194": 0.9908708845081042}, {"126": 0.9850341187664045}, {"173": 0.9813018038462913}, {"33": 0.9728706560815721}, {"125": 0.9591266737877446}, {"8": 0.9563812127701217}, {"128": 0.9450430565836911}]}

{"movie_id": 26, "similar_movies": [{"26": 1}, {"50": 0.9997262543544589}, {"104": 0.9942332800619018}, {"133": 0.9897024385688302}, {"80": 0.983005031307336}, {"198": 0.9799551854821513}, {"25": 0.9728537300373539}, {"114": 0.9701885369741388}, {"183": 0.9692214236752525}, {"20": 0.9676138693553693}]}

{"movie_id": 27, "similar_movies": [{"27": 1}, {"49": 0.9941255468410355}, {"26": 0.992217520650716}, {"102": 0.9879987322737449}, {"139": 0.9853146889600923}, {"98": 0.982941172219089}, {"39": 0.9734829951751149}, {"67": 0.9697981425853615}, {"193": 0.9628156917205686}, {"3": 0.961144428036752}]}

{"movie_id": 28, "similar_movies": [{"28": 1}, {"70": 0.9977709988448149}, {"50": 0.9960506663938977}, {"179": 0.9933333460392193}, {"22": 0.9927865362870554}, {"74": 0.9883003782487538}, {"34": 0.9846478340770131}, {"167": 0.9774615791033294}, {"152": 0.9744688760389937}, {"53": 0.9714765728105099}]}

{"movie_id": 29, "similar_movies": [{"29": 1}, {"41": 0.9909061115521252}, {"196": 0.9702226585241436}, {"147": 0.9605335047394152}, {"181": 0.9568641337411545}, {"162": 0.9515743879079841}, {"21": 0.9399116542080999}, {"63": 0.9380186746440764}, {"66": 0.9365092475987475}, {"39": 0.9211885255274737}]}

{"movie_id": 30, "similar_movies": [{"30": 1}, {"153": 0.9943592046442302}, {"20": 0.9737696938854548}, {"150": 0.9718586998148337}, {"123": 0.962767403089261}, {"171": 0.9616324351705503}, {"179": 0.9598116641216379}, {"107": 0.9562875549103769}, {"115": 0.9488787388290911}, {"186": 0.9447244356633946}]}

{"movie_id": 31, "similar_movies": [{"31": 1}, {"176": 0.9997323509927838}, {"36": 0.998995458196446}, {"32": 0.9981904845483744}, {"75": 0.9928472055429245}, {"111": 0.9885042343592196}, {"43": 0.961649905691506}, {"148": 0.9600273379357582}, {"123": 0.9514573940865767}, {"104": 0.951404105391269}]}

{"movie_id": 32, "similar_movies": [{"32": 1}, {"186": 0.9977879632227447}, {"95": 0.9874721665922865}, {"13": 0.9792703456785918}, {"60": 0.9774690151954164}, {"1": 0.9747990334837806}, {"9": 0.9739918222514286}, {"177": 0.9707097318265279}, {"75": 0.9695875935627865}, {"187": 0.9622393302800922}]}

{"movie_id": 33, "similar_movies": [{"33": 1}, {"112": 0.9976518254817828}, {"139": 0.9970505294188117}, {"96": 0.9940605206904418}, {"111": 0.9929732506613229}, {"84": 0.9866697863245366}, {"157": 0.9728949784362944}, {"178": 0.960601037030951}, {"93": 0.9498819946229651}, {"114": 0.9486680684664479}]}

{"movie_id": 34, "similar_movies": [{"34": 1}, {"150": 0.9926612485804904}, {"138": 0.9912414136621619}, {"58": 0.9714537912980963}, {"76": 0.9682856393242198}, {"192": 0.958245614346841}, {"117": 0.9467294479452661}, {"158": 0.9433952350695565}, {"31": 0.9415931343823538}, {"84": 0.9412917477490239}]}

{"movie_id": 35, "similar_movies": [{"35": 1}, {"95": 0.9898539250438505}, {"161": 0.988357302101559}, {"32": 0.9769821968639005}, {"89": 0.976776750995962}, {"133": 0.9751893409080981}, {"191": 0.9672216128092221}, {"167": 0.9604252395317829}, {"170": 0.9589585562693492}, {"13": 0.95731607998284}]}

{"movie_id": 36, "similar_movies": [{"36": 1}, {"154": 0.9969452071663925}, {"192": 0.9961627328106317}, {"150": 0.9950076727348196}, {"177": 0.9913682647232693}, {"140": 0.9701868539745657}, {"7": 0.9541058378293532}, {"190": 0.9461711801958685}, {"89": 0.9456284752530586}, {"37": 0.9329488874477683}]}

{"movie_id": 37, "similar_movies": [{"37": 1}, {"87": 0.9882448974435816}, {"188": 0.9877687875477197}, {"103": 0.9843878199811342}, {"77": 0.9840319979788841}, {"3": 0.984008506639386}, {"20": 0.9712988364085136}, {"137": 0.9696236417447996}, {"108": 0.9638222947298662}, {"119": 0.9604088377609441}]}

{"movie_id": 38, "similar_movies": [{"38": 1}, {"78": 0.9951947407780108}, {"138": 0.993847166215424}, {"137": 0.985808457031313}, {"160": 0.9780314073519303}, {"147": 0.9764884759601296}, {"43": 0.975716008276438}, {"109": 0.9713197772221003}, {"60": 0.969853447931359}, {"64": 0.9682275254915857}]}

{"movie_id": 39, "similar_movies": [{"39": 1}, {"67": 0.994853383031354}, {"125": 0.9878313244286827}, {"119": 0.9862978257584525}, {"173": 0.9858734476140543}, {"102": 0.979792398017016}, {"17": 0.9796045843095003}, {"98": 0.9793612024140932}, {"101": 0.9723373504594204}, {"60": 0.9714934523677563}]}

{"movie_id": 40, "similar_movies": [{"40": 1}, {"108": 0.9826920250775644}, {"38": 0.9776238429247417}, {"200": 0.9742151903054641}, {"22": 0.9717070994976074}, {"97": 0.9684048598464055}, {"19": 0.967114008665731}, {"148": 0.9630772615740275}, {"199": 0.9618979960503022}, {"140": 0.9603914352547909}]}

{"movie_id": 41, "similar_movies": [{"41": 1}, {"135": 0.9907046546536276}, {"58": 0.9848306861754166}, {"89": 0.9792988889442191}, {"182": 0.9790746104990686}, {"195": 0.9767674678102791}, {"185": 0.9723878811364846}, {"75": 0.9720384621037346}, {"155": 0.971269923869877}, {"10": 0.9694974563102952}]}

{"movie_id": 42, "similar_movies": [{"42": 1}, {"125": 0.9960253066076068}, {"151": 0.9954834968440349}, {"101": 0.9929588925532458}, {"57": 0.9923933581941575}, {"34": 0.9845982849226027}, {"81": 0.9837567884516187}, {"44": 0.9804996292904153}, {"107": 0.9803212454671553}, {"153": 0.9683695310252329}]}

{"movie_id": 43, "similar_movies": [{"43": 1}, {"193": 0.9992934942394192}, {"136": 0.9967207471653772}, {"81": 0.994630017735018}, {"99": 0.9783719479898763}, {"162": 0.9739025078096579}, {"3": 0.9736492593321255}, {"171": 0.9688098039672028}, {"179": 0.9630307738023844}, {"199": 0.9548273709629187}]}

{"movie_id": 44, "similar_movies": [{"44": 1}, {"57": 0.9968270891660607}, {"142": 0.9780150885049932}, {"33": 0.950074859071667}, {"160": 0.9469553486693367}, {"150": 0.9452058538635875}, {"111": 0.943943106269383}, {"45": 0.9398532252431495}, {"26": 0.9354371806608943}, {"54": 0.9265157642594937}]}

{"movie_id": 45, "similar_movies": [{"45": 1}, {"39": 0.9999369783941603}, {"98": 0.9943913748516846}, {"29": 0.9912065247474242}, {"0": 0.9910599489223764}, {"147": 0.9894821730881009}, {"139": 0.9894144878633153}, {"97": 0.9880291897270506}, {"100": 0.983160913196268}, {"68": 0.9788064831317493}]}

{"movie_id": 46, "similar_movies": [{"46": 1}, {"50": 0.9945265722258818}, {"71": 0.9896301548748687}, {"154": 0.9861191703199923}, {"60": 0.98322157525583}, {"37": 0.9725898803150907}, {"56": 0.9671856554219351}, {"138": 0.9631503459409196}, {"13": 0.9617661806026294}, {"8": 0.960808212622168}]}

{"movie_id": 47, "similar_movies": [{"47": 1}, {"173": 0.9976173227018557}, {"165": 0.9959723037766617}, {"182": 0.995707820439961}, {"58": 0.9908964727061875}, {"145": 0.9897201914859921}, {"121": 0.9823465109770213}, {"84": 0.9720115946642447}, {"168": 0.9698179918150243}, {"5": 0.9626243622490827}]}

{"movie_id": 48, "similar_movies": [{"48": 1}, {"191": 0.9998846665943717}, {"179": 0.9973084978783209}, {"166": 0.9873264538121103}, {"181": 0.9842018132522656}, {"8": 0.9782780180391484}, {"75": 0.9773629797927792}, {"147": 0.9710770325084064}, {"37": 0.9652661677134988}, {"56": 0.9633728126861152}]}

{"movie_id": 49, "similar_movies": [{"49": 1}, {"26": 0.9984456570917348}, {"29": 0.9973574290830396}, {"31": 0.9947813731439308}, {"87": 0.9803343648358249}, {"120": 0.9733169927733978}, {"8": 0.964442182475032}, {"165": 0.9629841997353328}, {"94": 0.9608740542565664}, {"38": 0.9531372392205462}]}

{"movie_id": 50, "similar_movies": [{"50": 1}, {"96": 0.9996970283674897}, {"40": 0.9924977734359413}, {"107": 0.9828339346972716}, {"149": 0.9815932715527329}, {"184": 0.9687534457920395}, {"93": 0.9538751874742208}, {"122": 0.9363067721878096}, {"187": 0.9244801375160796}, {"97": 0.9217609525477737}]}

{"movie_id": 51, "similar_movies": [{"51": 1}, {"71": 0.995230275569037}, {"173": 0.9944448005957194}, {"139": 0.9883432573146187}, {"41": 0.9855183016090667}, {"113": 0.9843095651643359}, {"184": 0.9798805565990931}, {"109": 0.9795421789112482}, {"23": 0.9731135510453832}, {"12": 0.9587281233433116}]}

{"movie_id": 52, "similar_movies": [{"52": 1}, {"181": 0.9984317600313257}, {"101": 0.9938908139925844}, {"162": 0.9937807864127428}, {"12": 0.9934333382294076}, {"23": 0.9898654329981136}, {"167": 0.9862714678875013}, {"141": 0.9773478859952252}, {"184": 0.97337945208905}, {"30": 0.9654912639446178}]}

{"movie_id": 53, "similar_movies": [{"53": 1}, {"174": 0.9912158385949852}, {"46": 0.9884211888847798}, {"57": 0.9702443361935165}, {"115": 0.9537412080451799}, {"63": 0.9474907240032289}, {"79": 0.9399099366051678}, {"34": 0.9285118074083096}, {"58": 0.9050582210543834}, {"98": 0.898968120676356}]}

{"movie_id": 54, "similar_movies": [{"54": 1}, {"1": 0.995774007009357}, {"105": 0.9904757008379017}, {"137": 0.9861587713889803}, {"26": 0.9817333047446275}, {"172": 0.9772616645949215}, {"141": 0.9695461068390177}, {"36": 0.9629704950775411}, {"24": 0.9626970711485114}, {"35": 0.9604884640437656}]}

{"movie_id": 55, "similar_movies": [{"55": 1}, {"1": 0.9998400993826437}, {"19": 0.996829070991256}, {"196": 0.9949474160002554}, {"78": 0.989098142448801}, {"197": 0.9809285894272135}, {"93": 0.979059801223773}, {"84": 0.9741836011692013}, {"32": 0.9716275235601777}, {"98": 0.9662959584558188}]}

{"movie_id": 56, "similar_movies": [{"56": 1}, {"102": 0.9894417637914406}, {"101": 0.9839187486639134}, {"138": 0.9786572454175335}, {"168": 0.9784390031343175}, {"124": 0.9777132087132714}, {"112": 0.9740105519517228}, {"64": 0.9718200552672835}, {"55": 0.967030601589546}, {"106": 0.9648279310747998}]}

{"movie_id": 57, "similar_movies": [{"57": 1}, {"194": 0.9919168554550883}, {"30": 0.984607646105768}, {"14": 0.9843601930524626}, {"105": 0.9783664319142324}, {"73": 0.9746686835239704}, {"196": 0.9525054653692064}, {"167": 0.9471573681406313}, {"83": 0.9425818188740018}, {"133": 0.9349216072561359}]}

{"movie_id": 58, "similar_movies": [{"58": 1}, {"65": 0.9976692821181072}, {"60": 0.9939009029538983}, {"43": 0.9935408286946237}, {"129": 0.9881180464092043}, {"198": 0.9876939088523782}, {"30": 0.9806626182115075}, {"61": 0.9784177767269537}, {"151": 0.9761696504216453}, {"197": 0.9652495763481062}]}

{"movie_id": 59, "similar_movies": [{"59": 1}, {"3": 0.9969228634787863}, {"11": 0.9899785670375918}, {"81": 0.9832658525756854}, {"188": 0.9781236163034175}, {"95": 0.9776057907861546}, {"28": 0.9743465460176168}, {"41": 0.9729084460543622}, {"12": 0.9540035284391817}, {"187": 0.9464573113825949}]}

{"movie_id": 60, "similar_movies": [{"60": 1}, {"101": 0.9927646980680394}, {"197": 0.9698468717659714}, {"34": 0.9671827385415319}, {"121": 0.9576772217720151}, {"102": 0.9572706170768654}, {"27": 0.9530636698967456}, {"194": 0.950583297471338}, {"4": 0.9490910992139512}, {"123": 0.9450564122092491}]}

{"movie_id": 61, "similar_movies": [{"61": 1}, {"13": 0.9896730694238751}, {"39": 0.9795131693876782}, {"88": 0.9662073929483841}, {"160": 0.958087131820653}, {"43": 0.956967252634608}, {"198": 0.9531797642235}, {"120": 0.9511120491249057}, {"2": 0.947325449731468}, {"118": 0.9396519818043456}]}

{"movie_id": 62, "similar_movies": [{"62": 1}, {"104": 0.9995574713600679}, {"94": 0.991051371105218}, {"166": 0.9896907399541224}, {"162": 0.9838028195896757}, {"129": 0.9788486265595182}, {"55": 0.973013677849786}, {"131": 0.9715711579004132}, {"92": 0.9686906691097987}, {"153": 0.9686523880683109}]}

{"movie_id": 63, "similar_movies": [{"63": 1}, {"158": 0.9976596666069877}, {"104": 0.99554621698307}, {"11": 0.9949626580332473}, {"191": 0.9910287782550407}, {"92": 0.9901654844311378}, {"32": 0.989935891055066}, {"21": 0.9854054942612587}, {"52": 0.9804859040492002}, {"135": 0.9782536318210138}]}

{"movie_id": 64, "similar_movies": [{"64": 1}, {"18": 0.9996514785403317}, {"82": 0.9923770775554148}, {"93": 0.9721142952093467}, {"159": 0.9692214351045707}, {"128": 0.9632515618451842}, {"133": 0.9630432733146175}, {"3": 0.9627353847353535}, {"42": 0.9486634636112563}, {"28": 0.9481757775418578}]}

{"movie_id": 65, "similar_movies": [{"65": 1}, {"94": 0.9971488689095616}, {"106": 0.9961504844340441}, {"30": 0.9955366711560292}, {"115": 0.9943127212086282}, {"190": 0.9930328896170801}, {"70": 0.9769648442113052}, {"105": 0.9644985003603934}, {"173": 0.9635574392378208}, {"151": 0.963048056018748}]}

{"movie_id": 66, "similar_movies": [{"66": 1}, {"165": 0.9978086252040543}, {"143": 0.9902501629572142}, {"75": 0.9889908958357088}, {"129": 0.986851446104634}, {"130": 0.982481287805683}, {"121": 0.9803743647851826}, {"99": 0.9769403010007787}, {"91": 0.9738334870649965}, {"106": 0.9716518991591454}]}

{"movie_id": 67, "similar_movies": [{"67": 1}, {"132": 0.9958215306912335}, {"113": 0.9920401192067165}, {"118": 0.989899211465993}, {"33": 0.9882844052944977}, {"174": 0.9879812876523251}, {"31": 0.9861329889804495}, {"77": 0.9849178345314082}, {"25": 0.9758436295804038}, {"163": 0.9758193913820385}]}

{"movie_id": 68, "similar_movies": [{"68": 1}, {"147": 0.9710743738939758}, {"163": 0.9692194368398879}, {"90": 0.964244848799567}, {"158": 0.9596155772819945}, {"51": 0.9528871538773231}, {"136": 0.9438105926142344}, {"86": 0.9384706569578196}, {"192": 0.9317309583128555}, {"1": 0.9290758616655956}]}

{"movie_id": 69, "similar_movies": [{"69": 1}, {"182": 0.992481431121589}, {"61": 0.9843559923781859}, {"40": 0.9838335615191878}, {"105": 0.9812762528201431}, {"35": 0.9792548764539981}, {"198": 0.97747553102348}, {"191": 0.967626811594374}, {"155": 0.96068534037519}, {"93": 0.9597130192227163}]}

{"movie_id": 70, "similar_movies": [{"70": 1}, {"125": 0.9951811229631111}, {"158": 0.9939504193983117}, {"146": 0.9849374405571742}, {"183": 0.9771022877161644}, {"197": 0.9758836751684039}, {"74": 0.9700677544684466}, {"195": 0.9637487900564905}, {"68": 0.9561690480179765}, {"172": 0.9534429984138884}]}

{"movie_id": 71, "similar_movies": [{"71": 1}, {"91": 0.9983946227246929}, {"49": 0.9944848497495731}, {"134": 0.992725643319232}, {"69": 0.9916872466068114}, {"79": 0.9718604095527092}, {"50": 0.9630400619620199}, {"197": 0.9598850637368548}, {"105": 0.9595541145634816}, {"154": 0.9536470041870673}]}

{"movie_id": 72, "similar_movies": [{"72": 1}, {"22": 0.9998253928736189}, {"122": 0.9957247671485423}, {"113": 0.99162174701357}, {"178": 0.9797290945153796}, {"61": 0.9774910437293087}, {"169": 0.9744853919827465}, {"173": 0.9737195864802202}, {"166": 0.9690079910258882}, {"161": 0.9681156857304223}]}

{"movie_id": 73, "similar_movies": [{"73": 1}, {"22": 0.9982618402417942}, {"144": 0.9938665433854066}, {"5": 0.9899492316174758}, {"98": 0.9856668095336563}, {"50": 0.9853265598842988}, {"127": 0.9810561584699815}, {"194": 0.9781224227416951}, {"13": 0.966189887042378}, {"65": 0.9645854394209292}]}

{"movie_id": 74, "similar_movies": [{"74": 1}, {"102": 0.9985004606908321}, {"25": 0.9929285527965006}, {"38": 0.9919852965157165}, {"163": 0.9896793711137586}, {"15": 0.9888026883346714}, {"20": 0.9814050234000247}, {"55": 0.9746100129415753}, {"105": 0.9736594781062513}, {"29": 0.9716299629511203}]}

{"movie_id": 75, "similar_movies": [{"75": 1}, {"49": 0.9988385341000896}, {"136": 0.9957242721113284}, {"147": 0.9943260874128224}, {"95": 0.9938682242034536}, {"97": 0.9902288180597576}, {"115": 0.9841259991114395}, {"98": 0.9807554109578158}, {"36": 0.9731795561279017}, {"94": 0.953291850518553}]}

{"movie_id": 76, "similar_movies": [{"76": 1}, {"91": 0.9948403363698286}, {"173": 0.9893406910141853}, {"128": 0.9747532578877443}, {"123": 0.9679102842854272}, {"170": 0.9671305284428586}, {"113": 0.9669664767679491}, {"31": 0.9658409398798209}, {"74": 0.9646736107991829}, {"119": 0.9619085229724023}]}

{"movie_id": 77, "similar_movies": [{"77": 1}, {"117": 0.999667374611239}, {"144": 0.9982057094026417}, {"191": 0.9871969218047068}, {"75": 0.9864465575455195}, {"152": 0.9782995253812874}, {"14": 0.972206396930269}, {"124": 0.9712427257554856}, {"118": 0.9566592898447701}, {"98": 0.9525197871572393}]}

{"movie_id": 78, "similar_movies": [{"78": 1}, {"55": 0.9916231498528691}, {"141": 0.9892212737664521}, {"44": 0.979785236125051}, {"36": 0.9733179248270665}, {"125": 0.9672026006529151}, {"93": 0.9670167292557028}, {"166": 0.9655531093999186}, {"79": 0.9521941962420903}, {"13": 0.947361030122956}]}

{"movie_id": 79, "similar_movies": [{"79": 1}, {"25": 0.9966338688006615}, {"40": 0.9892975149997922}, {"56": 0.9842970184021818}, {"179": 0.9826909346590413}, {"61": 0.9818935787825278}, {"100": 0.9648894801265866}, {"84": 0.9622749127896388}, {"48": 0.9523601518674469}, {"82": 0.9515740950206917}]}

{"movie_id": 80, "similar_movies": [{"80": 1}, {"70": 0.9952034121463409}, {"20": 0.9896726169682353}, {"51": 0.9874566314078399}, {"151": 0.9874066417771261}, {"156": 0.9841424735962498}, {"115": 0.9712570329540675}, {"95": 0.9622140995014741}, {"8": 0.9592682135346449}, {"92": 0.9535837576448376}]}

{"movie_id": 81, "similar_movies": [{"81": 1}, {"108": 0.9994961001779268}, {"182": 0.992621442733534}, {"156": 0.9911143387918873}, {"165": 0.9814726245208507}, {"104": 0.9798075760844862}, {"15": 0.9770986251857947}, {"32": 0.9744369385738068}, {"200": 0.973397693100416}, {"42": 0.9657854677545632}]}

{"movie_id": 82, "similar_movies": [{"82": 1}, {"139": 0.9961146224542987}, {"166": 0.9862815496044519}, {"0": 0.9794989202291156}, {"73": 0.9658192789112914}, {"156": 0.9585887198924812}, {"162": 0.9502875768908527}, {"64": 0.9502316198014955}, {"13": 0.9481573136540071}, {"169": 0.9478906317050408}]}

{"movie_id": 83, "similar_movies": [{"83": 1}, {"144": 0.9985777392170709}, {"190": 0.9981339203637154}, {"197": 0.9889203184750599}, {"160": 0.9844662807894213}, {"120": 0.9811338390606235}, {"25": 0.9801507612554201}, {"85": 0.9780607611177063}, {"87": 0.9728380494702678}, {"99": 0.971136917757514}]}

{"movie_id": 84, "similar_movies": [{"84": 1}, {"72": 0.9993937354463966}, {"50": 0.999142522697174}, {"121": 0.9981395963750472}, {"58": 0.9897985759597145}, {"8": 0.9875667301070772}, {"46": 0.9706324294428288}, {"107": 0.9652649936706299}, {"49": 0.9615092984063023}, {"197": 0.9535204949098035}]}

{"movie_id": 85, "similar_movies": [{"85": 1}, {"185": 0.9915902725884411}, {"104": 0.9858179924904511}, {"140": 0.9822765137728529}, {"59": 0.9814680399419966}, {"78": 0.9780813749855728}, {"135": 0.9666004748492634}, {"16": 0.964761736617012}, {"152": 0.9633449131779934}, {"65": 0.961482722253187}]}

{"movie_id": 86, "similar_movies": [{"86": 1}, {"133": 0.9954084610555543}, {"158": 0.9932230063041532}, {"71": 0.9897068020652962}, {"182": 0.9813255513832253}, {"60": 0.9788067641028677}, {"187": 0.9736049847122761}, {"27": 0.9695581454460842}, {"54": 0.9662218680732495}, {"101": 0.9614054455754324}]}

{"movie_id": 87, "similar_movies": [{"87": 1}, {"111": 0.9994431266379258}, {"85": 0.9972412681817195}, {"151": 0.9970275834424223}, {"79": 0.9888533011045597}, {"42": 0.988316345786284}, {"98": 0.9862442137555945}, {"140": 0.9861797798663379}, {"149": 0.9857739830029724}, {"185": 0.9798031340208251}]}

{"movie_id": 88, "similar_movies": [{"88": 1}, {"195": 0.9996249900743448}, {"2": 0.9995668892923666}, {"114": 0.9992145701268174}, {"16": 0.9848551520317623}, {"183": 0.9843242087027329}, {"74": 0.9782738488038938}, {"109": 0.9775890467462551}, {"148": 0.9738152706622449}, {"89": 0.9727537821777659}]}

{"movie_id": 89, "similar_movies": [{"89": 1}, {"32": 0.9738710629280514}, {"47": 0.9723495803867488}, {"116": 0.969501094813563}, {"20": 0.9687672095625026}, {"9": 0.9676855808335736}, {"52": 0.9645626780765986}, {"70": 0.9605962883874146}, {"148": 0.9511096703242923}, {"147": 0.8962565149844703}]}

{"movie_id": 90, "similar_movies": [{"90": 1}, {"151": 0.9947309645952374}, {"53": 0.9908558093574675}, {"169": 0.9868116072496789}, {"55": 0.9749347488879396}, {"24": 0.9664970919201357}, {"94": 0.9658153433301313}, {"130": 0.9633243429351339}, {"114": 0.9590742363889504}, {"183": 0.9507356841756713}]}

{"movie_id": 91, "similar_movies": [{"91": 1}, {"53": 0.9984651629082475}, {"95": 0.995758927437824}, {"133": 0.9891222297265894}, {"128": 0.9842165764687834}, {"111": 0.9808355594424649}, {"90": 0.979285424478737}, {"48": 0.9790266076298446}, {"27": 0.9762481981534192}, {"119": 0.9686044222264598}]}

{"movie_id": 92, "similar_movies": [{"92": 1}, {"144": 0.9946392692909418}, {"9": 0.9925173866133399}, {"163": 0.9841999759530204}, {"32": 0.9687897411642583}, {"109": 0.9666978362662932}, {"64": 0.9603922056430394}, {"128": 0.9576264038705806}, {"56": 0.9542031272829044}, {"174": 0.952954665659073}]}

{"movie_id": 93, "similar_movies": [{"93": 1}, {"98": 0.9948236548500966}, {"116": 0.9925561267350878}, {"76": 0.9921765659963864}, {"117": 0.990141086752339}, {"186": 0.9898799116674946}, {"133": 0.9813767981127233}, {"110": 0.9676468291021747}, {"165": 0.9628589609934939}, {"144": 0.9590569204264234}]}

{"movie_id": 94, "similar_movies": [{"94": 1}, {"108": 0.994337705006954}, {"146": 0.9939764468039762}, {"137": 0.9864404475450317}, {"198": 0.9864300028640058}, {"175": 0.9775825484870264}, {"142": 0.9773307257568618}, {"106": 0.9764517032274187}, {"192": 0.9701493542023922}, {"12": 0.964922562396693}]}

{"movie_id": 95, "similar_movies": [{"95": 1}, {"159": 0.9874605888736607}, {"199": 0.9747155309100752}, {"151": 0.9645332939040652}, {"121": 0.9485115709330805}, {"18": 0.9469423269873334}, {"184": 0.9458779505223209}, {"176": 0.9320195692039297}, {"147": 0.9263544460590312}, {"37": 0.920247912627242}]}

{"movie_id": 96, "similar_movies": [{"96": 1}, {"22": 0.9946751843803661}, {"135": 0.9861696159638502}, {"147": 0.9834058430675485}, {"163": 0.9828901494334723}, {"200": 0.9808257319112978}, {"107": 0.9692864377070944}, {"136": 0.9589871525734872}, {"77": 0.9566563410431224}, {"106": 0.9445704069896896}]}

{"movie_id": 97, "similar_movies": [{"97": 1}, {"156": 0.9826647862176208}, {"52": 0.9776245716689387}, {"96": 0.9768487653013835}, {"87": 0.9717121255178773}, {"79": 0.96993133624547}, {"39": 0.9686490423637546}, {"116": 0.9392360220129747}, {"146": 0.9382047622430543}, {"21": 0.9019881655515287}]}

{"movie_id": 98, "similar_movies": [{"98": 1}, {"128": 0.9998631743002553}, {"105": 0.9849662200133129}, {"190": 0.9837766645463675}, {"6": 0.9808286047820645}, {"176": 0.9514758640545271}, {"191": 0.9514562237269693}, {"54": 0.9508497342802853}, {"127": 0.9486191116688525}, {"150": 0.9483362702764462}]}

{"movie_id": 99, "similar_movies": [{"99": 1}, {"95": 0.9998349947760854}, {"176": 0.998004143882744}, {"112": 0.9901335797930029}, {"118": 0.9900818608384676}, {"147": 0.9841541739074413}, {"107": 0.9798043271342756}, {"25": 0.9788124752540359}, {"49": 0.972331075522435}, {"38": 0.9695822115485395}]}

{"movie_id": 100, "similar_movies": [{"100": 1}, {"38": 0.9956207168243603}, {"115": 0.9948818531747572}, {"128": 0.9926026895806392}, {"149": 0.9850657198777801}, {"10": 0.9823572703342667}, {"3": 0.9777048504212356}, {"1": 0.969749744244039}, {"158": 0.9621786500287246}, {"117": 0.9593779499335426}]}

{"movie_id": 101, "similar_movies": [{"101": 1}, {"163": 0.9973657797988571}, {"115": 0.9905654963679513}, {"144": 0.9859768984453952}, {"173": 0.9839595689351388}, {"70": 0.9795833549963091}, {"73": 0.9792512645157179}, {"117": 0.9764478322097905}, {"98": 0.9728529077429875}, {"139": 0.9718513460547087}]}

{"movie_id": 102, "similar_movies": [{"102": 1}, {"74": 0.9974841784034154}, {"181": 0.9882193203260847}, {"68": 0.985991333469266}, {"186": 0.9812355885061101}, {"50": 0.9626780662180201}, {"172": 0.9599450144400743}, {"185": 0.9533219251034528}, {"89": 0.9493566494967351}, {"5": 0.9327491036619935}]}

{"movie_id": 103, "similar_movies": [{"103": 1}, {"104": 0.9963411809851654}, {"54": 0.9943732590386809}, {"89": 0.9879120291138472}, {"161": 0.9864186215284376}, {"118": 0.9850164136577291}, {"155": 0.9615023443806754}, {"148": 0.948990583588222}, {"25": 0.9376194615779092}, {"78": 0.9349424211610624}]}

{"movie_id": 104, "similar_movies": [{"104": 1}, {"87": 0.9990423170404767}, {"149": 0.9949042923776013}, {"113": 0.9761912962531467}, {"31": 0.9722020083449472}, {"127": 0.970819824925722}, {"154": 0.9654224227603256}, {"180": 0.9470742458925658}, {"69": 0.9460653975289726}, {"166": 0.9349189722720459}]}

{"movie_id": 105, "similar_movies": [{"105": 1}, {"177": 0.9818982408863375}, {"141": 0.9392561081281481}, {"42": 0.9371428564300388}, {"0": 0.9283642549945637}, {"74": 0.9273852558716713}, {"171": 0.9231654127293967}, {"87": 0.9194729548834675}, {"28": 0.9185120219243927}, {"56": 0.9102558262328988}]}

{"movie_id": 106, "similar_movies": [{"106": 1}, {"94": 0.9938410136971807}, {"122": 0.9933305228424743}, {"197": 0.9680890447723536}, {"18": 0.9617160297912142}, {"160": 0.9561223707214319}, {"118": 0.9369470572347647}, {"128": 0.9366250146042625}, {"49": 0.9349898841370987}, {"87": 0.9346526971215341}]}

{"movie_id": 107, "similar_movies": [{"107": 1}, {"156": 0.9946110271414177}, {"173": 0.9825626942237398}, {"172": 0.9820982740621746}, {"90": 0.9796296549447063}, {"16": 0.9789616535280761}, {"47": 0.9761146839011741}, {"19": 0.9742639286980344}, {"13": 0.9727331242626345}, {"10": 0.9551324795537715}]}

{"movie_id": 108, "similar_movies": [{"108": 1}, {"93": 0.9995650816637445}, {"86": 0.9942017743591611}, {"87": 0.9913027916453692}, {"100": 0.9823757767572652}, {"146": 0.9757775847282002}, {"115": 0.9592768114215466}, {"181": 0.9581496027719414}, {"68": 0.9546038508552377}, {"49": 0.9516719037539636}]}

{"movie_id": 109, "similar_movies": [{"109": 1}, {"183": 0.9866315549223663}, {"52": 0.9819460336528683}, {"89": 0.9794222436583542}, {"36": 0.9676313406725217}, {"188": 0.9654634061735667}, {"172": 0.9645040473215021}, {"94": 0.9621446050085154}, {"168": 0.947403735771744}, {"96": 0.9472835279117751}]}

{"movie_id": 110, "similar_movies": [{"110": 1}, {"191": 0.9986838001912937}, {"38": 0.9962428856062666}, {"8": 0.9937050523208264}, {"109": 0.9906029336350866}, {"16": 0.9843812896971329}, {"123": 0.9825404040975343}, {"140": 0.9794973776199862}, {"117": 0.9784569597395651}, {"84": 0.9744079165397674}]}

{"movie_id": 111, "similar_movies": [{"111": 1}, {"185": 0.9998389967056895}, {"70": 0.9934655339293743}, {"156": 0.9873020488288569}, {"113": 0.9839272817392974}, {"43": 0.983076685387658}, {"74": 0.9786878563730617}, {"191": 0.977652165156691}, {"12": 0.9755963509616217}, {"71": 0.9739228703904772}]}

{"movie_id": 112, "similar_movies": [{"112": 1}, {"35": 0.9964311955166123}, {"104": 0.9950035684421776}, {"99": 0.9879208542776008}, {"193": 0.9862924096707901}, {"26": 0.9849603747736009}, {"33": 0.9725718419276375}, {"196": 0.9703241964639069}, {"85": 0.9681804422837279}, {"122": 0.9516200364088154}]}

{"movie_id": 113, "similar_movies": [{"113": 1}, {"98": 0.9962470743153129}, {"181": 0.9945706709282343}, {"198": 0.9921195039020057}, {"130": 0.9876703418842456}, {"43": 0.9836434762132651}, {"138": 0.9828093294831963}, {"144": 0.9821697879387734}, {"136": 0.9786877661268603}, {"20": 0.9617664017226653}]}

{"movie_id": 114, "similar_movies": [{"114": 1}, {"55": 0.997141503864237}, {"61": 0.9955581707818213}, {"187": 0.993896276802162}, {"27": 0.9926300111943112}, {"179": 0.9897927159885982}, {"12": 0.9787794819470705}, {"13": 0.9775410941613565}, {"9": 0.9764170463095596}, {"40": 0.9605713943998255}]}

{"movie_id": 115, "similar_movies": [{"115": 1}, {"111": 0.9972625513657531}, {"27": 0.9956740115848148}, {"41": 0.9873863257604085}, {"66": 0.9753001119016438}, {"164": 0.9741058959993645}, {"8": 0.9590997289324414}, {"186": 0.9473925879391323}, {"196": 0.9330476776111056}, {"163": 0.9049053127282232}]}

{"movie_id": 116, "similar_movies": [{"116": 1}, {"185": 0.9813557095584027}, {"142": 0.9700639238186535}, {"12": 0.9696039896041289}, {"5": 0.968634311959893}, {"78": 0.9678340011400706}, {"62": 0.9664425120931792}, {"75": 0.9626264404183389}, {"145": 0.9496078978780063}, {"168": 0.940847524946556}]}

{"movie_id": 117, "similar_movies": [{"117": 1}, {"20": 0.9946041586507637}, {"184": 0.9908352797815829}, {"97": 0.9843513742939154}, {"190": 0.9727789890444256}, {"137": 0.9724634424676772}, {"149": 0.9686070094233237}, {"109": 0.9553560975946918}, {"172": 0.9539978611630049}, {"75": 0.9532915400424018}]}

{"movie_id": 118, "similar_movies": [{"118": 1}, {"200": 0.9992535534051561}, {"75": 0.9992053759874879}, {"100": 0.9970132241921286}, {"159": 0.9861674387206854}, {"142": 0.9853083144171413}, {"59": 0.9815480473365565}, {"77": 0.9731871122450075}, {"192": 0.9641419556243325}, {"85": 0.9636356551786309}]}

{"movie_id": 119, "similar_movies": [{"119": 1}, {"10": 0.998260896144785}, {"24": 0.9961933673209988}, {"90": 0.9940025820552845}, {"50": 0.9892054375927377}, {"14": 0.9882642095091565}, {"178": 0.9856000776458842}, {"95": 0.9849649811571413}, {"69": 0.976898502557866}, {"186": 0.9758250084417204}]}

{"movie_id": 120, "similar_movies": [{"120": 1}, {"198": 0.9925451950443542}, {"37": 0.991721776091975}, {"110": 0.9810586953340195}, {"157": 0.9655767867663372}, {"179": 0.9414192598835012}, {"159": 0.9373777597230426}, {"30": 0.9349875478501168}, {"93": 0.9340771182683381}, {"75": 0.9337165970695329}]}

{"movie_id": 121, "similar_movies": [{"121": 1}, {"25": 0.9965886229739183}, {"76": 0.9963725779228805}, {"179": 0.9895325500732064}, {"38": 0.9894702805766291}, {"72": 0.9871511533956632}, {"155": 0.9774244781687376}, {"52": 0.9752452859427456}, {"124": 0.9725020351584115}, {"157": 0.9696297091162069}]}

{"movie_id": 122, "similar_movies": [{"122": 1}, {"190": 0.9976543986526565}, {"77": 0.9960805503065584}, {"173": 0.9866319510191126}, {"162": 0.9863838532405076}, {"128": 0.9839070858308299}, {"100": 0.9730287660731651}, {"187": 0.9669054051884556}, {"14": 0.959156951724087}, {"91": 0.9572498544753123}]}

{"movie_id": 123, "similar_movies": [{"123": 1}, {"193": 0.9909920587725665}, {"48": 0.986738981349931}, {"152": 0.9860815620453252}, {"190": 0.9834241831712447}, {"76": 0.9697704121036583}, {"65": 0.9594519772751009}, {"126": 0.9593951420245102}, {"142": 0.9582317356088759}, {"137": 0.9443600634412914}]}

{"movie_id": 124, "similar_movies": [{"124": 1}, {"9": 0.9928857700418381}, {"176": 0.9813406921113612}, {"161": 0.9725358115215752}, {"90": 0.9679729738030662}, {"171": 0.9659966609813757}, {"117": 0.95633119869594}, {"155": 0.950605544359207}, {"150": 0.9481915202411915}, {"96": 0.9319573595585053}]}

{"movie_id": 125, "similar_movies": [{"125": 1}, {"54": 0.9907166226580932}, {"0": 0.9876926955255625}, {"80": 0.9672230733662075}, {"145": 0.9599041666662034}, {"25": 0.9582621236195461}, {"133": 0.955235205580369}, {"10": 0.9497842484293091}, {"100": 0.9466110709598341}, {"73": 0.9441008041666707}]}

{"movie_id": 126, "similar_movies": [{"126": 1}, {"188": 0.9891646941854952}, {"137": 0.9882906206684692}, {"145": 0.9877965321388296}, {"189": 0.9707735357385432}, {"18": 0.9518868785954373}, {"144": 0.9448972444244799}, {"168": 0.943552022018779}, {"82": 0.9426609402321444}, {"99": 0.9380928456099298}]}

{"movie_id": 127, "similar_movies": [{"127": 1}, {"56": 0.9985327211315993}, {"166": 0.9950613806868562}, {"35": 0.9950480530137946}, {"137": 0.9928429810422452}, {"138": 0.9838523492625839}, {"152": 0.9794791316389355}, {"92": 0.9761692847699477}, {"146": 0.9691990598817779}, {"119": 0.9495380695840601}]}

{"movie_id": 128, "similar_movies": [{"128": 1}, {"70": 0.993533987993086}, {"92": 0.9752367287053472}, {"7": 0.9745222478058588}, {"133": 0.9741520770981027}, {"96": 0.9720926570465722}, {"56": 0.967631013852611}, {"21": 0.965621474825265}, {"164": 0.9650037912478509}, {"82": 0.9603190074695975}]}

{"movie_id": 129, "similar_movies": [{"129": 1}, {"13": 0.9889561448155955}, {"159": 0.9813051244835447}, {"147": 0.9772774356893712}, {"23": 0.9747020341789352}, {"71": 0.9649945400169322}, {"6": 0.9614724143955633}, {"118": 0.9577216702149085}, {"145": 0.9560812592691381}, {"86": 0.9499681284097916}]}

{"movie_id": 130, "similar_movies": [{"130": 1}, {"106": 0.9968316516562301}, {"122": 0.9897639093992152}, {"120": 0.9885177877692823}, {"135": 0.9883412980484982}, {"131": 0.9866497789636386}, {"195": 0.9699366186604055}, {"73": 0.9696438895989408}, {"178": 0.9666523700635741}, {"162": 0.960411901797751}]}

{"movie_id": 131, "similar_movies": [{"131": 1}, {"171": 0.9805192825302067}, {"186": 0.9777908387448266}, {"122": 0.9769220473530511}, {"101": 0.9725678910188704}, {"130": 0.9720489550367395}, {"41": 0.9703386446287718}, {"100": 0.9616675391520602}, {"1": 0.9525527874634403}, {"98": 0.9518434399952882}]}

{"movie_id": 132, "similar_movies": [{"132": 1}, {"75": 0.9999203009265232}, {"20": 0.9977078162890283}, {"149": 0.9960015937032158}, {"164": 0.9957654856117315}, {"193": 0.9827687139830041}, {"58": 0.9781802273259466}, {"12": 0.9352383853275799}, {"194": 0.9326662397859962}, {"46": 0.9292978148049964}]}

{"movie_id": 133, "similar_movies": [{"133": 1}, {"126": 0.9991487142883828}, {"165": 0.9940801998970366}, {"177": 0.9912593313037883}, {"184": 0.9866506208532382}, {"148": 0.9825158773590386}, {"183": 0.9816442827525116}, {"180": 0.9805244510494491}, {"101": 0.9790514301818207}, {"194": 0.9662743490125254}]}

{"movie_id": 134, "similar_movies": [{"134": 1}, {"162": 0.9956875950400563}, {"6": 0.9856177417414127}, {"119": 0.9828324433646347}, {"159": 0.9654478316113306}, {"194": 0.9623007441494535}, {"94": 0.9518286976237129}, {"26": 0.9517443657922868}, {"10": 0.9418790549519089}, {"89": 0.9410797505154229}]}

{"movie_id": 135, "similar_movies": [{"135": 1}, {"145": 0.9986278478139325}, {"101": 0.9955637512751927}, {"94": 0.9923434682367616}, {"9": 0.9903646223357925}, {"68": 0.9866988604802647}, {"98": 0.9613221081385537}, {"62": 0.9534080649211554}, {"1": 0.9507707777676007}, {"187": 0.9324270406459485}]}

{"movie_id": 136, "similar_movies": [{"136": 1}, {"112": 0.9958876557380594}, {"0": 0.9864583154005797}, {"51": 0.9823203021245372}, {"157": 0.9807772058251472}, {"61": 0.9795899676809092}, {"182": 0.9740579412233807}, {"144": 0.9693013657752108}, {"141": 0.9680970513502845}, {"120": 0.9680122400613032}]}

{"movie_id": 137, "similar_movies": [{"137": 1}, {"173": 0.9961185092869032}, {"172": 0.9896789466108125}, {"118": 0.9887351161639972}, {"22": 0.9827636226186978}, {"138": 0.9825832257728544}, {"160": 0.9791918572792198}, {"115": 0.9747296330977047}, {"184": 0.9731288615464164}, {"41": 0.9641690439994981}]}

{"movie_id": 138, "similar_movies": [{"138": 1}, {"92": 0.9960183935313447}, {"108": 0.9899763413723668}, {"75": 0.9855076430546987}, {"43": 0.9852318097276047}, {"132": 0.9850469465586016}, {"182": 0.9808154032610872}, {"137": 0.9785091211691983}, {"122": 0.9708437071083122}, {"158": 0.9704652065992583}]}

{"movie_id": 139, "similar_movies": [{"139": 1}, {"118": 0.9926803042736312}, {"40": 0.9812534491104281}, {"113": 0.9669134685710463}, {"135": 0.9619120085904105}, {"131": 0.9479718247186144}, {"188": 0.9476751757012682}, {"36": 0.9425999669112828}, {"64": 0.9377286630622244}, {"56": 0.9365105644319907}]}

{"movie_id": 140, "similar_movies": [{"140": 1}, {"133": 0.9912232795928624}, {"121": 0.9876581885972506}, {"76": 0.9862535697656267}, {"28": 0.9818490722527333}, {"127": 0.9797137898393053}, {"8": 0.9790504658090899}, {"6": 0.973606622435504}, {"0": 0.9647684436695407}, {"97": 0.9634415022558707}]}

{"movie_id": 141, "similar_movies": [{"141": 1}, {"110": 0.9752849509232975}, {"126": 0.9748501040690927}, {"93": 0.973155249234064}, {"50": 0.9711974678659281}, {"24": 0.9611227689304822}, {"131": 0.9603288224942459}, {"1": 0.9567160342529493}, {"169": 0.9420230935230578}, {"2": 0.9255735639178444}]}

{"movie_id": 142, "similar_movies": [{"142": 1}, {"146": 0.9893152105284488}, {"191": 0.987959625227598}, {"157": 0.9864059460462788}, {"130": 0.9852411496052595}, {"195": 0.981389458080056}, {"175": 0.9678757586277398}, {"194": 0.9670888521374397}, {"133": 0.96351881882375}, {"127": 0.9622026769657974}]}

{"movie_id": 143, "similar_movies": [{"143": 1}, {"188": 0.9996197047167019}, {"50": 0.9990320960898593}, {"85": 0.9954901107932204}, {"133": 0.9938543327237634}, {"114": 0.9906589989586914}, {"55": 0.988726897588688}, {"37": 0.9856131880708641}, {"196": 0.9693130506356793}, {"74": 0.9681515618210119}]}

{"movie_id": 144, "similar_movies": [{"144": 1}, {"160": 0.9911249334193333}, {"178": 0.9893823751721449}, {"24": 0.988542513853623}, {"36": 0.9873737124451758}, {"169": 0.985472359863111}, {"149": 0.9761240875878716}, {"184": 0.9751869720068151}, {"183": 0.9710118965186407}, {"74": 0.9659744383125193}]}

{"movie_id": 145, "similar_movies": [{"145": 1}, {"119": 0.9880235751475483}, {"38": 0.9677038654042838}, {"81": 0.9574966560861755}, {"123": 0.955273463356445}, {"91": 0.9522287954235766}, {"97": 0.9463693899646788}, {"149": 0.9439548610676736}, {"192": 0.9369745931952833}, {"13": 0.9303048022820226}]}

{"movie_id": 146, "similar_movies": [{"146": 1}, {"119": 0.9909824927461768}, {"10": 0.9900312742803337}, {"148": 0.97810419543535}, {"23": 0.9710322858740508}, {"140": 0.966279702827068}, {"157": 0.9549625706352434}, {"72": 0.9533261297233004}, {"101": 0.9451449559569096}, {"16": 0.9442203096912418}]}

{"movie_id": 147, "similar_movies": [{"147": 1}, {"56": 0.9980458123486562}, {"170": 0.9919233071615963}, {"66": 0.98277921156972}, {"55": 0.9824458199536115}, {"175": 0.9779490241448363}, {"100": 0.9741030998693372}, {"176": 0.9711316040218338}, {"50": 0.9578819966018972}, {"174": 0.9503279288194508}]}

{"movie_id": 148, "similar_movies": [{"148": 1}, {"1": 0.9969607431289038}, {"31": 0.9965874121443605}, {"11": 0.9926783252942335}, {"7": 0.9857670798812774}, {"197": 0.9823807200140326}, {"6": 0.9754206324007648}, {"99": 0.9704943768750331}, {"43": 0.969380650360105}, {"63": 0.9658359754540538}]}

{"movie_id": 149, "similar_movies": [{"149": 1}, {"57": 0.9979058804434948}, {"105": 0.9948624863345052}, {"150": 0.9935270250455404}, {"67": 0.9929756489592096}, {"28": 0.992957054261975}, {"191": 0.9919966998196466}, {"75": 0.9897777466845681}, {"46": 0.9854854460205784}, {"61": 0.9826909697594342}]}

{"movie_id": 150, "similar_movies": [{"150": 1}, {"185": 0.9985963925436405}, {"98": 0.9937366241736136}, {"117": 0.9921006568890178}, {"164": 0.9916730414023505}, {"10": 0.9850566933816982}, {"140": 0.9745938475190947}, {"101": 0.9611360986473922}, {"166": 0.958592776087704}, {"30": 0.9579205444852852}]}

{"movie_id": 151, "similar_movies": [{"151": 1}, {"104": 0.9887542834366569}, {"79": 0.9854952174194171}, {"101": 0.9777353672476174}, {"12": 0.9737031755670595}, {"122": 0.9706304977270719}, {"119": 0.9680195268816831}, {"136": 0.9659734797419082}, {"135": 0.9582189513313695}, {"6": 0.9559195334046322}]}

{"movie_id": 152, "similar_movies": [{"152": 1}, {"136": 0.9974750439471278}, {"31": 0.9812367755406546}, {"4": 0.9786731386405116}, {"89": 0.9768761134552781}, {"174": 0.975895895807374}, {"185": 0.9701187717582604}, {"100": 0.9585873448863129}, {"74": 0.9501250625309039}, {"177": 0.9498420251273645}]}

{"movie_id": 153, "similar_movies": [{"153": 1}, {"134": 0.993389583723103}, {"43": 0.9866825100076193}, {"171": 0.9859829750082141}, {"139": 0.9808467958734208}, {"11": 0.9800041776914672}, {"81": 0.9767950336526448}, {"145": 0.9722510666997464}, {"10": 0.9714880845250697}, {"8": 0.9713302675211168}]}

{"movie_id": 154, "similar_movies": [{"154": 1}, {"62": 0.9930031145426645}, {"9": 0.9891689992654322}, {"197": 0.9890359240522462}, {"105": 0.9865326296994619}, {"95": 0.9840199744491078}, {"97": 0.9838785091386153}, {"74": 0.9806925789842571}, {"170": 0.9785389154170852}, {"42": 0.9775555628068}]}

{"movie_id": 155, "similar_movies": [{"155": 1}, {"179": 0.9898430647100247}, {"42": 0.9839112787671709}, {"82": 0.9819185940347546}, {"137": 0.9662645097733265}, {"95": 0.9631717246933291}, {"148": 0.958167966359456}, {"183": 0.9562270642118766}, {"192": 0.9538932477687394}, {"182": 0.9526192853101485}]}

{"movie_id": 156, "similar_movies": [{"156": 1}, {"5": 0.9930235836807415}, {"164": 0.9924376484447981}, {"181": 0.9863581092428966}, {"120": 0.982392926317569}, {"136": 0.9810707742409046}, {"143": 0.9703029889920027}, {"121": 0.9688273784682231}, {"195": 0.9661433016051637}, {"4": 0.9658129375207836}]}

{"movie_id": 157, "similar_movies": [{"157": 1}, {"58": 0.982810452115251}, {"193": 0.9799477468518931}, {"53": 0.9786440206187357}, {"100": 0.9779624375027667}, {"113": 0.97655872451972}, {"63": 0.9641981580161092}, {"111": 0.95868301819682}, {"4": 0.9534642298920715}, {"44": 0.9335220917970093}]}

{"movie_id": 158, "similar_movies": [{"158": 1}, {"103": 0.9992681830114072}, {"120": 0.9987050472155856}, {"163": 0.9974599044748886}, {"98": 0.9850995814291228}, {"68": 0.9839835371389529}, {"40": 0.9831631029242927}, {"33": 0.9830906169707441}, {"92": 0.9775434879477056}, {"17": 0.9750259769306147}]}

{"movie_id": 159, "similar_movies": [{"159": 1}, {"131": 0.9904044641927499}, {"186": 0.9903530469773048}, {"169": 0.9855116644318007}, {"51": 0.9690658404592629}, {"97": 0.9660387712037941}, {"170": 0.9543452259826297}, {"149": 0.9536960473356673}, {"198": 0.9503398586651257}, {"161": 0.9476402941306401}]}

{"movie_id": 160, "similar_movies": [{"160": 1}, {"89": 0.9889621558551063}, {"183": 0.9880841918976397}, {"27": 0.958711829395841}, {"111": 0.9491424671440096}, {"72": 0.9456778426807677}, {"133": 0.9367515051917283}, {"169": 0.9360064283028529}, {"137": 0.9300571575653525}, {"124": 0.9209730754291234}]}

{"movie_id": 161, "similar_movies": [{"161": 1}, {"142": 0.9989855096569578}, {"190": 0.9984273421531069}, {"79": 0.9928324010772711}, {"61": 0.9915791465018431}, {"173": 0.988193815587789}, {"16": 0.9877650031415177}, {"145": 0.9724793749810867}, {"123": 0.9668923840199402}, {"189": 0.9650353087899921}]}

{"movie_id": 162, "similar_movies": [{"162": 1}, {"45": 0.9995505798105542}, {"30": 0.9884503770756592}, {"5": 0.9585622396130997}, {"12": 0.9585290448114625}, {"170": 0.956048032521164}, {"102": 0.9530647547643487}, {"137": 0.9441711647428348}, {"10": 0.9408205375755025}, {"41": 0.9405477793568056}]}

{"movie_id": 163, "similar_movies": [{"163": 1}, {"22": 0.9991674226497553}, {"156": 0.999106098516013}, {"89": 0.9947887844619308}, {"34": 0.9946858228108844}, {"80": 0.9928863352417843}, {"93": 0.976109619173694}, {"68": 0.9701522208717164}, {"8": 0.9582222856584433}, {"162": 0.9545872764452135}]}

{"movie_id": 164, "similar_movies": [{"164": 1}, {"38": 0.9932637996187306}, {"96": 0.9912774683923049}, {"89": 0.9871360492157508}, {"149": 0.987073741914045}, {"115": 0.9813442854531409}, {"42": 0.9784734627434164}, {"44": 0.9722913333827139}, {"34": 0.9714287005746618}, {"159": 0.9595896464053824}]}

{"movie_id": 165, "similar_movies": [{"165": 1}, {"60": 0.9986448830122647}, {"184": 0.9980130842053805}, {"47": 0.9961892585978485}, {"126": 0.9950546342888347}, {"81": 0.9931688482281493}, {"110": 0.9929140099739282}, {"39": 0.988342645301719}, {"139": 0.9874783841491923}, {"158": 0.9862656315272023}]}

{"movie_id": 166, "similar_movies": [{"166": 1}, {"188": 0.9969308743719405}, {"41": 0.9941076199197452}, {"100": 0.9932594041515248}, {"130": 0.9918059985377992}, {"144": 0.9852752182898501}, {"56": 0.9844300111156141}, {"112": 0.9719831286911691}, {"136": 0.9687499602150846}, {"64": 0.9671197325098624}]}

{"movie_id": 167, "similar_movies": [{"167": 1}, {"35": 0.9983566120920799}, {"54": 0.9948410407188086}, {"189": 0.9916123904139944}, {"11": 0.9812354009698772}, {"6": 0.9809190660889913}, {"114": 0.9698406749294066}, {"138": 0.966469594446635}, {"162": 0.9651207550740586}, {"87": 0.9611673755922057}]}

{"movie_id": 168, "similar_movies": [{"168": 1}, {"143": 0.998184151225324}, {"58": 0.9863641782181432}, {"170": 0.9837680684145937}, {"156": 0.981008864308595}, {"30": 0.9741707375209949}, {"11": 0.9628541245664195}, {"36": 0.9536754797675275}, {"24": 0.9504240861518498}, {"6": 0.9495321188748351}]}

{"movie_id": 169, "similar_movies": [{"169": 1}, {"86": 0.9836635891884955}, {"10": 0.9824971520870951}, {"200": 0.9802001835408383}, {"187": 0.9735671869409595}, {"17": 0.9712212165445129}, {"198": 0.9680776377439486}, {"64": 0.9615931634090922}, {"27": 0.9478752546150244}, {"160": 0.9458092715488664}]}

{"movie_id": 170, "similar_movies": [{"170": 1}, {"78": 0.9974423920793893}, {"28": 0.9956531167747851}, {"33": 0.9928845150103771}, {"47": 0.987519614881972}, {"192": 0.9836937993534565}, {"73": 0.9735813220170353}, {"169": 0.9656824176929579}, {"82": 0.9639854839515472}, {"142": 0.9493912676497249}]}

{"movie_id": 171, "similar_movies": [{"171": 1}, {"23": 0.997127189011022}, {"51": 0.9939550575224918}, {"87": 0.9911836441612611}, {"144": 0.9868921171504612}, {"45": 0.9788284404537735}, {"28": 0.9746920332391891}, {"12": 0.9696358306160879}, {"188": 0.9667517355579236}, {"3": 0.9661373580055539}]}

{"movie_id": 172, "similar_movies": [{"172": 1}, {"126": 0.9961059509824697}, {"25": 0.9918779344707533}, {"145": 0.9762321782193937}, {"100": 0.9650386279191465}, {"34": 0.9544458850189104}, {"48": 0.9526307732595511}, {"199": 0.9466995102746278}, {"171": 0.9409346257447373}, {"191": 0.9135386261676823}]}

{"movie_id": 173, "similar_movies": [{"173": 1}, {"65": 0.9995548908214595}, {"15": 0.9918552309281339}, {"156": 0.990642939337953}, {"89": 0.9780814080627676}, {"193": 0.9718060271744586}, {"115": 0.966743288222337}, {"24": 0.96638527876417}, {"76": 0.9559450965214928}, {"182": 0.9517930704395265}]}

{"movie_id": 174, "similar_movies": [{"174": 1}, {"62": 0.9986690350181409}, {"173": 0.9944933376274041}, {"63": 0.9927733128352925}, {"161": 0.9843219810026884}, {"108": 0.9811021170608492}, {"29": 0.980852027371051}, {"98": 0.9747664371412774}, {"84": 0.970494478398628}, {"58": 0.9522871663411641}]}

{"movie_id": 175, "similar_movies": [{"175": 1}, {"98": 0.995314291105609}, {"146": 0.9952750270493274}, {"71": 0.9936621102875638}, {"157": 0.9763338103411086}, {"10": 0.973320776801692}, {"103": 0.967717257323709}, {"182": 0.9645724354257215}, {"27": 0.9613829947494477}, {"127": 0.9460329711816191}]}

{"movie_id": 176, "similar_movies": [{"176": 1}, {"7": 0.9950743104463191}, {"84": 0.9923012442996113}, {"159": 0.99083342482518}, {"90": 0.9857804836938897}, {"79": 0.980995075417697}, {"160": 0.9807657839041184}, {"93": 0.9727012039460619}, {"113": 0.9705477139552019}, {"83": 0.9681152587314972}]}

{"movie_id": 177, "similar_movies": [{"177": 1}, {"195": 0.9967848025634911}, {"142": 0.9916897399053686}, {"64": 0.9905875399688846}, {"179": 0.9880542313897986}, {"69": 0.9871030074299296}, {"187": 0.9855981380928407}, {"75": 0.983920643904268}, {"137": 0.9829135104237572}, {"47": 0.9812984372325617}]}

{"movie_id": 178, "similar_movies": [{"178": 1}, {"180": 0.9975426471799436}, {"46": 0.9912756278982158}, {"63": 0.9874162870102206}, {"109": 0.9855154023996895}, {"52": 0.9836108977037763}, {"92": 0.9800055643152386}, {"5": 0.9778635242765072}, {"61": 0.975527927908497}, {"40": 0.9739766189724703}]}

{"movie_id": 179, "similar_movies": [{"179": 1}, {"138": 0.9929670083522273}, {"154": 0.9910748542083518}, {"148": 0.9903149389994537}, {"37": 0.9843441751136528}, {"124": 0.9740026028876441}, {"85": 0.9702363921857495}, {"151": 0.9655028573443283}, {"16": 0.9629263376462018}, {"194": 0.9595221849741427}]}

{"movie_id": 180, "similar_movies": [{"180": 1}, {"104": 0.9961911625235236}, {"62": 0.9925357732391391}, {"134": 0.9911261258276716}, {"146": 0.9874994637770123}, {"46": 0.9832383595109975}, {"118": 0.9814928936496108}, {"69": 0.9671028996807054}, {"124": 0.9658956971148605}, {"15": 0.9635096301392798}]}

{"movie_id": 181, "similar_movies": [{"181": 1}, {"55": 0.9936950317499655}, {"89": 0.9876753328137435}, {"28": 0.9861191977143948}, {"15": 0.9689781582665644}, {"126": 0.9622529038817151}, {"33": 0.960221484707557}, {"129": 0.9513535824769588}, {"139": 0.9474341937884536}, {"96": 0.9428697580725431}]}

{"movie_id": 182, "similar_movies": [{"182": 1}, {"65": 0.9944229076213418}, {"69": 0.9931316005466986}, {"25": 0.993048236824521}, {"97": 0.9895254669466396}, {"6": 0.987633936273012}, {"128": 0.986417037687181}, {"48": 0.9842083286903731}, {"24": 0.973989615848931}, {"98": 0.9634686834612511}]}

{"movie_id": 183, "similar_movies": [{"183": 1}, {"182": 0.9931598499071288}, {"80": 0.9906022450956549}, {"143": 0.987832613206931}, {"25": 0.9869585556867149}, {"125": 0.9751370269407111}, {"46": 0.96763456921488}, {"173": 0.9648840311637301}, {"133": 0.9623446544548659}, {"178": 0.9620068809664295}]}

{"movie_id": 184, "similar_movies": [{"184": 1}, {"34": 0.9946042420833692}, {"192": 0.990310328264973}, {"46": 0.9871241899339025}, {"128": 0.9836370363358438}, {"188": 0.9669542456069389}, {"12": 0.965874763831114}, {"23": 0.9639102430129165}, {"155": 0.9625311536213841}, {"54": 0.9619146794032178}]}

{"movie_id": 185, "similar_movies": [{"185": 1}, {"33": 0.9983730080354987}, {"170": 0.9957960620520308}, {"103": 0.9807051144290746}, {"129": 0.9757702749249006}, {"200": 0.965898747507703}, {"192": 0.9646596055262899}, {"53": 0.9614888351911595}, {"180": 0.9572755766756631}, {"161": 0.9545890745990278}]}

{"movie_id": 186, "similar_movies": [{"186": 1}, {"127": 0.9989792876626993}, {"179": 0.998372973271747}, {"189": 0.9969822709774812}, {"65": 0.9937257055401629}, {"8": 0.9811940396747059}, {"175": 0.9745449813735261}, {"1": 0.9717878135925977}, {"156": 0.9620633129941991}, {"79": 0.954359022015973}]}

{"movie_id": 187, "similar_movies": [{"187": 1}, {"52": 0.9937891841166835}, {"88": 0.9927874801805707}, {"128": 0.9911919509811533}, {"165": 0.9901344949145976}, {"84": 0.9724625081427083}, {"97": 0.9636944315411025}, {"35": 0.9592726561198797}, {"107": 0.9556312121110093}, {"173": 0.9518035757409167}]}

{"movie_id": 188, "similar_movies": [{"188": 1}, {"45": 0.9901428809664801}, {"119": 0.9896950124612014}, {"103": 0.9885426932079027}, {"27": 0.9849738807964217}, {"108": 0.9814959063413342}, {"39": 0.9803642654393194}, {"195": 0.9762041200243858}, {"149": 0.971997503518613}, {"20": 0.971135478622609}]}

{"movie_id": 189, "similar_movies": [{"189": 1}, {"2": 0.9964154800687899}, {"101": 0.9914801406968261}, {"119": 0.9809705485344318}, {"194": 0.9790847887585457}, {"16": 0.971423202940862}, {"35": 0.9704081940339546}, {"9": 0.9690786829997655}, {"90": 0.9666381304145175}, {"85": 0.9607615079445169}]}

{"movie_id": 190, "similar_movies": [{"190": 1}, {"68": 0.9965056335878153}, {"22": 0.9955288453329005}, {"57": 0.9953196213974347}, {"174": 0.975671592299767}, {"168": 0.9749193171111594}, {"149": 0.9671029109508413}, {"139": 0.9655307886656315}, {"111": 0.9542582843943541}, {"151": 0.9466765091943732}]}

{"movie_id": 191, "similar_movies": [{"191": 1}, {"113": 0.9964975396991766}, {"59": 0.99247031198165}, {"195": 0.9896829581148083}, {"160": 0.9721266677675078}, {"157": 0.9674405882620596}, {"25": 0.9668955452637011}, {"48": 0.9640059610870726}, {"101": 0.9547556205395629}, {"105": 0.9503009846987704}]}

{"movie_id": 192, "similar_movies": [{"192": 1}, {"63": 0.9951973571748454}, {"156": 0.988704919767744}, {"77": 0.9841403025352493}, {"152": 0.9639125255855532}, {"26": 0.9456525966009106}, {"115": 0.9452407031367895}, {"94": 0.9145659040125469}, {"55": 0.9133240670824188}, {"136": 0.9095858090141844}]}

{"movie_id": 193, "similar_movies": [{"193": 1}, {"36": 0.9988603694613181}, {"128": 0.9985860350093974}, {"158": 0.9957211702731927}, {"151": 0.9864305205173496}, {"109": 0.9788139589070546}, {"2": 0.9721304077761501}, {"66": 0.9707989917562472}, {"68": 0.9699063964599572}, {"191": 0.9647851874119178}]}

{"movie_id": 194, "similar_movies": [{"194": 1}, {"188": 0.9973888082669604}, {"89": 0.992087690849534}, {"151": 0.988709449081915}, {"149": 0.9885035038343124}, {"90": 0.9875535499994172}, {"156": 0.9848724257771393}, {"39": 0.9817929088676332}, {"56": 0.9761561638158207}, {"46": 0.9744928422924555}]}

{"movie_id": 195, "similar_movies": [{"195": 1}, {"188": 0.9940126931837974}, {"157": 0.9836494349271117}, {"1": 0.9773928287766005}, {"166": 0.9712467032653371}, {"70": 0.9643066416135888}, {"4": 0.9554527880577786}, {"34": 0.9531094182471926}, {"160": 0.9501873618475312}, {"52": 0.9420798627147293}]}

{"movie_id": 196, "similar_movies": [{"196": 1}, {"26": 0.9964196765777462}, {"171": 0.9935648576190033}, {"19": 0.9871289971920043}, {"178": 0.9819638652322231}, {"133": 0.9796241383983526}, {"101": 0.9664162801979164}, {"67": 0.959551008090284}, {"87": 0.9595028986624199}, {"13": 0.9593214347086494}]}

{"movie_id": 197, "similar_movies": [{"197": 1}, {"175": 0.9968230135454019}, {"37": 0.9902730682574592}, {"163": 0.9733504475239811}, {"195": 0.9706352711055994}, {"74": 0.9620748113840438}, {"28": 0.9615397798902143}, {"24": 0.9594270944303003}, {"88": 0.9579668696322989}, {"183": 0.9359314572178741}]}

{"movie_id": 198, "similar_movies": [{"198": 1}, {"11": 0.9946831859153804}, {"37": 0.9903592505036303}, {"51": 0.9804903970300951}, {"146": 0.9728466143022767}, {"63": 0.9686517592536588}, {"22": 0.9655924191586123}, {"155": 0.9647011578593929}, {"180": 0.9632071214651765}, {"77": 0.9627883997734612}]}

{"movie_id": 199, "similar_movies": [{"199": 1}, {"175": 0.9896890450051905}, {"143": 0.9807406756657584}, {"74": 0.978763374565677}, {"134": 0.9719474042128795}, {"189": 0.9710564744057264}, {"170": 0.9680532305409957}, {"123": 0.9649705618609383}, {"186": 0.9589246058047864}, {"138": 0.958582020697547}]}

{"movie_id": 200, "similar_movies": [{"200": 1}, {"42": 0.9855823271540549}, {"161": 0.9797527129933763}, {"135": 0.9788585072758413}, {"119": 0.9778016426424512}, {"7": 0.9747736080311282}, {"2": 0.9673451689580801}, {"159": 0.9655597788538048}, {"96": 0.9621011879729715}, {"133": 0.9615714623297356}]}

SELECT 201
movie_id	similar_movie_id	similarity
0	0	1
0	1	0.6402839231277071
0	2	0.80326410702165
0	3	0.931589426258701
0	4	0.6259215008930064
similar_movie_id	similarity	score
0	1	1
109	0.9972348380720784	2
89	0.996691205306764	3
72	0.9565037077794105	4
76	0.9471737433998897	5