SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-12T15:32:26.388086+00:00","dedupe_key":"signal_enriched:news_delta:2279f679356bf5c8","evidence_event_ids":["evt_b5bbbaeb1cd0"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 30028 in events