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-12T20:02:46.159605+00:00","dedupe_key":"signal_enriched:market_headline_delta:9730983aa77972e6","evidence_event_ids":["evt_73ae93c59ab4"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxQbkVCNTFHWVJEakpMTXVfaWN2ZzI5RERTel9IWDVZOHFzS19kOXptRlNHRGhTUDgzYlVJRzRTcXFkTm94SEdZUnhxclR1Qll0ci13Y1RjeDgxNVVtSjZRVU9fX0tDN1NzNkswRThCOHFKY0hoRFBYOW9pM0RHa2p1RVM3bHJyQlpmZzY2endiUHU0cjgzNEdKUXlWMlVhRTFGdmlNSUxmYnNaSm41UkVN?oc=5","as_of":"2026-04-12T20:02:46.159605+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/CBMirwFBVV95cUxQbkVCNTFHWVJEakpMTXVfaWN2ZzI5RERTel9IWDVZOHFzS19kOXptRlNHRGhTUDgzYlVJRzRTcXFkTm94SEdZUnhxclR1Qll0ci13Y1RjeDgxNVVtSjZRVU9fX0tDN1NzNkswRThCOHFKY0hoRFBYOW9pM0RHa2p1RVM3bHJyQlpmZzY2endiUHU0cjgzNEdKUXlWMlVhRTFGdmlNSUxmYnNaSm41UkVN?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_dbe0e2d233798aa3","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-12T21:56:40.654482+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxQbkVCNTFHWVJEakpMTXVfaWN2ZzI5RERTel9IWDVZOHFzS19kOXptRlNHRGhTUDgzYlVJRzRTcXFkTm94SEdZUnhxclR1Qll0ci13Y1RjeDgxNVVtSjZRVU9fX0tDN1NzNkswRThCOHFKY0hoRFBYOW9pM0RHa2p1RVM3bHJyQlpmZzY2endiUHU0cjgzNEdKUXlWMlVhRTFGdmlNSUxmYnNaSm41UkVN?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxQbkVCNTFHWVJEakpMTXVfaWN2ZzI5RERTel9IWDVZOHFzS19kOXptRlNHRGhTUDgzYlVJRzRTcXFkTm94SEdZUnhxclR1Qll0ci13Y1RjeDgxNVVtSjZRVU9fX0tDN1NzNkswRThCOHFKY0hoRFBYOW9pM0RHa2p1RVM3bHJyQlpmZzY2endiUHU0cjgzNEdKUXlWMlVhRTFGdmlNSUxmYnNaSm41UkVN?oc=5","source_event_id":"evt_73ae93c59ab4","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"f7837b28cf76d856","published_at":"2026-04-12T19:40:10+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity_market","name":"Stock market","relevance":"high","symbol":"","type":"index/market"},{"asset_class":"geopolitical_risk","name":"Iran war","relevance":"high","symbol":"","type":"geopolitical_event"},{"asset_class":"equities_sector","name":"Software stocks","relevance":"medium","symbol":"","type":"sector"}],"event_type":"geopolitical_risk","information_gaps":["No article text or additional details were provided.","No specific index, tickers, or companies are mentioned in the provided headline.","No timeframe or magnitude of the 'resilient' performance is provided.","No explanation or data supporting the resilience claim is available from the provided text."],"key_facts":["CNBC headline states the stock market has stayed resilient despite the Iran war.","CNBC headline states there has been a rout in software stocks."],"numeric_claims":[],"primary_claim":"The stock market has stayed resilient despite the Iran war and a software stock rout.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"The CNBC headline claims the stock market has remained resilient despite the Iran war and a rout in software stocks.","topics":["market resilience","Iran war","software stock rout","risk sentiment"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"","tickers":[],"title":"Why the stock market has stayed resilient despite the Iran war and software stock rout - CNBC","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 31042 in events