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-08T09:22:54.724598+00:00","dedupe_key":"signal_enriched:news_delta:f2aabf7ed119fa77","evidence_event_ids":["evt_c7d5799cdcbc"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPakVPUUh5RENfTl9wRG1yMUpTMmJvRDdFRXFuYTdJUUdSX2M1czJFYjB5cVRvNlRhc3lza2tkR2hoaHZ2MUpSaXVsMlVIMmppdEVEVTZsc0k0aUNUQm4tWXZELW03dVhPWFQ2eUR1WDN3bXFVbzVqaTJhc1M5Q1dlazBPaC0tR1ltUE9ERkx0ZDJhS1Z6MTJmZXFJS1BndGF0dF8w?oc=5","as_of":"2026-04-08T09:22:54.724598+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/CBMiowFBVV95cUxPakVPUUh5RENfTl9wRG1yMUpTMmJvRDdFRXFuYTdJUUdSX2M1czJFYjB5cVRvNlRhc3lza2tkR2hoaHZ2MUpSaXVsMlVIMmppdEVEVTZsc0k0aUNUQm4tWXZELW03dVhPWFQ2eUR1WDN3bXFVbzVqaTJhc1M5Q1dlazBPaC0tR1ltUE9ERkx0ZDJhS1Z6MTJmZXFJS1BndGF0dF8w?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_eba451b0f8e10fa7","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-08T09:23:11.673839+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPakVPUUh5RENfTl9wRG1yMUpTMmJvRDdFRXFuYTdJUUdSX2M1czJFYjB5cVRvNlRhc3lza2tkR2hoaHZ2MUpSaXVsMlVIMmppdEVEVTZsc0k0aUNUQm4tWXZELW03dVhPWFQ2eUR1WDN3bXFVbzVqaTJhc1M5Q1dlazBPaC0tR1ltUE9ERkx0ZDJhS1Z6MTJmZXFJS1BndGF0dF8w?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"global.morningstar.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPakVPUUh5RENfTl9wRG1yMUpTMmJvRDdFRXFuYTdJUUdSX2M1czJFYjB5cVRvNlRhc3lza2tkR2hoaHZ2MUpSaXVsMlVIMmppdEVEVTZsc0k0aUNUQm4tWXZELW03dVhPWFQ2eUR1WDN3bXFVbzVqaTJhc1M5Q1dlazBPaC0tR1ltUE9ERkx0ZDJhS1Z6MTJmZXFJS1BndGF0dF8w?oc=5","source_event_id":"evt_c7d5799cdcbc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"86e5805ee73da78e","published_at":"2026-04-08T09:17:12+00:00","publisher_domain":"global.morningstar.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["Q1"],"entities":[{"asset_class":"","name":"Morningstar Canada","relevance":"high","symbol":"","type":"media_outlet"}],"event_type":"price_action","information_gaps":["No article body content is available beyond the headline, so the specific reasons for the Q1 decline are not provided.","No specific companies, sectors, indices, or tickers are mentioned.","No timing details (e.g., which quarter/month) for when opportunities may appear are provided beyond the general phrase 'may be ahead'.","No performance magnitude (percent/absolute returns) is included in the provided text."],"key_facts":["The headline states that tech stocks sank in Q1.","The headline states that the biggest opportunities may be ahead.","The source is Morningstar Canada."],"numeric_claims":[],"primary_claim":"Tech stocks sank in Q1, but the biggest opportunities may be ahead, according to Morningstar Canada.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"Morningstar Canada reports that tech stocks fell during Q1, but suggests the largest opportunities may come later. The provided content includes only the headline and no article details.","topics":["tech stocks","Q1 performance","market outlook","investment opportunities"]},"source":"Morningstar Canada","source_domain":"global.morningstar.com","source_url":"https://global.morningstar.com","summary":"Tech Stocks Sank in Q1\u2014but the Biggest Opportunities May Be Ahead Morningstar Canada","title":"Tech Stocks Sank in Q1\u2014but the Biggest Opportunities May Be Ahead - Morningstar Canada","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 5619 in events