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/CBMiWkFVX3lxTE94YjJRSkJYajlZSDFjVGdUUlpRcWk0Z1FRWGdBajQ1SktObHJ4Qmp6OVlSVkQ4elFydXJaa2xjemlaRUpydmVlNGl2MVF6OVd1LXg3MEdhWVpHdw?oc=5","as_of":"2026-04-10T18:45:20.644848+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/CBMiWkFVX3lxTE94YjJRSkJYajlZSDFjVGdUUlpRcWk0Z1FRWGdBajQ1SktObHJ4Qmp6OVlSVkQ4elFydXJaa2xjemlaRUpydmVlNGl2MVF6OVd1LXg3MEdhWVpHdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_77bba3831552e9ef","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-10T18:47:16.234146+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE94YjJRSkJYajlZSDFjVGdUUlpRcWk0Z1FRWGdBajQ1SktObHJ4Qmp6OVlSVkQ4elFydXJaa2xjemlaRUpydmVlNGl2MVF6OVd1LXg3MEdhWVpHdw?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/CBMiWkFVX3lxTE94YjJRSkJYajlZSDFjVGdUUlpRcWk0Z1FRWGdBajQ1SktObHJ4Qmp6OVlSVkQ4elFydXJaa2xjemlaRUpydmVlNGl2MVF6OVd1LXg3MEdhWVpHdw?oc=5","source_event_id":"evt_67a211c67fed","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cd00bfff7c52f5de","published_at":"2026-04-10T18:21:59+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["Tuesday (exact date not specified in provided text)"],"entities":[{"asset_class":"sovereign","name":"Lebanon","relevance":"directly stated condition for talks","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"counterparty to proposed talks; subject of strikes mentioned in source summary","symbol":"","type":"country"},{"asset_class":"person","name":"Netanyahu","relevance":"approves talks with Lebanon (per source summary)","symbol":"","type":"person"},{"asset_class":"sovereign","name":"United States","relevance":"pressuring Israel to agree to ceasefire ahead of talks (per source summary)","symbol":"","type":"country"},{"asset_class":"media","name":"BBC","relevance":"publisher of the headline","symbol":"","type":"media"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is not actually the article content (it appears to be page styling/HTML), so only the headline and the supplied source summary can be used for grounded claims.","Details of what specific ceasefire terms Lebanon requires are not provided in the signal.","Whether talks are scheduled to begin immediately after a ceasefire or how long a ceasefire must hold is not specified.","The reference to an \u201cIran ceasefire\u201d is only present in the provided source summary; the relationship to Lebanon\u2013Israel talks is not fully detailed here."],"key_facts":["Lebanon\u2019s position is that a ceasefire must be in place before Israel talks (BBC headline).","Netanyahu approved talks with Lebanon after Israeli strikes imperil an Iran ceasefire (as stated in the provided source summary; not fully verifiable from the cleaned article text).","The U.S. is pushing Israel to agree to a ceasefire ahead of Tuesday talks with Lebanon (as stated in the provided source summary; not fully verifiable from the cleaned article text)."],"numeric_claims":[],"primary_claim":"Lebanon says a ceasefire must be in place before Israel talks.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Lebanon says any Israel\u2013Lebanon talks must be preceded by a ceasefire. The signal implies negotiations are being conditioned on stopping fighting, with near-term timing tied to upcoming talks referenced by other outlets.","topics":["Lebanon-Israel ceasefire","negotiations","diplomacy","Middle East conflict","U.S. pressure"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Lebanon says ceasefire must be in place before Israel talks BBC Netanyahu approves talks with Lebanon after Israeli strikes imperil Iran ceasefire AP News US said pushing Israel to agree to ceasefire ahead of Tuesday talks with Lebanon The Times of Israel Netanyahu announces negotiations with Lebanon after U.S. pressure Axios Fighting in Lebanon Continues Even as Trump Asks Israel to Limit Attacks WSJ","title":"Lebanon says ceasefire must be in place before Israel talks - 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_4e5da530d237 in signals