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/CBMihAFBVV95cUxQOXVuZlJBM1diNm5qUHFaTUdNaVk2dUtuRm81Wk5hQVJVbkZmLS14dXcwQlpFUFJNWmEwZERCU0gxZ2N1b0VQR3k2S3JBcXVBMkQ5YVkybUdZUUVaSjByQTA4UWttck5yOVBzUXNJZnVCaVNWVDNxenpkR1FyeTYySnVxdlE?oc=5","as_of":"2026-04-08T21:48:34.675102+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQOXVuZlJBM1diNm5qUHFaTUdNaVk2dUtuRm81Wk5hQVJVbkZmLS14dXcwQlpFUFJNWmEwZERCU0gxZ2N1b0VQR3k2S3JBcXVBMkQ5YVkybUdZUUVaSjByQTA4UWttck5yOVBzUXNJZnVCaVNWVDNxenpkR1FyeTYySnVxdlE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f72cf26de19f4a47","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=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:16:00.047236+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQOXVuZlJBM1diNm5qUHFaTUdNaVk2dUtuRm81Wk5hQVJVbkZmLS14dXcwQlpFUFJNWmEwZERCU0gxZ2N1b0VQR3k2S3JBcXVBMkQ5YVkybUdZUUVaSjByQTA4UWttck5yOVBzUXNJZnVCaVNWVDNxenpkR1FyeTYySnVxdlE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ft.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQOXVuZlJBM1diNm5qUHFaTUdNaVk2dUtuRm81Wk5hQVJVbkZmLS14dXcwQlpFUFJNWmEwZERCU0gxZ2N1b0VQR3k2S3JBcXVBMkQ5YVkybUdZUUVaSjByQTA4UWttck5yOVBzUXNJZnVCaVNWVDNxenpkR1FyeTYySnVxdlE?oc=5","source_event_id":"evt_f6da086fb0a3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"82b17bb0164cd44e","published_at":"2026-04-08T12:58:43+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Israel","relevance":"directly making the vow","symbol":"","type":"country"},{"asset_class":"armed_group","name":"Hizbollah","relevance":"target of Israel\u2019s stated continued war","symbol":"","type":"armed group"},{"asset_class":"sovereign","name":"Iran","relevance":"ceasefire origin referenced","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"the conflict theater referenced by other outlets in the provided source summary","symbol":"","type":"country"}],"event_type":"conflict","information_gaps":["The provided Financial Times article text is not actually present (only page styling/HTML), so details beyond the headline are not verifiable from the supplied content.","The exact timing/date of the Iran ceasefire and Israel\u2019s vow (e.g., when it takes effect) is not specified in the provided excerpt.","The specific terms/exemptions of the Iran ceasefire (e.g., whether it applies to Lebanon) are not included in the supplied Financial Times content; only a general reference is present in the source summary.","No direct market/asset impact is stated; any directional impact on markets would be speculative beyond the conflict facts."],"key_facts":["Financial Times headline states: Israel vows to continue war on Hizbollah despite Iran ceasefire.","Source summary includes multiple reports of Israeli strikes in Lebanon occurring as the Iran truce/ceasefire takes effect (e.g., central Beirut and broader Lebanon), with reported casualties (numbers vary by outlet)."],"numeric_claims":[{"label":"casualties (reported)","value":"182 killed (AP, per provided source summary)"}],"primary_claim":"Israel vows to continue its war on Hizbollah despite an Iran ceasefire.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Israel says it will continue its war against Hizbollah even after an Iran ceasefire, according to the Financial Times. The signal implies continued military escalation in Lebanon despite the ceasefire taking effect.","topics":["Israel-Hizbollah conflict","Iran ceasefire","Lebanon escalation","military operations","ceasefire compliance risk"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"Israel vows to continue war on Hizbollah despite Iran ceasefire Financial Times Israel Escalates Attacks on Lebanon as Iran Cease-Fire Takes Effect The New York Times \u2018People are afraid\u2019: Lebanese reeling after Israel\u2019s devastating attacks Al Jazeera At least 182 killed as Israel strikes central Beirut after saying Iran truce doesn\u2019t apply there AP News More than 100 killed across Lebanon in large wave of Israeli strikes BBC","title":"Israel vows to continue war on Hizbollah despite Iran ceasefire - Financial Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/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_08da9e49a00b in signals