{"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":"medium","critiques":[],"evidence_keys":["event.top_values","event.n_unique","certainty.top_rate","certainty.top_value","severity.top_values","urgency.top_value","urgency.top_rate","country.null_rate","event_type.null_rate","row_count"],"featured_charts":[{"caption":"Look for the dominance of Small Craft Advisories and Winter Weather alerts, which together account for the majority of all 571 records.","column":"event","kind":"bar"},{"caption":"Severity splits roughly across Minor, Moderate, and Severe with very few Extreme events \u2014 check whether Extreme cases align with specific event types.","column":"severity","kind":"donut"},{"caption":"Nearly 90% of alerts are rated 'Likely', with Observed, Possible, and Unknown making up a small tail worth filtering separately.","column":"certainty","kind":"donut"},{"caption":"Over 90% of alerts are flagged 'Expected', with Immediate urgency appearing in only 6 records \u2014 those outliers may warrant closer review.","column":"urgency","kind":"bar"},{"caption":"Geographic concentration around Southeast Alaska waterways (Glacier Bay, Lynn Canal) suggests a heavy cluster of marine advisories in this snapshot.","column":"areaDesc","kind":"bar"}],"model":"anthropic:default","narrative":"This dataset contains 571 weather alert and atmospheric event records, combining operational NWS advisory data with a small number of rare/quirky atmospheric phenomena entries. The bulk of the dataset is well-populated NWS alerts \u2014 dominated by Small Craft Advisories (149), Winter Weather Advisories (95), and Winter Storm Warnings (60) \u2014 with certainty skewed heavily toward 'Likely' (89% of records). A key anomaly worth investigating is that columns like country, event_type, magnitude, source, and state have a ~98.6% null rate, meaning they are only populated for roughly 8 rare-event records, suggesting the dataset is a hybrid merge of two very different sources. Severity is fairly well distributed across Minor, Moderate, and Severe, making it a useful dimension for filtering operational alerts.","scope":"dataset","target":"__global__"},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","entropy_ratio","alerts","top_values","top_rate","null_rate"],"model":"anthropic:default","narrative":"This column contains full-text NWS (National Weather Service) alert and forecast descriptions \u2014 multi-line, structured prose covering marine, fire weather, wind, and winter storm warnings across various US regions. With 527 unique values out of 571 rows and an entropy ratio of 0.9945, nearly every entry is distinct, making this essentially free text. The long-tail alert and the presence of duplicate entries (e.g., the same Southeast Alaska marine forecast appearing 4 times) suggest periodic reissue of templated advisories rather than purely unique records, which may indicate time-series duplication worth investigating.","role":"free_text","scope":"column","target":"description","treatment":"Tokenize and embed (e.g., TF-IDF or sentence transformer) before modelling; consider deduplicating or grouping by alert template for frequency analysis."},{"confidence":"high","critiques":[],"evidence_keys":["cardinality","n_unique","n","entropy_ratio","top_value","top_rate","top_values","alerts"],"model":"anthropic:default","narrative":"This column contains geographic area descriptions used in weather or emergency alerts, predominantly covering coastal and inland waterways of Southeast Alaska (e.g., 'Glacier Bay', 'Stephens Passage', 'Northern Lynn Canal') with some continental US zones also present (e.g., 'Greater Lake Tahoe Area', 'Sacramento Mountains'). With 441 unique values across only 571 rows and an entropy ratio of 0.98, cardinality is extremely high \u2014 nearly every row is a distinct area. The long-tail alert confirms that most areas appear only once or twice, with even the top value ('Glacier Bay') appearing just 9 times (1.6% of rows). The multi-zone concatenated entries (e.g., 'Greater Lake Tahoe Area; Greater Lake Tahoe Area') suggest some records bundle multiple zones into a single string, which may cause deduplication or parsing issues.","role":"label","scope":"column","target":"areaDesc","treatment":"Parse semicolon-delimited multi-zone entries into separate records, then use as a grouping/filter dimension rather than a model feature; too high-cardinality for direct encoding without aggregation."},{"confidence":"high","critiques":[],"evidence_keys":["n","n_unique","entropy_ratio","top_rate","top_value","alerts","top_values"],"model":"anthropic:default","narrative":"This column contains NWS (National Weather Service) alert headlines \u2014 structured text strings describing weather advisory type, issuance timestamp, expiry, and issuing office. Despite appearing categorical, the entropy ratio of 0.943 and 305 unique values out of 571 records signal near free-text behaviour, with a long-tail alert confirming most headlines appear only once or a handful of times. The most frequent value ('Small Craft Advisory issued February 17\u2026') appears only 19 times (top_rate \u2248 3.4%), indicating very little repetition across the dataset.","role":"free_text","scope":"column","target":"headline","treatment":"Parse structured subfields (alert type, issue time, expiry time, NWS office) via regex before modelling; do not use raw string as a categorical feature."},{"confidence":"low","critiques":[],"evidence_keys":["column","kind","n","null_rate","alerts","stats"],"model":"anthropic:default","narrative":"This column is named 'date' and contains 571 non-null values with a 0.0% null rate, suggesting it is a timestamp or date field. However, saturn skipped profiling it (kind: 'unknown', no stats, no uniqueness count), so no distribution, range, or format details are available. The absence of any computed statistics prevents assessment of cardinality, temporal range, or potential drift. Treat with caution until the parsing issue causing the skip is resolved.","role":"timestamp","scope":"column","target":"date","treatment":"Investigate why saturn skipped this column, parse to a proper datetime type, then extract temporal features or use as an index."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","n","null_rate","n_unique","stats"],"model":"anthropic:default","narrative":"The column 'effective' contains 571 non-null values but was skipped by the profiler, leaving its type and distribution entirely unknown. No stats, uniqueness count, or value samples are available, so its semantic role cannot be determined from this evidence alone. The name suggests a boolean flag (e.g., is-effective) or a date (effective date/start), but this is speculation beyond the evidence.","role":"other","scope":"column","target":"effective","treatment":"Manually inspect raw values to determine type, then re-profile before any modelling use."},{"confidence":"low","critiques":[],"evidence_keys":["column","kind","n","null_rate","alerts","n_unique","stats"],"model":"anthropic:default","narrative":"The column 'expires' likely represents an expiration date or timestamp field, but the profiler skipped analysis entirely, yielding no stats, no uniqueness count, and a kind of 'unknown'. With 571 non-null rows and zero null rate, data is present but its structure or encoding prevented saturn from classifying it. No further distributional signals are available from the evidence.","role":"timestamp","scope":"column","target":"expires","treatment":"Inspect raw values to confirm encoding (ISO string, epoch int, or other format), parse to datetime, then use as a feature or filter boundary."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","column","n","null_rate","kind","stats"],"model":"anthropic:default","narrative":"The column 'onset' likely records the timing or start of a clinical or epidemiological event (e.g., symptom onset date), but the profiler emitted a 'skipped' alert and returned no stats, leaving its true type and distribution entirely uncharacterised. With 571 non-null rows and zero null rate, data is present, but nothing about format, uniqueness, or value range can be confirmed from this evidence alone. An analyst should inspect raw values to determine whether it is a date string, numeric duration, or categorical stage before any downstream use.","role":"timestamp","scope":"column","target":"onset","treatment":"Inspect raw values to confirm type (date vs. numeric vs. categorical), then parse or encode accordingly before modelling."},{"confidence":"low","critiques":[],"evidence_keys":["alerts","n","null_rate","kind","stats"],"model":"anthropic:default","narrative":"The column 'sent' has 571 non-null rows but was skipped by the profiler, leaving its type and value distribution entirely unknown. No stats, uniqueness counts, or distribution metrics are available. The name suggests a boolean flag (e.g., message/email sent status) or a timestamp, but this cannot be confirmed from the evidence. An analyst should inspect raw values directly before any downstream use.","role":"other","scope":"column","target":"sent","treatment":"Inspect raw values to determine dtype, then re-profile before any modelling or filtering."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","cardinality","entropy_ratio","null_rate","top_values"],"model":"anthropic:default","narrative":"This column encodes an analyst-assigned confidence level for some observation or classification, with four ordinal categories: Likely, Observed, Unknown, and Possible. The distribution is severely skewed: 'Likely' dominates at 89.3% of all records (503/571), while 'Observed', 'Unknown', and 'Possible' each account for only 18\u201324 records. The low entropy ratio of 0.328 confirms near-constant behaviour, and the 1.4% null rate is minor. The near-total dominance of a single category limits this column's discriminative power as a feature.","role":"label","scope":"column","target":"certainty","treatment":"Ordinal-encode with awareness of severe class imbalance; consider collapsing minority categories or using as a stratification variable rather than a predictive feature."},{"confidence":"high","critiques":[],"evidence_keys":["n_unique","top_value","top_rate","entropy_ratio","null_rate","top_values"],"model":"anthropic:default","narrative":"This column contains National Weather Service alert/advisory event type names, serving as a categorical label for meteorological warning events. With 35 unique values across 571 rows, it covers a meaningful range of weather phenomena. 'Small Craft Advisory' dominates at 26.5% (149 occurrences), while the top 4 event types together account for the majority of records \u2014 suggesting a skewed distribution toward marine and winter/wind events. Entropy ratio of 0.72 indicates moderate-to-high diversity, but the heavy concentration in a few categories is worth noting for class-imbalance handling in any classification task.","role":"label","scope":"column","target":"event","treatment":"One-hot encode or target-encode for modelling; be aware of class imbalance with 'Small Craft Advisory' at 26.5% and many tail categories."},{"confidence":"high","critiques":[],"evidence_keys":["top_values","top_rate","top_value","n_unique","null_rate","entropy_ratio","n"],"model":"anthropic:default","narrative":"This column is an ordinal severity classification with 5 levels \u2014 Moderate, Minor, Severe, Unknown, and Extreme \u2014 likely describing the intensity of incidents, events, or conditions. 'Moderate' dominates at 36.9% of records (208/571), and 'Extreme' is strikingly rare at only 5 occurrences, suggesting a heavily right-skewed real-world distribution where catastrophic events are uncommon. The 19 'Unknown' values represent a data-quality concern distinct from the 1.4% null rate, effectively adding a second form of missingness. Entropy ratio of 0.77 indicates a reasonably spread distribution, though the extreme imbalance at the tail warrants attention for any classification task.","role":"label","scope":"column","target":"severity","treatment":"Encode as ordinal (Minor < Moderate < Severe < Extreme); treat 'Unknown' as a separate missing indicator before modelling."},{"confidence":"high","critiques":[],"evidence_keys":["top_value","top_rate","cardinality","entropy_ratio","top_values","null_rate"],"model":"anthropic:default","narrative":"This column is a categorical urgency classification, likely from an incident or request management system, with 5 distinct levels. It is severely dominated by 'Expected' (510 out of 571 rows, 90.6%), leaving the remaining 4 categories \u2014 'Unknown', 'Future', 'Past', and 'Immediate' \u2014 collectively accounting for fewer than 10% of records. The very low entropy ratio of 0.27 confirms extreme class imbalance, which will limit this column's discriminative power in most models. The 'Immediate' category, presumably the most critical, appears only 6 times, making it near-invisible to any classifier trained on this distribution.","role":"feature","scope":"column","target":"urgency","treatment":"One-hot encode but flag severe class imbalance; consider oversampling minority classes (especially 'Immediate' with n=6) or collapsing into binary 'Expected vs. Other' before modelling."}],"providers":["anthropic:default"],"total_usage":{"completion_tokens":3421,"prompt_tokens":12841,"total_tokens":16262}},"language_counts":{},"meta":{"generated_at":"2026-06-22T00:46:08+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"}}