SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxOeS1HU3p1c1B0ajVtLU5GYkFxUHpuWGJPSDBmbEw2LWVOcU5QelNlaHVaSHdYNGY5MC1XRmJaZm5haXhLblVfbWFVMHZ3cDFhQkQ3NXpVcjhWelN3SGg5NWgzVWtlb3ZvMU1VaU9pd2JMbGdiNkd3cHVNaE5zeHBNdzZPYWxFemxQ?oc=5","as_of":"2026-04-10T17:15:06.516150+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxOeS1HU3p1c1B0ajVtLU5GYkFxUHpuWGJPSDBmbEw2LWVOcU5QelNlaHVaSHdYNGY5MC1XRmJaZm5haXhLblVfbWFVMHZ3cDFhQkQ3NXpVcjhWelN3SGg5NWgzVWtlb3ZvMU1VaU9pd2JMbGdiNkd3cHVNaE5zeHBNdzZPYWxFemxQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b3a937a9f6a198fb","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T17:18:36.143213+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxOeS1HU3p1c1B0ajVtLU5GYkFxUHpuWGJPSDBmbEw2LWVOcU5QelNlaHVaSHdYNGY5MC1XRmJaZm5haXhLblVfbWFVMHZ3cDFhQkQ3NXpVcjhWelN3SGg5NWgzVWtlb3ZvMU1VaU9pd2JMbGdiNkd3cHVNaE5zeHBNdzZPYWxFemxQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"denverpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxOeS1HU3p1c1B0ajVtLU5GYkFxUHpuWGJPSDBmbEw2LWVOcU5QelNlaHVaSHdYNGY5MC1XRmJaZm5haXhLblVfbWFVMHZ3cDFhQkQ3NXpVcjhWelN3SGg5NWgzVWtlb3ZvMU1VaU9pd2JMbGdiNkd3cHVNaE5zeHBNdzZPYWxFemxQ?oc=5","source_event_id":"evt_97b03b6b3777","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6a80384a5802e819","published_at":"2026-04-10T05:00:25+00:00","publisher_domain":"denverpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sports_team","name":"University of Denver (DU) Pioneers","relevance":"primary winner/advancing team","symbol":"","type":"team"},{"asset_class":"sports_team","name":"University of Michigan Wolverines","relevance":"primary opponent eliminated from semifinal","symbol":"","type":"team"},{"asset_class":"sports_team","name":"Wisconsin","relevance":"next opponent mentioned for Frozen Four title game","symbol":"","type":"team"},{"asset_class":"sports_event","name":"Frozen Four","relevance":"competition stage where result occurred","symbol":"","type":"tournament_stage"},{"asset_class":"sports_event","name":"NCAA title game","relevance":"next stage DU is advancing to","symbol":"","type":"tournament_stage"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not include the actual game narrative; only the headline and the supplied source summary provide the substantive facts.","Exact final score, goal scorers/timing beyond the mentioned overtime winner, and the exact date/time of the next game are not present in the provided text.","Whether the Wisconsin game is explicitly the NCAA title game or the Frozen Four championship game is not fully disambiguated in the provided excerpts (headline variants suggest both)."],"key_facts":["DU defeated Michigan in double overtime in the Frozen Four semifinal (per headline/source summary).","DU\u2019s win advanced them to the NCAA title game (per headline/source summary).","The next mentioned matchup is against Wisconsin for the Frozen Four title (per source summary/headline variants).","Anderson\u2019s overtime winner and Hicks\u2019 49 saves are mentioned in the provided source summary (specifics not fully verifiable from the cleaned article text shown)."],"numeric_claims":[{"label":"Overtime periods","value":"2 (double OT)"},{"label":"Saves by Hicks","value":"49"}],"primary_claim":"DU (University of Denver) beat Michigan in double overtime in the Frozen Four semifinal, advancing to the NCAA title game.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Denver\u2019s Pioneers defeated Michigan in the Frozen Four semifinal in double overtime, extending their run to the NCAA title game. The next near-term catalyst is their upcoming matchup against Wisconsin for the Frozen Four championship (and thus the path to the NCAA title game).","topics":["NCAA Division I men's ice hockey","Frozen Four semifinal","double overtime","team advancement","upcoming championship matchup"]},"source":"The Denver Post","source_domain":"denverpost.com","source_url":"https://www.denverpost.com","summary":"DU Pioneers outlast Michigan in double OT at Frozen Four, dream run continues to NCAA title game The Denver Post Denver stuns Michigan in 2OT, plays Wisconsin for Frozen Four title ESPN 2026 DI men's ice hockey championship: Bracket, schedule, scores NCAA.com Anderson's OT Winner, Hicks' 49 Saves Sends Denver to Title Game University of Denver Athletics Top-Ranked Michigan's Season Ends in 2OT in Frozen Four Semifinal University of Michigan Athletics","title":"DU Pioneers outlast Michigan in double OT at Frozen Four, dream run continues to NCAA title game - The Denver Post","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/m=syndicationarticleview,_b,_tp"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_bf2f5d5438d7 in signals