{"columns":[{"alerts":[],"column":"movieId","extras":{"histogram":{"counts":[7196,1111,0,1114,796,435,754,816,789,1132,1107,1398,1556,1541,1535,1847,2673,2763,3280,3282,3146,3258,3464,3492,3484,3486,3401,3369,3050,2907,2325,1839,1672,1531,1566,1679,1911,2168,2580,2132],"edges":[1.0,7319.9,14638.8,21957.699999999997,29276.6,36595.5,43914.399999999994,51233.299999999996,58552.2,65871.09999999999,73190.0,80508.9,87827.79999999999,95146.7,102465.59999999999,109784.5,117103.4,124422.29999999999,131741.19999999998,139060.1,146379.0,153697.9,161016.8,168335.69999999998,175654.59999999998,182973.5,190292.4,197611.3,204930.19999999998,212249.09999999998,219568.0,226886.9,234205.8,241524.69999999998,248843.59999999998,256162.5,263481.39999999997,270800.3,278119.2,285438.1,292757.0]},"sample":[469.0,577.0,652.0,886.0,1252.0,1620.0,1630.0,1781.0,1977.0,2022.0,2070.0,2081.0,2267.0,2287.0,2780.0,2883.0,3119.0,3342.0,3363.0,3734.0,3919.0,4020.0,4029.0,5192.0,5669.0,5785.0,6027.0,6028.0,6775.0,7030.0,7042.0,7202.0,7351.0,7587.0,7623.0,7831.0,8143.0,8400.0,8537.0,8610.0,8662.0,8738.0,8915.0,8975.0,8982.0,25874.0,25947.0,26871.0,27595.0,27624.0,27912.0,31053.0,31437.0,33677.0,34542.0,38798.0,40478.0,40819.0,43934.0,44779.0,45668.0,47571.0,48584.0,48715.0,50514.0,51894.0,52460.0,52804.0,58293.0,58306.0,58760.0,58847.0,59031.0,59485.0,61110.0,61352.0,65601.0,67980.0,68157.0,68462.0,69275.0,69475.0,72571.0,72852.0,72872.0,74754.0,74791.0,76217.0,76720.0,77177.0,78957.0,80498.0,80748.0,81355.0,82449.0,82469.0,83275.0,83796.0,83835.0,86860.0,87181.0,89219.0,90254.0,91331.0,91564.0,91789.0,92222.0,92479.0,97779.0,101505.0,102716.0,102819.0,104064.0,104233.0,105377.0,105519.0,106854.0,107675.0,107901.0,108932.0,109925.0,110284.0,112807.0,114601.0,116199.0,116576.0,116748.0,117374.0,117656.0,119141.0,120492.0,120536.0,120586.0,120755.0,121399.0,121659.0,121689.0,121757.0,122411.0,122851.0,122982.0,123151.0,123526.0,123639.0,124021.0,124318.0,124737.0,125101.0,125257.0,125485.0,125541.0,125795.0,126046.0,126785.0,127579.0,128105.0,128227.0,128437.0,128983.0,129378.0,129466.0,129779.0,130516.0,130522.0,130528.0,131365.0,132210.0,132278.0,132632.0,133065.0,133285.0,133443.0,133953.0,134653.0,135593.0,135613.0,136888.0,138440.0,138740.0,138912.0,139319.0,139361.0,139701.0,140076.0,140104.0,140373.0,140922.0,141126.0,142168.0,142202.0,143373.0,145640.0,146230.0,147136.0,147597.0,147752.0,147998.0,148162.0,148781.0,149240.0,149568.0,149624.0,149700.0,150064.0,151621.0,152513.0,152559.0,152790.0,152910.0,153018.0,153028.0,153076.0,153228.0,153324.0,153350.0,153596.0,153830.0,153865.0,154307.0,154480.0,154917.0,155151.0,155411.0,155469.0,155854.0,155858.0,155884.0,157168.0,157480.0,157685.0,158107.0,158294.0,158388.0,158609.0,158813.0,159083.0,159387.0,159678.0,159680.0,160022.0,160068.0,160139.0,160692.0,160884.0,162330.0,163124.0,163629.0,163843.0,164157.0,164393.0,164552.0,164635.0,164887.0,164937.0,165313.0,165515.0,165541.0,165597.0,165779.0,166373.0,166437.0,166900.0,167306.0,167730.0,168412.0,169148.0,169394.0,169624.0,170193.0,171483.0,171761.0,173307.0,173435.0,173591.0,173807.0,173821.0,174079.0,174177.0,175237.0,175305.0,175513.0,175583.0,175689.0,175881.0,175891.0,176235.0,177127.0,177315.0,177347.0,177931.0,178045.0,178775.0,179105.0,180053.0,180435.0,180643.0,180983.0,181663.0,182247.0,183429.0,183573.0,183947.0,184255.0,184755.0,185115.0,185277.0,186189.0,186643.0,187967.0,188833.0,189091.0,189115.0,189333.0,189383.0,190081.0,190383.0,190413.0,190485.0,191753.0,193179.0,193701.0,193839.0,195011.0,195141.0,195245.0,195489.0,195605.0,195687.0,195713.0,195823.0,195993.0,196203.0,196385.0,196575.0,197127.0,197385.0,198057.0,198309.0,198543.0,198977.0,199021.0,199325.0,199706.0,201646.0,201680.0,201712.0,201787.0,202319.0,202333.0,202411.0,203262.0,203300.0,205575.0,205749.0,205771.0,205843.0,206327.0,206739.0,206791.0,206849.0,207501.0,207996.0,208695.0,209351.0,210041.0,210265.0,210829.0,210891.0,211145.0,211430.0,212339.0,212349.0,212715.0,212919.0,213942.0,214088.0,214362.0,214494.0,214544.0,214696.0,215643.0,215655.0,216181.0,216352.0,216442.0,216751.0,217091.0,217294.0,217631.0,218505.0,218941.0,219037.0,219139.0,219278.0,219290.0,220230.0,220276.0,220518.0,220922.0,221222.0,221248.0,221856.0,223240.0,223300.0,223340.0,223742.0,224753.0,225794.0,225866.0,226482.0,226636.0,227096.0,227258.0,227502.0,228777.0,231237.0,231257.0,233203.0,233637.0,233939.0,234999.0,235041.0,235165.0,235265.0,235351.0,235635.0,237746.0,238590.0,239602.0,241176.0,242112.0,242488.0,243600.0,244282.0,244582.0,245262.0,245314.0,249134.0,250824.0,253154.0,257551.0,258173.0,259673.0,259993.0,260289.0,260507.0,260969.0,261569.0,261635.0,262619.0,263503.0,264089.0,265138.0,265572.0,268366.0,268436.0,269726.0,270916.0,271258.0,271891.0,272573.0,272613.0,272663.0,274581.0,274671.0,274781.0,275147.0,275193.0,275491.0,275495.0,275559.0,275857.0,278166.0,279268.0,279360.0,280186.0,280428.0,280498.0,280944.0,281156.0,281506.0,281860.0,282489.0,282527.0,282555.0,282921.0,283097.0,283487.0,283597.0,284093.0,284423.0,286377.0,288691.0,289077.0,289351.0,289747.0,290135.0,290868.0,291280.0,292389.0]},"kind":"numeric","n":87585,"n_null":0,"n_unique":87585,"null_rate":0.0,"stats":{"iqr":100546.0,"kurtosis":-0.5774915128949369,"max":292757.0,"mean":157651.3655192099,"median":165741.0,"min":1.0,"n_outliers":0,"outlier_rate":0.0,"q1":112657.0,"q3":213203.0,"skew":-0.39139923474865146,"std":79013.40209904632,"zero_rate":0.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=+2.24"},{"code":"outliers","level":"warn","message":"8.6% rows beyond 1.5 IQR"}],"column":"imdbId","extras":{"histogram":{"counts":[44057,7224,6540,3749,3128,2659,2286,2278,2216,1712,1536,1290,1232,839,1095,930,678,601,674,572,531,391,156,96,79,83,56,120,85,173,135,58,55,36,18,15,65,59,52,26],"edges":[1.0,727028.425,1454055.85,2181083.2750000004,2908110.7,3635138.125,4362165.550000001,5089192.975000001,5816220.4,6543247.825,7270275.25,7997302.675000001,8724330.100000001,9451357.525,10178384.950000001,10905412.375,11632439.8,12359467.225000001,13086494.65,13813522.075000001,14540549.5,15267576.925,15994604.350000001,16721631.775,17448659.200000003,18175686.625,18902714.05,19629741.475,20356768.900000002,21083796.325000003,21810823.75,22537851.175,23264878.6,23991906.025000002,24718933.450000003,25445960.875,26172988.3,26900015.725,27627043.150000002,28354070.575000003,29081098.0]},"sample":[107151.0,109120.0,112257.0,115783.0,71315.0,119468.0,123953.0,116379.0,87298.0,95497.0,86423.0,97757.0,102469.0,47573.0,57449.0,140397.0,67656.0,86969.0,69704.0,82945.0,104409.0,219699.0,120202.0,80934.0,310793.0,322802.0,101748.0,61610.0,284262.0,105211.0,90563.0,222812.0,303348.0,62229.0,180303.0,31047.0,48308.0,94331.0,297753.0,86873.0,40491.0,55572.0,368658.0,299863.0,327919.0,33945.0,40919.0,110612.0,311361.0,319758.0,418038.0,279037.0,408664.0,436727.0,427312.0,388125.0,69005.0,358273.0,424942.0,393685.0,410297.0,381690.0,436262.0,24916.0,457655.0,19071.0,446013.0,432290.0,443649.0,416044.0,85764.0,82313.0,855895.0,478090.0,414426.0,988047.0,1179891.0,79168.0,361748.0,847877.0,1278340.0,60358.0,68498.0,57207.0,114432.0,368226.0,1433540.0,1445202.0,23241.0,884762.0,62277.0,1328867.0,23753.0,1247184.0,1376709.0,33389.0,175934.0,1217637.0,13158.0,26121.0,1379222.0,55872.0,128170.0,46432.0,190882.0,1656170.0,482857.0,58266.0,2104994.0,1484521.0,1905041.0,1291580.0,1625350.0,31143.0,2512204.0,1928340.0,1833888.0,2572632.0,446463.0,1490017.0,56628.0,2008693.0,98492.0,1371150.0,800367.0,470995.0,1430811.0,2451742.0,109678.0,2788710.0,42410.0,3096712.0,1307926.0,49500.0,78843.0,43040.0,865521.0,1520453.0,55429.0,68902.0,53275.0,431265.0,19571.0,108159.0,39178.0,67162.0,26534.0,99248.0,84914.0,42035.0,1947964.0,3626442.0,1118665.0,1828124.0,1401643.0,72662.0,1425253.0,80401.0,40670.0,72007.0,72595.0,2636124.0,1286151.0,147926.0,70170.0,68005.0,67446.0,81233.0,2483260.0,79019.0,2979638.0,3626436.0,31417.0,1543017.0,349333.0,1754000.0,1633989.0,2491500.0,2544472.0,89811.0,2940482.0,1198333.0,2402701.0,1547638.0,3202374.0,147995.0,195621.0,875695.0,2452384.0,1954780.0,1228963.0,38306.0,116763.0,103168.0,2788526.0,4119052.0,48971.0,2664880.0,2966934.0,48981.0,4419390.0,3358470.0,2139855.0,272087.0,4000936.0,325849.0,57558.0,38091.0,302525.0,106372.0,451983.0,103132.0,390005.0,114445.0,120547.0,151372.0,4400028.0,279783.0,39812.0,3619854.0,2190193.0,2170369.0,2216212.0,27814.0,306836.0,1591138.0,79191.0,52818.0,188794.0,43932.0,3651804.0,464071.0,77278.0,353671.0,2567026.0,2169322.0,118683.0,123368.0,2938464.0,39490.0,67806.0,4483220.0,2573806.0,4483460.0,99255.0,3581436.0,66818.0,3165636.0,1315058.0,5374830.0,1570387.0,2948566.0,2043801.0,2534648.0,5213744.0,399048.0,1519633.0,1825130.0,53899.0,6039284.0,5156940.0,2327519.0,39893.0,4482938.0,1262877.0,1897941.0,5538568.0,3864466.0,162212.0,266791.0,6710658.0,4464394.0,454914.0,143353.0,171869.0,72382.0,280035.0,327809.0,271527.0,5475022.0,6340296.0,5778384.0,3492714.0,5028892.0,113971.0,457437.0,465711.0,6417144.0,34527.0,209191.0,3630800.0,65600.0,3416674.0,4835618.0,1139592.0,87301.0,469093.0,3605266.0,21151.0,100303.0,1720621.0,4493080.0,6978288.0,6010630.0,85345.0,25592.0,89233.0,6514342.0,1819601.0,1318517.0,3303310.0,7375578.0,4912910.0,198332.0,64609.0,140808.0,435312.0,69990.0,4173442.0,349776.0,101327.0,61785.0,2243597.0,7571992.0,93896.0,6504868.0,3148576.0,117080.0,5639446.0,2990140.0,90678.0,2372461.0,216986.0,2141717.0,8108034.0,8426964.0,101956.0,142826.0,95246.0,5628332.0,8611750.0,3662778.0,13.0,8772262.0,3390582.0,3446330.0,4382376.0,6733368.0,7422552.0,4636022.0,133735.0,104509.0,7058080.0,6302006.0,176734.0,1449854.0,114344.0,7321356.0,37634.0,9749604.0,6208032.0,6446550.0,63769.0,7124092.0,11136630.0,10922658.0,6328242.0,7590074.0,4694594.0,7142506.0,7279250.0,7066546.0,83061.0,222320.0,2364673.0,11968448.0,5822690.0,8951692.0,9174334.0,6225534.0,7139378.0,4650414.0,8890158.0,194297.0,11490170.0,2028457.0,6185692.0,6713802.0,5523672.0,7336182.0,5584782.0,89229.0,7334158.0,9011130.0,1003004.0,242686.0,58558.0,8160834.0,10003008.0,9113332.0,192482.0,8717446.0,8945942.0,3766366.0,9129362.0,1738.0,9029572.0,11827806.0,11812338.0,483370.0,5659996.0,838241.0,10539608.0,4223932.0,82986.0,193832.0,3914684.0,368575.0,4177856.0,11929008.0,11572530.0,5973514.0,4682198.0,385635.0,110864.0,1381557.0,354408.0,3398738.0,758747.0,7216068.0,26774.0,76281.0,8328072.0,418020.0,8413040.0,10914182.0,7628846.0,6178388.0,14091792.0,4372736.0,8165192.0,10801496.0,102533.0,13809646.0,1285304.0,2040366.0,46005.0,12478496.0,88115.0,70005.0,225583.0,17886.0,69469.0,12223548.0,11127056.0,955411.0,2198161.0,23092.0,13073374.0,15106860.0,114056.0,11997258.0,3706352.0,8569206.0,14479746.0,66175.0,40110.0,15109082.0,23237.0,26510.0,14174940.0,7790254.0,21283348.0,10345782.0,438867.0,109858.0,19113302.0,3582.0,4878714.0,3978144.0,1589484.0,14163772.0,133334.0,11296142.0,23629716.0,26260504.0,15486810.0,790822.0,76911.0,21338696.0,2730046.0,486731.0,11987416.0,77428.0,44147.0,11151916.0,28199975.0,11038592.0,6295106.0,1621766.0]},"kind":"numeric","n":87585,"n_null":0,"n_unique":87585,"null_rate":0.0,"stats":{"iqr":3782654.0,"kurtosis":5.857414785329954,"max":29081098.0,"mean":2792839.5607467033,"median":492996.0,"min":1.0,"n_outliers":7575,"outlier_rate":0.08648741222812126,"q1":94642.0,"q3":3877296.0,"skew":2.2429025065022983,"std":4278865.870527586,"zero_rate":0.0}},{"alerts":[],"column":"tmdbId","extras":{"histogram":{"counts":[13785,12892,8691,5333,4232,3219,2874,2446,2936,2854,2029,2342,2233,2131,2112,2038,1694,1579,1258,1452,1212,921,939,534,715,670,684,529,532,483,340,404,322,287,262,166,129,83,82,37],"edges":[2.0,29660.375,59318.75,88977.125,118635.5,148293.875,177952.25,207610.625,237269.0,266927.375,296585.75,326244.125,355902.5,385560.875,415219.25,444877.625,474536.0,504194.375,533852.75,563511.125,593169.5,622827.875,652486.25,682144.625,711803.0,741461.375,771119.75,800778.125,830436.5,860094.875,889753.25,919411.625,949070.0,978728.375,1008386.75,1038045.125,1067703.5,1097361.875,1127020.25,1156678.625,1186337.0]},"sample":[10612.0,349394.0,10801.0,253632.0,3063.0,10155.0,9427.0,47452.0,36599.0,10957.0,10340.0,14822.0,26618.0,30197.0,9406.0,5622.0,33015.0,622.0,22178.0,25636.0,34077.0,11973.0,11209.0,39578.0,41324.0,39497.0,10727.0,9045.0,891.0,11986.0,43436.0,102057.0,4377.0,58467.0,26670.0,10829.0,20532.0,80708.0,25783.0,1777.0,26126.0,18671.0,21241.0,33377.0,28333.0,33049.0,800.0,16233.0,23986.0,15271.0,55309.0,16442.0,36851.0,43471.0,17824.0,142.0,68098.0,9005.0,4173.0,19059.0,9697.0,11652.0,46774.0,59500.0,1265.0,7485.0,32627.0,15008.0,15511.0,37300.0,31421.0,14272.0,13079.0,15356.0,13436.0,18539.0,8280.0,27644.0,13119.0,25004.0,23924.0,8284.0,153118.0,94721.0,46886.0,27583.0,34016.0,36419.0,27179.0,20497.0,1789.0,39691.0,41402.0,67232.0,37080.0,40149.0,25770.0,33146.0,39557.0,5937.0,51462.0,407.0,75969.0,76163.0,65754.0,39072.0,244115.0,73700.0,82693.0,127544.0,98248.0,183672.0,115782.0,98568.0,85889.0,158752.0,29600.0,290075.0,79316.0,206822.0,42216.0,185602.0,246869.0,27371.0,112710.0,287495.0,17234.0,242680.0,284293.0,88253.0,315057.0,87101.0,191120.0,44933.0,48594.0,52448.0,142897.0,111577.0,133446.0,113144.0,93892.0,36983.0,133241.0,16356.0,24978.0,82309.0,61095.0,44128.0,43377.0,318359.0,256196.0,34560.0,253851.0,26925.0,56482.0,128145.0,106139.0,253849.0,50714.0,10119.0,112649.0,44570.0,97559.0,79823.0,26113.0,53435.0,164331.0,246654.0,64959.0,280133.0,89857.0,42770.0,160833.0,321109.0,46403.0,46513.0,306825.0,38162.0,59223.0,3602.0,86215.0,40127.0,10270.0,226458.0,284258.0,23331.0,336251.0,23245.0,103028.0,303554.0,156388.0,110261.0,347548.0,254309.0,161620.0,113464.0,224365.0,26571.0,250096.0,363486.0,29389.0,267955.0,276139.0,73468.0,340357.0,82153.0,340881.0,66702.0,31364.0,74903.0,138093.0,128714.0,302436.0,293471.0,122356.0,342686.0,40909.0,187579.0,38553.0,56344.0,77829.0,108000.0,41568.0,41988.0,383535.0,297784.0,271664.0,357125.0,69399.0,31502.0,97844.0,361205.0,174759.0,89868.0,289520.0,376549.0,47138.0,356366.0,377150.0,397003.0,185738.0,123655.0,49037.0,82686.0,155577.0,127236.0,405203.0,98277.0,405627.0,382170.0,37609.0,137608.0,59822.0,61736.0,64501.0,145963.0,208039.0,16766.0,276578.0,353979.0,115903.0,261439.0,417056.0,220653.0,306207.0,361018.0,27231.0,19002.0,194089.0,331641.0,173616.0,195796.0,46588.0,384160.0,445224.0,44449.0,131085.0,51962.0,40544.0,442087.0,390043.0,36885.0,24877.0,65507.0,270910.0,91270.0,96097.0,138242.0,117278.0,99180.0,78201.0,67204.0,461858.0,49921.0,405490.0,151017.0,136467.0,19243.0,484645.0,75194.0,81469.0,35452.0,85155.0,253261.0,410794.0,454286.0,404665.0,63063.0,456337.0,310098.0,28762.0,55323.0,14132.0,518000.0,438679.0,319674.0,210228.0,395053.0,414191.0,173731.0,437926.0,520360.0,30172.0,109815.0,476764.0,451691.0,103043.0,108545.0,132088.0,172716.0,532444.0,522866.0,470121.0,426375.0,412656.0,541716.0,360504.0,236601.0,431602.0,572710.0,444697.0,424249.0,11116.0,553645.0,543917.0,477518.0,175362.0,592136.0,314629.0,592800.0,606215.0,338464.0,282761.0,496053.0,50048.0,477428.0,503088.0,265641.0,255929.0,67842.0,55634.0,515362.0,294644.0,52425.0,560014.0,578399.0,468996.0,554294.0,638164.0,584897.0,283984.0,647325.0,269732.0,189576.0,24328.0,125708.0,582681.0,549590.0,462604.0,334933.0,578908.0,397512.0,518596.0,164283.0,592938.0,188541.0,706249.0,398626.0,110110.0,82180.0,406454.0,601452.0,687972.0,477408.0,613842.0,637860.0,623184.0,342091.0,75493.0,721335.0,675554.0,77421.0,667154.0,530578.0,675568.0,119317.0,185651.0,605193.0,746817.0,226860.0,533713.0,145115.0,37444.0,430364.0,667869.0,668176.0,728143.0,46100.0,621758.0,331983.0,126786.0,491731.0,170675.0,674865.0,722913.0,514236.0,651680.0,17228.0,50538.0,180988.0,654795.0,155331.0,204763.0,91892.0,57581.0,103461.0,712071.0,533514.0,605680.0,549358.0,795843.0,847357.0,870352.0,864665.0,40801.0,789988.0,114509.0,175535.0,702694.0,166709.0,189908.0,734322.0,465959.0,788396.0,891708.0,874954.0,142872.0,785210.0,113254.0,799876.0,59127.0,72765.0,97527.0,852902.0,356029.0,51932.0,612381.0,877826.0,90546.0,722624.0,25372.0,846801.0,561167.0,242612.0,968867.0,772973.0,1013860.0,136785.0,107289.0,580897.0,1046991.0,838609.0,1043559.0,1029578.0,739405.0,606893.0,1054831.0,278769.0,40482.0,137509.0,329700.0,593014.0,1147612.0,330045.0,362772.0,942894.0,835365.0,785302.0,437516.0,1168261.0]},"kind":"numeric","n":87585,"n_null":124,"n_unique":87425,"null_rate":0.0014157675401038992,"stats":{"iqr":334857.0,"kurtosis":0.9079110098625924,"max":1186337.0,"mean":241382.280422131,"median":139272.0,"min":2.0,"n_outliers":2200,"outlier_rate":0.02515406867060747,"q1":46836.0,"q3":381693.0,"skew":1.2543330371912316,"std":247146.66704343288,"zero_rate":0.0}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","columns.imdbId.stats.skew","columns.imdbId.stats.outlier_rate","columns.imdbId.stats.max","columns.tmdbId.stats.skew","columns.tmdbId.null_rate","columns.movieId.stats.max","columns.movieId.stats.skew"],"featured_charts":[{"caption":"Heavy right skew and a long tail up to ~29M \u2014 most IDs cluster well below the mean.","column":"imdbId","kind":"histogram"},{"caption":"Moderately right-skewed distribution of TMDB IDs, with values concentrated under 400K.","column":"tmdbId","kind":"histogram"},{"caption":"MovieLens IDs spread fairly evenly across the range, slightly weighted toward higher values.","column":"movieId","kind":"histogram"}],"model":"anthropic:claude-opus-4-7","narrative":"This is a movie ID linkage table with 87,585 rows and 3 numeric identifier columns: imdbId, tmdbId, and movieId. As expected for ID columns, movieId and imdbId are unique per row, while tmdbId is nearly unique with a tiny null rate (0.0014). The most notable shape is imdbId, which is heavily right-skewed (skew 2.24) with about 8.6% flagged as outliers \u2014 reflecting how IMDb IDs span a huge range from 1 up to ~29M. tmdbId is also right-skewed but more moderately, while movieId is distributed fairly evenly up to 292,757. There's little analytical signal here beyond confirming the file is a clean ID crosswalk.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.skew","stats.zero_rate"],"model":"anthropic:claude-opus-4-7","narrative":"movieId is a fully unique integer key spanning 1 to 292,757 across all 87,585 rows with no nulls or zeros, consistent with an external catalogue identifier rather than a dense surrogate index. The range far exceeds the row count, indicating gaps in the ID space (likely a sparse catalogue like MovieLens). Distribution stats (mean 157,651, median 165,741, skew -0.39) are artefacts of the ID assignment and carry no analytical meaning.","role":"identifier","scope":"column","target":"movieId","treatment":"Use as a join key to movie metadata; exclude from modelling features."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","min","max","skew","n_outliers"],"model":"anthropic:claude-opus-4-7","narrative":"This is the IMDb title identifier: all 87,585 rows are unique with no nulls, matching the row count exactly. Although flagged as skewed (2.24) with 7,575 outliers, that's expected since IMDb IDs are issued sequentially over time and span 1 to 29,081,098. The distribution shape is an artifact of ID assignment, not a meaningful numeric signal.","role":"identifier","scope":"column","target":"imdbId","treatment":"Treat as a key for joins to IMDb metadata; do not use as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","min","max","skew"],"model":"anthropic:claude-opus-4-7","narrative":"This is almost certainly the TMDB movie/title identifier used for joins to The Movie Database. With 87,425 unique values across 87,585 rows and a null rate of 0.0014, it behaves as a near-unique key rather than a modelling feature, despite its numeric stats showing a wide range (2 to 1,186,337) and right skew (1.25).","role":"foreign_key","scope":"column","target":"tmdbId","treatment":"left-join on this id; do not use as a numeric feature."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":1316,"prompt_tokens":3410,"total_tokens":4726}},"language_counts":{},"meta":{"generated_at":"2026-05-01T18:07:15+00:00","mode":"full","row_count":87585,"sampled_rows":87585,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/entertainment/movies/ml-32m/links.csv"},"notes":[],"saturn_version":"0.2.0","schema":{"imdbId":"numeric","movieId":"numeric","tmdbId":"numeric"}}