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/CBMiWkFVX3lxTE5xVmlCbExfUmNMRy1tTmRPMkhrZm1PUUlpMEs2NHFwdVYtNUlDbkJzLVl0dG5ZbTlLN2FnWVZwVTY2RkQ0YmtuV1JpcVI2Y3lQSjN2NVh0c0h5dw?oc=5","as_of":"2026-04-08T21:48:34.469299+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/CBMiWkFVX3lxTE5xVmlCbExfUmNMRy1tTmRPMkhrZm1PUUlpMEs2NHFwdVYtNUlDbkJzLVl0dG5ZbTlLN2FnWVZwVTY2RkQ0YmtuV1JpcVI2Y3lQSjN2NVh0c0h5dw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_377748a15f3b01dc","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:27.316947+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5xVmlCbExfUmNMRy1tTmRPMkhrZm1PUUlpMEs2NHFwdVYtNUlDbkJzLVl0dG5ZbTlLN2FnWVZwVTY2RkQ0YmtuV1JpcVI2Y3lQSjN2NVh0c0h5dw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE5xVmlCbExfUmNMRy1tTmRPMkhrZm1PUUlpMEs2NHFwdVYtNUlDbkJzLVl0dG5ZbTlLN2FnWVZwVTY2RkQ0YmtuV1JpcVI2Y3lQSjN2NVh0c0h5dw?oc=5","source_event_id":"evt_59872f12695e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a7355976d24f96d5","published_at":"2026-04-08T20:25:49+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"medium","symbol":"","type":"country"},{"asset_class":"media","name":"BBC","relevance":"medium","symbol":"","type":"media"},{"asset_class":"media","name":"The New York Times","relevance":"low","symbol":"","type":"media"},{"asset_class":"media","name":"AP News","relevance":"low","symbol":"","type":"media"},{"asset_class":"media","name":"The Washington Post","relevance":"low","symbol":"","type":"media"},{"asset_class":"media","name":"Vox","relevance":"low","symbol":"","type":"media"}],"event_type":"conflict","information_gaps":["The provided content does not include the actual ceasefire terms, start/end dates, or verification mechanisms.","No specific incident(s) of alleged ceasefire violations are described in the provided text.","The exact nature of the comparison between Iran\u2019s 10-point proposal and US demands is not included.","No market/asset impact details are provided (this appears to be geopolitical/conflict-focused).","The provided text does not specify whether the ceasefire is officially announced, signed, or conditional beyond the two-week framing."],"key_facts":["BBC: Coverage focuses on what is known about a two-week ceasefire between the US and Iran.","The New York Times: Discusses Iran\u2019s 10-point proposal and compares it to US demands (details not provided in the provided text).","Vox: Characterizes the ceasefire as already getting shaky (specific breach details not provided in the provided text).","AP News: Describes a shift from prior US threats toward agreeing to a two-week ceasefire with Tehran (specific prior threat language not provided in the provided text).","The Washington Post: Reports that Iran accuses the US and Israel of ceasefire violations and warns about the truce (specific incidents not provided in the provided text)."],"numeric_claims":[],"primary_claim":"A two-week US\u2013Iran ceasefire is in place but is being reported as shaky due to accusations of violations by Iran (and related claims by other parties).","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Multiple outlets report on a two-week ceasefire arrangement between the US and Iran, including what is included in Iran\u2019s proposal and claims of violations. The truce is described as unstable, with near-term risk of escalation tied to alleged ceasefire breaches.","topics":["US-Iran ceasefire","ceasefire violations","Iran proposal vs US demands","diplomatic negotiations","risk of escalation"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"What we know about the two-week ceasefire between the US and Iran BBC What Is In Iran\u2019s 10-Point Proposal, and How Does It Compare to U.S. Demands? The New York Times The ceasefire is already getting shaky vox.com How Trump went from threatening Iran's annihilation to agreeing to a 2-week ceasefire with Tehran AP News Iran accuses U.S. and Israel of ceasefire violations, threatening truce The Washington Post","title":"What we know about the two-week ceasefire between the US and Iran - BBC","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_1a797ccc7c90 in signals