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/CBMiX0FVX3lxTE1WU1JhSGlqVEFPZTB0V3VaQ1lIdG5SUi02eGlrb19UMWJsTEJsYW5pcV9VeHkwbHM3cHFBU3RNdjVDT19CT3JhSjhTYTRiUjlZQldwZnVsdEdKdnE1RWtr?oc=5","as_of":"2026-04-09T12:52:06.103156+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/CBMiX0FVX3lxTE1WU1JhSGlqVEFPZTB0V3VaQ1lIdG5SUi02eGlrb19UMWJsTEJsYW5pcV9VeHkwbHM3cHFBU3RNdjVDT19CT3JhSjhTYTRiUjlZQldwZnVsdEdKdnE1RWtr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e946c9c98ea37f8b","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-09T23:24:07.289279+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiX0FVX3lxTE1WU1JhSGlqVEFPZTB0V3VaQ1lIdG5SUi02eGlrb19UMWJsTEJsYW5pcV9VeHkwbHM3cHFBU3RNdjVDT19CT3JhSjhTYTRiUjlZQldwZnVsdEdKdnE1RWtr?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"jpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiX0FVX3lxTE1WU1JhSGlqVEFPZTB0V3VaQ1lIdG5SUi02eGlrb19UMWJsTEJsYW5pcV9VeHkwbHM3cHFBU3RNdjVDT19CT3JhSjhTYTRiUjlZQldwZnVsdEdKdnE1RWtr?oc=5","source_event_id":"evt_bfb8f6394a78","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"72aaa5bc64a14af7","published_at":"2026-04-09T06:46:27+00:00","publisher_domain":"jpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United Kingdom","relevance":"warned about destabilization risk","symbol":"","type":"country"},{"asset_class":"sovereign","name":"France","relevance":"warned about destabilization risk","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"conducting strikes alleged to risk destabilizing ceasefire","symbol":"","type":"country"},{"asset_class":"non-state_actor","name":"Hezbollah","relevance":"referenced in related European criticism of IDF strikes","symbol":"","type":"armed group"},{"asset_class":"sovereign","name":"Lebanon","relevance":"called to be included in Iran ceasefire deal (per source summary)","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"referenced in US-Iran ceasefire deal and Iran ceasefire framework","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"referenced as part of US-Iran ceasefire deal (per source summary)","symbol":"","type":"country"},{"asset_class":"politician","name":"Yvette Cooper","relevance":"urged Lebanon inclusion and toll-free Strait of Hormuz reopening (per source summary)","symbol":"","type":"person"},{"asset_class":"geography","name":"Strait of Hormuz","relevance":"called for toll-free reopening (per source summary)","symbol":"","type":"geographic chokepoint"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is not the actual article content; it appears to be page styling/HTML boilerplate, so only the headline and the supplied source summary can be treated as grounded facts.","The specific ceasefire being referenced (who agreed, start/end dates, and current status) is not stated in the provided text.","No details are given on the timing, location, or scale of Israel\u2019s strikes beyond the general claim that they risk destabilizing the ceasefire.","The exact mechanism of the UK/France warning (diplomatic channel, statement wording, or whether it was public) is not included.","Near-term catalyst timing (e.g., when the ceasefire could break) is not specified in the provided text."],"key_facts":["The Jerusalem Post headline states that the UK and France warned Israel that its strikes risk destabilizing the ceasefire.","The provided source summary includes additional headlines: European countries criticized IDF strikes on Hezbollah as \u201cUnacceptable\u201d (The Times of Israel).","The provided source summary includes: Britain to call for toll-free Strait of Hormuz reopening and that Lebanon must be part of an Iran ceasefire (CNBC).","The provided source summary includes: Yvette Cooper urging Lebanon\u2019s inclusion in a US-Iran ceasefire deal and full toll-free reopening of the Strait of Hormuz (The Guardian)."],"numeric_claims":[],"primary_claim":"UK and France warned that Israel\u2019s strikes risk destabilizing the ceasefire.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The Jerusalem Post reports that the UK and France warned Israel that its strikes could destabilize an existing ceasefire. Separate related headlines in the provided source summary also reference European criticism of IDF strikes on Hezbollah and UK/European positions on including Lebanon in an Iran ceasefire framework, alongside calls for toll-free Strait of Hormuz reopening.","topics":["ceasefire stability","Israel-Hezbollah conflict","European diplomatic warnings","UK/France policy statements","Iran ceasefire negotiations","Strait of Hormuz shipping access"]},"source":"The Jerusalem Post","source_domain":"jpost.com","source_url":"https://www.jpost.com","summary":"UK, France warn Israel strikes risk destabilizing ceasefire The Jerusalem Post Britain to call for toll-free Strait of Hormuz, says Lebanon must be part of Iran ceasefire CNBC Lebanon must be included in US-Iran ceasefire deal, Yvette Cooper to say The Guardian \u2018Unacceptable\u2019: European countries slam IDF strikes on Hezbollah amid US-Iran truce The Times of Israel Cooper urges full and toll-free reopening of Strait of Hormuz BBC","title":"UK, France warn Israel strikes risk destabilizing ceasefire - The Jerusalem Post","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_cfaf7a8756e1 in signals