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-08T21:48:33.806987+00:00","dedupe_key":"signal_enriched:market_headline_delta:3c4fcf2ce9a15b26","evidence_event_ids":["evt_636010035cd9"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi2AFBVV95cUxPdGwxZDdHRlhHTGVkajZPcGY4bXQtMVFIekN1VVA4Z2JTWVdsdXN0NHREbkpMenhiZGZWM1JRODJVdFluSjZnTi1UNE9RaHJGbG1STFQtYVZ4Qm4zZi1Nb1prUXIwRXdWRGJ3R2VhN3RaUEtneE1QTGh2dlFSdGFPejFjTXo3d3diaW9JemlVbHhHb0U4Zl96WTkycnhxeGRvQ1lPTW9YY1NwdEpwMGZWTUNEWU42eTktQjl5ejY2THhyWEk0NUxOOHgzTXNKa1Z6WTl3ZlN2OVY?oc=5","as_of":"2026-04-08T21:48:33.806987+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/CBMi2AFBVV95cUxPdGwxZDdHRlhHTGVkajZPcGY4bXQtMVFIekN1VVA4Z2JTWVdsdXN0NHREbkpMenhiZGZWM1JRODJVdFluSjZnTi1UNE9RaHJGbG1STFQtYVZ4Qm4zZi1Nb1prUXIwRXdWRGJ3R2VhN3RaUEtneE1QTGh2dlFSdGFPejFjTXo3d3diaW9JemlVbHhHb0U4Zl96WTkycnhxeGRvQ1lPTW9YY1NwdEpwMGZWTUNEWU42eTktQjl5ejY2THhyWEk0NUxOOHgzTXNKa1Z6WTl3ZlN2OVY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e1ba030840f84ec2","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-09T22:13:30.466571+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi2AFBVV95cUxPdGwxZDdHRlhHTGVkajZPcGY4bXQtMVFIekN1VVA4Z2JTWVdsdXN0NHREbkpMenhiZGZWM1JRODJVdFluSjZnTi1UNE9RaHJGbG1STFQtYVZ4Qm4zZi1Nb1prUXIwRXdWRGJ3R2VhN3RaUEtneE1QTGh2dlFSdGFPejFjTXo3d3diaW9JemlVbHhHb0U4Zl96WTkycnhxeGRvQ1lPTW9YY1NwdEpwMGZWTUNEWU42eTktQjl5ejY2THhyWEk0NUxOOHgzTXNKa1Z6WTl3ZlN2OVY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi2AFBVV95cUxPdGwxZDdHRlhHTGVkajZPcGY4bXQtMVFIekN1VVA4Z2JTWVdsdXN0NHREbkpMenhiZGZWM1JRODJVdFluSjZnTi1UNE9RaHJGbG1STFQtYVZ4Qm4zZi1Nb1prUXIwRXdWRGJ3R2VhN3RaUEtneE1QTGh2dlFSdGFPejFjTXo3d3diaW9JemlVbHhHb0U4Zl96WTkycnhxeGRvQ1lPTW9YY1NwdEpwMGZWTUNEWU42eTktQjl5ejY2THhyWEk0NUxOOHgzTXNKa1Z6WTl3ZlN2OVY?oc=5","source_event_id":"evt_636010035cd9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f62c4882d8b5a8ba","published_at":"2026-04-08T21:22:29+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.78,"dates_mentioned":["April 8"],"entities":[{"asset_class":"commodity_futures","name":"Oil","relevance":"high","symbol":"CL=F","type":"commodity"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"equities_index","name":"Stock market (unspecified indices)","relevance":"medium","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["No specific oil price level, percentage change, or which oil benchmark is named in the provided text.","No specific stock indices or tickers are mentioned in the provided text.","No details on the timing, terms, or confirmation status of the \"Iran ceasefire\" are included in the provided text.","No quantitative market move (e.g., index points/percent) is provided in the provided text."],"key_facts":["Headline states: \"Oil Prices Plunge and Markets Rally on Iran Ceasefire\".","Headline is dated \"April 8\" and framed as \"Stock Market Today\"."],"numeric_claims":[],"primary_claim":"Oil prices plunged and markets rallied on an Iran ceasefire (Stock Market Today, April 8).","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"On April 8, the article headline claims oil prices plunged while stock markets rallied, attributing the move to an Iran ceasefire.","topics":["oil prices","market rally","Iran ceasefire","geopolitical risk"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Stock Market Today, April 8: Oil Prices Plunge and Markets Rally on Iran Ceasefire - The Motley Fool","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 8429 in events