SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T08:24:00.584848+00:00","dedupe_key":"signal_enriched:news_delta:16ea162ea91a1905","evidence_event_ids":["evt_58ab0b9a004e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPSFItM3FaT0xEYTBpN1g3al9xTlVRZk9NU2FMWmlBaVg0amFkaWljelNFdUVLaGRXUWp6TnJneEpnQnpWTGVRci1PaDIzZldrcWRpYzJhcWdKNlhDTTVEQ0EwcXByMWZZbTJLVXRxWkJpaUFXZTZmWU1Eck54cmVzcndmeWZ2enU3dTFsbndUUmZtODNKdkhITFpfb3hYbnppaVhrZmNIeDhxaUhYRUJBZGotNm50dzBF?oc=5","as_of":"2026-04-09T08:24:00.584848+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/CBMiuAFBVV95cUxPSFItM3FaT0xEYTBpN1g3al9xTlVRZk9NU2FMWmlBaVg0amFkaWljelNFdUVLaGRXUWp6TnJneEpnQnpWTGVRci1PaDIzZldrcWRpYzJhcWdKNlhDTTVEQ0EwcXByMWZZbTJLVXRxWkJpaUFXZTZmWU1Eck54cmVzcndmeWZ2enU3dTFsbndUUmZtODNKdkhITFpfb3hYbnppaVhrZmNIeDhxaUhYRUJBZGotNm50dzBF?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_73edbce6dfb986a1","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:52:31.649622+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPSFItM3FaT0xEYTBpN1g3al9xTlVRZk9NU2FMWmlBaVg0amFkaWljelNFdUVLaGRXUWp6TnJneEpnQnpWTGVRci1PaDIzZldrcWRpYzJhcWdKNlhDTTVEQ0EwcXByMWZZbTJLVXRxWkJpaUFXZTZmWU1Eck54cmVzcndmeWZ2enU3dTFsbndUUmZtODNKdkhITFpfb3hYbnppaVhrZmNIeDhxaUhYRUJBZGotNm50dzBF?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxPSFItM3FaT0xEYTBpN1g3al9xTlVRZk9NU2FMWmlBaVg0amFkaWljelNFdUVLaGRXUWp6TnJneEpnQnpWTGVRci1PaDIzZldrcWRpYzJhcWdKNlhDTTVEQ0EwcXByMWZZbTJLVXRxWkJpaUFXZTZmWU1Eck54cmVzcndmeWZ2enU3dTFsbndUUmZtODNKdkhITFpfb3hYbnppaVhrZmNIeDhxaUhYRUJBZGotNm50dzBF?oc=5","source_event_id":"evt_58ab0b9a004e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9f4b6acaf561ed94","published_at":"2026-04-09T07:45:55+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["yesterday"],"entities":[{"asset_class":"N/A","name":"Naim Qassem","relevance":"high","symbol":"","type":"person"},{"asset_class":"N/A","name":"Hezbollah","relevance":"high","symbol":"","type":"organization"},{"asset_class":"N/A","name":"Israeli military (IDF)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"N/A","name":"Beirut","relevance":"medium","symbol":"","type":"location"},{"asset_class":"N/A","name":"Qassem\u2019s secretary","relevance":"medium","symbol":"","type":"person"},{"asset_class":"N/A","name":"Qassem\u2019s nephew","relevance":"medium","symbol":"","type":"person"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no readable Reuters body content; only the headline and the provided source summary are available.","Exact date/time of the strike and the specific operational details (e.g., weapon type, target location) are not included in the provided text.","Whether Qassem\u2019s death is independently verified (vs. only claimed by the IDF) is not established in the provided material.","The source summary\u2019s phrasing about \u201csecretary of Hezbollah leader\u201d is ambiguous about whether it refers to Qassem\u2019s secretary or another individual; the relationship is not fully clarified."],"key_facts":["Reuters headline states the Israeli military says it has killed Hezbollah chief Naim Qassem.","Source summary says the IDF says it killed Qassem\u2019s secretary of Hezbollah leader in a Beirut airstrike yesterday.","Source summary further states that Qassem\u2019s secretary and nephew were killed in the IDF strike in Beirut."],"numeric_claims":[],"primary_claim":"The Israeli military says it killed Hezbollah chief Naim Qassem in a Beirut airstrike.","relevance_score":0.86,"sentiment":"neutral","source_quality":"high","summary":"Reuters reports that the Israeli military (IDF) says it killed Hezbollah chief Naim Qassem in a Beirut airstrike. The report also indicates that Qassem\u2019s secretary and nephew were killed in the same strike.","topics":["Israel-Hezbollah conflict","Beirut airstrike","leadership targeting","Hezbollah leadership","IDF operations"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Israeli military says it has killed Hezbollah chief Naim Qassem Reuters IDF says it killed secretary of Hezbollah leader in Beirut airstrike yesterday The Times of Israel Naim Qassem's secretary and nephew killed in IDF strike in Beirut The Jerusalem Post Israel says it has killed Lebanon's Hezbollah chief Naim Qassem as US\u2011Iran truce teeters Khaleej Times Iran Israel War News Live Updates: Israel says nephew of Hezbollah Chief Naim Qassem killed in strikes Firstpost","title":"Israeli military says it has killed Hezbollah chief Naim Qassem - Reuters","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 9329 in events