{"columns":[{"alerts":[{"code":"long_tail","level":"info","message":"300 singleton categories"}],"column":"time_tag","extras":{"singletons":300,"top_values":[["2026-01-20T00:06:00",1],["2026-01-20T00:07:00",1],["2026-01-20T00:08:00",1],["2026-01-20T00:09:00",1],["2026-01-20T00:10:00",1],["2026-01-20T00:11:00",1],["2026-01-20T00:12:00",1],["2026-01-20T00:13:00",1],["2026-01-20T00:14:00",1],["2026-01-20T00:15:00",1],["2026-01-20T00:16:00",1],["2026-01-20T00:17:00",1],["2026-01-20T00:18:00",1],["2026-01-20T00:19:00",1],["2026-01-20T00:20:00",1],["2026-01-20T00:21:00",1],["2026-01-20T00:22:00",1],["2026-01-20T00:23:00",1],["2026-01-20T00:24:00",1],["2026-01-20T00:25:00",1]]},"kind":"categorical","n":300,"n_null":0,"n_unique":300,"null_rate":0.0,"stats":{"cardinality":300,"entropy":8.228818690495883,"entropy_ratio":1.0000000000000002,"top_rate":0.0033333333333333335,"top_value":"2026-01-20T00:06:00"}},{"alerts":[{"code":"outliers","level":"warn","message":"15.3% rows beyond 1.5 IQR"}],"column":"kp_index","extras":{"histogram":{"counts":[4,0,4,0,0,16,0,0,22,0,0,17,0,0,65,0,172],"edges":[0.0,0.35294117647058826,0.7058823529411765,1.0588235294117647,1.411764705882353,1.7647058823529413,2.1176470588235294,2.4705882352941178,2.823529411764706,3.1764705882352944,3.5294117647058827,3.882352941176471,4.235294117647059,4.588235294117648,4.9411764705882355,5.294117647058824,5.647058823529412,6.0]},"sample":[4.0,4.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,0.0,0.0,0.0,0.0,1.0,1.0,1.0,1.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,2.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,4.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0,5.0]},"kind":"numeric","n":300,"n_null":0,"n_unique":7,"null_rate":0.0,"stats":{"iqr":1.0,"kurtosis":2.1486339817509457,"max":6.0,"mean":5.09,"median":6.0,"min":0.0,"n_outliers":46,"outlier_rate":0.15333333333333332,"q1":5.0,"q3":6.0,"skew":-1.6832634492324496,"std":1.3958490780988577,"zero_rate":0.013333333333333334}},{"alerts":[{"code":"outliers","level":"warn","message":"6.0% rows beyond 1.5 IQR"}],"column":"estimated_kp","extras":{"histogram":{"counts":[4,2,2,0,6,4,6,6,16,10,4,3,63,2,0,4,168],"edges":[0.0,0.3723529411764706,0.7447058823529412,1.1170588235294119,1.4894117647058824,1.861764705882353,2.2341176470588238,2.606470588235294,2.978823529411765,3.3511764705882356,3.723529411764706,4.095882352941176,4.4682352941176475,4.840588235294118,5.212941176470588,5.585294117647059,5.95764705882353,6.33]},"sample":[3.67,4.33,5.67,5.67,5.67,5.67,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.0,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,6.33,0.0,0.0,0.33,0.33,0.67,0.67,1.0,1.0,1.67,1.67,1.67,1.67,1.67,1.67,2.0,2.0,2.0,2.0,2.33,2.33,2.33,2.33,2.33,2.33,2.67,2.67,2.67,2.67,2.67,2.67,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.0,3.33,3.33,3.33,3.33,3.33,3.33,3.33,3.67,3.67,3.67,3.67,3.67,3.67,3.67,3.67,3.67,4.0,4.0,4.0,4.0,4.33,4.33,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,4.67,5.0,5.0,4.67,4.67,4.67,4.67,4.67,4.67]},"kind":"numeric","n":300,"n_null":0,"n_unique":18,"null_rate":0.0,"stats":{"iqr":1.6600000000000001,"kurtosis":0.9484977849120471,"max":6.33,"mean":5.1834999999999996,"median":6.33,"min":0.0,"n_outliers":18,"outlier_rate":0.06,"q1":4.67,"q3":6.33,"skew":-1.2951656475609759,"std":1.5383553579579263,"zero_rate":0.006666666666666667}},{"alerts":[],"column":"activity","extras":{"singletons":0,"top_values":[["Moderate Storm",172],["Minor Storm",65],["Unsettled",38],["Active",17],["Quiet",8]]},"kind":"categorical","n":300,"n_null":0,"n_unique":5,"null_rate":0.0,"stats":{"cardinality":5,"entropy":1.689886825603473,"entropy_ratio":0.727794641584476,"top_rate":0.5733333333333334,"top_value":"Moderate Storm"}},{"alerts":[{"code":"outliers","level":"warn","message":"15.3% rows beyond 1.5 IQR"}],"column":"intensity","extras":{"histogram":{"counts":[4,0,4,0,0,16,0,0,22,0,0,17,0,0,65,0,172],"edges":[0.0,0.03923529411764706,0.07847058823529413,0.11770588235294119,0.15694117647058825,0.1961764705882353,0.23541176470588238,0.27464705882352947,0.3138823529411765,0.35311764705882354,0.3923529411764706,0.4315882352941177,0.47082352941176475,0.5100588235294118,0.5492941176470589,0.588529411764706,0.627764705882353,0.667]},"sample":[0.444,0.444,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.667,0.0,0.0,0.0,0.0,0.111,0.111,0.111,0.111,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.222,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.333,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.444,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556,0.556]},"kind":"numeric","n":300,"n_null":0,"n_unique":7,"null_rate":0.0,"stats":{"iqr":0.11099999999999999,"kurtosis":2.1391894446629074,"max":0.667,"mean":0.56578,"median":0.667,"min":0.0,"n_outliers":46,"outlier_rate":0.15333333333333332,"q1":0.556,"q3":0.667,"skew":-1.6820633422890485,"std":0.15530037224272547,"zero_rate":0.013333333333333334}},{"alerts":[{"code":"long_tail","level":"info","message":"298 singleton categories"}],"column":"solar_wind_time","extras":{"singletons":298,"top_values":[["2026-01-20 03:58:00.000",2],["2026-01-20 00:06:00.000",1],["2026-01-20 00:07:00.000",1],["2026-01-20 00:08:00.000",1],["2026-01-20 00:09:00.000",1],["2026-01-20 00:10:00.000",1],["2026-01-20 00:11:00.000",1],["2026-01-20 00:12:00.000",1],["2026-01-20 00:13:00.000",1],["2026-01-20 00:14:00.000",1],["2026-01-20 00:15:00.000",1],["2026-01-20 00:16:00.000",1],["2026-01-20 00:17:00.000",1],["2026-01-20 00:18:00.000",1],["2026-01-20 00:19:00.000",1],["2026-01-20 00:20:00.000",1],["2026-01-20 00:21:00.000",1],["2026-01-20 00:22:00.000",1],["2026-01-20 00:23:00.000",1],["2026-01-20 00:24:00.000",1]]},"kind":"categorical","n":300,"n_null":0,"n_unique":299,"null_rate":0.0,"stats":{"cardinality":299,"entropy":8.222152023829217,"entropy_ratio":0.9997750911974288,"top_rate":0.006666666666666667,"top_value":"2026-01-20 03:58:00.000"}},{"alerts":[],"column":"solar_wind_speed","extras":{"histogram":{"counts":[6,24,68,22,17,14,10,19,14,9,6,7,11,14,18,31,10],"edges":[881.6,891.5823529411765,901.564705882353,911.5470588235294,921.5294117647059,931.5117647058823,941.4941176470588,951.4764705882353,961.4588235294118,971.4411764705883,981.4235294117647,991.4058823529411,1001.3882352941176,1011.3705882352941,1021.3529411764705,1031.335294117647,1041.3176470588235,1051.3]},"sample":[1028.9,1041.1,1046.7,1049.4,1036.6,1039.8,1037.6,1033.5,1027.6,1024.3,1027.6,1018.5,1018.6,1019.3,1030.6,1029.1,1038.5,1038.6,1040.2,1043.0,1032.7,1030.5,1031.7,1033.9,1036.5,1037.4,1036.4,1034.6,1038.2,1031.7,1032.5,1033.1,1034.6,1034.6,1040.7,1035.7,1033.7,1036.6,1037.2,1035.8,1034.7,1037.1,1043.7,1047.2,1046.7,1049.4,1049.7,1051.3,1048.7,1037.0,1035.9,1012.7,1024.0,1022.9,1024.5,1028.6,1028.5,1023.9,1021.2,1027.9,1027.5,1027.2,1017.5,1027.6,1016.8,1021.3,1016.2,1025.0,1015.1,1011.5,1011.8,1011.4,1009.4,1006.1,1006.4,1008.0,1001.1,1000.6,1001.8,1004.5,1003.5,1013.0,1005.3,1003.8,1010.3,1003.8,1000.2,998.4,996.3,997.0,996.5,989.4,986.9,985.8,985.9,990.6,981.2,984.2,979.7,971.8,970.6,968.7,972.7,972.7,971.6,971.9,966.4,963.0,960.6,954.6,955.2,956.6,964.9,959.0,963.2,955.2,952.8,971.6,961.5,951.6,951.4,959.4,963.9,958.9,970.1,974.3,967.1,965.0,967.7,958.5,966.0,959.1,960.7,958.2,955.6,953.1,950.4,951.1,953.0,949.7,941.5,935.3,954.4,964.1,952.4,944.4,945.5,942.8,938.8,937.6,944.9,939.2,934.4,938.4,942.7,940.3,939.6,940.0,924.2,920.8,932.2,921.2,929.3,926.3,933.3,925.6,915.7,914.8,914.0,910.2,909.5,910.8,911.1,905.3,908.2,909.7,907.9,906.8,907.9,898.6,905.9,909.1,908.8,915.5,909.6,901.7,901.9,905.5,908.0,907.2,912.6,903.1,898.6,899.5,903.2,900.4,903.5,902.5,902.4,898.8,895.9,898.7,895.1,887.7,900.7,898.9,902.2,905.3,907.6,910.2,908.6,911.0,908.4,908.8,906.2,903.7,905.4,904.9,904.3,903.8,901.9,903.9,900.7,894.6,909.6,909.9,908.6,915.3,905.6,907.0,908.4,909.7,909.3,909.3,912.8,912.8,912.1,909.5,915.6,911.4,914.4,905.6,908.0,906.9,907.8,911.5,917.2,923.0,925.7,920.7,924.4,929.6,918.6,905.2,892.6,905.7,888.5,890.7,904.3,906.7,904.3,904.3,893.5,898.2,914.2,922.2,924.6,921.4,927.5,927.3,934.6,929.4,936.0,937.4,914.5,916.2,924.3,926.1,922.0,921.7,920.6,916.6,908.9,908.6,907.8,907.4,903.4,903.8,895.8,888.4,898.0,893.2,895.2,899.7,898.1,897.5,898.4,894.8,888.9,881.6]},"kind":"numeric","n":300,"n_null":0,"n_unique":266,"null_rate":0.0,"stats":{"iqr":99.80000000000007,"kurtosis":-1.322905701430791,"max":1051.3,"mean":955.7919999999999,"median":940.15,"min":881.6,"n_outliers":0,"outlier_rate":0.0,"q1":908.55,"q3":1008.35,"skew":0.45061562214941653,"std":51.97797709617058,"zero_rate":0.0}},{"alerts":[],"column":"solar_wind_density","extras":{"histogram":{"counts":[6,15,28,29,37,33,34,38,34,31,6,4,1,2,1,0,1],"edges":[0.23,0.7058823529411765,1.181764705882353,1.6576470588235295,2.133529411764706,2.6094117647058823,3.085294117647059,3.561176470588235,4.037058823529412,4.512941176470589,4.988823529411765,5.464705882352941,5.940588235294118,6.416470588235295,6.892352941176471,7.368235294117648,7.844117647058824,8.32]},"sample":[3.52,4.08,3.68,4.56,4.53,4.78,4.52,4.68,5.73,6.38,6.6,6.77,5.8,8.32,7.31,4.31,5.04,5.05,3.29,4.36,4.11,3.75,3.95,4.05,3.64,3.53,3.68,2.83,2.55,3.54,3.76,3.44,3.61,3.81,4.14,3.54,2.79,2.44,2.38,2.49,2.6,2.42,2.3,2.64,2.45,2.95,1.77,2.66,1.77,3.05,3.16,5.18,3.44,2.76,2.87,2.8,2.79,3.47,3.85,2.9,2.95,2.63,3.23,2.6,4.43,2.9,4.52,2.95,4.96,4.43,4.8,4.54,4.57,5.22,4.54,5.06,4.44,5.88,4.15,3.13,3.38,4.59,2.85,2.52,4.24,3.34,4.32,4.39,3.52,3.37,3.15,3.43,3.35,3.28,3.88,3.81,4.06,3.94,4.06,4.24,4.35,4.59,4.22,3.86,3.86,3.95,3.76,3.33,4.15,4.62,3.12,5.4,4.76,4.23,4.75,4.62,4.56,3.76,4.24,3.92,3.93,4.58,4.52,4.79,4.66,3.81,3.61,3.44,3.53,4.45,4.24,4.46,3.84,4.13,3.29,3.57,3.93,3.88,4.11,2.55,4.03,3.21,4.42,2.81,4.74,3.38,4.33,3.26,3.71,4.02,3.03,4.58,5.53,4.87,4.52,3.9,3.82,3.38,4.22,4.56,4.0,4.95,3.78,3.49,4.39,4.78,4.39,4.3,4.38,3.91,3.58,4.01,3.94,4.39,3.18,4.59,3.77,4.6,2.84,3.82,3.39,3.0,2.95,3.35,3.47,3.06,2.7,3.51,2.54,3.06,2.46,2.64,1.41,2.94,2.39,2.16,2.41,2.19,1.9,1.81,2.02,2.13,1.41,0.71,1.5,1.73,1.6,2.26,2.45,0.95,1.22,0.94,0.72,1.02,1.0,0.84,0.43,0.52,0.58,0.45,0.6,0.73,1.01,0.23,2.77,1.24,1.1,1.83,1.34,0.74,1.1,2.26,2.64,2.64,1.64,1.73,1.93,1.65,2.34,3.0,2.41,1.99,1.74,2.61,2.61,2.6,2.62,2.33,2.07,2.56,2.5,2.31,2.14,2.26,1.9,2.38,1.71,2.19,1.74,2.19,1.69,1.85,2.36,2.41,2.34,2.12,1.84,2.09,1.46,1.54,1.75,1.38,1.88,1.6,1.98,2.14,1.74,1.58,1.39,1.39,1.34,1.12,1.87,1.99,2.21,1.58,1.56,2.09,1.4,1.21,1.59,1.22,1.72,1.61,1.31,1.36,1.22,1.11,1.22,0.72]},"kind":"numeric","n":300,"n_null":0,"n_unique":215,"null_rate":0.0,"stats":{"iqr":2.0200000000000005,"kurtosis":0.11676096921646195,"max":8.32,"mean":3.1025999999999994,"median":3.1399999999999997,"min":0.23,"n_outliers":2,"outlier_rate":0.006666666666666667,"q1":2.09,"q3":4.11,"skew":0.25549158222416446,"std":1.3438306600198422,"zero_rate":0.0}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["activity.top_values","activity.top_rate","kp_index.stats","estimated_kp.stats","intensity.stats","solar_wind_speed.stats","solar_wind_density.stats","row_count"],"featured_charts":[{"caption":"Shows how 'Moderate Storm' dominates the period, with 'Quiet' barely represented.","column":"activity","kind":"bar"},{"caption":"Reveals the strong left skew with most values pinned at kp=6 and a tail of low-end outliers.","column":"kp_index","kind":"histogram"},{"caption":"Mirrors kp_index \u2014 clustered near 0.667 with ~15% outliers on the low side.","column":"intensity","kind":"histogram"},{"caption":"Confirms elevated wind speeds (881\u20131051 km/s) consistent with an active storm window.","column":"solar_wind_speed","kind":"histogram"},{"caption":"The most well-behaved numeric variable \u2014 roughly symmetric around 3.1 with few outliers.","column":"solar_wind_density","kind":"histogram"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset captures 300 minute-by-minute aurora and solar wind observations starting 2026-01-20, with 8 columns covering geomagnetic indices (kp_index, estimated_kp, intensity), solar wind conditions (speed, density), and a categorical activity label. The activity field is heavily skewed toward 'Moderate Storm' (172 of 300, ~57%), with only 8 'Quiet' readings \u2014 worth a closer look since this dominates the storyline. The kp_index and intensity columns are left-skewed and pile up at their max values (median equals max), with ~15% flagged as low-side outliers, suggesting the sample is a sustained storm period rather than a balanced range. Solar wind speed is also unusually elevated (min 881, max 1051 km/s), reinforcing that this is a storm-window snapshot rather than typical conditions.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is an ISO-8601 timestamp column at minute resolution, with all 300 values unique (entropy_ratio 1.0) and zero nulls. The visible top values form a contiguous one-minute sequence starting 2026-01-20T00:06:00, consistent with a regular time index rather than event timestamps. Cardinality equals row count, so it acts as a row key over time.","role":"timestamp","scope":"column","target":"time_tag","treatment":"Parse to datetime and use as the time index; do not one-hot encode."},{"confidence":"high","critiques":[],"evidence_keys":["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","stats.zero_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Numeric column on a small 0-6 integer scale with only 7 distinct values, consistent with a Kp geomagnetic index reading. The distribution is heavily concentrated at the high end (median and Q3 both 6.0, mean 5.09) and strongly left-skewed (skew -1.68), with 46 low-side outliers flagged (15.3%). No nulls, and zeros are rare (1.3%).","role":"feature","scope":"column","target":"kp_index","treatment":"Treat as ordinal categorical (7 levels) rather than continuous; outliers are real low-Kp readings, do not clip."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.median","stats.q3","stats.skew","stats.n_outliers","stats.outlier_rate","stats.zero_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This looks like an estimated Kp geomagnetic index value, bounded between 0.0 and 6.33 across 300 rows with only 18 unique values, consistent with the discrete third-step Kp scale. The distribution is heavily left-skewed (skew -1.30) with the median pinned at the maximum 6.33 and Q3 also at 6.33, meaning at least half the rows sit at the ceiling. 18 low-side outliers (6% rate) and a near-zero zero_rate (0.67%) confirm a long thin tail toward quiet conditions.","role":"feature","scope":"column","target":"estimated_kp","treatment":"Treat as ordinal/discrete and consider binning or a rank transform before modelling given the ceiling-heavy left skew."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","top_rate","top_value","top_values","entropy_ratio","null_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical descriptor of geomagnetic or space-weather activity level, with 5 ordered classes from 'Quiet' to 'Moderate Storm'. The distribution is heavily skewed toward storm conditions: 'Moderate Storm' alone accounts for 57.3% (172/300) of rows, while 'Quiet' appears just 8 times, suggesting the dataset is filtered to disturbed periods rather than representing typical activity. Entropy ratio of 0.73 confirms moderate concentration on the top class.","role":"label","scope":"column","target":"activity","treatment":"Treat as ordinal target; consider class-weighting or stratified sampling given the imbalance toward 'Moderate Storm'."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","min","max","median","mean","skew","n_outliers","outlier_rate","zero_rate","q1","q3"],"model":"anthropic:claude-opus-4-7","narrative":"Numeric 'intensity' column bounded between 0.0 and 0.667 with only 7 unique values across 300 rows, suggesting a discretised or quantised measurement rather than a continuous reading. Distribution is heavily left-skewed (skew -1.68) with median equal to the max (0.667), and 46 rows (15.3%) flagged as outliers on the low end. The handful of zeros (1.3%) and the ceiling at 0.667 hint at a capped or normalised score.","role":"feature","scope":"column","target":"intensity","treatment":"Treat as ordinal/categorical given only 7 unique values, or bin explicitly before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column is a minute-resolution timestamp of solar wind observations, all falling on 2026-01-20 with values like '2026-01-20 03:58:00.000'. With 299 unique values across 300 rows and entropy ratio 0.9997, it is effectively a per-row time index; only '2026-01-20 03:58:00.000' repeats (twice). No nulls, but the long_tail alert reflects this near-unique structure rather than meaningful categories.","role":"timestamp","scope":"column","target":"solar_wind_time","treatment":"Parse to datetime and use as the time axis; do not treat as a categorical feature."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.min","stats.max","stats.mean","stats.median","stats.std","stats.skew","stats.kurtosis","stats.n_outliers","stats.iqr"],"model":"anthropic:claude-opus-4-7","narrative":"Numeric measurements of solar wind speed across 300 records, all populated and tightly clustered between 881.6 and 1051.3 with a mean of 955.79 and median of 940.15. The distribution is mildly right-skewed (0.45) and platykurtic (kurtosis -1.32), suggesting a flatter-than-normal spread with no outliers flagged. With 266 unique values out of 300, the column behaves as a continuous physical feature rather than a categorical one.","role":"feature","scope":"column","target":"solar_wind_speed","treatment":"Use as-is for modelling; optional standardization given the narrow range and mild skew."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.mean","stats.median","stats.min","stats.max","stats.iqr","stats.skew","stats.kurtosis","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This is a numeric feature capturing solar wind density, fully populated across 300 rows with 215 distinct values. The distribution is fairly symmetric (skew 0.26, kurtosis 0.12) with mean 3.10 and median 3.14, ranging from 0.23 to 8.32 and an IQR of 2.02. Only 2 outliers (0.67%) appear, so the column looks clean and well-behaved.","role":"feature","scope":"column","target":"solar_wind_density","treatment":"Use as-is in modelling; standard scaling is sufficient given the near-symmetric distribution."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":3065,"prompt_tokens":9069,"total_tokens":12134}},"language_counts":{},"meta":{"generated_at":"2026-05-01T16:55:47+00:00","mode":"full","row_count":300,"sampled_rows":300,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/data/quirky/aurora.json"},"notes":[],"saturn_version":"0.2.0","schema":{"activity":"categorical","estimated_kp":"numeric","intensity":"numeric","kp_index":"numeric","solar_wind_density":"numeric","solar_wind_speed":"numeric","solar_wind_time":"categorical","time_tag":"categorical"}}