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/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5","as_of":"2026-04-09T12:01:21.191854+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/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_86286518e9724494","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:18:12.379229+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"timesofisrael.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxNZlpOdzFadFVDZkxuZlI3RGp0azdnRGpDZTMycjhDUkpRV0R2UHNINnhUT2JfUVJveXlCcFhIUXVJVU9jUERsVlpJQWllRlV4S1REODg0cWs0U3NPVDlSVnEtazZ0NGZJS0hXODBvdURfNkV2Ry1fTFp0cG5EUUF3RTdUdGdfamZaN3UtdXNmc3hJbTY0b1lkdXBPVGdRMWl1N0xxNEgySFhqY0pfYUgzZtIBtgFBVV95cUxPSGI5X29uQUgzMjUwU190czctd2R6QVdHZTRqQ0Z0S1BiVnVSRkFFbTkwSjYxdTV3STAxSGxLcjFEQWdYcFppZXkwY2YxTnF4NDhSZWtzemZPNmVLZW9GMTRKVnctcFpDdG1jV1lpVnZiM3FQQmVNUmhSeGJnaEY1XzR4Y0hUY1JWSEZrZGFJRkZjOXVkckJUWmRqdzNwV0V5V0ZCQlVPTGd1ZE1UZ0NMQXV5NTczQQ?oc=5","source_event_id":"evt_326464cfb90c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bb2b3ae300ef9cc3","published_at":"2026-04-09T10:23:05+00:00","publisher_domain":"timesofisrael.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"European countries (unspecified)","relevance":"high","symbol":"","type":"group"},{"asset_class":"military","name":"IDF (Israel Defense Forces)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"military/political","name":"Hezbollah","relevance":"high","symbol":"","type":"organization"},{"asset_class":"political_agreement","name":"US-Iran truce","relevance":"medium","symbol":"","type":"agreement"},{"asset_class":"sovereign","name":"Britain (UK)","relevance":"medium","symbol":"","type":"country"},{"asset_class":"politician","name":"Yvette Cooper","relevance":"medium","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Lebanon","relevance":"medium","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"medium","symbol":"","type":"country"},{"asset_class":"maritime_route","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geography"}],"event_type":"conflict","information_gaps":["Which specific European countries made the condemnation is not stated in the provided text.","The exact nature (timing, location, scale) of the IDF strikes on Hezbollah is not provided.","The details of the US-Iran truce (start/end dates, enforcement mechanism) are not provided.","The specific UK/EU officials\u2019 statements timing (date/time) and whether they are scheduled for a particular session are not provided.","The \u201cbill\u201d Europe fears is not specified (cost type, who pays, magnitude)."],"key_facts":["The Times of Israel headline states that European countries \u201cslam\u201d/condemn IDF strikes on Hezbollah.","The condemnation is described as occurring \u201camid\u201d a US-Iran truce (timing linkage).","The provided source summary includes that Britain will call for the Strait of Hormuz to be toll-free.","The provided source summary includes that Lebanon must be included in the US-Iran ceasefire deal.","The provided source summary includes that Yvette Cooper will urge full and toll-free reopening of the Strait of Hormuz.","The provided source summary includes that Europe fears \u201cgetting stuck with the bill\u201d after Trump\u2019s Iran deal (as stated in the summary)."],"numeric_claims":[],"primary_claim":"European countries condemned IDF strikes on Hezbollah during the period of a US-Iran truce.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"European countries criticized IDF strikes on Hezbollah while a US-Iran truce is in place, with additional UK and EU-related calls tied to the Iran ceasefire and Strait of Hormuz reopening. The near-term catalyst implied is the political messaging around the ceasefire terms and maritime access demands.","topics":["IDF strikes","Hezbollah","European diplomatic response","US-Iran truce","Iran ceasefire terms","Strait of Hormuz toll-free reopening","Lebanon inclusion in ceasefire"]},"source":"The Times of Israel","source_domain":"timesofisrael.com","source_url":"https://www.timesofisrael.com","summary":"\u2018Unacceptable\u2019: European countries slam IDF strikes on Hezbollah amid US-Iran truce The Times of Israel 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 Cooper urges full and toll-free reopening of Strait of Hormuz BBC Europe fears getting stuck with the bill after Trump\u2019s Iran deal politico.eu","title":"\u2018Unacceptable\u2019: European countries slam IDF strikes on Hezbollah amid US-Iran truce - The Times of Israel","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_99f6728a0123 in signals