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/CBMimAFBVV95cUxQMTRCMzBLRVRCWkF1MkVQTktfeDAwYWVBeGZDdmw3VFB4WlpFVEp0YnZxQ2ZFaDVZenhFREZaUE1ubFU3YjN0WTBMcnI2SVB3VzZWcEJNdFdVVzFsX2x0UV9DQ2Y1ZGRhN2JtVGtNSlF6dmJacHVxUUFUOF9IYy1Md3pHaFFoWllXYzQwOVZ5WDdrcno0Q000bw?oc=5","as_of":"2026-04-12T15:32:26.388086+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQMTRCMzBLRVRCWkF1MkVQTktfeDAwYWVBeGZDdmw3VFB4WlpFVEp0YnZxQ2ZFaDVZenhFREZaUE1ubFU3YjN0WTBMcnI2SVB3VzZWcEJNdFdVVzFsX2x0UV9DQ2Y1ZGRhN2JtVGtNSlF6dmJacHVxUUFUOF9IYy1Md3pHaFFoWllXYzQwOVZ5WDdrcno0Q000bw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ca653dc5216ea541","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=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T16:11:39.527002+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQMTRCMzBLRVRCWkF1MkVQTktfeDAwYWVBeGZDdmw3VFB4WlpFVEp0YnZxQ2ZFaDVZenhFREZaUE1ubFU3YjN0WTBMcnI2SVB3VzZWcEJNdFdVVzFsX2x0UV9DQ2Y1ZGRhN2JtVGtNSlF6dmJacHVxUUFUOF9IYy1Md3pHaFFoWllXYzQwOVZ5WDdrcno0Q000bw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nhl.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQMTRCMzBLRVRCWkF1MkVQTktfeDAwYWVBeGZDdmw3VFB4WlpFVEp0YnZxQ2ZFaDVZenhFREZaUE1ubFU3YjN0WTBMcnI2SVB3VzZWcEJNdFdVVzFsX2x0UV9DQ2Y1ZGRhN2JtVGtNSlF6dmJacHVxUUFUOF9IYy1Md3pHaFFoWllXYzQwOVZ5WDdrcno0Q000bw?oc=5","source_event_id":"evt_b5bbbaeb1cd0","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"1c621671ab0c7dc7","published_at":"2026-04-12T02:29:32+00:00","publisher_domain":"nhl.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sports_team","name":"Detroit Red Wings","relevance":"high","symbol":"","type":"sports_team"}],"event_type":"other","information_gaps":["No article text is available, so the specific game/date and the opponent details are not confirmed from the provided content.","The signal does not provide the score, standings context, or the exact timing of the elimination beyond \u201cafter elimination.\u201d","No tradable asset symbols are provided; this is a sports-team news item without financial instrument identifiers."],"key_facts":["The headline states the Red Wings are \u201cdown\u201d after elimination.","The elimination extends the Red Wings\u2019 playoff drought to 10 years.","The provided source summary also states the Red Wings missed playoffs for the 10th straight season."],"numeric_claims":[{"label":"playoff_drought_years","value":"10"},{"label":"straight_seasons_missed_playoffs","value":"10"}],"primary_claim":"The Red Wings\u2019 elimination extends their playoff drought to 10 years.","relevance_score":0.35,"sentiment":"negative","source_quality":"unknown","summary":"The Detroit Red Wings were eliminated from the NHL playoffs, extending their current playoff drought to 10 consecutive seasons.","topics":["NHL","playoffs","elimination","playoff drought","Detroit Red Wings"]},"source":"NHL.com","source_domain":"nhl.com","source_url":"https://www.nhl.com","summary":"Red Wings \u2018down\u2019 after elimination extends playoff drought to 10 years NHL.com Wojo: Red Wings miss playoffs again, and this collapse demands answers The Detroit News Red Wings miss playoffs for 10th straight season, scoring woes among factors NHL.com Red Wings lose, extend NHL's longest current playoff drought ESPN Devils Top Red Wings 5-3 in Motown All About The Jersey","title":"Red Wings \u2018down\u2019 after elimination extends playoff drought to 10 years - NHL.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/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_429c47dde712 in signals