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/CBMiXEFVX3lxTFBtd05YT2ZUaXhubk04SWpjOW0wcHU3TWNETjM1eWNfVnNjUkpUeTM2UThjdlloYzJ2bENuQmQzVVdUZHJyZEhTUU5USlJwSHRScmJ2alFWSVRpb09N?oc=5","as_of":"2026-04-08T10:54:37.964212+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/CBMiXEFVX3lxTFBtd05YT2ZUaXhubk04SWpjOW0wcHU3TWNETjM1eWNfVnNjUkpUeTM2UThjdlloYzJ2bENuQmQzVVdUZHJyZEhTUU5USlJwSHRScmJ2alFWSVRpb09N?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3c7074a5fca72349","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-08T10:55:25.598005+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiXEFVX3lxTFBtd05YT2ZUaXhubk04SWpjOW0wcHU3TWNETjM1eWNfVnNjUkpUeTM2UThjdlloYzJ2bENuQmQzVVdUZHJyZEhTUU5USlJwSHRScmJ2alFWSVRpb09N?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/CBMiXEFVX3lxTFBtd05YT2ZUaXhubk04SWpjOW0wcHU3TWNETjM1eWNfVnNjUkpUeTM2UThjdlloYzJ2bENuQmQzVVdUZHJyZEhTUU5USlJwSHRScmJ2alFWSVRpb09N?oc=5","source_event_id":"evt_660cd2ad6b67","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fdfd08b98a153423","published_at":"2026-04-08T08:03:01+00:00","publisher_domain":"jpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Israeli leaders","relevance":"high","symbol":"","type":"group"},{"asset_class":"sovereign","name":"Israel","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"The Jerusalem Post","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"ceasefire","relevance":"high","symbol":"","type":"event"}],"event_type":"conflict","information_gaps":["Which specific ceasefire (date/parties/terms) is being referenced is not stated in the provided text.","The identities of the Israeli leaders involved and the exact accusations are not included in the provided excerpt.","No direct information is provided on market/economic impacts; only political instability is implied by the framing.","Near-term catalyst timing (e.g., vote, cabinet meeting, negotiations deadline) is not specified in the provided excerpt."],"key_facts":["The Jerusalem Post headline describes the situation as a \u201cPolitical disaster.\u201d","Israeli leaders are \u201clashing out\u201d over a ceasefire.","There is a split among Israeli leaders on who is to blame."],"numeric_claims":[],"primary_claim":"Israeli leaders are lashing out over a ceasefire and are split on who is to blame, described by The Jerusalem Post as a \u201cpolitical disaster.\u201d","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Jerusalem Post reports that Israeli political leaders are publicly attacking each other over a ceasefire arrangement, with disagreement over who is responsible for the terms and outcomes. The dispute is framed as a \u201cpolitical disaster,\u201d suggesting near-term instability in Israel\u2019s internal political cohesion around the ceasefire.","topics":["Israel","ceasefire","internal political dispute","blame allocation","Middle East crisis"]},"source":"The Jerusalem Post","source_domain":"jpost.com","source_url":"https://www.jpost.com","summary":"'Political disaster': Israeli leaders lash out over ceasefire, split on who\u2019s to blame The Jerusalem Post Middle East crisis live: Israel says Iran war ceasefire doesn\u2019t include Lebanon as air strikes continue The Guardian Netanyahu says US-Iran ceasefire \u2018does not include Lebanon\u2019 Al Jazeera Israel backs Trump's two-week pause on Iran strikes, says Lebanon excluded Reuters US Iran War Ceasefire News Live Updates: 'Fruit of Khamenei's blood': Iran president says ceasefire inked on Tehran's terms The Times of India","title":"'Political disaster': Israeli leaders lash out over ceasefire, split on who\u2019s to blame - 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_9114ccb3b85a in signals