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-14T22:34:43.797235+00:00","dedupe_key":"signal_enriched:market_headline_delta:28af5d92b6670978","evidence_event_ids":["evt_a47dc721a299"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE9LVklyZlFhT08wcTRJYUs2dEc2VW4wUk1mWmFsWC1vNEx3dUdRMlkzQnB2ZWptWk5FQWhjalNfTmlaUGVja3pCTWV5QXhRZV9zZml5eW1rWnduNmo5VER3VmdzYjhfRGlyNkRSSzNvQjUybWd3ZWIxTm5OMA?oc=5","as_of":"2026-04-14T22:34:43.797235+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE9LVklyZlFhT08wcTRJYUs2dEc2VW4wUk1mWmFsWC1vNEx3dUdRMlkzQnB2ZWptWk5FQWhjalNfTmlaUGVja3pCTWV5QXhRZV9zZml5eW1rWnduNmo5VER3VmdzYjhfRGlyNkRSSzNvQjUybWd3ZWIxTm5OMA?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_abd878b0ada9b364","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-15T00:44:36.492427+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE9LVklyZlFhT08wcTRJYUs2dEc2VW4wUk1mWmFsWC1vNEx3dUdRMlkzQnB2ZWptWk5FQWhjalNfTmlaUGVja3pCTWV5QXhRZV9zZml5eW1rWnduNmo5VER3VmdzYjhfRGlyNkRSSzNvQjUybWd3ZWIxTm5OMA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"aol.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE9LVklyZlFhT08wcTRJYUs2dEc2VW4wUk1mWmFsWC1vNEx3dUdRMlkzQnB2ZWptWk5FQWhjalNfTmlaUGVja3pCTWV5QXhRZV9zZml5eW1rWnduNmo5VER3VmdzYjhfRGlyNkRSSzNvQjUybWd3ZWIxTm5OMA?oc=5","source_event_id":"evt_a47dc721a299","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"8a59e241d033a596","published_at":"2026-04-14T22:19:37+00:00","publisher_domain":"aol.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":["April 14"],"entities":[{"asset_class":"geopolitical","name":"Iran war","relevance":"high","symbol":"","type":"geopolitical_event"}],"event_type":"geopolitical_risk","information_gaps":["No article text was provided, so the specific markets (e.g., index names), magnitude of the move, and which \u201ctalks\u201d are referenced are not stated.","No tickers or specific tradable assets are mentioned in the provided text.","No details on timing, confirmation, or whether the move is continuation vs reversal beyond the headline wording."],"key_facts":["Headline dated April 14 references markets erasing Iran war losses.","The recovery is attributed to \u201ctalk optimism\u201d in the headline."],"numeric_claims":[],"primary_claim":"Stock markets erased losses from the Iran war on talk optimism.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"The headline says markets recovered losses related to the Iran war after talk optimism on April 14.","topics":["stock market","geopolitical risk","Iran","market recovery","optimism talks"]},"source":"AOL.com","source_domain":"aol.com","source_url":"https://www.aol.com","summary":"","tickers":[],"title":"Stock Market Today, April 14: Markets Erase Iran War Losses on Talk Optimism - AOL.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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 45458 in events