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-09T06:55:02.569758+00:00","dedupe_key":"signal_enriched:news_delta:3d271d81a581ce64","evidence_event_ids":["evt_9c0bf892b6cf"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxNbDRwdlZJV2xadVZDNG5fSElMMDB1S2pIeTZ2U01vamRNUkJja3VRdldON2pvem9BWGQzVXctcGdHMzhiQmRPM3BCX2JVYlIyOENOS1FFQmFkMUR2anZaV19rVkZtTm9wbEhNQWtwYTd5MEVveTRTQWV4bVhYbXVQREVWNVZOTW44V2pmMGtZZ19reTNMSGfSAZsBQVVfeXFMT1pvMFlZTUJ4QjA1eUhHdmstVkwwb25zYUtPOTlQekJONXczY2NLbkNBTTZuUFBTVVdwdkhvWFZBdFRCenQzRWhEWU9VVWdLdW5xemZpVzF1dzVmdUM3U3F5LXVXbDFVQWxfZ2VvN2ZQc2lBQkFmZUREN3laMnVQN3ZHQ1VoNXFjU1lLdlNJWTFnOFYxR0E1NDNhZ28?oc=5","as_of":"2026-04-09T06:55:02.569758+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/CBMilgFBVV95cUxNbDRwdlZJV2xadVZDNG5fSElMMDB1S2pIeTZ2U01vamRNUkJja3VRdldON2pvem9BWGQzVXctcGdHMzhiQmRPM3BCX2JVYlIyOENOS1FFQmFkMUR2anZaV19rVkZtTm9wbEhNQWtwYTd5MEVveTRTQWV4bVhYbXVQREVWNVZOTW44V2pmMGtZZ19reTNMSGfSAZsBQVVfeXFMT1pvMFlZTUJ4QjA1eUhHdmstVkwwb25zYUtPOTlQekJONXczY2NLbkNBTTZuUFBTVVdwdkhvWFZBdFRCenQzRWhEWU9VVWdLdW5xemZpVzF1dzVmdUM3U3F5LXVXbDFVQWxfZ2VvN2ZQc2lBQkFmZUREN3laMnVQN3ZHQ1VoNXFjU1lLdlNJWTFnOFYxR0E1NDNhZ28?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f56b8aae9107cd6a","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:48:37.742299+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxNbDRwdlZJV2xadVZDNG5fSElMMDB1S2pIeTZ2U01vamRNUkJja3VRdldON2pvem9BWGQzVXctcGdHMzhiQmRPM3BCX2JVYlIyOENOS1FFQmFkMUR2anZaV19rVkZtTm9wbEhNQWtwYTd5MEVveTRTQWV4bVhYbXVQREVWNVZOTW44V2pmMGtZZ19reTNMSGfSAZsBQVVfeXFMT1pvMFlZTUJ4QjA1eUhHdmstVkwwb25zYUtPOTlQekJONXczY2NLbkNBTTZuUFBTVVdwdkhvWFZBdFRCenQzRWhEWU9VVWdLdW5xemZpVzF1dzVmdUM3U3F5LXVXbDFVQWxfZ2VvN2ZQc2lBQkFmZUREN3laMnVQN3ZHQ1VoNXFjU1lLdlNJWTFnOFYxR0E1NDNhZ28?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxNbDRwdlZJV2xadVZDNG5fSElMMDB1S2pIeTZ2U01vamRNUkJja3VRdldON2pvem9BWGQzVXctcGdHMzhiQmRPM3BCX2JVYlIyOENOS1FFQmFkMUR2anZaV19rVkZtTm9wbEhNQWtwYTd5MEVveTRTQWV4bVhYbXVQREVWNVZOTW44V2pmMGtZZ19reTNMSGfSAZsBQVVfeXFMT1pvMFlZTUJ4QjA1eUhHdmstVkwwb25zYUtPOTlQekJONXczY2NLbkNBTTZuUFBTVVdwdkhvWFZBdFRCenQzRWhEWU9VVWdLdW5xemZpVzF1dzVmdUM3U3F5LXVXbDFVQWxfZ2VvN2ZQc2lBQkFmZUREN3laMnVQN3ZHQ1VoNXFjU1lLdlNJWTFnOFYxR0E1NDNhZ28?oc=5","source_event_id":"evt_9c0bf892b6cf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"37857d669345055b","published_at":"2026-04-09T04:06:34+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"U.S. military","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"CNBC","relevance":"medium","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["The specific agreement being referenced is not identified in the provided headline/signal text.","The geographic meaning of \u201cstay near Iran\u201d (locations, bases, force levels) is not specified.","The timing/catalyst window for when the warning takes effect (e.g., specific deadline date) is not included in the provided text.","Whether Trump also described specific threatened actions is not present in the provided headline text (only implied by the broader source summary).","No direct quotes beyond the \u201creal agreement\u201d phrase are available from the provided content."],"key_facts":["Trump stated the U.S. military will stay near Iran until a \u201creal agreement\u201d is honored.","Trump\u2019s warning is conditional on whether Tehran honors the agreement (implied by \u201cuntil \u2026 is honored\u201d)."],"numeric_claims":[],"primary_claim":"Trump warned that the U.S. military will stay near Iran until a \u201creal agreement\u201d is honored.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"CNBC reports that Trump said the U.S. military will remain near Iran until a \u201creal agreement\u201d is honored, implying continued U.S. posture in the region absent compliance by Tehran.","topics":["U.S.-Iran relations","military posture","diplomatic agreement compliance","regional security risk"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"Trump warns U.S. military will stay near Iran until 'real agreement' is honored CNBC New Deadline Looms for U.S. and Iran as Truce Wavers The New York Times CNBC Daily Open: Trump touts \"next conquest\" CNBC Would Trump\u2019s Threatened Attacks on Iran\u2019s Infrastructure Be a War Crime? Time Magazine Trump says US military to stay around Iran; threatens action if Tehran fails to comply with deal Reuters","title":"Trump warns U.S. military will stay near Iran until 'real agreement' is honored - CNBC","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 9266 in events