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-08T09:38:01.011171+00:00","dedupe_key":"signal_enriched:news_delta:3ca942fb1dedcc3c","evidence_event_ids":["evt_df865c4b9a15"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5","as_of":"2026-04-08T09:38:01.011171+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/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0179e58c15184357","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-08T09:38:37.869772+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5","source_event_id":"evt_df865c4b9a15","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8c2b67307e88d4de","published_at":"2026-04-08T07:55:01+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"United States","relevance":"direct party to ceasefire agreement","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"direct party to ceasefire agreement","symbol":"","type":"country"},{"asset_class":"","name":"Strait of Hormuz","relevance":"mentioned as a key unresolved issue","symbol":"","type":"geographic chokepoint"},{"asset_class":"","name":"Trump","relevance":"mentioned in source summary as backing down; questions remain","symbol":"","type":"person"},{"asset_class":"","name":"NPR","relevance":"headline source","symbol":"","type":"publisher"},{"asset_class":"","name":"Reuters","relevance":"included in source summary as reporting talks timing and reactions","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Times","relevance":"included in source summary","symbol":"","type":"publisher"},{"asset_class":"","name":"WSJ","relevance":"included in source summary","symbol":"","type":"publisher"},{"asset_class":"","name":"Al Jazeera","relevance":"included in source summary","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no substantive content beyond styling/HTML; therefore, details of the ceasefire terms, start/end dates, and enforcement mechanisms are not available in the provided text.","No specific date for when the two-week ceasefire begins is stated in the provided text.","No specific details of what \u201ctalks\u201d cover or when they will start are provided beyond \u201csoon.\u201d","The provided text does not specify which parties (e.g., specific governments/armed groups) are included in the ceasefire beyond the U.S. and Iran."],"key_facts":["U.S. and Iran agreed to a ceasefire lasting two weeks (per NPR headline).","Source summary indicates there are questions remaining over Iran and the Strait of Hormuz.","Source summary indicates Trump \u201cbacks down,\u201d but questions remain (as characterized in the provided text).","Source summary indicates Iran says talks to begin soon (timing described as soon, without a specific date).","Source summary indicates Gulf and Arab nations react to the ceasefire announcement."],"numeric_claims":[{"label":"ceasefire duration","value":"2 weeks"}],"primary_claim":"The U.S. and Iran agreed to a two-week ceasefire.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"The U.S. and Iran have agreed to a two-week ceasefire, with reporting noting uncertainty about Iran\u2019s position and issues involving the Strait of Hormuz. Multiple outlets frame the move as a near-term pause while talks are expected to begin soon.","topics":["U.S.-Iran ceasefire","Middle East conflict","diplomacy","Strait of Hormuz","ceasefire duration (two weeks)","talks timeline (soon)","regional reactions"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"U.S. and Iran agree to 2-week ceasefire NPR Trump Backs Down, but Questions Remain Over Iran and the Strait of Hormuz The New York Times What\u2019s in Iran\u2019s Proposed Peace Plan WSJ Iran war live: Trump announces two-week ceasefire as Iran says talks to begin soon Reuters Gulf, Arab nations react to Iran-US ceasefire announcement Al Jazeera","title":"U.S. and Iran agree to 2-week ceasefire - NPR","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 5741 in events