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-08T21:48:34.386848+00:00","dedupe_key":"signal_enriched:news_delta:f28d75b0c6e8dc21","evidence_event_ids":["evt_c57900b74588"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?oc=5","as_of":"2026-04-08T21:48:34.386848+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/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_961ef5f4afec6159","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:13:46.624361+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?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/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?oc=5","source_event_id":"evt_c57900b74588","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"eb3caf92fa721ea1","published_at":"2026-04-08T21:04:12+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Pete Hegseth","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Caine","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"infrastructure","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_feature"},{"asset_class":"","name":"Pentagon","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"","name":"Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Washington Post","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"The Hill","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"newsnationnow.com","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only CSS/HTML boilerplate and does not include the actual article content; extraction is therefore based on the provided headline and source summary only.","\u201cCaine\u201d is not fully identified (e.g., first name/role) in the provided text.","The timing and specifics of the cease-fire expiration and any proposed resumption of combat are not detailed in the provided material.","The Strait of Hormuz closure is attributed to \u201cIran media\u201d in the summary; confirmation by other sources is not provided here."],"key_facts":["The Washington Post headline states that Pete Hegseth proclaims victory in an Iran war while Caine takes a cautious tone.","The New York Times coverage referenced in the source summary says resuming combat in Iran would be risky for Trump even if a cease-fire expires.","Iran media (as cited in the source summary) says the Strait of Hormuz is closed.","The Hill headline referenced in the source summary says critics within the Pentagon add to Pete Hegseth\u2019s troubles and that a Democratic senator says Hegseth is \u201cblowing smoke\u201d with claims about the Iran war."],"numeric_claims":[],"primary_claim":"Senator Caine is taking a cautious tone in response to Pete Hegseth\u2019s claims about victory in an Iran war.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that Pete Hegseth is proclaiming victory in an Iran war narrative, while Senator Caine is taking a more cautious tone. Other referenced coverage suggests renewed U.S. combat in Iran would be risky even if a cease-fire expires, and that Iran media claims the Strait of Hormuz has been closed.","topics":["U.S.-Iran conflict","cease-fire risk","Pentagon internal criticism","maritime chokepoint disruption","political messaging"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"As Hegseth proclaims victory in Iran war, Caine takes cautious tone The Washington Post For Trump, Resuming Combat in Iran Would Be Risky, Even if Cease-Fire Expires The New York Times Live updates: Iran media says Strait of Hormuz closed newsnationnow.com Critics within the Pentagon add to Pete Hegseth\u2019s many troubles ms.now Democratic senator: Hegseth \u2018blowing smoke\u2019 with claims about Iran war The Hill","title":"As Hegseth proclaims victory in Iran war, Caine takes cautious tone - 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 8436 in events