{"columns":[{"alerts":[{"code":"allcaps","level":"info","message":"25.3% rows are all-caps"}],"column":"name","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[38,93,586,173,320,194,613,273,395,199,411,1001,412,2593,964,91,106,48,74,30,22,45,15,20,3,13,7,7,3,6,1,10,1,1,3,2,0,1,0,2],"edges":[1.0,2.475,3.95,5.425000000000001,6.9,8.375,9.850000000000001,11.325000000000001,12.8,14.275,15.75,17.225,18.700000000000003,20.175,21.650000000000002,23.125,24.6,26.075000000000003,27.55,29.025000000000002,30.5,31.975,33.45,34.925000000000004,36.400000000000006,37.875,39.35,40.825,42.300000000000004,43.775000000000006,45.25,46.725,48.2,49.675000000000004,51.150000000000006,52.625,54.1,55.575,57.050000000000004,58.525000000000006,60.0]},"near_unique":false,"sample":["Sapphire Pool","Resort","Hot_Spring 1314069995","Seismograph Pool","\u0411\u0430\u0437\u043e\u0432\u0430 \u0442\u043e\u0447\u043a\u0430","Hot_Spring 1332652552","Hot_Spring 10157173617","Hot_Spring 1317055945","Hot_Spring 1313849084","\u0413\u043e\u0440\u044f\u0447\u0438\u0439 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a \u041a\u044b\u043d\u0434\u044b\u0433-1","Hot_Spring 12193166087","Termales N\u00e1poles","\u0627\u0645\u064a\u0631\u0627\u0644\u062f \u0627\u0644\u062c\u062f\u064a\u062f\u0647","Wallender Born","Hot_Spring 8455150341","Hot_Spring 7319935590","\u041a\u0430\u043b\u044c\u043c\u0430\u0440","Hot_Spring 1313849196","Hot_Spring 1349329884","Hot_Spring 9752915525","\u4e8c\u865f\u4e95","Jean Batten Geyser","\u5927\u6cb9\u5751\u6eab\u6cc9","Hot_Spring 4690487490","Hot_Spring 12329037115","Tire Pool","86","\u0639\u062f\u0648\u0627\u0646 \u060c \u0642\u0645\u0629","Hammam Kiria","Hot_Spring 1332652559","Geyser 12259690981","Hot_Spring 12260907856","Hot_Spring 12260907847","\u0622\u0628\u06af\u0631\u0645 \u0645\u0646\u0634\u06af\u0647","\u0421\u0430\u043d\u0435\u043f\u0456\u0434\u0435\u043c\u0441\u0442\u0430\u043d\u0446\u0456\u044f","\u0627\u0645 \u0627\u0644\u0647\u0634\u064a\u0645","Hot_Spring 1324924199","skid451","3117 \u062d\u0631\u064a\u0629 \u0645\u0642\u0627\u0628\u0644 \u0627\u0644\u0645\u0644\u0639\u0628","\u0412\u0435\u0440\u0445\u043d\u0435-\u041a\u043e\u0448\u0435\u043b\u0435\u0432\u0441\u043a\u0438\u0435 \u043f\u0430\u0440\u043e\u0433\u0438\u0434\u0440\u043e\u0442\u0435\u0440\u043c\u0430\u043b\u044c\u043d\u044b\u0435 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438","Hot_Spring 1288732757","East Mustard Spring","\u0633\u0643\u0629 \u0627\u0644\u0642\u0637\u0627\u0631 \u0627\u0644\u062d\u062f\u064a\u062f","Variable Spring","Hot_Spring 1331849969","Hot_Spring 1332652616","\u0627\u0645\u0631\u0642 \u064a\u0648\u0645 \u0627\u0644\u0627\u062d\u062f \u0639\u0644\u064a\u0647 \u0627\u0643\u064a\u062f","Sulfur Springs","Aguas Calientes","Hot_Spring 1316828168"],"top_values":[["\u0637\u0631\u064a\u0642 \u0627\u0644\u0631\u0648\u064a\u0643",40],["Hot Spring",15],["\u0645\u062d\u0644",14],["\u064a\u0645\u064a\u0646",11],["Hot Springs",9],["Aguas Termales",9],["Thermo Hot Springs",9],["Terra Cotta Geysers",7],["Buhar \u00c7\u0131k\u0131\u015f\u0131",7],["\u0627\u0644\u0645\u0646\u0632\u0644",6],["Fumarole",6],["\u064a\u0633\u0627\u0631",6],["\u0627\u0633\u0628\u0648\u0639 \u0627\u0644\u062c\u0627\u064a",6],["\u062a\u0627\u062c\u0631 \u062c\u0645\u0644\u0629",6],["\u0422\u0435\u0440\u043c\u0430\u043b\u044c\u043d\u044b\u0435 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438",5],["\u0633\u064a\u0637\u0631\u0629 \u0627\u0645\u0646\u064a\u0647",5],["\u0634\u0627\u0631\u0639 \u0627\u0644\u0645\u0639\u0634",5],["\u0622\u0628\u06af\u0631\u0645",5],["\u6eab\u6cc9\u9732\u982d",5],["Olympic Hot Springs",4]],"top_words":[["hot_spring",3393],["geyser",1083],["hot",295],["spring",240],["springs",216],["de",126],["pool",85],["termales",79],["\u0637\u0631\u064a\u0642",65],["termas",62],["\u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438",62],["\u0627\u0628\u0648",55],["\u0645\u062d\u0644",55],["\u0627\u0644\u0649",55],["aguas",54],["\u0627\u0644\u0631\u0648\u064a\u0643",40],["\u0634\u0627\u0631\u0639",37],["\u0633\u064a\u0637\u0631\u0629",36],["\u062c\u0633\u0631",31],["\u0645\u0643\u0627\u0646",31],["\u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a",30],["\u062d\u064a",30],["\u0639\u0644\u064a",28],["\u0442\u0435\u0440\u043c\u0430\u043b\u044c\u043d\u044b\u0435",28],["\u064a\u0633\u0627\u0631",28]],"vocab_skipped":null,"word_histogram":{"counts":[1323,0,0,5813,0,0,937,0,0,477,0,0,131,0,0,58,0,0,22,0,0,6,0,0,6,0,0,1,0,2],"edges":[1.0,1.3333333333333333,1.6666666666666665,2.0,2.333333333333333,2.6666666666666665,3.0,3.333333333333333,3.6666666666666665,4.0,4.333333333333333,4.666666666666666,5.0,5.333333333333333,5.666666666666666,6.0,6.333333333333333,6.666666666666666,7.0,7.333333333333333,7.666666666666666,8.0,8.333333333333332,8.666666666666666,9.0,9.333333333333332,9.666666666666666,10.0,10.333333333333332,10.666666666666666,11.0]}},"kind":"text","n":8776,"n_null":0,"n_unique":8316,"null_rate":0.0,"stats":{"allcaps_rate":0.25250683682771197,"boilerplate_rate":0.0,"duplicate_rate":0.05241567912488605,"emoji_rate":0.0,"len_max":60,"len_mean":17.099247948951685,"len_median":19.0,"len_min":1,"len_p95":24.0,"n_duplicates":460,"n_empty":0,"one_word_rate":0.15075205104831357,"readability_flesch_mean":101.58795000000002,"url_rate":0.0,"vocab_size":9610,"word_mean":2.160323609845032,"word_median":2.0}},{"alerts":[{"code":"high_skew","level":"info","message":"skew=-2.36"},{"code":"outliers","level":"warn","message":"10.1% rows beyond 1.5 IQR"}],"column":"lat","extras":{"histogram":{"counts":[1,0,0,23,30,132,24,9,14,10,55,104,20,13,29,14,25,35,32,35,63,88,276,82,134,100,298,997,1011,438,597,3559,117,105,101,30,9,88,75,3],"edges":[-54.6773309,-51.5363793375,-48.395427775,-45.2544762125,-42.11352465,-38.9725730875,-35.831621525,-32.690669962499996,-29.5497184,-26.4087668375,-23.267815275,-20.126863712499997,-16.985912149999997,-13.844960587499997,-10.704009024999998,-7.563057462499998,-4.422105899999998,-1.2811543374999985,1.8597972250000012,5.000748787500001,8.14170035,11.2826519125,14.423603475000007,17.5645550375,20.705506600000007,23.8464581625,26.987409725000006,30.1283612875,33.269312850000006,36.4102644125,39.551215975000005,42.6921675375,45.833119100000005,48.97407066250001,52.115022225000004,55.25597378750001,58.396925350000004,61.53787691250001,64.678828475,67.81978003750001,70.9607316]},"sample":[44.5316132,44.2418802,44.7379953,44.6998969,44.7054909,48.7634039,49.0201911,40.4374198,40.438286,-36.9042439,-38.3104572,-42.7443016,-42.8018693,44.7228864,17.0372339,28.3607173,9.8149271,35.9834655,-39.7391884,40.2448906,46.1979781,0.6206664,65.6413806,33.2229602,32.7416569,10.4782926,64.0586099,43.3506013,44.4645031,44.472933,44.4718875,44.4682856,44.416312,44.7243031,48.0931251,-17.6656942,44.7220753,44.7208025,44.7218858,52.04187,42.81842,34.17544,45.0835359,41.8210741,33.8645684,39.8326186,40.8271455,-17.2326272,33.0935084,37.6475756,-28.0230092,-2.4993168,-8.4300833,-18.099106,-39.2278964,21.45581,64.86507,64.8654019,64.8650591,65.8866939,35.9925066,0.0048011,38.1340171,25.3169388,31.3437463,31.3592053,31.2797799,31.5477707,33.7307023,66.1871161,23.1230783,25.1691384,18.4110681,49.0333386,37.7019189,44.1779671,37.8674367,14.8137741,44.4831122,45.241586,31.3979009,32.9266209,29.9849023,12.3709455,34.4307706,30.1480286,27.0366459,-40.4955341,32.1821643,32.0616333,36.6174165,-8.238965,31.6010927,31.4667854,49.7629376,41.9947525,-18.0997204,29.8647845,30.0653062,33.0798187,33.1553582,33.1630859,33.1706435,32.9590558,33.2064645,32.9718968,33.1530829,33.1498235,36.3219115,-8.8812975,34.6020453,36.4106003,15.5513456,32.5871961,64.8320847,32.744961,32.4093414,63.7451876,38.246669,32.1360756,39.7902624,14.7528018,37.0140581,31.2665225,30.4519784,32.4770982,15.3549891,32.0991727,31.444363,37.6133784,31.9885866,33.482119,29.9783413,29.9792171,37.6482885,34.93551,34.9330185,34.8860456,34.8833214,35.3637591,35.0590488,35.0717232,34.8072792,35.069409,35.1359245,35.0630296,34.8414855,34.8146868,35.0704633,32.3590767,34.9431265,32.0568312,13.5061597,32.538409,32.7596338,46.1868396,39.3123657,39.313478,39.3137104,35.4423258,40.1910609,40.1921346,36.232102,41.3762284,41.359344,50.1645647,35.0998837,13.4519791,36.5185488,35.1311751,35.1127875,35.1280001,36.6225844,29.0484173,31.4109853,-22.4509428,-22.4294142,35.1229757,-38.1327396,-38.142908,13.2720376,32.3852938,41.5914032,43.0808857,40.0959589,10.7396879,34.7308726,-25.2810556,15.6533943,40.7388884,38.0379432,37.195582,38.2168232,43.6212434,30.4037787,33.4689033,23.7387731,42.364234,15.8819689,39.8174282,15.8103002,32.7910846,35.6236427,44.3547343,53.5121574,49.375746,49.379186,34.4331503,36.9549756,15.8728338,29.991026,35.4724177,33.3316434,39.9411905,30.3821102,29.0950287,49.1333227,29.2034194,29.8947566,30.5316842,33.3594554,35.5485478,32.5489181,20.1824089,36.1798293,45.0419527,33.4306265,36.3554711,22.8844217,40.8152966,39.8403791,36.0903871,36.0613082,36.0444729,32.6238634,28.9215238,28.7783534,28.8007972,28.8052002,28.7558058,31.8548074,41.0538987,35.6295097,31.2092362,28.5827922,33.3415264,40.29241,44.7535406,-38.4802322,31.1763242,43.0024119,35.8098642,40.3679387,40.3664484,33.4600531,19.5528895,52.5045982,34.7749415,38.1720603,33.0539779,31.0081046,31.3886848,36.1551806,14.2831396,33.222941,48.8697049,51.361232,-38.0401149,28.8336205,37.5209692,9.8942785,42.3656212,42.5784736,8.7523308,35.752352,44.0922247,35.1589876,56.7183394,-4.8012097,28.8325196,29.1795133,44.5431414,33.2587423,44.520425,-16.6552742,44.7434027,44.6849588,-39.8231749,44.4187591,44.4306623,44.4330515,44.4327948,44.4328392,44.4328587,44.5518831,44.4599382,44.4649142,44.4165833,44.4005759,44.3520718,44.349022,44.3493565,40.9721268,44.6217255,44.6253149,44.628402,44.7029364,44.7032315,44.46279,44.4637772,44.4675156,44.4801888,44.4846882,44.461568,44.4626568,44.4636384,44.6507729,44.4586547,44.4604746,44.5145456,44.4641991,44.5213966,44.5215114,44.5252809,44.5355067,44.534914,44.539938,44.539753,44.5395298,44.5394265,44.5396527,44.5515053,44.551515,44.5504833,44.5498764,44.5546371,66.1869594,44.5545322,44.5542459,44.5547128,44.5574504,44.5650905,44.5640627,44.5653746,44.5511195,44.5552644,44.5571277,44.5577584,44.5572372,44.5572943,44.555616,44.5612287,44.3515813,44.3535429,44.3537419,44.3545531,44.3554109,44.354873,44.3557267,44.4164021,44.4167322,44.4160055,32.8878613,44.3543772,-0.8402714,45.7909353,24.0190385,35.1406781,16.092385,24.650131,36.8708332,36.6215385,11.4539052,40.4416224,38.6333126,31.2905658,16.4343011,44.5667577,22.691892,37.618842,40.4349607,51.9767752,38.4041709,19.4364526,19.4640904,64.9607697,56.9355358,24.9993843,36.9744986,28.6424629,43.5631247,51.5912112,38.9316027,44.5151305,-37.0308486,40.5594186,43.3295361,-22.3419362,44.4750628,-22.429186,-1.9882002,14.6800809,44.7810116,14.237197,39.4391413,37.2658876,38.7783789,10.4886326,10.4883561,-1.5120536,39.4930465,44.8465701,38.2653371,23.0419343,23.0440252,13.9154014,29.4460375,44.4182377,44.3505452,44.7434042,44.7428831,44.4158113,22.9916643,23.0766595,44.4205845,44.4301155,44.4310171,44.4318797,44.4332993,44.4326512,44.4341797,44.556182,44.7316326,44.7324634,44.5723452,44.5737959,44.5545128,44.5541382,44.48449,44.4845112,44.4811658,44.4810484,44.4811754,44.4804531,44.4801119,44.4797772,44.522691,44.5171141,44.5224252,44.4586589,44.4647395,44.402878,44.3526256,44.3490266,44.6080959,44.624091,44.6238046,44.6547589,44.6550976,44.6529863,44.7149732,44.3562752,44.3549368,44.4693695,44.4755428,42.2216789,44.5356318,44.5343309,44.5332678,44.5325127,44.5494199,44.5499654,44.5510718,64.373749,44.5653236,44.562051,44.5511069,44.5468345,44.550837,44.5537663,44.5540108,44.5406496,44.556924,44.5569512,44.55708,44.5570116,44.5569874,44.5563849,44.5599311,44.5613968,44.5611167,44.5577919,44.5425263,44.7286005,44.5492459,44.5498579,23.5677527,43.8583757,-32.0268372,45.3687568]},"kind":"numeric","n":8776,"n_null":0,"n_unique":8758,"null_rate":0.0,"stats":{"iqr":12.220910525,"kurtosis":6.276551705009451,"max":70.9607316,"mean":34.774681165462624,"median":40.8604357,"min":-54.6773309,"n_outliers":889,"outlier_rate":0.10129899726526892,"q1":32.311357924999996,"q3":44.53226845,"skew":-2.3597810236228987,"std":18.124532403926153,"zero_rate":0.0}},{"alerts":[],"column":"lon","extras":{"histogram":{"counts":[4,2,2,3,2,18,403,3413,23,24,58,158,193,11,5,0,7,154,122,68,102,203,374,637,1145,325,48,43,114,26,99,181,45,190,80,234,41,83,5,131],"edges":[-176.6303353,-167.7306050175,-158.830874735,-149.9311444525,-141.03141417,-132.1316838875,-123.23195360500002,-114.33222332250001,-105.43249304000001,-96.53276275750001,-87.63303247500001,-78.7333021925,-69.83357191000002,-60.933841627500016,-52.034111345000014,-43.13438106250001,-34.23465078000001,-25.334920497500008,-16.435190215000006,-7.535459932500004,1.3642703499999982,10.2640006325,19.163730915000002,28.063461197500004,36.96319147999998,45.86292176249998,54.76265204499998,63.662382327499984,72.56211260999999,81.46184289249999,90.36157317499999,99.26130345749999,108.16103374,117.0607640225,125.960494305,134.8602245875,143.75995487,152.6596851525,161.559415435,170.4591457175,179.358876]},"sample":[-110.8733377,-110.7243769,-110.3268637,-110.684055,-110.7074311,8.2426254,18.6897985,-121.4054103,-121.4088551,-71.3574211,176.3212023,172.0584292,171.7069274,-110.7069447,42.9894858,83.9599485,80.0112236,-114.748019,-71.845354,20.4328264,8.5398758,-77.9520639,-16.808333,78.3149559,130.2621806,-84.6728237,-21.2323209,51.3375956,-110.8303587,-110.8422066,-110.8417547,-110.8380234,-110.5714389,-110.7056092,7.6785997,145.2396037,-110.7041989,-110.7077195,-110.7073265,143.0894818,41.379122,131.0716135,147.9887358,41.7984268,135.8881943,22.7860217,14.1419596,-69.8627112,9.7658201,-118.8080444,-69.1831533,-79.0517056,116.54096,-69.0284264,-71.6565419,104.3824861,-19.5590551,-19.5576139,-19.5603714,-17.30847,139.0837636,100.2004089,-107.735277,55.4231428,34.3552752,34.3513742,34.29483,34.4688708,44.6026612,-21.8762547,120.8273334,100.3221021,109.7287975,93.4794626,-108.0311774,145.3122244,72.6176166,49.8301904,-110.8503532,148.0125248,45.2028069,44.7805063,31.3116985,123.2411981,5.0605883,46.1614688,14.419525,-72.1605044,35.0561683,-7.5759271,38.138319,115.4065704,44.2518503,43.9587812,24.0576019,79.078855,-69.0281944,47.8613346,31.2453296,44.2161496,44.06824,44.2521892,43.9887225,44.443953,44.131699,44.4667378,44.0812498,44.0759593,43.1937303,13.3360802,43.6754051,43.1550004,45.4366838,44.0557924,-22.31587,22.6577997,35.28572,73.5786497,-119.2051258,44.9651305,-118.070144,101.5082979,43.819575,45.1059605,46.3295566,45.5176103,43.2937697,44.3148323,45.8287433,140.0602354,44.3740444,126.6335914,31.3230157,31.3207001,-118.8754516,36.4578065,36.3775671,36.4301347,36.4335546,36.3897377,36.341711,36.3371335,36.5280178,36.3381996,36.329523,36.338335,36.5379548,36.475433,36.3360638,44.6738359,36.4109769,44.3388717,120.9708853,44.3335175,44.6155481,7.4160981,-117.5515799,-117.5497667,-117.5496273,2.9071829,-117.1071612,-117.1055304,36.7896271,-119.1831931,-119.2245066,30.052238,36.7581826,-16.6686324,136.6200316,36.7365325,36.7684509,36.7712053,138.598208,21.2685457,46.1700596,-67.0342259,-67.0428465,36.7632455,176.245568,176.2602169,45.1338362,15.1570613,19.7135067,11.3009863,20.6784279,-85.3471368,36.7130273,-57.609965,104.119856,-8.0932917,-1.426305,50.0254698,139.4395924,25.3005493,47.6854861,-7.9667892,121.0883782,11.8866196,45.6450964,45.6363944,103.763294,95.6167362,138.356682,-110.7984228,50.1584129,32.8400252,32.8415001,41.2252944,139.7794482,45.9531038,100.2194003,137.7925268,44.3734912,-116.6825406,45.3221391,46.16425,19.4195976,44.7644758,43.9866404,44.5202496,44.3283727,45.4150641,4.7460111,-87.5173588,44.0234009,147.9378702,44.3945634,43.0546217,120.6653394,-0.3384645,45.6661403,41.5103486,41.4704928,41.5414401,44.0485776,19.7912447,19.8165492,19.8339825,19.8314676,19.8285251,35.4579596,-117.090349,45.947038,45.550604,83.3883115,44.3671792,-116.0551554,-110.7252556,176.1478397,101.1736743,141.7246688,137.2410025,-117.325531,-117.3248707,-7.6471276,-99.1366379,158.1662051,36.3407321,-113.2047857,44.3712807,46.2942397,46.1470658,44.1090847,99.8961118,44.3717916,2.7763386,156.7221877,-71.2244417,19.7489629,41.8460657,98.6413362,42.1953119,76.7518753,-70.9592881,140.4025994,-116.050601,129.1600762,159.8672694,55.5232351,19.8327638,-102.9955912,-110.7963663,44.3339419,-110.8302021,179.358876,-110.7472959,-110.7541066,-71.6363056,-110.5723599,-110.5796962,-110.5825578,-110.5834615,-110.5832702,-110.5827695,-110.8089796,-110.8343102,-110.8306518,-110.8110457,-110.814128,-110.7988687,-110.7940166,-110.794096,21.9131592,-110.4337231,-110.434678,-110.4332591,-110.383713,-110.384498,-110.8280613,-110.8280831,-110.8384794,-110.8515941,-110.8517707,-110.8539455,-110.8533069,-110.8543354,-114.7356353,-110.8349589,-110.821756,-110.8340591,-110.8483672,-110.8313256,-110.8322495,-110.8382743,-110.799591,-110.7995362,-110.8015127,-110.8042762,-110.8040284,-110.8034335,-110.8036786,-110.8068216,-110.8082072,-110.809494,-110.8116452,-110.8128513,-21.8752644,-110.8111857,-110.8115147,-110.8127978,-110.8078107,-110.8317528,-110.8318037,-110.8309386,-110.8541488,-110.8300308,-110.8309144,-110.8311096,-110.8325384,-110.8322861,-110.8362269,-110.8331118,-110.7969278,-110.7975437,-110.8010258,-110.8007041,-110.8000733,-110.7981231,-110.7977492,-110.5718549,-110.5724386,-110.5721748,11.714007,-110.8013148,-80.1655,-112.1269673,121.1901167,139.0910712,-89.7977781,121.2050328,138.1766619,138.2786242,-69.3673792,-121.4024502,-112.1078463,100.2498259,120.506476,-110.8716374,121.000499,-119.0734063,-121.3974122,-176.6303353,14.9857411,-70.7595983,-70.7398659,-21.5165506,65.5255583,-13.7790371,72.8834248,83.7845524,-114.7971625,8.1671076,121.5019592,-110.8322002,-71.4074732,-106.84993,-7.7516086,-68.0122092,-110.8435292,-67.7541163,101.3579447,-87.2775873,-121.9767453,40.2995173,32.5048662,-107.0104522,22.7469589,-84.6769066,-84.6767979,-78.4637002,43.6500845,-115.6976335,48.0407384,-80.6159168,-80.6128998,-89.8175088,88.2362294,-110.5724523,-110.8062748,-110.7472984,-110.7454117,-110.5768693,97.7738405,112.4835591,-110.5727747,-110.5794502,-110.5797528,-110.5810405,-110.5818074,-110.5834337,-110.581426,-110.8376606,-110.7071366,-110.7098324,-110.8063889,-110.8080149,-110.8134211,-110.8145199,-110.851972,-110.8521496,-110.8504941,-110.8504777,-110.8513844,-110.8507865,-110.850907,-110.8490049,-110.8126384,-110.8111478,-110.8322826,-110.8349539,-110.839851,-110.8241143,-110.7994031,-110.7941181,-110.4403588,-110.4281869,-110.4282522,-110.4818181,-110.4838003,-110.4821441,-110.4742358,-110.7966285,-110.7983712,-110.8489497,-110.8438736,78.1676287,-110.79714,-110.7992029,-110.7975085,-110.7970692,-110.8526659,-110.8559139,-110.8570832,-21.563846,-110.8322722,-110.8342483,-110.8538949,-110.8110797,-110.8118046,-110.8354034,-110.8351639,-110.8055353,-110.8311468,-110.8315371,-110.8314954,-110.8316043,-110.832356,-110.8336451,-110.8332128,-110.8329656,-110.8353556,-110.841965,-110.8610732,-110.7035891,-110.8520652,-110.8537903,113.7790545,78.4211574,-64.557203,33.7896184]},"kind":"numeric","n":8776,"n_null":0,"n_unique":8747,"null_rate":0.0,"stats":{"iqr":154.9583959,"kurtosis":-1.1794860664096776,"max":179.358876,"mean":-23.99175270700775,"median":-21.228268900000003,"min":-176.6303353,"n_outliers":0,"outlier_rate":0.0,"q1":-110.80898127500001,"q3":44.149414625,"skew":0.4043288997369321,"std":89.39310417462954,"zero_rate":0.0}},{"alerts":[{"code":"long_tail","level":"info","message":"5 singleton categories"},{"code":"null_rate","level":"warn","message":"99.9% null"}],"column":"country","extras":{"singletons":5,"top_values":[["IQ",3],["TW",1],["MX",1],["DE",1],["RU",1],["JP",1]]},"kind":"categorical","n":8776,"n_null":8768,"n_unique":6,"null_rate":0.9990884229717412,"stats":{"cardinality":6,"entropy":2.4056390622295662,"entropy_ratio":0.9306282244165778,"top_rate":0.375,"top_value":"IQ"}},{"alerts":[],"column":"type","extras":{"singletons":0,"top_values":[["hot_spring",7082],["geyser",1694]]},"kind":"categorical","n":8776,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.7077597710716964,"entropy_ratio":0.7077597710716964,"top_rate":0.8069735642661805,"top_value":"hot_spring"}},{"alerts":[{"code":"long_tail","level":"info","message":"44 singleton categories"},{"code":"null_rate","level":"warn","message":"98.3% null"}],"column":"temperature","extras":{"singletons":44,"top_values":[["hot",76],["90",4],["100",4],["21",3],["95",3],["37",2],["43",2],["28",2],["40",2],["42",2],["38",2],["48",2],["37-39\u00b0",1],["35-37 \u00b0C",1],["58\u00b0C",1],["52,1",1],["25-30",1],["98\u00b0C",1],["40-43\u00b0",1],["77",1]]},"kind":"categorical","n":8776,"n_null":8628,"n_unique":56,"null_rate":0.9831358249772105,"stats":{"cardinality":56,"entropy":3.7341002168043596,"entropy_ratio":0.6429950066632626,"top_rate":0.5135135135135135,"top_value":"hot"}},{"alerts":[{"code":"long_tail","level":"info","message":"119 singleton categories"},{"code":"null_rate","level":"warn","message":"98.5% null"}],"column":"wikipedia","extras":{"singletons":119,"top_values":[["en:Olympic Hot Springs",3],["en:Fan and Mortar Geysers",2],["ja:\u9262\u5f62\u99c5",2],["ja:\u7537\u887e\u99c5",2],["ru:\u0414\u0430\u0447\u043d\u044b\u0435 \u0433\u043e\u0440\u044f\u0447\u0438\u0435 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438",2],["is:Geysir",1],["en:Wilbur Hot Springs",1],["en:Morning Glory Pool",1],["en:Giant Geyser",1],["en:Great Fountain Geyser",1],["fr:Echinus Geyser",1],["en:Excelsior Geyser",1],["en:Turquoise Pool",1],["en:Opal Pool",1],["en:Fishing Cone",1],["is:Strokkur (hver)",1],["de:Wallender Born",1],["en:Fountain Paint Pot",1],["de:Geysir Andernach",1],["en:Old Faithful",1]]},"kind":"categorical","n":8776,"n_null":8646,"n_unique":124,"null_rate":0.985186873290793,"stats":{"cardinality":124,"entropy":6.924253293781044,"entropy_ratio":0.9956942520358381,"top_rate":0.023076923076923078,"top_value":"en:Olympic Hot Springs"}},{"alerts":[{"code":"long_tail","level":"info","message":"131 singleton categories"},{"code":"null_rate","level":"warn","message":"98.1% null"}],"column":"description","extras":{"singletons":131,"top_values":[["Mud geyser created from recent seismic activity",12],["\u71b1\u6d77\u4e03\u6e6f",5],["Free outdoor foot bath hot spring",4],["\u0410\u043a\u0442\u0438\u0432\u043d\u0430\u044f \u0433\u0440\u0443\u043f\u043f\u0430 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u043e\u0432. \u0432\u0445\u043e\u0434\u044f\u0449\u0430\u044f \u0432 \u0441\u043e\u0441\u0442\u0430\u0432 \u0414\u0430\u0447\u043d\u044b\u0445 \u0433\u043e\u0440\u044f\u0447\u0438\u0445 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u043e\u0432. \u041e\u0442\u043a\u0440\u044b\u0442\u0430 \u0438 \u043d\u0430\u0437\u0432\u0430\u043d\u0430 \u041a\u0438\u0440\u0441\u0430\u043d\u043e\u0432\u044b\u043c \u0418.\u0422. \u0438 \u041a\u0438\u0440\u0441\u0430\u043d\u043e\u0432\u043e\u0439 \u0422.\u041f. \u0432 1962 \u0433.",3],["Hot Spring",3],["Exploitation traditionnelle",3],["\u0413\u043e\u0440\u044f\u0447\u0438\u0435 \u0442\u0435\u0440\u043c\u0430\u043b\u044c\u043d\u044b\u0435 \u0438\u0441\u0442\u043e\u0447\u043d\u0438\u043a\u0438",3],["For 70/100 THB, possibility to get a private room",2],["hot spring",2],["Strong sulfur smell. \u224822\u00b0C, https://www.researchgate.net/publication/302914492_Ujerat_Termale_dhe_Minerale_te_Shqiperise_Thermal_and_Mineral_Waters_of_Albania",2],["The only true geyser in the state of Colorado. Frequency of the eruptions vary, 30 to 40 minute intervals are most common. The action is slight and boils 12-15 minutes emitting carbon dioxide and hydrogen sulfide gas. Temperature is usually 82.4 F.",1],["Bad. Thapai Hot springs 300\u0e3f tickets",1],["Heilwasser mit leicht erh\u00f6htem Arsengehalt",1],["\u0412\u043e\u0434\u0430 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u043f\u0440\u0438\u043c\u0435\u0441\u0438 \u043a\u043e\u0431\u0430\u043b\u044c\u0442\u0430",1],["Term\u00e1lna voda 60 stup\u0148ov",1],["sulfur baths",1],["Two blue fibreglass pools perched on a cliff, overlooking the river valley, surrounded by a wooden deck set amongst bush and forest. Pools are feed from a naturally hot thermal spring in the surrounding geology",1],["29.8-30 \u00b0C, 30-70 l/s\n\nhttps://www.researchgate.net/publication/302914492_Ujerat_Termale_dhe_Minerale_te_Shqiperise_Thermal_and_Mineral_Waters_of_Albania",1],["29.7-30 \u00b0C, 5-50 l/s\n\nhttps://www.researchgate.net/publication/302914492_Ujerat_Termale_dhe_Minerale_te_Shqiperise_Thermal_and_Mineral_Waters_of_Albania",1],["Private hot spring pools",1]]},"kind":"categorical","n":8776,"n_null":8606,"n_unique":141,"null_rate":0.9806289881494986,"stats":{"cardinality":141,"entropy":6.893810109715676,"entropy_ratio":0.9655802962183958,"top_rate":0.07058823529411765,"top_value":"Mud geyser created from recent seismic activity"}},{"alerts":[{"code":"null_rate","level":"warn","message":"97.9% null"}],"column":"intermittent","extras":{"singletons":0,"top_values":[["no",170],["yes",15]]},"kind":"categorical","n":8776,"n_null":8591,"n_unique":2,"null_rate":0.9789197812215132,"stats":{"cardinality":2,"entropy":0.4059770384755711,"entropy_ratio":0.4059770384755711,"top_rate":0.918918918918919,"top_value":"no"}},{"alerts":[{"code":"null_rate","level":"warn","message":"99.0% null"}],"column":"access","extras":{"singletons":0,"top_values":[["yes",24],["customers",21],["private",20],["no",19],["permissive",5]]},"kind":"categorical","n":8776,"n_null":8687,"n_unique":5,"null_rate":0.9898587055606198,"stats":{"cardinality":5,"entropy":2.1944234194689383,"entropy_ratio":0.945086725252528,"top_rate":0.2696629213483146,"top_value":"yes"}},{"alerts":[{"code":"null_rate","level":"warn","message":"97.5% null"}],"column":"tourism","extras":{"singletons":3,"top_values":[["attraction",194],["hotel",9],["yes",7],["camp_site",3],["camp_site;loding",3],["information",2],["viewpoint",2],["picnic_site",1],["caravan_site",1],["guest_house",1]]},"kind":"categorical","n":8776,"n_null":8553,"n_unique":10,"null_rate":0.9745897903372835,"stats":{"cardinality":10,"entropy":0.9126771382341444,"entropy_ratio":0.2747431949652393,"top_rate":0.8699551569506726,"top_value":"attraction"}},{"alerts":[],"column":"osm_id","extras":{"histogram":{"counts":[207,170,72,1866,85,28,18,37,44,40,61,39,140,107,68,73,66,87,112,68,147,167,394,194,403,271,323,138,192,270,79,274,215,286,115,386,1210,110,122,92],"edges":[27750092.0,365447810.775,703145529.55,1040843248.3249999,1378540967.1,1716238685.875,2053936404.6499999,2391634123.4249997,2729331842.2,3067029560.975,3404727279.75,3742424998.5249996,4080122717.2999997,4417820436.075,4755518154.849999,5093215873.625,5430913592.4,5768611311.174999,6106309029.95,6444006748.724999,6781704467.5,7119402186.275,7457099905.049999,7794797623.825,8132495342.599999,8470193061.374999,8807890780.15,9145588498.925,9483286217.699999,9820983936.474998,10158681655.25,10496379374.025,10834077092.8,11171774811.574999,11509472530.349998,11847170249.125,12184867967.9,12522565686.675,12860263405.449999,13197961124.224998,13535658843.0]},"sample":[356504371.0,356506589.0,356511304.0,356511346.0,356511806.0,660488903.0,856527464.0,1076297912.0,1083172196.0,1114295689.0,1123053079.0,1123053088.0,1123053255.0,1214317546.0,1237961494.0,1485423757.0,1642992389.0,2006103281.0,2193113864.0,2482320996.0,2484805998.0,3334236505.0,3605875006.0,3720026186.0,3832327966.0,3982524482.0,4313430469.0,4403343892.0,4415201849.0,4415201886.0,4415202089.0,4415202093.0,4416209371.0,4416230998.0,4438974292.0,4457165547.0,4460196757.0,4460196763.0,4460196770.0,4481129589.0,4508189492.0,4618262412.0,4650856238.0,4684186995.0,4685319402.0,4913508322.0,5039903664.0,5186075860.0,5194110678.0,5237362509.0,5307268721.0,5331985128.0,5560534093.0,5607889516.0,5629135758.0,5725580468.0,5775507067.0,5775507073.0,5775512591.0,5775555869.0,5861124169.0,5884058401.0,6119699476.0,6128015088.0,6133966990.0,6134396496.0,6138549088.0,6161988285.0,6174809986.0,6219545654.0,6295230851.0,6325155900.0,6447051986.0,6694043586.0,6707642882.0,6711181086.0,6714083485.0,6743545167.0,6831704685.0,6846728785.0,6876780985.0,6903657685.0,6920478485.0,6997334885.0,7004745092.0,7038966298.0,7089312587.0,7104662490.0,7171332185.0,7182038985.0,7214588485.0,7218463985.0,7237399486.0,7261553185.0,7277048797.0,7319555352.0,7319935591.0,7322100786.0,7387204585.0,7553938199.0,7553938204.0,7553958488.0,7553958888.0,7553959799.0,7553959891.0,7553960095.0,7554025937.0,7554026007.0,7561016185.0,7702923113.0,7728655285.0,7758322285.0,7761507985.0,7791090986.0,7802952750.0,7810370387.0,7872943885.0,7917971285.0,7921608424.0,8109268619.0,8117420725.0,8127709117.0,8172656117.0,8193662120.0,8193662518.0,8211297417.0,8245592317.0,8251769918.0,8270898217.0,8283204216.0,8311115218.0,8340956417.0,8412333226.0,8412333520.0,8437047417.0,8455135823.0,8455150017.0,8455150059.0,8455150222.0,8455150232.0,8455150323.0,8455150327.0,8455150429.0,8455151123.0,8455151127.0,8455151817.0,8455151838.0,8455155026.0,8455155420.0,8462229618.0,8480333217.0,8484345217.0,8533565718.0,8608465017.0,8637254518.0,8643766517.0,8663794059.0,8663794071.0,8663794072.0,8688877922.0,8695890323.0,8695890325.0,8739344317.0,8774092219.0,8774092272.0,8778680617.0,8806683042.0,8827293217.0,8827381417.0,8829040617.0,8829156817.0,8829623118.0,8842212099.0,8881913817.0,8914705618.0,8917218666.0,8917218743.0,8933794218.0,8943712114.0,8947591536.0,9075742617.0,9088970917.0,9177009984.0,9187090893.0,9201243784.0,9291191630.0,9291965225.0,9435096261.0,9687577117.0,9687674688.0,9698412584.0,9708696317.0,9719924573.0,9801424365.0,9817506617.0,9821763017.0,9880784242.0,9891374577.0,9919489622.0,9923946119.0,9926251717.0,9933440017.0,9941251548.0,9947960015.0,9949988117.0,9965282917.0,9965535818.0,9968293119.0,9992417019.0,10005355117.0,10050797985.0,10050989565.0,10055297617.0,10086208023.0,10095772318.0,10095772320.0,10100549605.0,10101960420.0,10101960429.0,10101960431.0,10123070717.0,10157173617.0,10180138915.0,10208910617.0,10239103209.0,10269921653.0,10281829109.0,10296646710.0,10582240055.0,10608116684.0,10678836157.0,10699440708.0,10699440805.0,10699441005.0,10706370606.0,10727162505.0,10748653805.0,10748671305.0,10750034705.0,10763136705.0,10781273705.0,10799862121.0,10809402305.0,10829147105.0,10893653354.0,10898913105.0,10902693628.0,10911551390.0,10913816283.0,10971428205.0,10976643905.0,11005699530.0,11009504620.0,11009504621.0,11099076505.0,11126148106.0,11143134228.0,11145765807.0,11191918538.0,11201776137.0,11207226637.0,11218021637.0,11248762839.0,11282883969.0,11308868469.0,11309892964.0,11369776813.0,11374552076.0,11432268669.0,11452077283.0,11464534669.0,11483364253.0,11486482221.0,11526434869.0,11672970269.0,11686887924.0,11692563983.0,11704192510.0,11777824169.0,11786548869.0,11795556772.0,11817169076.0,11825829169.0,11940739187.0,11966258403.0,11994855166.0,12042310822.0,12092071077.0,12160771405.0,12160771695.0,12160772434.0,12160772666.0,12160772687.0,12160772726.0,12162682588.0,12187359987.0,12187360147.0,12187360370.0,12189394929.0,12193165826.0,12193166053.0,12193166080.0,12194126037.0,12206023186.0,12206023343.0,12206023690.0,12206186503.0,12206186535.0,12215347642.0,12215347644.0,12216529892.0,12219582324.0,12220731860.0,12223066141.0,12223066153.0,12223066206.0,12242167125.0,12242225827.0,12242225861.0,12242836266.0,12257707033.0,12257707083.0,12257707104.0,12257707161.0,12259690609.0,12259690644.0,12259690969.0,12259690972.0,12259690976.0,12259690986.0,12259690998.0,12260385695.0,12260385698.0,12260385727.0,12260385728.0,12265180995.0,12282946106.0,12305559042.0,12305559138.0,12305559298.0,12305885283.0,12309792744.0,12309793100.0,12309793147.0,12309793398.0,12329036602.0,12329036759.0,12329037022.0,12329037076.0,12329037081.0,12329037207.0,12329037355.0,12344628235.0,12344628283.0,12344628328.0,12344628412.0,12344628431.0,12344628463.0,12344628530.0,12344628658.0,12344628723.0,12344628760.0,12352430123.0,12496398531.0,12614318301.0,12673425849.0,12681344448.0,12685983302.0,12729068002.0,12749314883.0,12756677891.0,12757363700.0,12762913401.0,12783923004.0,12816148405.0,12822507601.0,12845250102.0,12890320747.0,12906334171.0,12960172301.0,12986077738.0,13108180394.0,13175400449.0,13186949601.0,13186970303.0,13192251100.0,13340688901.0,13424629301.0,13436904994.0,13452864501.0,13475668767.0,13476493574.0,13481140201.0,27750100.0,30929847.0,193786022.0,230019420.0,232042272.0,353672482.0,466226081.0,533523349.0,542866016.0,552482734.0,555022469.0,686302187.0,686782862.0,938039118.0,971881484.0,971881485.0,983908753.0,1058316079.0,1074303616.0,1090677796.0,1146143608.0,1146143623.0,1204787140.0,1229636120.0,1277633765.0,1280539185.0,1293978126.0,1293979194.0,1295794521.0,1301267606.0,1312832310.0,1313849113.0,1313849134.0,1313849137.0,1313849152.0,1313849193.0,1313849229.0,1313851376.0,1313885618.0,1314066704.0,1314066709.0,1314069980.0,1314070010.0,1314070035.0,1314070041.0,1314755487.0,1314755488.0,1314755510.0,1314755512.0,1314755513.0,1314755515.0,1314755519.0,1314755523.0,1315779017.0,1315779027.0,1316828155.0,1316828251.0,1317055942.0,1317055963.0,1317432142.0,1317432176.0,1318892420.0,1318892457.0,1318892459.0,1318892460.0,1318892462.0,1318892463.0,1318892469.0,1318911712.0,1318911715.0,1320229425.0,1320476176.0,1324004757.0,1324875680.0,1324875687.0,1324875699.0,1324875710.0,1324924179.0,1324924190.0,1324924194.0,1327615655.0,1330439817.0,1330439842.0,1330439882.0,1331849949.0,1331849956.0,1331849970.0,1331849977.0,1332652450.0,1332652475.0,1332652484.0,1332652495.0,1332652497.0,1332652501.0,1332652531.0,1332652545.0,1332652559.0,1332652597.0,1332652615.0,1338749037.0,1338749052.0,1349329891.0,1349329894.0,1434825523.0,1446952549.0,1461922968.0,1472649801.0]},"kind":"numeric","n":8776,"n_null":0,"n_unique":8776,"null_rate":0.0,"stats":{"iqr":9941614452.5,"kurtosis":-1.4298489104043224,"max":13535658843.0,"mean":7186022130.99134,"median":8262841267.5,"min":27750092.0,"n_outliers":0,"outlier_rate":0.0,"q1":1334332063.75,"q3":11275946516.25,"skew":-0.301134313230387,"std":4373813805.456229,"zero_rate":0.0}},{"alerts":[],"column":"osm_type","extras":{"singletons":0,"top_values":[["node",6705],["way",2071]]},"kind":"categorical","n":8776,"n_null":0,"n_unique":2,"null_rate":0.0,"stats":{"cardinality":2,"entropy":0.7882986356602641,"entropy_ratio":0.7882986356602641,"top_rate":0.7640154968094804,"top_value":"node"}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","columns.type.top_values","columns.osm_type.top_values","columns.lat.stats","columns.lon.stats","columns.tourism.top_values","columns.country.null_rate","columns.temperature.top_values","columns.name.stats"],"featured_charts":[{"caption":"Shows the hot spring vs geyser split \u2014 about 81% are hot springs.","column":"type","kind":"donut"},{"caption":"Most features are mapped as nodes (76%) rather than ways, indicating point-based geometry dominates.","column":"osm_type","kind":"donut"},{"caption":"Latitude distribution is northern-skewed with a long southern tail; watch for the 889 flagged outliers.","column":"lat","kind":"histogram"},{"caption":"Longitude spreads globally but is bimodal between the Americas and Eurasia/Pacific.","column":"lon","kind":"histogram"},{"caption":"Among the ~2.5% of records with a tourism tag, 'attraction' dominates over hotels and campsites.","column":"tourism","kind":"bar"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset catalogs 8,776 geothermal features (hot springs and geysers) sourced from OpenStreetMap, with 13 columns covering location, type, and optional metadata like temperature and tourism use. The core signal is in the `type` and `osm_type` fields: roughly 80% are hot springs and 20% geysers, and most entries are point nodes rather than ways. Geographic coverage is global but skewed \u2014 latitude leans heavily toward the northern hemisphere with a long southern tail flagged as outliers, while longitude spans the full range. Be aware that nearly all the descriptive fields (`country`, `wikipedia`, `temperature`, `description`, `access`, `tourism`, `intermittent`) have null rates above 97%, so they're only useful for the small annotated subset. Within that subset, `tourism` is dominated by 'attraction' and `intermittent` is overwhelmingly 'no', which limits their analytic value.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.allcaps_rate","stats.duplicate_rate","stats.n_duplicates","stats.len_mean","stats.word_mean","stats.vocab_size","top_values","top_words"],"model":"anthropic:claude-opus-4-7","narrative":"Short free-text names for places, almost certainly hot springs and geysers given that 'hot_spring' (3393) and 'geyser' (1083) dominate top_words. The column is highly diverse (8316 unique of 8776) but multilingual \u2014 top values mix Arabic, English, Spanish, and Turkish \u2014 and 25.3% of entries are all-caps, which would break naive string matching. There are 460 duplicates (5.2%) including 40 repeats of a single Arabic name, suggesting the same feature recorded multiple times.","role":"label","scope":"column","target":"name","treatment":"Normalize case and unicode, then keep as a descriptive label; do not use as a join key given duplicates and language mix."},{"confidence":"high","critiques":[],"evidence_keys":["column","kind","n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.q1","stats.q3","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This is a latitude coordinate column, with values spanning -54.68 to 70.96 and a median of 40.86 placing most records in the northern hemisphere. The distribution is heavily left-skewed (skew -2.36, kurtosis 6.28) with 889 outliers (10.1%), reflecting a long southern-hemisphere tail relative to a northern-clustered core. Near-unique values (8758/8776) indicate point-level geolocations rather than coarse bins.","role":"feature","scope":"column","target":"lat","treatment":"Pair with longitude for geospatial features (e.g., bin, cluster, or compute distances) rather than treating as a standalone numeric."},{"confidence":"high","critiques":[],"evidence_keys":["stats.min","stats.max","stats.mean","stats.median","stats.iqr","stats.std","n","n_unique","null_rate","stats.zero_rate","stats.n_outliers"],"model":"anthropic:claude-opus-4-7","narrative":"This column is almost certainly geographic longitude in decimal degrees: values span -176.63 to 179.36, with mean -23.99 and median -21.23 sitting plausibly within the valid [-180, 180] range. The wide IQR of 154.96 and std of 89.39 indicate global coverage rather than a regional dataset, and near-uniqueness (8747 unique of 8776) suggests each row is a distinct location. No nulls, no zeros, and no flagged outliers.","role":"feature","scope":"column","target":"lon","treatment":"Pair with latitude for geospatial features; avoid treating as a plain scalar in models due to wraparound at \u00b1180."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.cardinality","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a country code field (ISO-2 style values like IQ, TW, MX, DE, RU, JP) that is effectively empty: 99.91% of the 8776 rows are null, leaving only 8 observed values across 6 distinct codes. The non-null distribution is too sparse to be meaningful, though IQ appears 3 times and accounts for 37.5% of present values. With this null rate, any apparent signal is noise.","role":"metadata","scope":"column","target":"country","treatment":"Drop the column; null rate of 99.91% leaves nothing to model."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.top_rate","stats.top_value","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Binary categorical column distinguishing two hydrothermal feature types: hot_spring (7082 rows, ~80.7%) and geyser (1694 rows). No nulls and only 2 unique values, so the field is clean but imbalanced roughly 4:1 toward hot_spring. Entropy ratio of 0.71 reflects that skew rather than any data quality issue.","role":"label","scope":"column","target":"type","treatment":"One-hot or boolean-encode; stratify splits to preserve the ~4:1 class balance."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"A free-text temperature field that is 98.31% null, with only 148 populated rows out of 8776. The dominant value is the descriptive string 'hot' (76 occurrences, 51.35% of populated rows), while the remaining entries are numeric strings like '90', '100', '21' \u2014 indicating a mix of qualitative and quantitative encodings with no consistent unit. Cardinality is 56 with entropy ratio 0.64, so the long tail is sparse but varied.","role":"feature","scope":"column","target":"temperature","treatment":"Drop or treat as missing-by-default; if retained, normalize units and split numeric vs categorical encodings before use."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a Wikipedia article reference column, with values formatted as language-prefixed page titles (e.g., 'en:Olympic Hot Springs', 'ja:\u9262\u5f62\u99c5') spanning multiple languages including English, Japanese, Russian, and Icelandic. The column is 98.52% null with only 124 unique values across 8776 rows, and entropy ratio of 0.996 indicates the few populated entries are nearly all distinct. The top value appears just 3 times (0.023 rate), confirming no meaningful concentration.","role":"metadata","scope":"column","target":"wikipedia","treatment":"Drop or retain only as a reference link; too sparse and high-cardinality for modelling."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n_unique","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Free-text descriptions, likely for hot spring or geothermal site entries, present on only ~1.94% of the 8776 rows (null_rate 0.9806). Among the 170 non-null entries there are 141 unique values with entropy ratio 0.966, so almost every description is bespoke; the most common string ('Mud geyser created from recent seismic activity') still only repeats 12 times (top_rate 0.0706). Languages are mixed \u2014 English, Japanese (\u71b1\u6d77\u4e03\u6e6f), Russian, French \u2014 which will complicate any text processing.","role":"free_text","scope":"column","target":"description","treatment":"Treat as multilingual free text: language-detect then tokenize/embed, but expect ~98% missingness to limit usefulness as a feature."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.top_value","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Binary yes/no flag indicating whether something is intermittent, but it is essentially absent: 97.89% of the 8,776 rows are null, leaving only 185 populated values. Among those few, 'no' dominates at 91.9% (170 vs 15 'yes'), so the column carries almost no usable signal.","role":"feature","scope":"column","target":"intermittent","treatment":"Drop or treat as a sparse indicator; null rate too high for direct modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a low-cardinality categorical access flag (5 distinct values: yes, customers, private, no, permissive) \u2014 likely an OSM-style access tag indicating who may use a feature. It is overwhelmingly null at 98.99%, leaving only 89 observed values across 8,776 rows. The non-null distribution is unusually flat (entropy ratio 0.945), with the modal value 'yes' accounting for just 26.97% of present values.","role":"feature","scope":"column","target":"access","treatment":"Treat missing as its own category ('unspecified') before encoding, given 99% nulls."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is an OpenStreetMap-style `tourism` tag classifying points of interest (attraction, hotel, camp_site, viewpoint, etc.). It is almost entirely empty \u2014 97.46% null across 8776 rows \u2014 and among the 223 populated entries, `attraction` dominates at 87% (194 records), leaving the other 9 categories as long-tail singletons. A stray `yes` value (7 rows) suggests inconsistent tagging upstream.","role":"metadata","scope":"column","target":"tourism","treatment":"Drop or collapse to a binary is_attraction flag; too sparse and skewed for direct use as a feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.iqr","stats.skew","stats.kurtosis","stats.zero_rate","stats.n_outliers"],"model":"anthropic:claude-opus-4-7","narrative":"This is almost certainly the OpenStreetMap object identifier: every one of the 8776 rows is unique with no nulls or zeros, and values span 27750092 to 13535658843, the range typical of OSM IDs. The distribution is broad (IQR ~9.94e9) and slightly left-skewed (-0.30) with flat kurtosis (-1.43), consistent with IDs accumulated across OSM history rather than a meaningful numeric feature. No outliers were flagged, which is expected for an identifier.","role":"identifier","scope":"column","target":"osm_id","treatment":"Use as a join key to OSM; do not feed into models as a numeric feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_value","stats.top_rate","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column records the OpenStreetMap geometry type, taking only two values across 8,776 rows: 'node' (6,705) and 'way' (2,071). 76.4% of records are nodes, giving an entropy ratio of 0.79 \u2014 moderately imbalanced but no nulls or rare categories.","role":"feature","scope":"column","target":"osm_type","treatment":"One-hot or binary-encode before modelling."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":4390,"prompt_tokens":16458,"total_tokens":20848}},"language_counts":{},"meta":{"generated_at":"2026-05-01T18:07:54+00:00","mode":"full","row_count":8776,"sampled_rows":8776,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/data/quirky/geothermal.json"},"notes":[],"saturn_version":"0.2.0","schema":{"access":"categorical","country":"categorical","description":"categorical","intermittent":"categorical","lat":"numeric","lon":"numeric","name":"text","osm_id":"numeric","osm_type":"categorical","temperature":"categorical","tourism":"categorical","type":"categorical","wikipedia":"categorical"}}