{"columns":[{"alerts":[],"column":"event","extras":{"singletons":8,"top_values":[["Small Craft Advisory",149],["Winter Weather Advisory",95],["Winter Storm Warning",60],["Wind Advisory",55],["High Wind Warning",21],["Red Flag Warning",20],["Gale Warning",20],["Brisk Wind Advisory",19],["Dense Fog Advisory",16],["Cold Weather Advisory",15],["Fire Weather Watch",12],["Heavy Freezing Spray Warning",10],["Winter Storm Watch",10],["Avalanche Warning",8],["High Surf Advisory",6],["Air Quality Alert",6],["Special Weather Statement",5],["Blizzard Warning",5],["Rip Current Statement",5],["Extreme Cold Warning",3]]},"kind":"categorical","n":571,"n_null":8,"n_unique":35,"null_rate":0.014010507880910683,"stats":{"cardinality":35,"entropy":3.6992881955140366,"entropy_ratio":0.7212096083006463,"top_rate":0.26465364120781526,"top_value":"Small Craft Advisory"}},{"alerts":[{"code":"long_tail","level":"info","message":"190 singleton categories"}],"column":"headline","extras":{"singletons":190,"top_values":[["Small Craft Advisory issued February 17 at 4:12AM AKST until February 18 at 5:00PM AKST by NWS Anchorage AK",19],["Small Craft Advisory issued February 17 at 3:15PM AKST until February 19 at 5:00AM AKST by NWS Anchorage AK",18],["Small Craft Advisory issued February 16 at 3:26PM AKST until February 18 at 5:00AM AKST by NWS Anchorage AK",17],["Small Craft Advisory issued February 17 at 5:25PM AKST until February 18 at 5:00AM AKST by NWS Juneau AK",15],["Small Craft Advisory issued February 17 at 3:15PM AKST until February 18 at 5:00PM AKST by NWS Anchorage AK",9],["Brisk Wind Advisory issued February 17 at 3:49PM AKST until February 18 at 5:00PM AKST by NWS Fairbanks AK",8],["Small Craft Advisory issued February 17 at 2:09PM PST until February 19 at 3:00AM PST by NWS San Francisco CA",6],["Winter Weather Advisory issued February 17 at 12:03PM PST until February 19 at 10:00AM PST by NWS Medford OR",6],["Winter Storm Warning issued February 17 at 10:33AM MST until February 19 at 5:00AM MST by NWS Grand Junction CO",6],["Wind Advisory issued February 17 at 10:08PM CST until February 18 at 12:00PM CST by NWS Sioux Falls SD",5],["Small Craft Advisory issued February 17 at 2:58PM AKST until February 18 at 5:00AM AKST by NWS Juneau AK",5],["Winter Storm Warning issued February 17 at 12:03PM PST until February 19 at 10:00AM PST by NWS Medford OR",5],["Winter Weather Advisory issued February 17 at 10:33AM MST until February 19 at 5:00AM MST by NWS Grand Junction CO",5],["Winter Storm Warning issued February 17 at 8:20PM PST until February 18 at 10:00PM PST by NWS Las Vegas NV",4],["Cold Weather Advisory issued February 17 at 5:55PM AKST until February 18 at 9:00AM AKST by NWS Juneau AK",4],["Small Craft Advisory issued February 17 at 5:25PM AKST until February 18 at 5:00PM AKST by NWS Juneau AK",4],["Heavy Freezing Spray Warning issued February 17 at 5:25PM AKST until February 18 at 5:00AM AKST by NWS Juneau AK",4],["Small Craft Advisory issued February 17 at 2:41PM AKST until February 18 at 3:00AM AKST by NWS Juneau AK",4],["Winter Storm Warning issued February 17 at 3:00PM PST until February 19 at 6:00AM PST by NWS Eureka CA",4],["Winter Weather Advisory issued February 17 at 1:43PM PST until February 18 at 4:00AM PST by NWS Reno NV",4]]},"kind":"categorical","n":571,"n_null":9,"n_unique":305,"null_rate":0.01576182136602452,"stats":{"cardinality":305,"entropy":7.78217678821367,"entropy_ratio":0.9429894925357603,"top_rate":0.033807829181494664,"top_value":"Small Craft Advisory issued February 17 at 4:12AM AKST until February 18 at 5:00PM AKST by NWS Anchorage AK"}},{"alerts":[{"code":"long_tail","level":"info","message":"490 singleton categories"}],"column":"description","extras":{"singletons":490,"top_values":[["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 25 kt. Seas 5 ft. Heavy freezing spray.\n.WED...N wind 15 kt diminishing to 10 kt in the morning. Seas 3 ft\nin the morning then 2 ft or less. Light freezing spray in the early\nmorning.\n.WED NIGHT...N wind 10 kt. Seas 2 ft or less.\n.THU...N wind 10 kt. Seas 2 ft or less. Light freezing\nspray.\n.THU NIGHT...N wind 15 kt. Seas 2 ft or less. Snow.\n.FRI...N gale to 35 kt. Seas 5 ft.\n.SAT...N gale to 45 kt. Seas 2 ft or less.\n.SUN...N gale to 35 kt. Seas 2 ft or less.",4],["The Winter Storm Watch has been replaced. Please see the latest information from NWS Gaylord MI on this developing situation.",4],["* WHAT...For the first Small Craft Advisory, east winds 20 to 25\nkts with gusts up to 30 kts and waves 5 to 7 ft expected. For\nthe Gale Warning, east winds 20 to 30 kts with gusts up to 40\nkts and waves 6 to 11 ft expected. For the second Small Craft\nAdvisory, southeast winds 10 to 20 kts with gusts up to 30 kts\nand waves 5 to 8 ft expected.\n\n* WHERE...Lake Michigan nearshore waters from Washington Island\nto Sturgeon Bay.\n\n* WHEN...For the first Small Craft Advisory, until midnight CST\ntonight. For the Gale Warning, until noon CST Wednesday. For\nthe second Small Craft Advisory, from noon to 10 PM CST\nWednesday.\n\n* IMPACTS...Strong winds will cause hazardous waves which could\ncapsize or damage vessels and reduce visibility.",3],["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...NE wind 25 kt. Seas 7 ft. Light freezing spray.\n.WED...NE wind 15 kt. Seas 5 ft.\n.WED NIGHT...NE wind 15 kt. Seas 5 ft.\n.THU...NE wind 15 kt. Seas 5 ft. Snow.\n.THU NIGHT...NE wind 20 kt. Seas 4 ft. SW swell. Snow and\nrain.\n.FRI...NE gale to 45 kt. Seas 10 ft.\n.SAT...NE gale to 45 kt. Seas 4 ft.\n.SUN...NE gale to 40 kt. Seas 3 ft.",3],["* WHAT...For the Gale Warning, north winds 25 to 35 kt with\ngusts up to 45 kt and seas 6 to 8 ft. For the Heavy Freezing\nSpray Warning, heavy freezing spray at a rate of 2 cm per hour\nor greater may rapidly accumulate on vessels. For the Small\nCraft Advisory, north winds 20 to 30 kt with gusts up to 40 kt\nand seas 6 to 8 ft expected.\n\n* WHERE...Northern Lynn Canal.\n\n* WHEN...For the Gale Warning, until midnight AKST tonight. For\nthe Heavy Freezing Spray Warning, until 6 AM AKST Wednesday.\nFor the Small Craft Advisory, from midnight tonight to noon\nAKST Wednesday.\n\n* IMPACTS...Operating a vessel in heavy freezing spray is\nhazardous. Freezing spray may render mechanical and electronic\ncomponents inoperative. Rapid ice accretion on decks and\nsuperstructures may result in a catastrophic loss of\nstability. Strong winds will cause hazardous seas which could\ncapsize or damage vessels and reduce visibility.",3],["...FIRE WEATHER WATCH REMAINS IN EFFECT FROM THURSDAY MORNING\nTHROUGH THURSDAY EVENING FOR BREEZY WINDS AND LOW RELATIVE\nHUMIDITY FOR THE FAR SOUTHERN TEXAS PANHANDLE, NORTHERN SOUTH\nPLAINS, AND NORTHERN ROLLING PLAINS...\n\n* Timing...Wednesday from 11 AM until 7 PM for the Red Flag\nWarning. For the Fire Weather Watch, Thursday from late morning\nthrough the evening.\n\n* Wind...For Wednesday, Southwest at 20 to 30 mph with gusts to 40\nmph. For Thursday, West at 20 to 25 mph with gusts to 35 mph.\n\n* Humidity...As low as 10 percent Wednesday and Thursday.\n\n* Fuels...Normal to dry.\n\n* Impacts...Any fires that develop can spread rapidly. Outdoor\nburning is discouraged.",2],["* WHAT...For the first High Wind Warning, west winds 35 to 45 mph\nwith gusts up to 60 mph. For the second High Wind Warning, west\nwinds 45 to 65 mph with gusts up to 80 mph expected.\n\n* WHERE...Guadalupe Mountains of west Texas and Southeast New Mexico.\n\n* WHEN...For the first High Wind Warning, until 10 PM MST /11 PM\nCST/ this evening. For the second High Wind Warning, from 9 AM MST\n/10 AM CST/ Wednesday to 9 PM MST /10 PM CST/ Thursday.\n\n* IMPACTS...Travel will be difficult, especially for high profile\nvehicles like campers, vans, and tractor trailers. Aviation\ninterests may experience localized but extreme turbulence, or\nstrong downward airflows if flying in the near the Guadalupe\nMountains. Severe turbulence near the mountains will be hazardous\nfor low flying light aircraft.",2],["...FIRE WEATHER WATCH REMAINS IN EFFECT FROM THURSDAY\nMORNING THROUGH THURSDAY EVENING...\n\n* WINDS...Southwest 15 to 25 mph with gusts up to 30 mph Wednesday.\n\n* RELATIVE HUMIDITY...As low as 10 percent.\n\n* TEMPERATURES...73 to 78 Wednesday afternoon.\n\n* IMPACTS...Any fires that develop will likely spread rapidly.\nOutdoor burning is not recommended.\n\n* SEVERITY...\n\nFUELS (ERC)...70th-89th percentile...4 (out of 5).\n\nWEATHER...Near Critical...2 (out of 5).\n\nFIRE ENVIRONMENT...6 (out of 10).",2],["Southeast Alaska Coastal Waters from Dixon Entrance to\nCape Suckling out 100 NM\n\nWind forecasts reflect the predominant speed and direction\nexpected. Seas forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 25 kt. Seas 9 ft.\n.WED...N wind 20 kt. Seas 8 ft. W swell in the afternoon.\n.WED NIGHT...NW wind 10 kt. Seas 6 ft. W swell in the\nevening.\n.THU...W wind 15 kt. Seas 6 ft. W swell.\n.THU NIGHT...W wind 25 kt. Seas 7 ft. W swell.\n.FRI...NE wind 25 kt. Seas 14 ft.\n.SAT...NE wind 30 kt. Seas 11 ft.\n.SUN...NE wind 25 kt. Seas 12 ft.",2],["Southeast Alaska Coastal Waters from Dixon Entrance to\nCape Suckling out 100 NM\n\nWind forecasts reflect the predominant speed and direction\nexpected. Seas forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 20 kt. Seas 9 ft.\n.WED...N wind 25 kt. Seas 8 ft.\n.WED NIGHT...N wind 15 kt. Seas 7 ft.\n.THU...NW wind 15 kt. Seas 5 ft.\n.THU NIGHT...W wind 25 kt. Seas 6 ft. W swell.\n.FRI...E wind 25 kt. Seas 13 ft.\n.SAT...NE wind 25 kt. Seas 12 ft.\n.SUN...NE wind 25 kt. Seas 13 ft.",2],["Southeast Alaska Coastal Waters from Dixon Entrance to\nCape Suckling out 100 NM\n\nWind forecasts reflect the predominant speed and direction\nexpected. Seas forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...NE wind 25 kt. Seas 8 ft.\n.WED...NE wind 15 kt. Seas 6 ft. SW swell in the afternoon.\n.WED NIGHT...Light winds. Seas 6 ft. SW swell.\n.THU...E wind 10 kt. Seas 6 ft. SW swell. Snow.\n.THU NIGHT...SW wind 20 kt. Seas 6 ft. SW swell. Snow.\n.FRI...NE gale to 45 kt. Seas 12 ft.\n.SAT...NE gale to 45 kt. Seas 8 ft.\n.SUN...NE gale to 35 kt. Seas 5 ft.",2],["Southeast Alaska Coastal Waters from Dixon Entrance to\nCape Suckling out 100 NM\n\nWind forecasts reflect the predominant speed and direction\nexpected. Seas forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...NE wind 25 kt. Seas 9 ft.\n.WED...N wind 20 kt. Seas 7 ft. W swell.\n.WED NIGHT...W wind 10 kt. Seas 6 ft. W swell.\n.THU...W wind 20 kt. Seas 7 ft. W swell.\n.THU NIGHT...W wind 25 kt. Seas 10 ft. W swell.\n.FRI...NE gale to 40 kt. Seas 13 ft.\n.SAT...NE gale to 40 kt. Seas 10 ft.\n.SUN...NE gale to 35 kt. Seas 11 ft.",2],["Southeast Alaska Coastal Waters from Dixon Entrance to\nCape Suckling out 100 NM\n\nWind forecasts reflect the predominant speed and direction\nexpected. Seas forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...NE wind 25 kt. Seas 8 ft.\n.WED...E wind 15 kt. Seas 6 ft. SW swell in the afternoon.\n.WED NIGHT...Light winds becoming E 10 kt late. Seas 6 ft.\nSW swell.\n.THU...E wind 15 kt. Seas 6 ft. SW swell. Snow.\n.THU NIGHT...E wind 25 kt. Seas 7 ft. SW swell. Snow and\nrain.\n.FRI...NE gale to 45 kt. Seas 12 ft.\n.SAT...NE gale to 45 kt. Seas 7 ft.\n.SUN...NE gale to 35 kt. Seas 5 ft.",2],["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 35 kt diminishing to 30 kt. Seas 9 ft. Heavy\nfreezing spray.\n.WED...N wind 25 kt diminishing to 15 kt in the afternoon. Seas 5\nft subsiding. Light freezing spray in the morning.\n.WED NIGHT...N wind 15 kt. Seas 3 ft.\n.THU...N wind 15 kt. Seas 2 ft or less. Light freezing\nspray.\n.THU NIGHT...N wind 20 kt. Seas 2 ft or less. Light freezing\nspray. Snow.\n.FRI...N gale to 45 kt. Seas 6 ft.\n.SAT...N storm force wind to 50 kt. Seas 2 ft or less.\n.SUN...N storm force wind to 50 kt. Seas 2 ft or less.",2],["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...NE wind 25 kt. Near Point Couverden, N wind 35 kt with\ngusts to 50 kt. Seas 7 ft. Light freezing spray.\n.WED...NE wind 15 kt. Seas 3 ft in the morning then 2 ft or less.\n.WED NIGHT...E wind 10 kt. Seas 2 ft or less.\n.THU...E wind 10 kt. Seas 2 ft or less.\n.THU NIGHT...E wind 15 kt. Seas 2 ft or less. Snow.\n.FRI...NE gale to 35 kt. Seas 5 ft.\n.SAT...N gale to 35 kt. Seas 3 ft.\n.SUN...N wind 30 kt. Seas 3 ft.",2],["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 30 kt. Out of interior passes, gusts to 45 kt.\nSeas 8 ft. Light freezing spray.\n.WED...N wind 25 kt diminishing to 15 kt in the afternoon. Out of\ninterior passes, gusts to 35 kt in the morning. Seas 5 ft subsiding.\nLight freezing spray in the morning.\n.WED NIGHT...N wind 15 kt becoming E late. Seas 3 ft in the\nevening then 2 ft or less.\n.THU...E wind 15 kt. Seas 2 ft or less. Snow.\n.THU NIGHT...SE wind 15 kt. Seas 2 ft or less. Snow.\n.FRI...N wind 25 kt. Seas 3 ft.\n.SAT...N gale to 35 kt. Seas 3 ft.\n.SUN...N gale to 35 kt. Seas 3 ft.",2],["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 30 kt. near Point Couverden, gusts to 50 kt. Seas\n10 ft. Light freezing spray.\n.WED...N wind 20 kt diminishing to 15 kt in the afternoon. Seas 7 ft\nsubsiding to 3 ft in the afternoon. Light freezing spray in the\nmorning.\n.WED NIGHT...N wind 15 kt. Seas 3 ft in the evening then\n2 ft or less.\n.THU...N wind 10 kt. Seas 2 ft or less.\n.THU NIGHT...N wind 20 kt. Seas 2 ft or less. Snow.\n.FRI...N gale to 45 kt. Seas 6 ft.\n.SAT...N storm force wind to 50 kt. Seas 3 ft.\n.SUN...N storm force wind to 50 kt. Seas 2 ft or less.",2],["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 25 kt. Near Point Couverden, N wind 35 kt with\ngusts to 50 kt. Seas 7 ft. Light freezing spray.\n.WED...N wind 20 kt diminishing to 10 kt in the afternoon. Seas 4 ft\nin the morning then 2 ft or less.\n.WED NIGHT...E wind 15 kt. Seas 3 ft in the evening then 2 ft or\nless.\n.THU...E wind 10 kt. Seas 2 ft or less. Snow.\n.THU NIGHT...SE wind 15 kt. Seas 2 ft or less. Snow and\nrain.\n.FRI...NE wind 25 kt. Seas 3 ft.\n.SAT...N gale to 35 kt. Seas 3 ft.\n.SUN...N wind 30 kt. Seas 2 ft or less.",2],["Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 25 kt. Seas 7 ft. Light freezing spray.\n.WED...N wind 20 kt diminishing to 15 kt in the afternoon. Seas 5\nft. Light freezing spray in the morning.\n.WED NIGHT...N wind 15 kt becoming E late. Seas 3 ft in the\nevening then 2 ft or less.\n.THU...E wind 10 kt. Seas 2 ft or less.\n.THU NIGHT...SE wind 15 kt. Seas 2 ft or less. Snow.\n.FRI...NE wind 20 kt. Seas 3 ft.\n.SAT...N wind 30 kt. Seas 3 ft.\n.SUN...N wind 30 kt. Seas 3 ft.",2],["...FIRE WEATHER WATCH REMAINS IN EFFECT FROM THURSDAY MORNING\nTHROUGH THURSDAY EVENING FOR GUSTY WINDS AND LOW RELATIVE\nHUMIDITY FOR FIRE WEATHER ZONES 228 AND 230...\n\n...RED FLAG WARNING WILL EXPIRE AT 7 PM MST THIS EVENING FOR\nGUSTY WINDS AND LOW RELATIVE HUMIDITY FOR FIRE WEATHER ZONES\n228 AND 230...\n\n* AFFECTED AREA...Fire Weather Zones 228 and 230.\n\n* TIMING...For the Red Flag Warning, from 10 AM to 7 PM MST\nWednesday. For the Fire Weather Watch, from Thursday morning\nthrough Thursday evening.\n\n* WINDS...West 30 to 40 mph with gusts up to 60 mph on Wednesday.\nWest to Northwest winds 15 to 25 mph with gusts up to 40 mph on\nThursday.\n\n* RELATIVE HUMIDITY...As low as 10 percent.\n\n* IMPACTS...Elevated fire danger is expected. Fires will catch\nand spread rapidly and erratically.",2]]},"kind":"categorical","n":571,"n_null":0,"n_unique":527,"null_rate":0.0,"stats":{"cardinality":527,"entropy":8.992259960745521,"entropy_ratio":0.9945364904755619,"top_rate":0.0070052539404553416,"top_value":"Southeast Alaska Inside Waters from Dixon Entrance to Skagway\n\nWind forecasts reflect the predominant speed and direction\nexpected. Sea forecasts represent the average of the highest\none-third of the combined windwave and swell height.\n\n.TONIGHT...N wind 25 kt. Seas 5 ft. Heavy freezing spray.\n.WED...N wind 15 kt diminishing to 10 kt in the morning. Seas 3 ft\nin the morning then 2 ft or less. Light freezing spray in the early\nmorning.\n.WED NIGHT...N wind 10 kt. Seas 2 ft or less.\n.THU...N wind 10 kt. Seas 2 ft or less. Light freezing\nspray.\n.THU NIGHT...N wind 15 kt. Seas 2 ft or less. Snow.\n.FRI...N gale to 35 kt. Seas 5 ft.\n.SAT...N gale to 45 kt. Seas 2 ft or less.\n.SUN...N gale to 35 kt. Seas 2 ft or less."}},{"alerts":[],"column":"severity","extras":{"singletons":0,"top_values":[["Moderate",208],["Minor",187],["Severe",144],["Unknown",19],["Extreme",5]]},"kind":"categorical","n":571,"n_null":8,"n_unique":5,"null_rate":0.014010507880910683,"stats":{"cardinality":5,"entropy":1.787523636396583,"entropy_ratio":0.7698445271981157,"top_rate":0.369449378330373,"top_value":"Moderate"}},{"alerts":[],"column":"certainty","extras":{"singletons":0,"top_values":[["Likely",503],["Observed",24],["Unknown",18],["Possible",18]]},"kind":"categorical","n":571,"n_null":8,"n_unique":4,"null_rate":0.014010507880910683,"stats":{"cardinality":4,"entropy":0.6569077395377587,"entropy_ratio":0.32845386976887936,"top_rate":0.8934280639431617,"top_value":"Likely"}},{"alerts":[],"column":"urgency","extras":{"singletons":0,"top_values":[["Expected",510],["Unknown",18],["Future",18],["Past",11],["Immediate",6]]},"kind":"categorical","n":571,"n_null":8,"n_unique":5,"null_rate":0.014010507880910683,"stats":{"cardinality":5,"entropy":0.627575347143679,"entropy_ratio":0.2702819904395545,"top_rate":0.9058614564831261,"top_value":"Expected"}},{"alerts":[{"code":"long_tail","level":"info","message":"369 singleton categories"}],"column":"areaDesc","extras":{"singletons":369,"top_values":[["Glacier Bay",9],["Northern Lynn Canal",7],["Stephens Passage",5],["Frederick Sound",5],["Cape Decision to Cape Edgecumbe from 15 to 80 NM",4],["Dixon Entrance to Cape Decision from 15 to 90 NM",4],["Icy Strait",4],["Northern Chatham Strait",4],["Greater Lake Tahoe Area; Greater Lake Tahoe Area",4],["Sacramento Mountains Above 7500 Feet; East Slopes Sacramento Mountains Below 7500 Feet",3],["Rock Island Passage to Sturgeon Bay WI",3],["Southern Lynn Canal",3],["Cross Sound",3],["Nikolski to Seguam Pacific Side from 15 to 75 NM",3],["Kuskokwim Delta from 15 to 80 NM",3],["Castle Cape to Cape Tolstoi from 15 to 100 NM",3],["Seguam to Adak Pacific Side from 15 to 75 NM",3],["Seguam to Adak Bering Side from 15 to 85 NM",3],["Nikolski to Seguam Bering Side out to 15 NM",3],["Pribilof Islands Nearshore Waters",3]]},"kind":"categorical","n":571,"n_null":8,"n_unique":441,"null_rate":0.014010507880910683,"stats":{"cardinality":441,"entropy":8.607670303085818,"entropy_ratio":0.9798552193024624,"top_rate":0.015985790408525755,"top_value":"Glacier Bay"}},{"alerts":[{"code":"skipped","level":"info","message":"no profiler for kind=unknown"}],"column":"sent","extras":{},"kind":"unknown","n":571,"n_null":0,"n_unique":null,"null_rate":0.0,"stats":{}},{"alerts":[{"code":"skipped","level":"info","message":"no profiler for kind=unknown"}],"column":"effective","extras":{},"kind":"unknown","n":571,"n_null":0,"n_unique":null,"null_rate":0.0,"stats":{}},{"alerts":[{"code":"skipped","level":"info","message":"no profiler for kind=unknown"}],"column":"onset","extras":{},"kind":"unknown","n":571,"n_null":0,"n_unique":null,"null_rate":0.0,"stats":{}},{"alerts":[{"code":"skipped","level":"info","message":"no profiler for kind=unknown"}],"column":"expires","extras":{},"kind":"unknown","n":571,"n_null":0,"n_unique":null,"null_rate":0.0,"stats":{}},{"alerts":[{"code":"null_rate","level":"warn","message":"97.2% null"},{"code":"outliers","level":"warn","message":"25.0% rows beyond 1.5 IQR"}],"column":"latitude","extras":{"histogram":{"counts":[3,10,1,0,2],"edges":[25.7617,34.5392,43.3167,52.0942,60.87169999999999,69.6492]},"sample":[34.803333333333335,36.286,34.30238095238095,35.01375,35.431666666666665,35.20571428571428,35.21142857142857,33.238571428571426,51.752,25.7617,35.4676,63.63,69.6492,39.0,41.8781,40.7128]},"kind":"numeric","n":571,"n_null":555,"n_unique":16,"null_rate":0.9719789842381786,"stats":{"iqr":6.042979166666669,"kurtosis":1.2974489859350546,"max":69.6492,"mean":40.45901532738095,"median":35.44963333333333,"min":25.7617,"n_outliers":4,"outlier_rate":0.25,"q1":34.96114583333333,"q3":41.004125,"skew":1.508452336996675,"std":11.579074210356413,"zero_rate":0.0}},{"alerts":[{"code":"null_rate","level":"warn","message":"97.2% null"},{"code":"outliers","level":"warn","message":"12.5% rows beyond 1.5 IQR"}],"column":"longitude","extras":{"histogram":{"counts":[9,4,0,1,2],"edges":[-120.60904761904762,-92.69617809523808,-64.78330857142856,-36.87043904761903,-8.95756952380951,18.9553]},"sample":[-120.55333333333334,-118.976,-120.60904761904762,-120.3,-101.93666666666667,-120.11428571428571,-91.24142857142859,-92.32571428571428,1.2577,-80.1918,-97.5164,-19.605,18.9553,-120.5,-93.0977,-74.006]},"kind":"numeric","n":571,"n_null":555,"n_unique":16,"null_rate":0.9719789842381786,"stats":{"iqr":41.51536428571427,"kurtosis":0.32482307533156707,"max":18.9553,"mean":-84.42252351190477,"median":-95.30705,"min":-120.60904761904762,"n_outliers":2,"outlier_rate":0.125,"q1":-120.16071428571428,"q3":-78.64535000000001,"skew":1.2825103491497676,"std":45.232527398778196,"zero_rate":0.0}},{"alerts":[{"code":"long_tail","level":"info","message":"8 singleton categories"},{"code":"null_rate","level":"warn","message":"98.6% null"}],"column":"event_type","extras":{"singletons":8,"top_values":[["Ball Lightning",1],["Waterspout",1],["Mammatus Clouds",1],["Volcanic Lightning",1],["Nacreous Clouds",1],["Fire Whirl",1],["Derecho",1],["Sprites",1]]},"kind":"categorical","n":571,"n_null":563,"n_unique":8,"null_rate":0.9859894921190894,"stats":{"cardinality":8,"entropy":3.0,"entropy_ratio":1.0,"top_rate":0.125,"top_value":"Ball Lightning"}},{"alerts":[{"code":"skipped","level":"info","message":"no profiler for kind=unknown"}],"column":"date","extras":{},"kind":"unknown","n":571,"n_null":0,"n_unique":null,"null_rate":0.0,"stats":{}},{"alerts":[{"code":"long_tail","level":"info","message":"5 singleton categories"},{"code":"null_rate","level":"warn","message":"98.6% null"}],"column":"state","extras":{"singletons":5,"top_values":[["International",3],["FL",1],["OK",1],["CA",1],["IA",1],["NY",1]]},"kind":"categorical","n":571,"n_null":563,"n_unique":6,"null_rate":0.9859894921190894,"stats":{"cardinality":6,"entropy":2.4056390622295662,"entropy_ratio":0.9306282244165778,"top_rate":0.375,"top_value":"International"}},{"alerts":[{"code":"long_tail","level":"info","message":"3 singleton categories"},{"code":"null_rate","level":"warn","message":"98.6% null"}],"column":"country","extras":{"singletons":3,"top_values":[["USA",5],["United Kingdom",1],["Iceland",1],["Norway",1]]},"kind":"categorical","n":571,"n_null":563,"n_unique":4,"null_rate":0.9859894921190894,"stats":{"cardinality":4,"entropy":1.5487949406953985,"entropy_ratio":0.7743974703476992,"top_rate":0.625,"top_value":"USA"}},{"alerts":[{"code":"long_tail","level":"info","message":"4 singleton categories"},{"code":"null_rate","level":"warn","message":"98.6% null"}],"column":"magnitude","extras":{"singletons":4,"top_values":[["N/A",4],["Unknown",1],["F0-F1",1],["EF-3 equivalent",1],["140 mph winds",1]]},"kind":"categorical","n":571,"n_null":563,"n_unique":5,"null_rate":0.9859894921190894,"stats":{"cardinality":5,"entropy":2.0,"entropy_ratio":0.8613531161467861,"top_rate":0.5,"top_value":"N/A"}},{"alerts":[{"code":"long_tail","level":"info","message":"8 singleton categories"},{"code":"null_rate","level":"warn","message":"98.6% null"}],"column":"source","extras":{"singletons":8,"top_values":[["Journal of Geophysical Research",1],["NOAA NWS Miami",1],["NOAA Storm Prediction Center",1],["Icelandic Met Office",1],["Norwegian Meteorological Institute",1],["NOAA NWS Sacramento",1],["NOAA Storm Events Database",1],["Atmospheric Research",1]]},"kind":"categorical","n":571,"n_null":563,"n_unique":8,"null_rate":0.9859894921190894,"stats":{"cardinality":8,"entropy":3.0,"entropy_ratio":1.0,"top_rate":0.125,"top_value":"Journal of Geophysical Research"}}],"insights":{"errors":[],"insights":[{"confidence":"high","critiques":[],"evidence_keys":["row_count","column_count","columns.event","columns.severity","columns.urgency","columns.certainty","columns.country","columns.event_type","columns.magnitude"],"featured_charts":[{"caption":"Shows that Small Craft Advisory and Winter Weather Advisory dominate the 35 alert types.","column":"event","kind":"bar"},{"caption":"Reveals a relatively balanced split between Moderate, Minor, and Severe alerts.","column":"severity","kind":"donut"},{"caption":"Highlights how nearly 90% of alerts are tagged 'Likely', limiting this field's discriminative power.","column":"certainty","kind":"donut"},{"caption":"Confirms 'Expected' overwhelms other urgency levels \u2014 useful for spotting the rare Immediate cases.","column":"urgency","kind":"bar"},{"caption":"Shows the geographic spread of the small subset with coordinates, skewed toward mid-northern latitudes.","column":"latitude","kind":"histogram"}],"model":"anthropic:claude-opus-4-7","narrative":"This dataset contains 571 weather alert records with 19 columns mixing NWS-style alert metadata (event, severity, urgency, certainty, areaDesc, headline) with sparse atmospheric event annotations (country, event_type, magnitude, source, state). The alert fields are well-populated and dominated by 'Small Craft Advisory' (149 of 571) and 'Winter Weather Advisory' (95), while certainty is overwhelmingly 'Likely' (89.3%) and urgency is 'Expected' (90.6%), suggesting limited variation in those risk dimensions. Severity is the most balanced operational field, split across Moderate (208), Minor (187), and Severe (144). Note that the curiosity-style columns (country, event_type, magnitude, source, state) are ~98.6% null and only describe a handful of rows, so treat them as a separate mini-dataset rather than primary signal.","scope":"dataset","target":"__global__"},{"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 column captures NWS-style weather alert types, with 35 distinct events across 571 rows and a 1.4% null rate. 'Small Craft Advisory' dominates at 26.5% (149 occurrences), followed by 'Winter Weather Advisory' (95) and 'Winter Storm Warning' (60), suggesting a marine/winter-weighted sample. Entropy ratio of 0.72 indicates moderate spread but a clear long tail of rarer event types.","role":"label","scope":"column","target":"event","treatment":"Use as a categorical label; consider grouping rare events into an 'Other' bucket before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.cardinality","stats.entropy","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values","alerts"],"model":"anthropic:claude-opus-4-7","narrative":"This column holds NWS-style alert headlines that pack advisory type, issuing/expiry timestamps, and originating forecast office into a single string (e.g. 'Small Craft Advisory issued February 17 at 4:12AM AKST until February 18 at 5:00PM AKST by NWS Anchorage AK'). Cardinality is high at 305 unique values across 571 rows with entropy ratio 0.943, yet the top headline still repeats 19 times because identical advisories cover multiple zones. Small Craft Advisories out of NWS Anchorage AK dominate the top of the distribution, and a long_tail alert is flagged.","role":"free_text","scope":"column","target":"headline","treatment":"Parse into structured fields (event type, issue/expiry timestamps, office) rather than using the raw string."},{"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 holds full-text NWS weather advisories \u2014 marine forecasts, gale/small craft warnings, fire weather watches, and high wind warnings \u2014 with structured sections like .TONIGHT/.WED, WHAT/WHERE/WHEN/IMPACTS embedded in the prose. It is near-unique (527 distinct of 571, entropy ratio 0.9945) with a long_tail alert, and the most common string repeats only 4 times (top_rate 0.0070). Treating these as categorical levels would be useless; they are documents, and several appear to be recurring boilerplate templates with swapped wind/sea numbers.","role":"free_text","scope":"column","target":"description","treatment":"Parse the structured fields (WHAT/WHERE/WHEN, wind/seas) with regex or tokenize and embed; do not one-hot."},{"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":"A 5-level severity classification, dominated by Moderate (208) and Minor (187), with Severe (144) close behind and Extreme appearing only 5 times. The Unknown bucket (19) plus a 1.4% null rate means roughly 4% of rows lack a clean severity signal. Entropy ratio of 0.77 shows the distribution is reasonably spread rather than collapsed onto one class.","role":"label","scope":"column","target":"severity","treatment":"Treat as ordinal (Minor<Moderate<Severe<Extreme); fold Unknown and nulls into a single missing category before modelling."},{"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":"A 4-level categorical certainty/confidence label, almost certainly attached to event or prediction records. The distribution is extremely concentrated: 'Likely' covers 89.3% of the 571 rows, while 'Observed', 'Unknown', and 'Possible' together account for only 60 rows. Null rate is negligible (1.4%) and entropy ratio is just 0.33, so this column carries little discriminative signal on its own.","role":"label","scope":"column","target":"certainty","treatment":"One-hot encode but expect low signal; consider collapsing rare levels or dropping due to severe class imbalance."},{"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 small-cardinality categorical flag describing the timing/urgency of an event, with 5 levels. The distribution is severely imbalanced: 'Expected' covers 90.6% of 571 rows, leaving 'Unknown', 'Future', 'Past', and 'Immediate' as rare tails (6-18 rows each). Entropy ratio of 0.27 confirms the column carries little information, and 1.4% of values are null.","role":"feature","scope":"column","target":"urgency","treatment":"Collapse rare levels into an 'Other' bucket or binarize as Expected vs not before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","null_rate","stats.entropy_ratio","stats.top_rate","stats.top_value","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"Free-text geographic descriptions for weather alerts, with 441 unique values across 571 rows (entropy ratio 0.98) and the most common value 'Glacier Bay' appearing only 9 times (1.6%). Many entries concatenate multiple zones with semicolons (e.g., 'Greater Lake Tahoe Area; Greater Lake Tahoe Area' which even repeats itself), so the field mixes single-region and compound-region strings. Null rate is low at 1.4%, but the long tail makes this unsuitable as a categorical feature without normalization.","role":"metadata","scope":"column","target":"areaDesc","treatment":"Split on ';' and normalize to canonical zone names before any grouping or joining."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","kind","n","null_rate","stats"],"model":"anthropic:claude-opus-4-7","narrative":"The column 'sent' was skipped by the profiler, so its kind is unknown and no descriptive statistics are available. The only signals are 571 rows with a 0.0 null rate, suggesting the field is fully populated but otherwise opaque. Without type or cardinality information, no further characterisation is possible.","role":"other","scope":"column","target":"sent","treatment":"Re-profile with type inference enabled before deciding on downstream handling."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","kind","n","null_rate","stats"],"model":"anthropic:claude-opus-4-7","narrative":"The column 'effective' was skipped by the profiler, so its kind is unknown and no descriptive statistics were computed. We only know it has 571 rows and zero nulls; uniqueness, type, and value distribution are all unreported.","role":"other","scope":"column","target":"effective","treatment":"Re-profile or inspect manually to determine type before any downstream use."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","column","kind","n","n_unique","null_rate","stats"],"model":"anthropic:claude-opus-4-7","narrative":"The column is named \"onset\" with 571 non-null entries and a null rate of 0.0, but saturn skipped profiling so its kind is unknown and no distributional stats were emitted. The name suggests an onset time or date (e.g., symptom or event onset), yet without dtype, uniqueness, or value statistics this is unverified. No surprises can be flagged because the evidence payload is empty beyond the row count.","role":"other","scope":"column","target":"onset","treatment":"Re-profile with an explicit type hint (likely datetime) before deciding on use."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","column","kind","n","null_rate","stats"],"model":"anthropic:claude-opus-4-7","narrative":"The column is named \"expires\" and contains 571 non-null entries, but saturn skipped profiling so its type and value distribution are unknown. No uniqueness, range, or format statistics are available to confirm whether it holds dates, durations, or flags. The name suggests a timestamp or expiry indicator, but this is unverified by the evidence.","role":"other","scope":"column","target":"expires","treatment":"Re-profile with an explicit parser to determine whether this is a timestamp before using it downstream."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.min","stats.max","stats.median","stats.mean","stats.skew","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This is a geographic latitude column, with values spanning 25.76 to 69.65 and a median of 35.45 \u2014 consistent with northern-hemisphere coordinates. The column is almost entirely empty (97.2% null) with only 16 unique values across 571 rows, and 4 of the 16 populated values (25%) are flagged as outliers, with a right skew of 1.51 pulling the mean up to 40.46.","role":"feature","scope":"column","target":"latitude","treatment":"Drop or treat as sparse metadata; too few non-null values to model directly."},{"confidence":"medium","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.min","stats.max","stats.median","stats.skew","stats.n_outliers","stats.outlier_rate"],"model":"anthropic:claude-opus-4-7","narrative":"Geographic longitude coordinates, but only 16 of 571 rows carry a value (null rate 0.972), making this column nearly empty. The populated values span -120.609 to 18.955 with median -95.307, suggesting a mix of North American and possibly European points, and 2 outliers (12.5% of non-nulls) plus a skew of 1.28 hint at a few eastern-hemisphere entries pulling the distribution right.","role":"feature","scope":"column","target":"longitude","treatment":"Drop or impute given 97.2% nulls; only usable if paired with latitude on the few populated rows."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","stats.entropy_ratio","stats.top_rate","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This is a categorical event_type label naming rare atmospheric or geological phenomena (e.g., Ball Lightning, Waterspout, Volcanic Lightning). It is almost entirely empty: null_rate is 0.986 across n=571, leaving only 8 populated rows, each a distinct value with frequency 1, so entropy_ratio is 1.0. The column is effectively a sparse free-list of unique tags rather than a usable category.","role":"label","scope":"column","target":"event_type","treatment":"Drop or retain only as a sparse annotation; too few non-null rows to model."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","column","kind","n","null_rate"],"model":"anthropic:claude-opus-4-7","narrative":"This column is named \"date\" and contains 571 non-null values, but saturn skipped detailed profiling so no type, uniqueness, or distribution stats are available. Without parsed values it is impossible to confirm whether entries are timestamps, formatted strings, or something else. The only firm signals are the full population (null_rate 0.0) and the row count of 571.","role":"timestamp","scope":"column","target":"date","treatment":"Parse to a proper datetime type and re-profile before use."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","top_value","top_rate","top_values","stats.entropy_ratio"],"model":"anthropic:claude-opus-4-7","narrative":"Geographic state field mixing US state abbreviations (FL, OK, CA, IA, NY) with an 'International' bucket. The column is essentially empty \u2014 98.6% null with only 8 non-null values across 571 rows, and 'International' accounts for 3 of those 8. With just 6 unique values and near-uniform distribution among the populated rows (entropy ratio 0.93), there is too little signal here to support analysis.","role":"metadata","scope":"column","target":"state","treatment":"Drop or collapse to a binary 'is_international' flag; null rate of 0.986 makes it unusable as-is."},{"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":"Country-of-origin field, but it is effectively empty: 98.6% of the 571 rows are null and only 8 records carry a value across 4 distinct countries (USA dominates at 5 of 8, or 62.5%). With such sparse coverage, the entropy ratio of 0.77 and the long tail are statistically meaningless. This column cannot support any country-level analysis as-is.","role":"metadata","scope":"column","target":"country","treatment":"Drop or set aside; null rate is too high to use as a feature."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","top_values","stats.top_rate","stats.top_value"],"model":"anthropic:claude-opus-4-7","narrative":"Categorical magnitude/intensity field, almost entirely empty: 98.6% null across 571 rows, leaving only 8 populated entries spread across 5 distinct values. The non-null content is also inconsistent, mixing placeholders (\"N/A\", \"Unknown\") with structured scales (\"F0-F1\", \"EF-3 equivalent\") and free text (\"140 mph winds\"), so even the present data is not directly comparable.","role":"feature","scope":"column","target":"magnitude","treatment":"Drop or set aside; too sparse and inconsistently coded to model without manual normalisation."},{"confidence":"high","critiques":[],"evidence_keys":["null_rate","n","n_unique","top_value","top_rate","entropy_ratio","top_values"],"model":"anthropic:claude-opus-4-7","narrative":"This appears to be a citation/provenance field naming the agency or publication that supplied each record (e.g., NOAA offices, meteorological institutes, journals). It is almost entirely empty: 98.6% null, with only 8 non-null values across 571 rows, and every observed source occurs exactly once (top_rate 0.125, entropy_ratio 1.0). With no repetition, the column carries no categorical signal in its current state.","role":"metadata","scope":"column","target":"source","treatment":"Drop or retain as provenance metadata only; too sparse and unique for modelling."}],"providers":["anthropic:claude-opus-4-7"],"total_usage":{"completion_tokens":5528,"prompt_tokens":26706,"total_tokens":32234}},"language_counts":{},"meta":{"generated_at":"2026-05-01T17:52:52+00:00","mode":"full","row_count":571,"sampled_rows":571,"seed":42,"source":"/home/coolhand/html/datavis/data_trove/data/quirky/atmospheric_real.json"},"notes":[],"saturn_version":"0.2.0","schema":{"areaDesc":"categorical","certainty":"categorical","country":"categorical","date":"unknown","description":"categorical","effective":"unknown","event":"categorical","event_type":"categorical","expires":"unknown","headline":"categorical","latitude":"numeric","longitude":"numeric","magnitude":"categorical","onset":"unknown","sent":"unknown","severity":"categorical","source":"categorical","state":"categorical","urgency":"categorical"}}