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-09T15:51:37.757437+00:00","dedupe_key":"signal_enriched:news_delta:807c1aaf67de31a6","evidence_event_ids":["evt_04de1fc8eb46"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOdmNTSVB0SDAyZGt6RFF6TG9oOUlLVEt4V3FaNS1qTHN5b09nQVlWd05xNWktM1phcldoNlBleGtfbUZ3bVB1ZlFEdlotbE5QQ1JkVHlkeGYxYUNscC0wZFNLczM3UHlZX1J0WVFYTHBEd0x5LWthWlc0V0c0alFsWmlTVGF4d2x5a2dyNHY5WlRvOUtHalE?oc=5","as_of":"2026-04-09T15:51:37.757437+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/CBMilgFBVV95cUxOdmNTSVB0SDAyZGt6RFF6TG9oOUlLVEt4V3FaNS1qTHN5b09nQVlWd05xNWktM1phcldoNlBleGtfbUZ3bVB1ZlFEdlotbE5QQ1JkVHlkeGYxYUNscC0wZFNLczM3UHlZX1J0WVFYTHBEd0x5LWthWlc0V0c0alFsWmlTVGF4d2x5a2dyNHY5WlRvOUtHalE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_61c0be413616b5d6","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:45:38.382083+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOdmNTSVB0SDAyZGt6RFF6TG9oOUlLVEt4V3FaNS1qTHN5b09nQVlWd05xNWktM1phcldoNlBleGtfbUZ3bVB1ZlFEdlotbE5QQ1JkVHlkeGYxYUNscC0wZFNLczM3UHlZX1J0WVFYTHBEd0x5LWthWlc0V0c0alFsWmlTVGF4d2x5a2dyNHY5WlRvOUtHalE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOdmNTSVB0SDAyZGt6RFF6TG9oOUlLVEt4V3FaNS1qTHN5b09nQVlWd05xNWktM1phcldoNlBleGtfbUZ3bVB1ZlFEdlotbE5QQ1JkVHlkeGYxYUNscC0wZFNLczM3UHlZX1J0WVFYTHBEd0x5LWthWlc0V0c0alFsWmlTVGF4d2x5a2dyNHY5WlRvOUtHalE?oc=5","source_event_id":"evt_04de1fc8eb46","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7038e67dbd468615","published_at":"2026-04-09T14:28:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign_state","name":"Israel","relevance":"primary_strike_actor","symbol":"","type":"state_actor"},{"asset_class":"sovereign_state","name":"Lebanon","relevance":"primary_affected_country","symbol":"","type":"country"},{"asset_class":"non_state_actor","name":"Hezbollah","relevance":"militant_actor_mentioned","symbol":"","type":"armed_group"},{"asset_class":"person","name":"Naim Qassem","relevance":"Hezbollah_leadership_mentioned","symbol":"","type":"person"},{"asset_class":"media","name":"Al Jazeera","relevance":"quoted/mentioned_source_in_summary","symbol":"","type":"media_outlet"},{"asset_class":"person","name":"Germany\u2019s Merz","relevance":"political_commentary_mentioned","symbol":"","type":"person"},{"asset_class":"agreement","name":"U.S.-Iran ceasefire","relevance":"diplomatic_context_mentioned","symbol":"","type":"diplomatic_agreement"},{"asset_class":"city","name":"Beirut","relevance":"location_mentioned","symbol":"","type":"city"},{"asset_class":"media","name":"The Times of Israel","relevance":"referenced_coverage","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"NBC News","relevance":"referenced_coverage","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"Reuters","relevance":"referenced_coverage","symbol":"","type":"media_outlet"}],"event_type":"conflict","information_gaps":["Exact date/time of the 10-minute period is not provided in the supplied text.","Exact number of deaths/injuries is not provided (only \u201ckilled hundreds\u201d).","The specific ceasefire being undermined is not identified in the provided text.","The precise content/quote from Germany\u2019s Merz and the details of how Iran peace talks are affected are not included.","The Reuters/NBC claim about killing Hezbollah chief Naim Qassem\u2019s nephew lacks the nephew\u2019s name and the operational details.","No confirmation is provided here that all referenced claims refer to the same incident/time window as The Guardian\u2019s headline."],"key_facts":["The Guardian headline describes Israeli strikes in Lebanon as the deadliest 10 minutes in decades and says the strikes killed hundreds (exact casualty figure not provided in the provided text).","The provided source summary states that Israeli attacks aimed to undermine a ceasefire, according to critics (attribution is to critics; specific critics not identified in the provided text).","The provided source summary includes a claim that Israeli attacks could jeopardize Iran peace talks (attributed to Germany\u2019s Merz in the summary).","The provided source summary says Israeli attacks devastate Beirut and threaten a U.S.-Iran ceasefire (as stated in the summary).","The provided source summary says Israel\u2019s military stated it killed the nephew of Hezbollah chief Naim Qassem (specific name and timing not provided in the provided text)."],"numeric_claims":[{"label":"casualties","value":"hundreds (exact number not provided)"},{"label":"time_window","value":"10 minutes"},{"label":"historical_comparison","value":"deadliest in decades"}],"primary_claim":"Israeli strikes in Lebanon killed hundreds within a span of about 10 minutes, described by The Guardian as the deadliest such period in decades.","relevance_score":0.92,"sentiment":"negative","source_quality":"high","summary":"The Guardian reports that Israeli strikes in Lebanon caused extreme casualties within a very short period, described as the deadliest 10 minutes in decades. Other referenced coverage frames the strikes as potentially aimed at undermining a ceasefire and affecting broader Iran-related diplomacy.","topics":["Israeli strikes in Lebanon","Lebanon casualties","ceasefire dynamics","Hezbollah leadership","Iran-related diplomacy","Beirut impact"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"The deadliest 10 minutes in decades: Lebanese reel from Israeli strikes that killed hundreds The Guardian Israeli attacks on Lebanon aimed to undermine ceasefire, critics say Al Jazeera Germany\u2019s Merz: Israeli campaign in Lebanon could jeopardize Iran peace talks The Times of Israel Israel's attacks devastate Beirut and threaten U.S.-Iran ceasefire NBC News Israeli military says it has killed nephew of Hezbollah chief Naim Qassem Reuters","title":"The deadliest 10 minutes in decades: Lebanese reel from Israeli strikes that killed hundreds - The Guardian","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 10408 in events