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/CBMiWkFVX3lxTE13LWVXQzlWMFVKRUYxa1o0dElLbktVSkREQlN2SW5KUUw0dF9lWkdNTUV5b01DMGVyUDB4d1NBdTVnRGRURFhzallZT0tneEN1OG1xcUNoUTJSZw?oc=5","as_of":"2026-04-08T19:34:52.525434+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/CBMiWkFVX3lxTE13LWVXQzlWMFVKRUYxa1o0dElLbktVSkREQlN2SW5KUUw0dF9lWkdNTUV5b01DMGVyUDB4d1NBdTVnRGRURFhzallZT0tneEN1OG1xcUNoUTJSZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_43c5b529922e67b6","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:08:30.195730+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE13LWVXQzlWMFVKRUYxa1o0dElLbktVSkREQlN2SW5KUUw0dF9lWkdNTUV5b01DMGVyUDB4d1NBdTVnRGRURFhzallZT0tneEN1OG1xcUNoUTJSZw?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/CBMiWkFVX3lxTE13LWVXQzlWMFVKRUYxa1o0dElLbktVSkREQlN2SW5KUUw0dF9lWkdNTUV5b01DMGVyUDB4d1NBdTVnRGRURFhzallZT0tneEN1OG1xcUNoUTJSZw?oc=5","source_event_id":"evt_79a25cbc6f4a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"124edd5337fc2ae3","published_at":"2026-04-08T13:13:46+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Israel","relevance":"primary actor conducting strikes","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"primary location affected by strikes","symbol":"","type":"country"},{"asset_class":"other","name":"Hezbollah","relevance":"Lebanon-based armed group referenced as pausing attacks","symbol":"","type":"organization"},{"asset_class":"sovereign","name":"Iran","relevance":"cease-fire referenced as not extending to Lebanon","symbol":"","type":"country"},{"asset_class":"other","name":"BBC","relevance":"source of the headline signal","symbol":"","type":"media"},{"asset_class":"other","name":"The New York Times","relevance":"reported Israel\u2019s position on cease-fire scope","symbol":"","type":"media"},{"asset_class":"other","name":"Reuters","relevance":"reported heaviest airstrikes and Hezbollah pause","symbol":"","type":"media"},{"asset_class":"other","name":"AP News","relevance":"reported casualties in central Beirut","symbol":"","type":"media"},{"asset_class":"other","name":"The Hill","relevance":"reported heaviest airstrikes of war and Hezbollah pause","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["Exact date/time of the air-strike wave is not provided in the supplied text.","The specific targets, duration, and scale (number of strikes) are not included.","The basis for the \u201cmore than 100 killed\u201d figure (time window, source, and whether it is confirmed) is not specified.","Whether Hezbollah\u2019s \u201cpause\u201d is temporary and how it relates causally to the strikes is not established in the provided text.","No direct casualty breakdown (civilian vs combatant) is provided."],"key_facts":["BBC reports Israel carried out a large wave of air strikes across Lebanon.","Israel is reported to say an Iran cease-fire does not extend to Lebanon and that strikes continue there (reported by The New York Times).","Reuters and The Hill report Israel\u2019s airstrikes were among the heaviest of the war and that Hezbollah paused attacks (timing/extent not fully specified in the provided text).","AP News reports more than 100 people were killed in strikes in central Beirut after Israel said the Iran truce does not apply there."],"numeric_claims":[{"label":"killed","value":"more than 100"}],"primary_claim":"Israel conducted a large wave of air strikes across Lebanon despite stating that an Iran cease-fire does not extend to Lebanon.","relevance_score":0.92,"sentiment":"negative","source_quality":"high","summary":"Israel carried out a large wave of air strikes across Lebanon, including strikes described as among the heaviest of the war. Multiple outlets report that Israel says any Iran cease-fire does not apply to Lebanon, with casualties reported in central Beirut.","topics":["Israel-Lebanon conflict","air strikes","cease-fire dispute","Hezbollah","casualties","Beirut"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Israel carries out large wave of air strikes across Lebanon BBC Israel Says Iran Cease-Fire Does Not Extend to Lebanon and Continues Strikes The New York Times Lebanon official labels Israeli strikes \u2018very dangerous turning point\u2019 The Hill Israel pounds Lebanon with heaviest airstrikes of war as Hezbollah pauses attacks Reuters More than 100 killed as Israel strikes central Beirut after saying Iran truce doesn\u2019t apply there AP News","title":"Israel carries out large wave of air strikes across Lebanon - 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_4547bd60db51 in signals