SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_328e5496ea99 in signals