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:34.425356+00:00","dedupe_key":"signal_enriched:news_delta:7775b3938dc3e351","evidence_event_ids":["evt_e689ecb42593"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxOMURvSnF5R0VYR04tcWpUZUFhdHlLeDRabTNoTDZmTEU5OVU1UFAwNjNxNlhodV9mdVRfOE0xSjlURDVKMFdNa2ZEWS1ETmlZNkQ3c1J5TlZhd2dGeW9OVkNWOEhUSmM1dHplMjBvcmUzTFRzREhpQUdMbW9mQnBzUW9uY2dZa0lJRk96ZzRCeG5KVGxINThyRWFQV3d2QzFKUElqa1NGcnBGU0hlUFhobEJn?oc=5","as_of":"2026-04-08T21:48:34.425356+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/CBMisgFBVV95cUxOMURvSnF5R0VYR04tcWpUZUFhdHlLeDRabTNoTDZmTEU5OVU1UFAwNjNxNlhodV9mdVRfOE0xSjlURDVKMFdNa2ZEWS1ETmlZNkQ3c1J5TlZhd2dGeW9OVkNWOEhUSmM1dHplMjBvcmUzTFRzREhpQUdMbW9mQnBzUW9uY2dZa0lJRk96ZzRCeG5KVGxINThyRWFQV3d2QzFKUElqa1NGcnBGU0hlUFhobEJn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_debb0ed2226cddb4","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:14:13.335606+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxOMURvSnF5R0VYR04tcWpUZUFhdHlLeDRabTNoTDZmTEU5OVU1UFAwNjNxNlhodV9mdVRfOE0xSjlURDVKMFdNa2ZEWS1ETmlZNkQ3c1J5TlZhd2dGeW9OVkNWOEhUSmM1dHplMjBvcmUzTFRzREhpQUdMbW9mQnBzUW9uY2dZa0lJRk96ZzRCeG5KVGxINThyRWFQV3d2QzFKUElqa1NGcnBGU0hlUFhobEJn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"agweb.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxOMURvSnF5R0VYR04tcWpUZUFhdHlLeDRabTNoTDZmTEU5OVU1UFAwNjNxNlhodV9mdVRfOE0xSjlURDVKMFdNa2ZEWS1ETmlZNkQ3c1J5TlZhd2dGeW9OVkNWOEhUSmM1dHplMjBvcmUzTFRzREhpQUdMbW9mQnBzUW9uY2dZa0lJRk96ZzRCeG5KVGxINThyRWFQV3d2QzFKUElqa1NGcnBGU0hlUFhobEJn?oc=5","source_event_id":"evt_e689ecb42593","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"37e7efbadf2e4c76","published_at":"2026-04-08T20:45:00+00:00","publisher_domain":"agweb.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"geopolitical","name":"Iran","relevance":"central geopolitical driver mentioned in headline","symbol":"","type":"country"},{"asset_class":"commodity","name":"Ag (agricultural markets)","relevance":"affected asset class/sector in headline","symbol":"","type":"market sector"},{"asset_class":"commodity","name":"Energy markets","relevance":"affected asset class/sector in headline","symbol":"","type":"market sector"}],"event_type":"geopolitical_risk","information_gaps":["No specific commodities, indices, or futures contracts are named.","No direction/magnitude (e.g., percent moves) is provided in the provided text.","No timing details for the ceasefire or market reaction are included beyond the headline framing.","No causal mechanism beyond the headline linkage is provided in the provided text.","The provided \u201carticle text\u201d appears to be page styling/HTML content rather than the article body; therefore, additional details cannot be extracted."],"key_facts":["agweb.com headline states that \u201cAg and Energy Markets Unwind\u201d on \u201cPossible Iran Ceasefire.\u201d","headline frames the situation as uncertain: \u201cWill it Stick?\u201d"],"numeric_claims":[],"primary_claim":"Ag and energy markets are unwinding on possible Iran ceasefire news, with uncertainty about whether it will stick.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The headline reports that agricultural and energy markets are declining (\u201cunwinding\u201d) on expectations of a possible Iran ceasefire, while questioning whether the ceasefire will hold.","topics":["Iran ceasefire","agricultural markets","energy markets","market unwind","geopolitical risk"]},"source":"agweb.com","source_domain":"agweb.com","source_url":"https://www.agweb.com","summary":"Ag and Energy Markets Unwind on Possible Iran Ceasefire: Will it Stick? agweb.com","title":"Ag and Energy Markets Unwind on Possible Iran Ceasefire: Will it Stick? - agweb.com","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 8447 in events