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-08T20:43:08.016544+00:00","dedupe_key":"signal_enriched:news_delta:b2365aae70c2b293","evidence_event_ids":["evt_b152dcae1311"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQNkhLS0drWU1yLVRhUnp1OTl5bm8zWjJkUkUxZl9vUkxiOWVDYWZ5Yk9pVnpxdXBEQ05SUkFTUG1fUUo4a3VqU2tkN0hjc2ZjNnJVNlRnWkpyRjZ1TFhFd3JPb0xhbnFiTHJfUkp4Vmx3dEVhR0cwd0pHVTJGWW1zdmRCQjFLR253WE43V2dtTDJtVWNpdlBmdA?oc=5","as_of":"2026-04-08T20:43:08.016544+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/CBMimAFBVV95cUxQNkhLS0drWU1yLVRhUnp1OTl5bm8zWjJkUkUxZl9vUkxiOWVDYWZ5Yk9pVnpxdXBEQ05SUkFTUG1fUUo4a3VqU2tkN0hjc2ZjNnJVNlRnWkpyRjZ1TFhFd3JPb0xhbnFiTHJfUkp4Vmx3dEVhR0cwd0pHVTJGWW1zdmRCQjFLR253WE43V2dtTDJtVWNpdlBmdA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_103d55e3c3cc6c5b","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:10:32.603775+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQNkhLS0drWU1yLVRhUnp1OTl5bm8zWjJkUkUxZl9vUkxiOWVDYWZ5Yk9pVnpxdXBEQ05SUkFTUG1fUUo4a3VqU2tkN0hjc2ZjNnJVNlRnWkpyRjZ1TFhFd3JPb0xhbnFiTHJfUkp4Vmx3dEVhR0cwd0pHVTJGWW1zdmRCQjFLR253WE43V2dtTDJtVWNpdlBmdA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxQNkhLS0drWU1yLVRhUnp1OTl5bm8zWjJkUkUxZl9vUkxiOWVDYWZ5Yk9pVnpxdXBEQ05SUkFTUG1fUUo4a3VqU2tkN0hjc2ZjNnJVNlRnWkpyRjZ1TFhFd3JPb0xhbnFiTHJfUkp4Vmx3dEVhR0cwd0pHVTJGWW1zdmRCQjFLR253WE43V2dtTDJtVWNpdlBmdA?oc=5","source_event_id":"evt_b152dcae1311","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b186fd9f762b1679","published_at":"2026-04-08T20:24:15+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"sovereign_state","name":"Israel","relevance":"primary actor conducting strikes","symbol":"","type":"state_actor"},{"asset_class":"sovereign_state","name":"Lebanon","relevance":"targeted jurisdiction; Israel claims it is not covered by the truce","symbol":"","type":"state_actor"},{"asset_class":"geography","name":"Beirut","relevance":"strike location (central Beirut mentioned in source summary)","symbol":"","type":"location"},{"asset_class":"sovereign_state","name":"Iran","relevance":"ceasefire/truce referenced as an Iran-related agreement","symbol":"","type":"state_actor"},{"asset_class":"media","name":"The Washington Post","relevance":"source of the headline delta","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["Exact time/date of the Beirut strikes is not provided in the extracted content.","Exact casualty count (e.g., 30 vs 50+) is not specified\u2014only \u201cdozens.\u201d","The specific terms of the \u201cIran truce\u201d and what jurisdictions it covers are not detailed in the provided text.","Whether the strikes are confirmed by independent sources (beyond outlet reporting) is not verifiable from the provided excerpt.","Market/financial impact is not addressed in the provided content; only geopolitical escalation is implied."],"key_facts":["The Washington Post headline reports that Israel killed dozens in Beirut.","The Washington Post headline states Israel says Lebanon is not part of an Iran truce.","Source summary indicates strikes occurred in central Beirut after the ceasefire/truce was said not to apply there.","Other cited outlets in the provided source summary (Al Jazeera, AP, UN-related condemnation, NYT) characterize the attacks as brutal/escalatory and report condemnation and casualty figures (exact numbers not fully specified in the provided text)."],"numeric_claims":[{"label":"casualties","value":"dozens killed (exact number not provided in the extracted text)"}],"primary_claim":"Israel says Lebanon is not part of an Iran truce and has killed dozens in Beirut in strikes reported by The Washington Post.","relevance_score":0.92,"sentiment":"negative","source_quality":"high","summary":"Israel carried out strikes in Beirut, killing dozens, while stating that Lebanon is not covered by an Iran ceasefire/truce. The move is framed as an escalation occurring as the ceasefire takes effect.","topics":["Israel-Lebanon conflict","Beirut strikes","Iran ceasefire/truce coverage dispute","escalation risk","casualties","international reaction"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Israel kills dozens in Beirut, says Lebanon is not part of Iran truce The Washington Post World reacts to \u2018brutal\u2019 Israeli attacks on Lebanon amid US-Iran ceasefire Al Jazeera Scores killed as Israel strikes central Beirut after saying Iran ceasefire doesn\u2019t apply there AP News UN Condemns Israeli Strikes on Lebanon, Calls Casualty Reports 'Appalling' U.S. News & World Report Israel Escalates Attacks on Lebanon as Iran Cease-Fire Takes Effect The New York Times","title":"Israel kills dozens in Beirut, says Lebanon is not part of Iran truce - The Washington Post","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 8353 in events