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-10T16:36:00.966799+00:00","dedupe_key":"signal_enriched:news_delta:e7df527862d20ebd","evidence_event_ids":["evt_d7d052a84db9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxPV19LbWdoa2djUnF1NTl1SkZkOHgxOGVkangtTXJ4aXk4bUt4QXlCbEI4Q0Q5eFR2dDZZWEtiYnhHTnk4NEg5NEE2dFo3TUk4eDNuZGxTWG9MRDFEZlY5d25va2ljd0xJOUthdjlxYUk0Qm1MclE0c3V4SjMzQkswaVZXclU3WnNDZ3d0SlJCZmpFNk9PdGo1S3RFbzNfUnRHS1EteGZxTkVKWjQ?oc=5","as_of":"2026-04-10T16:36:00.966799+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/CBMiqwFBVV95cUxPV19LbWdoa2djUnF1NTl1SkZkOHgxOGVkangtTXJ4aXk4bUt4QXlCbEI4Q0Q5eFR2dDZZWEtiYnhHTnk4NEg5NEE2dFo3TUk4eDNuZGxTWG9MRDFEZlY5d25va2ljd0xJOUthdjlxYUk0Qm1MclE0c3V4SjMzQkswaVZXclU3WnNDZ3d0SlJCZmpFNk9PdGo1S3RFbzNfUnRHS1EteGZxTkVKWjQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ff4fe5dfd1516fd1","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-10T17:00:20.017174+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxPV19LbWdoa2djUnF1NTl1SkZkOHgxOGVkangtTXJ4aXk4bUt4QXlCbEI4Q0Q5eFR2dDZZWEtiYnhHTnk4NEg5NEE2dFo3TUk4eDNuZGxTWG9MRDFEZlY5d25va2ljd0xJOUthdjlxYUk0Qm1MclE0c3V4SjMzQkswaVZXclU3WnNDZ3d0SlJCZmpFNk9PdGo1S3RFbzNfUnRHS1EteGZxTkVKWjQ?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/CBMiqwFBVV95cUxPV19LbWdoa2djUnF1NTl1SkZkOHgxOGVkangtTXJ4aXk4bUt4QXlCbEI4Q0Q5eFR2dDZZWEtiYnhHTnk4NEg5NEE2dFo3TUk4eDNuZGxTWG9MRDFEZlY5d25va2ljd0xJOUthdjlxYUk0Qm1MclE0c3V4SjMzQkswaVZXclU3WnNDZ3d0SlJCZmpFNk9PdGo1S3RFbzNfUnRHS1EteGZxTkVKWjQ?oc=5","source_event_id":"evt_d7d052a84db9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"07ed454b817b92ff","published_at":"2026-04-10T16:28:09+00:00","publisher_domain":"global.morningstar.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"etf","name":"European ETF investors","relevance":"high","symbol":"","type":"investor_group"},{"asset_class":"macro/geopolitical","name":"Iran war","relevance":"high","symbol":"","type":"geopolitical_event"},{"asset_class":"financial_markets","name":"Markets","relevance":"medium","symbol":"","type":"market"},{"asset_class":"news","name":"Morningstar Canada","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["No article body text was provided beyond the headline/source summary, so the magnitude (e.g., flows, performance), specific ETF sectors/regions, and timing of the retreat are not stated.","No specific market indicators (index moves, volatility measures) are included in the provided text.","No details are given on whether the retreat is temporary or how long it is expected to last."],"key_facts":["Headline states European ETF investors are retreating to the sidelines.","Headline links the retreat to the Iran war rattling markets."],"numeric_claims":[],"primary_claim":"European ETF investors are retreating to the sidelines due to market volatility from the Iran war.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Morningstar Canada reports that European ETF investors are pulling back from risk as the Iran war rattles markets.","topics":["European ETFs","investor risk-off behavior","Iran war","market volatility"]},"source":"Morningstar Canada","source_domain":"global.morningstar.com","source_url":"https://global.morningstar.com","summary":"European ETF Investors Retreat to the Sidelines as Iran War Rattles Markets Morningstar Canada","title":"European ETF Investors Retreat to the Sidelines as Iran War Rattles Markets - 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 18281 in events