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.417856+00:00","dedupe_key":"signal_enriched:news_delta:be0116aa3906b010","evidence_event_ids":["evt_585523aaade7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?oc=5","as_of":"2026-04-08T21:48:34.417856+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/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dcfd3ec2a88c0c3f","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:14:05.934337+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?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/CBMimwFBVV95cUxOYlBqLWRBRFRrM3gzSnZXSmYtTnZXaUdpOHFqUGIxZFB2VlJwRDYxWTdoUlBEMS1zNFJOS00xNFNObkNrd0tCd3ZDZl92a3dzZG9ScDBSVHB4Mk5WcVJ3SG9xTjUwdXZqYVR4NW0wRkxTaDJmWHNKTS1qRE5JLTh0NlNnVHFtYklVYXFXX3JzOVRPNExnbmxScGJKOA?oc=5","source_event_id":"evt_585523aaade7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0193e47159577eb3","published_at":"2026-04-08T20:49:18+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Donald Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"NPR","relevance":"medium","symbol":"","type":"media"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"media"},{"asset_class":"","name":"Vox","relevance":"low","symbol":"","type":"media"},{"asset_class":"","name":"The Washington Post","relevance":"medium","symbol":"","type":"media"},{"asset_class":"","name":"The Atlantic","relevance":"low","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["No article body content is provided, so specific outcomes, policy actions, or details of the reported truce are not stated.","No dates for the truce or backlash are provided beyond the \u201c5 weeks of war\u201d framing.","No direct evidence is included here for what was accomplished; only headline-level claims are visible."],"key_facts":["NPR headline asks what the U.S. war with Iran has accomplished.","The New York Times headline states: \u201cWhat Trump Has Accomplished in Iran After 5 Weeks of War.\u201d","Vox headline references a \u201csoft TACO\u201d theory of Trump.","The Washington Post headline says Trump\u2019s Iran brinkmanship reaches truce and escalates backlash at home.","The Atlantic headline is \u201cAmerica Looks Like a Paper Tiger.\u201d"],"numeric_claims":[{"label":"timeframe","value":"5 weeks"}],"primary_claim":"The provided headlines indicate ongoing U.S.-Iran conflict developments and debate over their outcomes, including a reported truce alongside domestic backlash.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The signal references multiple news pieces assessing the U.S. posture toward Iran, including claims about what the conflict has achieved, Trump\u2019s actions after weeks of war, and whether brinkmanship is leading to a truce while triggering domestic backlash.","topics":["U.S.-Iran conflict","Trump foreign policy","brinkmanship","truce","domestic backlash","media analysis"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"What has the U.S. war with Iran accomplished? NPR What Trump Has Accomplished in Iran After 5 Weeks of War The New York Times A new theory of Trump: the \u201csoft TACO\u201d vox.com Trump\u2019s Iran brinkmanship reaches truce, escalates backlash at home The Washington Post America Looks Like a Paper Tiger The Atlantic","title":"What has the U.S. war with Iran accomplished? - 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 8445 in events