{"columns":[{"alerts":[{"code":"one_word","level":"warn","message":"100.0% rows are a single word"},{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"81.9% duplicate strings"}],"column":"date","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,70022,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[9.5,9.525,9.55,9.575,9.6,9.625,9.65,9.675,9.7,9.725,9.75,9.775,9.8,9.825,9.85,9.875,9.9,9.925,9.95,9.975,10.0,10.025,10.05,10.075,10.1,10.125,10.15,10.175,10.2,10.225,10.25,10.275,10.3,10.325,10.35,10.375,10.4,10.425,10.45,10.475,10.5]},"near_unique":false,"sample":["1950-05-16","2009-06-27","2016-05-26","2013-06-21","1990-09-09","2022-04-05","1991-08-15","2018-04-15","2013-07-01","1956-04-03","2001-06-13","1997-05-18","1979-10-22","1951-04-20","1980-03-08","1971-05-31","1962-04-27","2014-07-27","2023-06-14","1989-05-29","1981-04-03","1956-06-25","1969-12-21","1962-06-05","2006-05-30","2010-05-10","1998-05-08","1971-07-10","1960-01-29","2022-04-13","2004-05-24","2004-06-24","2004-06-23","1988-05-18","1985-05-20","1991-05-29","2020-04-23","1995-08-23","1992-04-16","1997-12-24","2012-08-04","2019-06-23","1978-07-12","2019-06-15","2021-05-13","2022-05-31","1983-08-12","1988-05-21","1968-05-09","2017-04-05"],"top_values":[["2011-04-27",207],["1974-04-03",128],["2023-03-31",127],["2021-12-15",125],["2003-06-24",95],["2011-05-25",93],["2007-05-05",90],["1999-01-21",86],["2012-04-14",83],["2003-05-04",81],["2004-05-30",81],["2022-03-30",81],["1995-05-18",79],["2008-05-23",79],["2004-05-29",78],["2003-05-06",74],["2010-06-17",74],["2013-11-17",74],["2011-04-15",73],["2020-04-12",73]],"top_words":[["2011-04-27",56],["2021-12-15",43],["2007-05-05",32],["2023-03-31",31],["1974-04-03",29],["2013-11-17",26],["2003-06-24",26],["1995-05-18",24],["2020-04-13",24],["1996-04-19",24],["2011-05-25",24],["2004-05-29",24],["1992-11-22",24],["1990-06-02",23],["2019-04-30",23],["2010-06-17",23],["2020-04-12",23],["2010-05-10",22],["2012-04-14",22],["2004-05-22",21],["2003-05-04",21],["2017-05-18",21],["1999-01-21",21],["1967-09-20",21],["2003-05-06",20]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,70022,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[0.5,0.5333333333333333,0.5666666666666667,0.6,0.6333333333333333,0.6666666666666666,0.7,0.7333333333333334,0.7666666666666666,0.8,0.8333333333333333,0.8666666666666667,0.9,0.9333333333333333,0.9666666666666667,1.0,1.0333333333333332,1.0666666666666667,1.1,1.1333333333333333,1.1666666666666665,1.2,1.2333333333333334,1.2666666666666666,1.3,1.3333333333333335,1.3666666666666667,1.4,1.4333333333333333,1.4666666666666668,1.5]}},"kind":"text","n":70022,"n_null":0,"n_unique":12639,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.8194995858444489,"emoji_rate":0.0,"len_max":10,"len_mean":10.0,"len_median":10.0,"len_min":10,"len_p95":10.0,"n_duplicates":57383,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":7831,"word_mean":1.0,"word_median":1.0}},{"alerts":[{"code":"one_word","level":"warn","message":"100.0% rows are a single word"},{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"97.9% duplicate strings"}],"column":"time","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,70022,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[7.5,7.525,7.55,7.575,7.6,7.625,7.65,7.675,7.7,7.725,7.75,7.775,7.8,7.825,7.85,7.875,7.9,7.925,7.95,7.975,8.0,8.025,8.05,8.075,8.1,8.125,8.15,8.175,8.2,8.225,8.25,8.275,8.3,8.325,8.35,8.375,8.4,8.425,8.45,8.475,8.5]},"near_unique":false,"sample":["18:00:00","13:55:00","19:01:00","12:58:00","14:45:00","07:14:00","15:35:00","16:56:00","18:41:00","19:45:00","19:52:00","16:47:00","03:30:00","15:10:00","13:20:00","19:00:00","19:00:00","14:55:00","15:40:00","09:42:00","17:05:00","13:30:00","15:45:00","16:55:00","17:00:00","14:00:00","18:01:00","15:20:00","06:00:00","15:53:00","18:25:00","18:00:00","19:35:00","18:37:00","17:42:00","17:47:00","00:08:00","16:39:00","17:01:00","06:39:00","16:20:00","18:32:00","13:30:00","19:02:00","19:10:00","19:40:00","16:20:00","06:35:00","12:45:00","14:47:00"],"top_values":[["16:00:00",978],["17:00:00",971],["15:00:00",959],["17:30:00",907],["18:00:00",906],["16:30:00",810],["18:30:00",773],["19:00:00",767],["15:30:00",685],["14:00:00",646],["20:00:00",641],["19:30:00",613],["14:30:00",585],["17:45:00",493],["16:15:00",479],["13:30:00",452],["21:00:00",447],["17:15:00",442],["16:45:00",423],["18:15:00",417]],"top_words":[["15:00:00",284],["16:00:00",277],["17:00:00",276],["17:30:00",276],["18:00:00",264],["19:00:00",219],["16:30:00",215],["18:30:00",215],["14:00:00",198],["15:30:00",192],["20:00:00",178],["19:30:00",170],["14:30:00",155],["17:45:00",142],["16:15:00",137],["15:45:00",131],["21:00:00",129],["17:15:00",128],["13:00:00",127],["20:30:00",122],["16:45:00",121],["18:45:00",115],["13:30:00",113],["18:15:00",112],["16:20:00",107]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,70022,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[0.5,0.5333333333333333,0.5666666666666667,0.6,0.6333333333333333,0.6666666666666666,0.7,0.7333333333333334,0.7666666666666666,0.8,0.8333333333333333,0.8666666666666667,0.9,0.9333333333333333,0.9666666666666667,1.0,1.0333333333333332,1.0666666666666667,1.1,1.1333333333333333,1.1666666666666665,1.2,1.2333333333333334,1.2666666666666666,1.3,1.3333333333333335,1.3666666666666667,1.4,1.4333333333333333,1.4666666666666668,1.5]}},"kind":"text","n":70022,"n_null":0,"n_unique":1438,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.9794635971551798,"emoji_rate":0.0,"len_max":8,"len_mean":8.0,"len_median":8.0,"len_min":8,"len_p95":8.0,"n_duplicates":68584,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":1352,"word_mean":1.0,"word_median":1.0}},{"alerts":[],"column":"state","extras":{"singletons":1,"top_values":[["TX",9345],["KS",4474],["OK",4221],["FL",3620],["NE",3056],["IA",2887],["IL",2835],["MS",2657],["AL",2529],["MO",2462],["CO",2425],["LA",2305],["MN",2118],["AR",1981],["SD",1917],["GA",1898],["ND",1640],["IN",1610],["WI",1515],["NC",1472]]},"kind":"categorical","n":70022,"n_null":0,"n_unique":53,"null_rate":0.0,"stats":{"cardinality":53,"entropy":4.850514029298112,"entropy_ratio":0.8468193767310276,"top_rate":0.13345805603953043,"top_value":"TX"}},{"alerts":[],"column":"mag","extras":{"singletons":0,"top_values":[["0",32218],["1",23782],["2",9767],["3",2585],["-9",1024],["4",587],["5",59]]},"kind":"categorical","n":70022,"n_null":0,"n_unique":7,"null_rate":0.0,"stats":{"cardinality":7,"entropy":1.7721057980879125,"entropy_ratio":0.631236821594712,"top_rate":0.4601125360600954,"top_value":"0"}},{"alerts":[],"column":"injuries","extras":{"singletons":95,"top_values":[["0",62177],["1",2480],["2",1388],["3",770],["4",484],["5",385],["6",300],["7",194],["8",171],["10",141],["12",120],["9",117],["11",80],["20",71],["15",69],["13",66],["14",55],["30",46],["25",44],["16",43]]},"kind":"categorical","n":70022,"n_null":0,"n_unique":209,"null_rate":0.0,"stats":{"cardinality":209,"entropy":0.9454017755582204,"entropy_ratio":0.12266221923189075,"top_rate":0.8879637828111165,"top_value":"0"}},{"alerts":[{"code":"imbalance","level":"warn","message":"top value is 97.7% of rows"}],"column":"fatalities","extras":{"singletons":18,"top_values":[["0",68423],["1",830],["2",277],["3",134],["4",77],["5",46],["6",45],["7",32],["9",15],["10",15],["11",14],["8",13],["16",12],["13",8],["17",7],["18",6],["21",6],["12",6],["22",5],["25",4]]},"kind":"categorical","n":70022,"n_null":0,"n_unique":50,"null_rate":0.0,"stats":{"cardinality":50,"entropy":0.21737824378259438,"entropy_ratio":0.03851590764775866,"top_rate":0.9771643197852103,"top_value":"0"}},{"alerts":[{"code":"one_word","level":"warn","message":"100.0% rows are a single word"},{"code":"allcaps","level":"info","message":"92.5% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"98.5% duplicate strings"}],"column":"loss","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[5248,0,0,0,0,0,0,0,50873,0,0,0,0,7040,0,0,0,4912,0,0,0,0,1581,0,0,0,292,0,0,0,0,58,0,0,0,16,0,0,0,2],"edges":[1.0,1.225,1.45,1.675,1.9,2.125,2.35,2.575,2.8,3.025,3.25,3.475,3.7,3.9250000000000003,4.15,4.375,4.6,4.825,5.05,5.275,5.5,5.7250000000000005,5.95,6.175,6.4,6.625,6.8500000000000005,7.075,7.3,7.525,7.75,7.9750000000000005,8.2,8.425,8.65,8.875,9.1,9.325000000000001,9.55,9.775,10.0]},"near_unique":false,"sample":["3.0","0.0","0","0.0","3.0","0","5.0","100000","0.0","4.0","0.0","0.0","5.0","4.0","5.0","3.0","4.0","0.0","50000","4.0","3.0","4.0","3.0","0.0","0.0","0.0","0.0","4.0","3.0","8000","0.1","0.0","1.49","1.0","0.0","0.0","1000000","0.0","3.0","0.25","0.0","0","0.0","50000","0","0","1.0","4.0","3.0","50000"],"top_values":[["0.0",22764],["4.0",8823],["5.0",5978],["0",5248],["3.0",5191],["1.0",1816],["6.0",1760],["2.0",1715],["0.01",1671],["0.05",844],["0.1",832],["0.03",622],["0.02",596],["0.001",451],["50000",395],["0.2",383],["0.5",361],["100000",357],["0.25",350],["7.0",349]],"top_words":[["0.0",6487],["4.0",2506],["5.0",1678],["3.0",1523],["0",1509],["1.0",521],["2.0",501],["6.0",478],["0.01",464],["0.1",255],["0.05",223],["0.03",172],["0.02",157],["0.001",133],["7.0",119],["100000",112],["0.2",106],["0.005",98],["0.25",97],["50000",97],["0.5",96],["0.04",96],["0.15",88],["10000",85],["0.07",84]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,70022,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[0.5,0.5333333333333333,0.5666666666666667,0.6,0.6333333333333333,0.6666666666666666,0.7,0.7333333333333334,0.7666666666666666,0.8,0.8333333333333333,0.8666666666666667,0.9,0.9333333333333333,0.9666666666666667,1.0,1.0333333333333332,1.0666666666666667,1.1,1.1333333333333333,1.1666666666666665,1.2,1.2333333333333334,1.2666666666666666,1.3,1.3333333333333335,1.3666666666666667,1.4,1.4333333333333333,1.4666666666666668,1.5]}},"kind":"text","n":70022,"n_null":0,"n_unique":1019,"null_rate":0.0,"stats":{"allcaps_rate":0.9250521264745366,"boilerplate_rate":0.0,"duplicate_rate":0.9854474308074606,"emoji_rate":0.0,"len_max":10,"len_mean":3.1810716631915685,"len_median":3.0,"len_min":1,"len_p95":5.0,"n_duplicates":69003,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":503,"word_mean":1.0,"word_median":1.0}},{"alerts":[],"column":"slat","extras":{"histogram":{"counts":[33,6,8,26,1,0,76,487,748,1225,1468,3607,3441,5003,4775,5392,5164,4268,4028,4807,5498,5313,3995,3396,2407,1720,1257,1114,754,1,0,0,0,0,1,0,0,0,1,2],"edges":[17.7212,18.80367,19.88614,20.968609999999998,22.05108,23.13355,24.21602,25.29849,26.38096,27.463430000000002,28.5459,29.62837,30.71084,31.793309999999998,32.87578,33.95825,35.04072,36.12319,37.20566,38.288129999999995,39.370599999999996,40.45307,41.53554,42.61801,43.70048,44.78295,45.86542,46.94789,48.03036,49.11283,50.1953,51.277770000000004,52.360240000000005,53.442710000000005,54.525180000000006,55.60765000000001,56.69012000000001,57.77259000000001,58.855059999999995,59.937529999999995,61.02]},"sample":[42.07,43.47,32.92,38.68,45.78,30.33,32.77,32.17,39.37,31.4,40.87,38.15,32.08,36.02,39.22,40.33,36.27,43.87,40.83,31.2,32.38,36.88,36.0,40.23,31.5,30.92,46.4,34.2,37.82,34.87,34.28,40.72,35.75,41.18,35.22,42.37,35.58,32.87,39.48,40.98,37.83,41.43,36.42,34.47,37.27,40.32,44.68,42.13,38.55,31.75,40.85,37.08,34.4,38.57,42.65,32.33,43.5,44.85,40.63,37.83,48.3,39.55,32.3,34.8,35.3,42.82,39.07,43.07,43.38,43.3,38.8,38.82,30.92,39.45,43.35,43.58,28.9,33.0,34.85,37.22,40.32,43.38,33.68,29.77,42.12,38.3,36.8,32.77,42.0,32.4,35.0,28.63,32.77,34.25,34.92,42.53,37.92,41.08,44.82,31.2,30.35,38.03,36.05,33.97,30.53,37.0,29.07,37.62,41.28,30.7,39.08,29.92,35.08,40.2,40.25,37.28,42.93,32.08,40.18,33.83,42.77,42.02,32.93,31.87,32.15,27.02,46.53,36.82,39.43,45.8,46.05,42.28,41.17,41.85,34.15,29.73,37.42,33.37,36.88,41.32,33.7,31.78,30.75,30.1,43.62,42.43,46.12,38.8,43.15,32.47,33.98,36.47,37.9,47.95,27.83,40.07,27.88,30.48,40.5,30.27,38.5,34.95,36.63,28.87,24.55,32.85,31.72,36.72,29.88,41.98,39.85,28.92,41.43,40.27,38.07,38.15,38.2,45.68,42.05,31.9,35.12,34.55,35.78,36.28,34.03,39.22,31.28,35.53,35.27,34.15,35.13,35.92,48.45,31.87,30.47,38.8,31.92,41.17,40.05,27.52,39.88,39.0,40.87,40.42,36.92,37.6,40.43,29.15,35.15,28.97,46.12,46.0,37.5,32.82,25.47,38.67,32.77,31.92,33.75,34.62,31.32,39.32,39.43,43.75,36.35,37.93,30.57,45.5,33.0,40.88,27.25,28.92,37.4,40.52,47.53,37.27,42.23,27.73,48.55,47.83,43.27,32.73,44.82,39.48,39.08,41.23,31.4,34.52,34.47,34.35,31.38,37.83,40.27,37.92,32.05,31.12,40.45,44.38,34.03,45.38,26.75,31.27,41.77,38.4,37.35,39.93,26.03,44.58,31.08,31.95,24.92,31.3,28.8,45.47,35.45,33.75,40.87,46.1,40.17,42.85,41.45,44.5,39.25,40.62,45.5,36.38,33.05,29.23,37.78,30.38,30.95,37.57,47.18,40.63,32.43,30.58,40.23,26.5,30.02,34.23,28.35,41.95,35.93,43.02,41.62,34.5,31.08,41.3,29.32,33.48,31.42,36.17,32.65,38.08,37.88,36.5,34.8,26.95,40.03,36.9,37.03,38.23,43.17,35.92,34.47,35.92,48.23,31.83,42.3,38.72,37.78,41.88,48.98,32.8,28.08,32.63,27.93,41.15,34.72,33.08,31.38,33.87,33.58,39.98,42.05,42.08,36.48,36.17,34.37,40.38,39.03,43.63,43.89,37.2,44.78,40.92,40.43,35.68,34.46,35.65,32.67,38.99,38.82,42.98,40.97,39.71,46.99,29.02,32.9789,33.7888,26.7274,33.12,37.1577,36.9979,37.78,45.38,40.05,38.3644,36.7694,39.9137,29.9914,36.7595,35.8303,35.3833,35.9099,38.71,38.49,42.7031,41.09,46.6434,42.1606,40.91,47.9476,36.5256,37.0344,38.34,36.7645,35.01,36.8863,41.4781,38.659,32.7759,38.6521,34.917,47.3923,48.3,45.0801,34.79,29.3492,37.55,29.144,40.45,40.2351,43.26,35.6534,42.5262,38.97,29.8,44.0262,28.0209,45.285,34.5441,35.5725,38.191,42.4483,48.028,38.08,32.6807,36.9732,39.51,37.0975,35.94,39.785,39.8474,39.7923,36.5072,34.408,32.1438,32.0692,36.6429,41.3969,47.89,43.0096,39.78,33.3793,33.7179,30.9198,40.0074,30.6423,36.7086,47.6277,40.9,34.9536,32.5051,37.5468,36.2973,42.5,32.4676,30.296,38.9713,34.55,35.9009,32.4617,36.3302,42.648,31.6552,32.8574,33.9384,31.7592,35.535,42.9847,43.7419,39.633,32.4003,32.9656,33.6681,39.5153,37.2,40.19,47.89,30.516,33.912,31.8658,30.4632,33.4021,40.379,45.58,40.53,39.7259,42.3489,34.6785,38.757,35.211,28.6761,38.77,41.669,37.5782,47.67,41.481,29.97]},"kind":"numeric","n":70022,"n_null":0,"n_unique":16016,"null_rate":0.0,"stats":{"iqr":7.740000000000002,"kurtosis":-0.5824729798209627,"max":61.02,"mean":37.136784433463774,"median":37.02505,"min":17.7212,"n_outliers":70,"outlier_rate":0.0009996858130301904,"q1":33.19,"q3":40.93,"skew":0.03792448611580074,"std":5.089856692229972,"zero_rate":0.0}},{"alerts":[],"column":"slon","extras":{"histogram":{"counts":[2,9,25,8,0,0,0,1,0,0,0,0,0,0,0,15,231,241,282,174,399,323,325,1782,4689,6094,9665,8344,6626,6618,6086,5361,4363,3931,1885,1618,541,285,71,28],"edges":[-163.53,-161.0596275,-158.589255,-156.1188825,-153.64851,-151.1781375,-148.707765,-146.2373925,-143.76702,-141.2966475,-138.826275,-136.3559025,-133.88553000000002,-131.41515750000002,-128.944785,-126.4744125,-124.00404,-121.5336675,-119.06329500000001,-116.5929225,-114.12255,-111.65217750000001,-109.181805,-106.7114325,-104.24106,-101.77068750000001,-99.30031500000001,-96.8299425,-94.35957,-91.88919750000001,-89.418825,-86.9484525,-84.47808,-82.00770750000001,-79.53733500000001,-77.0669625,-74.59659,-72.12621750000001,-69.655845,-67.1854725,-64.7151]},"sample":[-92.92,-89.25,-98.25,-93.27,-89.13,-85.67,-101.43,-103.23,-97.75,-96.9,-97.62,-95.53,-96.72,-84.42,-99.98,-88.13,-95.83,-92.6,-96.57,-85.4,-94.9,-82.75,-80.08,-81.57,-81.45,-102.9,-97.7,-98.58,-97.03,-93.2,-92.55,-93.73,-100.17,-103.98,-102.3,-72.63,-109.78,-99.72,-101.52,-102.35,-87.67,-90.47,-100.82,-97.4,-92.52,-97.82,-94.83,-89.25,-95.28,-99.55,-85.82,-98.58,-103.13,-83.58,-85.3,-100.67,-97.5,-91.45,-105.02,-97.83,-99.17,-93.5,-89.65,-80.4,-94.4,-99.75,-96.77,-85.95,-94.68,-93.17,-79.75,-104.37,-96.08,-92.8,-114.75,-86.22,-98.55,-103.4,-96.55,-94.42,-86.53,-95.1,-102.97,-95.42,-83.58,-80.6,-98.78,-89.03,-72.7,-83.7,-80.4,-96.65,-96.6,-102.67,-102.18,-90.55,-95.17,-97.92,-92.02,-93.63,-89.25,-94.03,-97.95,-87.9,-88.22,-92.82,-82.1,-99.75,-87.42,-91.6,-88.5,-82.72,-93.25,-86.37,-103.37,-98.02,-96.4,-91.63,-95.47,-90.57,-104.65,-104.52,-102.55,-82.6,-94.35,-80.42,-91.92,-97.12,-87.37,-94.3,-88.7,-85.57,-104.13,-86.38,-99.72,-95.42,-102.53,-84.8,-97.93,-77.07,-78.88,-94.43,-95.05,-95.62,-92.98,-90.93,-90.63,-79.72,-95.15,-97.38,-81.25,-86.7,-94.37,-117.45,-82.75,-100.6,-97.58,-92.42,-96.2,-89.38,-92.07,-90.52,-100.48,-81.77,-81.77,-86.63,-83.25,-96.67,-94.88,-84.1,-100.38,-82.37,-87.98,-104.02,-102.32,-116.37,-78.42,-99.63,-101.33,-89.37,-99.63,-99.33,-100.45,-100.27,-102.8,-74.8,-91.38,-101.82,-101.82,-89.63,-101.9,-78.97,-106.63,-89.97,-104.2,-97.63,-96.8,-104.33,-102.82,-82.53,-87.0,-87.98,-93.47,-97.45,-89.33,-101.42,-102.3,-95.65,-91.37,-96.65,-99.75,-106.75,-96.77,-97.85,-80.47,-85.25,-97.7,-93.55,-118.0,-96.63,-89.32,-99.2,-98.18,-82.93,-98.08,-84.57,-90.5,-95.12,-95.07,-76.65,-80.83,-97.28,-99.23,-102.38,-96.72,-97.4,-88.33,-82.75,-96.32,-93.53,-96.0,-97.12,-72.03,-101.88,-76.53,-82.62,-86.48,-83.02,-99.18,-97.42,-91.4,-85.8,-96.85,-97.52,-99.02,-90.95,-96.38,-84.72,-98.78,-101.43,-81.55,-86.13,-83.75,-84.32,-79.57,-102.95,-97.52,-102.48,-97.53,-99.12,-80.63,-98.57,-81.27,-89.8,-77.9,-101.38,-90.63,-97.78,-84.95,-90.72,-89.67,-94.52,-96.07,-80.4,-97.33,-90.67,-93.92,-97.93,-97.63,-94.03,-100.73,-100.72,-109.23,-96.23,-85.9,-97.85,-103.07,-82.07,-97.87,-86.9,-82.7,-90.8,-87.4,-103.37,-73.32,-110.08,-89.82,-91.65,-96.1,-111.9,-82.97,-92.33,-88.5,-92.32,-91.77,-87.68,-87.75,-82.07,-88.12,-90.78,-98.55,-77.13,-95.32,-76.25,-82.62,-90.13,-122.25,-102.08,-98.47,-99.3,-103.38,-93.43,-97.25,-80.5,-80.58,-117.08,-81.98,-100.88,-101.57,-100.65,-97.35,-101.6,-89.62,-94.92,-92.52,-91.33,-96.6,-87.83,-86.5,-87.7,-96.28,-97.97,-98.95,-98.19,-89.48,-77.32,-79.99,-78.28,-90.71,-97.64,-98.99,-99.91,-94.53,-95.67,-94.47,-96.88,-94.93,-98.04,-83.8904,-97.8338,-80.0672,-82.191,-92.928,-91.8155,-96.71,-99.86,-87.6591,-97.8454,-87.2697,-84.6889,-82.1998,-87.3756,-78.3232,-96.0266,-101.47,-83.65,-98.58,-87.9153,-100.77,-95.57,-79.0162,-73.91,-100.564,-88.889,-96.4843,-87.0,-95.8126,-80.57,-77.0256,-83.0453,-77.592,-86.5429,-76.8901,-86.8502,-99.5787,-100.0,-92.9605,-76.67,-95.5771,-93.1902,-98.942,-91.842,-88.1663,-85.87,-97.3621,-74.579,-99.2,-81.55,-101.716,-82.6655,-89.692,-92.0074,-90.9038,-98.2257,-91.3733,-102.742,-88.1976,-89.6408,-92.3045,-94.03,-100.818,-100.435,-97.2698,-97.0883,-100.607,-96.4493,-96.341,-86.5919,-84.7015,-93.265,-103.9754,-97.49,-91.2827,-103.15,-88.0344,-84.4126,-92.7315,-88.9441,-92.1904,-89.0355,-110.8019,-101.79,-88.2448,-87.7038,-91.9741,-95.0889,-121.64,-91.9828,-90.925,-101.1154,-82.914,-85.5413,-87.8012,-92.4768,-91.9414,-96.4298,-90.5208,-86.5677,-81.3658,-97.179,-92.8534,-92.4836,-88.3524,-96.9627,-99.8055,-84.7821,-89.9178,-97.4,-81.01,-96.73,-88.1968,-96.458,-83.3347,-97.6845,-89.933,-75.2266,-99.33,-96.39,-96.64,-88.9027,-85.8392,-75.6398,-97.654,-99.1888,-105.32,-95.495,-85.1807,-94.64,-88.2825,-90.25]},"kind":"numeric","n":70022,"n_null":0,"n_unique":17912,"null_rate":0.0,"stats":{"iqr":11.70942500000001,"kurtosis":2.1562389272774656,"max":-64.7151,"mean":-92.73807187169747,"median":-93.5,"min":-163.53,"n_outliers":951,"outlier_rate":0.013581445831310159,"q1":-98.4,"q3":-86.690575,"skew":-0.322938160414178,"std":8.676753425244774,"zero_rate":0.0}},{"alerts":[{"code":"null_rate","level":"warn","message":"37.6% null"}],"column":"elat","extras":{"histogram":{"counts":[33,6,8,26,1,0,41,262,369,534,668,1952,2190,3083,3018,3496,3427,2899,2790,3133,3414,3272,2540,2078,1428,1122,745,676,443,1,0,0,0,0,1,0,0,0,1,2],"edges":[17.7212,18.80367,19.88614,20.968609999999998,22.05108,23.13355,24.21602,25.29849,26.38096,27.463430000000002,28.5459,29.62837,30.71084,31.793309999999998,32.87578,33.95825,35.04072,36.12319,37.20566,38.288129999999995,39.370599999999996,40.45307,41.53554,42.61801,43.70048,44.78295,45.86542,46.94789,48.03036,49.11283,50.1953,51.277770000000004,52.360240000000005,53.442710000000005,54.525180000000006,55.60765000000001,56.69012000000001,57.77259000000001,58.855059999999995,59.937529999999995,61.02]},"sample":[38.93,32.42,33.52,41.33,32.57,40.6,36.98,39.75,42.94,42.97,40.87,40.7,34.43,35.58,37.17,34.92,32.38,36.67,47.65,40.32,30.9,39.77,34.18,39.53,43.12,37.88,36.67,33.95,46.88,39.32,32.15,35.57,39.15,34.33,42.55,19.67,31.95,47.37,44.03,31.4,29.75,36.15,41.18,41.58,43.87,31.23,39.1,40.32,38.03,36.63,34.92,31.83,38.25,42.92,34.12,32.03,41.62,32.45,34.77,38.9,40.55,36.78,34.47,34.58,32.28,32.65,37.72,41.6,25.9,43.45,40.15,36.9,30.77,35.58,35.87,38.58,26.02,30.07,32.7,31.5,43.2,41.88,40.48,44.12,34.62,37.32,35.28,40.48,41.15,38.05,31.35,41.57,43.0,33.53,36.02,36.42,41.55,41.77,34.87,30.03,36.23,34.78,35.62,35.9,33.33,39.47,37.08,43.18,34.57,32.18,44.88,44.75,39.42,39.95,39.75,38.97,39.82,40.18,28.35,36.92,27.45,27.78,38.17,33.68,45.23,34.08,34.3,27.78,43.0,30.53,31.57,37.28,37.97,41.53,40.17,33.73,40.45,41.52,41.37,33.8,40.47,38.97,41.4,42.52,42.05,33.47,42.63,30.65,41.08,29.75,36.38,35.63,33.75,33.12,30.45,37.78,30.42,36.82,34.98,35.08,40.27,35.88,42.68,28.17,40.52,40.17,33.27,46.67,36.55,39.63,32.05,42.92,31.37,33.58,37.08,39.63,37.5,32.63,33.78,30.42,39.52,41.68,35.27,35.13,36.3,38.73,43.5,47.5,43.15,40.95,30.78,43.03,46.53,34.83,29.28,30.92,35.03,36.22,36.37,37.3,35.2,41.6,41.58,35.65,42.78,47.6,39.3,44.12,46.22,41.23,34.7,47.88,40.65,42.32,41.55,45.15,32.15,36.53,30.42,30.88,30.95,32.33,41.1,35.87,26.42,28.55,46.73,43.12,36.67,35.97,43.13,43.38,43.28,37.83,48.45,39.63,48.82,39.23,36.58,26.45,27.32,42.45,31.17,31.33,34.9,34.1,33.73,45.1,40.52,33.08,41.27,48.0,47.68,37.03,40.38,33.73,40.82,48.97,33.28,43.17,43.32,32.58,37.39,37.54,33.65,40.82,39.32,35.82,31.67,38.1,36.42,32.77,31.52,31.5,33.65,38.9,36.38,39.38,35.5,31.9,24.7,32.29,46.45,46.91,43.45,42.73,38.27,30.62,31.66,34.18,36.73,32.76,33.71,41.68,33.98,46.83,37.94,41.76,42.46,37.2909,33.3061,34.4793,32.1144,34.6136,30.2111,35.206,43.77,38.86,38.5614,35.0683,36.5909,35.484,37.6042,35.424,41.82,35.7508,45.9973,43.5513,43.9296,26.544,34.596,33.1484,34.2483,40.0489,39.064,35.6041,37.0495,34.5707,34.4639,36.9583,35.23,37.18,37.365,35.44,34.19,40.9995,45.2507,35.618,35.9608,37.3991,37.41,37.7414,46.0175,46.6316,35.6695,37.8816,38.1163,38.1955,38.3632,40.7187,42.8433,31.54,43.04,37.12,35.7253,33.735,32.408,41.6774,39.0299,41.8823,41.4014,40.7426,38.4596,38.447,30.6058,34.1776,39.87,44.1256,42.5743,44.0549,42.7735,45.8374,42.983,40.1835,35.6573,35.476,40.11,32.5369,34.1271,32.6429,31.3405,32.7729,31.3029,29.7876,37.491,38.6101,37.83,38.0791,36.1388,34.3028,44.412,38.7413,39.1999,41.5751,31.0912,37.8074,35.8031,31.5313,30.9425,31.696,38.6199,36.07,34.1008,44.0359,41.4133,42.08,39.65,37.2349,38.955,29.9646,29.7829,34.758,35.5556,38.8008,34.6021,41.7219,36.5978,36.0327,40.8982,39.68,44.7002,42.3666,41.86,47.3994,39.4103,44.7362,35.552,40.3626,30.0298,34.946,37.9143,47.6436,44.353,43.6751,39.595,39.658,37.0767,45.71,32.3373,32.4504,43.1971,33.6163,17.7212,44.843,33.8359,33.37,39.122,28.1203,31.9194,34.0492,35.934,32.7622,32.7476,38.1744,37.92,41.3487,48.6702,35.252,36.0277,42.3975,39.76,35.5223,32.7619,30.7499,36.5568,35.1635,35.5561,33.9544,33.3324,36.4279,36.5627,38.5735,40.02,34.4237,30.5457,33.225,41.5388,35.27,32.4626,31.9544,33.1125,45.9063,38.64,33.6524,37.2024,41.19,38.93,27.46,41.5468,35.3325,36.5052,33.0069,40.2701,35.021,35.031,40.0877,36.3731,30.17,35.89,39.2887]},"kind":"numeric","n":70022,"n_null":26363,"n_unique":16965,"null_rate":0.37649595841307015,"stats":{"iqr":7.419999999999995,"kurtosis":-0.4085161188476296,"max":61.02,"mean":37.261985941043086,"median":37.1309,"min":17.7212,"n_outliers":78,"outlier_rate":0.0017865732151446437,"q1":33.49,"q3":40.91,"skew":0.0340422275632008,"std":4.941523264483757,"zero_rate":0.0}},{"alerts":[{"code":"null_rate","level":"warn","message":"37.6% null"}],"column":"elon","extras":{"histogram":{"counts":[2,9,25,8,0,0,0,1,0,0,0,0,0,0,0,8,157,158,142,82,173,176,177,774,2464,3415,5507,5157,4463,4668,4417,3706,2739,2302,1344,1056,303,152,47,27],"edges":[-163.53,-161.0596275,-158.589255,-156.1188825,-153.64851,-151.1781375,-148.707765,-146.2373925,-143.76702,-141.2966475,-138.826275,-136.3559025,-133.88553000000002,-131.41515750000002,-128.944785,-126.4744125,-124.00404,-121.5336675,-119.06329500000001,-116.5929225,-114.12255,-111.65217750000001,-109.181805,-106.7114325,-104.24106,-101.77068750000001,-99.30031500000001,-96.8299425,-94.35957,-91.88919750000001,-89.418825,-86.9484525,-84.47808,-82.00770750000001,-79.53733500000001,-77.0669625,-74.59659,-72.12621750000001,-69.655845,-67.1854725,-64.7151]},"sample":[-94.23,-90.78,-90.87,-106.2,-89.08,-92.62,-97.27,-90.27,-85.32,-83.55,-85.12,-96.85,-91.92,-85.9,-96.67,-87.03,-90.77,-95.57,-95.27,-75.47,-91.83,-89.85,-83.93,-98.15,-96.87,-90.73,-97.55,-79.17,-94.23,-94.17,-102.15,-90.7,-97.87,-102.03,-88.98,-156.0,-97.2,-97.73,-98.68,-88.17,-95.58,-98.8,-92.97,-70.85,-89.0,-98.73,-91.15,-91.42,-84.07,-84.88,-102.4,-91.73,-99.18,-100.55,-86.33,-98.23,-94.83,-89.23,-99.15,-94.65,-88.85,-96.98,-87.05,-100.53,-90.33,-94.75,-99.98,-88.2,-97.55,-93.47,-89.37,-89.33,-98.33,-99.0,-91.75,-89.6,-80.15,-84.3,-91.87,-90.78,-76.17,-96.97,-75.67,-95.9,-91.38,-76.9,-84.6,-98.95,-99.9,-96.13,-90.62,-93.23,-90.68,-84.62,-81.42,-94.7,-73.03,-71.37,-82.55,-97.13,-87.97,-85.47,-101.6,-84.88,-87.32,-95.97,-89.92,-89.15,-102.28,-93.72,-117.1,-97.37,-97.82,-96.88,-100.62,-105.2,-104.43,-100.42,-80.72,-94.13,-82.62,-81.8,-86.5,-88.33,-94.25,-80.78,-80.55,-82.47,-92.7,-95.83,-83.02,-76.4,-90.33,-89.92,-97.5,-117.12,-90.1,-93.52,-75.75,-79.67,-85.87,-89.72,-97.5,-84.63,-92.88,-88.32,-103.28,-92.82,-76.83,-82.98,-97.18,-91.27,-90.73,-90.12,-86.9,-98.55,-95.48,-98.35,-102.0,-99.87,-98.95,-98.05,-103.87,-82.73,-99.12,-89.38,-111.42,-109.68,-80.55,-100.97,-87.7,-112.63,-101.63,-86.85,-90.0,-90.52,-104.13,-87.65,-91.98,-83.07,-98.7,-93.63,-95.88,-91.85,-93.83,-94.23,-95.67,-97.15,-101.33,-103.12,-89.77,-92.43,-96.28,-86.57,-96.1,-93.08,-98.67,-91.98,-86.42,-100.93,-93.9,-88.58,-87.48,-88.35,-96.92,-98.6,-103.5,-94.07,-94.82,-76.62,-76.73,-94.9,-85.28,-98.97,-100.97,-95.17,-102.15,-88.33,-95.48,-93.85,-92.18,-96.63,-87.62,-94.3,-99.1,-96.97,-95.77,-96.83,-88.83,-96.13,-94.93,-94.5,-92.58,-103.08,-116.83,-100.42,-104.5,-94.48,-79.42,-82.02,-81.85,-73.25,-84.73,-84.63,-93.52,-117.43,-101.6,-95.37,-99.15,-100.65,-103.32,-96.65,-95.07,-94.55,-94.47,-101.18,-105.08,-101.68,-84.57,-90.47,-89.53,-89.92,-100.02,-101.42,-89.13,-91.88,-88.45,-96.03,-91.35,-91.12,-87.2,-82.97,-83.71,-85.59,-101.77,-102.01,-83.57,-87.95,-101.01,-100.37,-81.1,-102.46,-97.33,-97.68,-84.98,-84.49,-85.5,-90.49,-85.49,-80.87,-85.17,-98.75,-93.58,-96.16,-87.13,-101.16,-93.95,-79.11,-84.78,-84.65,-82.9915,-87.0505,-86.0672,-86.4136,-91.7233,-97.366,-97.82,-103.27,-90.386,-84.454,-92.3761,-97.865,-97.5534,-95.8459,-103.67,-90.4262,-102.632,-94.0235,-93.2286,-97.7883,-98.959,-88.3345,-81.9926,-82.2784,-82.9597,-96.4325,-88.0944,-91.7763,-90.3796,-87.77,-84.88,-89.7027,-78.3296,-84.25,-84.99,-97.8507,-93.1593,-97.837,-85.7892,-93.4531,-93.27,-86.3849,-99.3827,-101.567,-94.2613,-86.2248,-82.0796,-99.5951,-99.3517,-95.8852,-97.8533,-99.84,-96.19,-87.0,-92.4743,-85.237,-93.8855,-93.8845,-97.6667,-79.7841,-91.3407,-86.0471,-88.2779,-84.5363,-90.7058,-86.1319,-104.04,-94.3451,-89.4915,-98.8248,-82.8316,-93.8817,-96.018,-99.6852,-87.5841,-97.64,-102.74,-83.0042,-81.256,-97.562,-103.355,-98.5037,-97.8701,-81.4203,-102.715,-96.8087,-76.62,-88.6785,-85.5695,-116.4,-83.9448,-97.5117,-96.8252,-92.4919,-90.1014,-78.2372,-80.3009,-86.7185,-99.1774,-95.075,-101.4053,-100.55,-95.3468,-96.3463,-89.3583,-101.81,-104.11,-88.7351,-86.5853,-90.1629,-94.8774,-96.534,-88.0731,-86.0126,-102.2886,-90.6933,-93.5965,-104.1487,-85.956,-103.13,-94.5186,-89.6911,-99.59,-94.2842,-82.2313,-122.9666,-97.298,-89.792,-90.7376,-99.312,-96.8761,-95.9222,-104.0556,-99.6402,-103.931,-103.784,-97.142,-92.77,-90.1042,-99.7607,-112.45,-105.7407,-64.7151,-94.2683,-78.6775,-84.811,-75.782,-81.965,-94.7755,-78.8464,-90.5227,-87.1826,-84.7321,-101.9611,-102.31,-72.828,-97.9684,-92.4421,-85.0326,-94.882,-101.71,-90.2417,-92.2488,-91.8492,-102.8362,-103.2629,-86.1183,-83.2464,-96.6613,-89.1176,-86.7961,-83.5087,-103.93,-94.9612,-96.4363,-94.1325,-90.7248,-94.116,-90.8085,-89.8341,-81.0357,-96.2542,-89.01,-102.5644,-99.5133,-95.56,-98.3894,-80.47,-88.0968,-76.7147,-86.8113,-85.4552,-74.5931,-98.003,-97.661,-76.7705,-100.7284,-83.824,-76.83,-102.0033]},"kind":"numeric","n":70022,"n_null":26363,"n_unique":18586,"null_rate":0.37649595841307015,"stats":{"iqr":11.260000000000005,"kurtosis":3.7660837497852473,"max":-64.7151,"mean":-92.19334524611192,"median":-92.47,"min":-163.53,"n_outliers":647,"outlier_rate":0.014819395771776725,"q1":-97.73,"q3":-86.47,"skew":-0.5953830018471938,"std":8.54527082662728,"zero_rate":0.0}},{"alerts":[{"code":"one_word","level":"warn","message":"100.0% rows are a single word"},{"code":"allcaps","level":"info","message":"100.0% rows are all-caps"},{"code":"short_text","level":"info","message":"95th-percentile length under 20 chars"},{"code":"duplicates","level":"warn","message":"94.8% duplicate strings"}],"column":"len","extras":{"language_counts":{},"language_sample_size":5000,"length_histogram":{"counts":[47630,0,0,0,0,0,0,0,11687,0,0,0,0,0,0,0,795,0,0,0,0,0,0,0,9118,0,0,0,0,0,0,0,789,0,0,0,0,0,0,3],"edges":[3.0,3.125,3.25,3.375,3.5,3.625,3.75,3.875,4.0,4.125,4.25,4.375,4.5,4.625,4.75,4.875,5.0,5.125,5.25,5.375,5.5,5.625,5.75,5.875,6.0,6.125,6.25,6.375,6.5,6.625,6.75,6.875,7.0,7.125,7.25,7.375,7.5,7.625,7.75,7.875,8.0]},"near_unique":false,"sample":["0.2","0.22","5.4400","0.21","0.3","2.2100","0.8","1.7000","0.8","0.2","0.1","0.5","0.5","1.5","1.0","0.9","1.0","0.25","3.2600","0.2","0.1","3.0","0.1","0.1","0.1","0.07","0.1","1.0","0.1","0.6900","1.2","0.2","7.8","0.1","0.1","0.5","3.6200","0.1","3.0","1.0","1.46","0.4800","0.1","0.1000","0.0500","0.0100","0.2","0.8","0.4","7.1000"],"top_values":[["0.1",15456],["0.5",4842],["1.0",4603],["0.2",4447],["2.0",2724],["0.3",2410],["3.0",1145],["1.5",1087],["5.0",738],["4.0",682],["0.8",572],["2.5",509],["6.0",457],["0.4",405],["8.0",399],["7.0",375],["10.0",363],["0.0100",361],["0.7",349],["0.1000",253]],"top_words":[["0.1",4310],["0.5",1364],["1.0",1312],["0.2",1276],["2.0",783],["0.3",686],["3.0",335],["1.5",327],["5.0",205],["4.0",180],["2.5",164],["0.8",162],["6.0",129],["8.0",121],["0.4",109],["10.0",107],["0.0100",102],["0.7",98],["7.0",93],["0.1000",76],["2.3",71],["0.6",71],["9.0",68],["0.25",66],["3.5",62]],"vocab_skipped":null,"word_histogram":{"counts":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,70022,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"edges":[0.5,0.5333333333333333,0.5666666666666667,0.6,0.6333333333333333,0.6666666666666666,0.7,0.7333333333333334,0.7666666666666666,0.8,0.8333333333333333,0.8666666666666667,0.9,0.9333333333333333,0.9666666666666667,1.0,1.0333333333333332,1.0666666666666667,1.1,1.1333333333333333,1.1666666666666665,1.2,1.2333333333333334,1.2666666666666666,1.3,1.3333333333333335,1.3666666666666667,1.4,1.4333333333333333,1.4666666666666668,1.5]}},"kind":"text","n":70022,"n_null":0,"n_unique":3663,"null_rate":0.0,"stats":{"allcaps_rate":1.0,"boilerplate_rate":0.0,"duplicate_rate":0.9476878695267201,"emoji_rate":0.0,"len_max":8,"len_mean":3.6255462568906913,"len_median":3.0,"len_min":3,"len_p95":6.0,"n_duplicates":66359,"n_empty":0,"one_word_rate":1.0,"readability_flesch_mean":121.22000000000004,"url_rate":0.0,"vocab_size":2204,"word_mean":1.0,"word_median":1.0}},{"alerts":[],"column":"wid","extras":{"singletons":171,"top_values":[["10",14417],["50",10366],["100",7067],["30",4772],["20",4368],["200",2946],["25",2452],["150",2101],["40",1967],["75",1906],["300",1430],["33",1160],["17",1037],["400",944],["23",812],["250",765],["60",737],["440",677],["500",636],["80",573]]},"kind":"categorical","n":70022,"n_null":0,"n_unique":419,"null_rate":0.0,"stats":{"cardinality":419,"entropy":4.463386826152722,"entropy_ratio":0.5123965111755086,"top_rate":0.20589243380651795,"top_value":"10"}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","columns.state.top_values","columns.state.top_rate","columns.fatalities.top_rate","columns.injuries.top_rate","columns.mag.top_values","columns.mag.top_rate","columns.elat.null_rate","columns.elon.null_rate","columns.slat.stats","columns.slon.stats"],"featured_charts":[{"caption":"Top tornado states \u2014 Texas, Kansas, and Oklahoma dominate the count.","column":"state","kind":"bar"},{"caption":"Magnitude distribution skews heavily toward weak (0\u20131) tornadoes.","column":"mag","kind":"bar"},{"caption":"Fatalities are 0 in roughly 98% of events; the deadly tail is tiny but important.","column":"fatalities","kind":"donut"},{"caption":"Starting latitudes cluster around 37\u00b0N, consistent with the U.S. tornado belt.","column":"slat","kind":"histogram"},{"caption":"Starting longitudes concentrate around -93\u00b0, reinforcing the central-U.S. footprint.","column":"slon","kind":"histogram"}],"model":"anthropic:claude-opus-4-7","narrative":"This is a tornado event log with 70,022 rows and 13 columns covering dates, times, start/end coordinates, magnitudes, widths, fatalities, injuries, and U.S. state. Geographically it is a U.S.-centered dataset: starting longitudes average around -92.7 and latitudes around 37.1, with Texas (13.3% of records), Kansas, and Oklahoma leading the state counts. The severity fields are highly imbalanced \u2014 fatalities are 0 in 97.7% of events and injuries are 0 in 88.8% \u2014 so any analysis of harm should focus on the rare non-zero tail. Magnitude (mag) is a more usable categorical signal with 7 levels, dominated by 0 (46%) and 1 (34%). Note that the end-coordinate columns (elat, elon) are null in ~37.7% of rows, which matters if you plan to draw tornado tracks rather than just start points.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["kind","n","n_unique","null_rate","stats.len_min","stats.len_max","stats.one_word_rate","stats.duplicate_rate","stats.n_duplicates","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a date column stored as ISO-formatted text (YYYY-MM-DD), with every value exactly 10 characters long and one token. Across 70,022 rows there are only 12,639 unique dates and an 81.9% duplicate rate, so many records share dates \u2014 top value 2011-04-27 appears 207 times. The range spans at least 1974-04-03 to 2023-03-31, suggesting it was misclassified as text rather than a date type.","role":"timestamp","scope":"column","target":"date","treatment":"Cast to a proper date type and use for temporal joins or time-based features."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.len_min","stats.len_max","stats.duplicate_rate","stats.one_word_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds clock times stored as 8-character HH:MM:SS strings, with all 70,022 rows non-null and uniform length (len_min=len_max=8). Only 1,438 distinct values appear and 97.95% are duplicates, with afternoon/evening slots like 16:00:00 (978), 17:00:00 (971) and 15:00:00 (959) dominating \u2014 consistent with event start times rather than free text. It's mistyped as text: parse to a proper time type before use.","role":"timestamp","scope":"column","target":"time","treatment":"Cast to a time type and bucket by hour for 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 US state code column with 53 distinct values, slightly more than the 50 states (likely including DC and territories like PR). TX dominates at 13.3% of 70,022 rows, followed by KS (4,474) and OK (4,221), giving a clear southern/plains skew rather than a uniform national distribution. Entropy ratio of 0.847 confirms the distribution is fairly spread but not flat, and there are no nulls.","role":"feature","scope":"column","target":"state","treatment":"One-hot or target-encode; consider grouping low-frequency states into an 'Other' bucket."},{"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":"`mag` is a low-cardinality categorical with 7 distinct values dominated by '0' (46% of 70022 rows) and decreasing counts through '1','2','3','4','5'. The ordered integer levels suggest a magnitude or severity code rather than a free category, and the presence of '-9' (1024 rows) is the standout signal \u2014 almost certainly a sentinel for missing/unknown that is not being counted as null.","role":"feature","scope":"column","target":"mag","treatment":"Recode '-9' as missing, then treat as an ordinal feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_rate","stats.top_value","stats.entropy_ratio","stats.cardinality","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Counts of injuries stored as strings, with 209 distinct values across 70,022 rows and no nulls. The distribution is severely zero-inflated: '0' accounts for 88.8% of records, and entropy ratio is just 0.123. Tail values like '1' through '10' decay quickly but 209 unique tokens suggests very long tails or non-integer entries worth inspecting.","role":"numeric_target","scope":"column","target":"injuries","treatment":"Cast to integer and model as a zero-inflated count (e.g., hurdle or ZIP regression)."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.top_rate","stats.top_value","stats.entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a fatality count per event, stored as a categorical/string field with 50 distinct integer values and no nulls across 70,022 rows. The distribution is extremely imbalanced: '0' accounts for 97.72% of records, giving an entropy ratio of just 0.039, with '1' at 830 rows and a long thin tail (2 \u2192 277, 3 \u2192 134, down to single-digit counts at higher values). Despite being typed as categorical, the values are numeric and ordered, so the current encoding is likely a load artifact.","role":"numeric_target","scope":"column","target":"fatalities","treatment":"Cast to integer and model as a zero-inflated count rather than a categorical."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","stats.one_word_rate","stats.duplicate_rate","stats.len_max","stats.len_min","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Numeric loss values stored as text strings, with all 70,022 entries being single tokens (one_word_rate 1.0) and lengths of 1-10 characters. The distribution is heavily concentrated: '0.0' alone accounts for 22,764 rows and the duplicate_rate is 0.985 across only 1,019 unique values. Mixed formatting is a hazard \u2014 '0' and '0.0' appear as separate tokens, so a naive cast will collapse them but string-based grouping won't.","role":"feature","scope":"column","target":"loss","treatment":"Cast to float (normalising '0' vs '0.0') before any modelling or aggregation."},{"confidence":"high","critiques":[],"evidence_keys":["min","max","mean","median","skew","kurtosis","iqr","q1","q3","std","n","n_unique","null_rate","zero_rate","n_outliers","outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Values range from 17.72 to 61.02 with a mean of 37.14 and median of 37.03, consistent with a starting latitude (slat) field in decimal degrees, likely covering the contiguous US. The distribution is essentially symmetric (skew 0.04, kurtosis -0.58) with a tight IQR of 7.74 and only 70 outliers (0.10%). No nulls and no zeros, and 16,016 unique values across 70,022 rows suggest repeated coordinates rather than free-form noise.","role":"feature","scope":"column","target":"slat","treatment":"Use as-is for geospatial features; optionally pair with a longitude column for distance or region encoding."},{"confidence":"high","critiques":[],"evidence_keys":["min","max","median","mean","std","q1","q3","iqr","skew","kurtosis","n_outliers","outlier_rate","null_rate","zero_rate","n_unique"],"model":"anthropic:claude-opus-4-7","narrative":"Values are negative decimal degrees ranging from -163.53 to -64.7151 with a median of -93.5, consistent with western-hemisphere longitudes (the 'slon' name suggests starting longitude). The distribution is mildly left-skewed (-0.32) and concentrated within an IQR of ~11.7 degrees around the central US longitude band. Only 951 outliers (1.36%) fall outside that range, and there are no nulls or zeros.","role":"feature","scope":"column","target":"slon","treatment":"Use as a geographic coordinate; pair with the matching latitude column for spatial features rather than treating as a standalone scalar."},{"confidence":"high","critiques":[],"evidence_keys":["column","kind","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.skew","stats.kurtosis","stats.n_outliers","stats.q1","stats.q3"],"model":"anthropic:claude-opus-4-7","narrative":"Almost certainly an event latitude in decimal degrees, with values spanning 17.72 to 61.02 \u2014 consistent with locations across North America. The distribution is roughly symmetric (skew 0.03, kurtosis -0.41) and centered near 37.26, with only 78 mild outliers. The standout concern is that 37.65% of rows are null, so coverage is partial.","role":"feature","scope":"column","target":"elat","treatment":"Pair with the matching longitude and impute or filter the 37.65% nulls before any spatial modelling."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","stats.min","stats.max","stats.median","stats.mean","stats.iqr","stats.skew","stats.kurtosis","n_unique"],"model":"anthropic:claude-opus-4-7","narrative":"This is almost certainly longitude (east coordinate), with values bounded between -163.53 and -64.7151 and a median of -92.47, consistent with points across North America. The distribution is moderately left-skewed (-0.60) with kurtosis 3.77 and a tight IQR of 11.26 around the median. Notably, 37.65% of rows are null, which will materially shrink any geo-based analysis.","role":"feature","scope":"column","target":"elon","treatment":"Pair with the matching latitude column and filter out the ~38% null rows before spatial analysis."},{"confidence":"high","critiques":[],"evidence_keys":["kind","n","n_unique","stats.len_min","stats.len_max","stats.word_mean","stats.duplicate_rate","stats.one_word_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Despite being typed as text, `len` holds short numeric tokens (length 3-8, one word each) like '0.1', '0.5', '1.0' \u2014 almost certainly a length or size measurement stored as strings. Values are highly concentrated: '0.1' alone covers 15,456 of 70,022 rows and the duplicate rate is 94.8% across only 3,663 unique tokens. The allcaps and one_word alerts are artefacts of numeric strings rather than real text signal.","role":"feature","scope":"column","target":"len","treatment":"Cast to float and treat as a numeric feature rather than text."},{"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":"wid is a categorical column with 419 distinct values, all numeric-looking strings like '10', '50', '100', '30' \u2014 almost certainly a width or weight parameter stored as text rather than a true category. The distribution is heavily concentrated on round numbers: '10' alone covers 20.6% of 70022 rows and the top ten values are all multiples of 5 or 25, giving an entropy ratio of 0.51. No nulls, but the string encoding of clearly numeric quanta is the surprise.","role":"feature","scope":"column","target":"wid","treatment":"cast to numeric and consider binning or log-transform given the round-number concentration."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":4348,"prompt_tokens":17482,"total_tokens":21830}},"language_counts":{},"meta":{"generated_at":"2026-05-01T23:12:11+00:00","mode":"full","row_count":70022,"sampled_rows":70022,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/data/quirky/tornadoes.json"},"notes":[],"saturn_version":"0.2.0","schema":{"date":"text","elat":"numeric","elon":"numeric","fatalities":"categorical","injuries":"categorical","len":"text","loss":"text","mag":"categorical","slat":"numeric","slon":"numeric","state":"categorical","time":"text","wid":"categorical"}}