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-08T12:48:27.239728+00:00","dedupe_key":"signal_enriched:news_delta:abe3ae81c9f7573c","evidence_event_ids":["evt_53d8870824d9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNVmQ2VW5TbzlTZ3FJS3N6OVItaWp6dFI5Mmc4UTdKc0dCcnVPaFJxRUZ3eWg4ZWRhYktyUVhaSkR0QXAtRk43VmNxaG04TERXSmRKQlJQTWhocEIwMmRqVkliaFdDdDZROWFzZmlDaDVjS2VLUFJlVmU5LTNpX1NVQjV2bzVRY0xiSHJublRfLUhtMGd1ODNSaNIBngFBVV95cUxQeU0wNmVTekV3eHNwQ0xMTG0yNUN6WnlhaVpIVG44bDJCSXdZeFJVaHB3VWZCTWdaeVVMWmtERm9JSzJqOUp1dlRwMUZYRkt5ZkJBODNHR3pVOVYyWGktaFBTQmZUMkdONzg1LWppSnZNbUdwWXpVanI3UjhRTktTRk1RLTB3OHVqOC00d1cyWnVRMVE4ay1BSXVwdGNGdw?oc=5","as_of":"2026-04-08T12:48:27.239728+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/CBMimAFBVV95cUxNVmQ2VW5TbzlTZ3FJS3N6OVItaWp6dFI5Mmc4UTdKc0dCcnVPaFJxRUZ3eWg4ZWRhYktyUVhaSkR0QXAtRk43VmNxaG04TERXSmRKQlJQTWhocEIwMmRqVkliaFdDdDZROWFzZmlDaDVjS2VLUFJlVmU5LTNpX1NVQjV2bzVRY0xiSHJublRfLUhtMGd1ODNSaNIBngFBVV95cUxQeU0wNmVTekV3eHNwQ0xMTG0yNUN6WnlhaVpIVG44bDJCSXdZeFJVaHB3VWZCTWdaeVVMWmtERm9JSzJqOUp1dlRwMUZYRkt5ZkJBODNHR3pVOVYyWGktaFBTQmZUMkdONzg1LWppSnZNbUdwWXpVanI3UjhRTktTRk1RLTB3OHVqOC00d1cyWnVRMVE4ay1BSXVwdGNGdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7b99e6153cc1457a","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-08T12:48:56.462563+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNVmQ2VW5TbzlTZ3FJS3N6OVItaWp6dFI5Mmc4UTdKc0dCcnVPaFJxRUZ3eWg4ZWRhYktyUVhaSkR0QXAtRk43VmNxaG04TERXSmRKQlJQTWhocEIwMmRqVkliaFdDdDZROWFzZmlDaDVjS2VLUFJlVmU5LTNpX1NVQjV2bzVRY0xiSHJublRfLUhtMGd1ODNSaNIBngFBVV95cUxQeU0wNmVTekV3eHNwQ0xMTG0yNUN6WnlhaVpIVG44bDJCSXdZeFJVaHB3VWZCTWdaeVVMWmtERm9JSzJqOUp1dlRwMUZYRkt5ZkJBODNHR3pVOVYyWGktaFBTQmZUMkdONzg1LWppSnZNbUdwWXpVanI3UjhRTktTRk1RLTB3OHVqOC00d1cyWnVRMVE4ay1BSXVwdGNGdw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"newsnationnow.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNVmQ2VW5TbzlTZ3FJS3N6OVItaWp6dFI5Mmc4UTdKc0dCcnVPaFJxRUZ3eWg4ZWRhYktyUVhaSkR0QXAtRk43VmNxaG04TERXSmRKQlJQTWhocEIwMmRqVkliaFdDdDZROWFzZmlDaDVjS2VLUFJlVmU5LTNpX1NVQjV2bzVRY0xiSHJublRfLUhtMGd1ODNSaNIBngFBVV95cUxQeU0wNmVTekV3eHNwQ0xMTG0yNUN6WnlhaVpIVG44bDJCSXdZeFJVaHB3VWZCTWdaeVVMWmtERm9JSzJqOUp1dlRwMUZYRkt5ZkJBODNHR3pVOVYyWGktaFBTQmZUMkdONzg1LWppSnZNbUdwWXpVanI3UjhRTktTRk1RLTB3OHVqOC00d1cyWnVRMVE4ay1BSXVwdGNGdw?oc=5","source_event_id":"evt_53d8870824d9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7f009f5e80327e4a","published_at":"2026-04-08T10:52:24+00:00","publisher_domain":"newsnationnow.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"context for ceasefire deal","symbol":"","type":"country"},{"asset_class":"commodity","name":"Oil","relevance":"price moved sharply lower","symbol":"","type":"commodity"},{"asset_class":"equities","name":"Stocks","relevance":"price moved sharply higher","symbol":"","type":"asset class"},{"asset_class":"geopolitical","name":"Iran ceasefire deal","relevance":"stated driver of oil and stock moves","symbol":"","type":"agreement"}],"event_type":"geopolitical_risk","information_gaps":["No specific index or stock tickers are named (e.g., S&P 500, Nasdaq, individual companies).","No magnitude of the stock surge or oil plunge is provided in the provided text.","No details on the ceasefire deal terms, timing, or whether it is newly announced vs. already in effect.","No confirmation of causality beyond the headline\u2019s stated linkage."],"key_facts":["Headline states stocks surged.","Headline states oil plunged.","Headline links both moves to an Iran ceasefire deal.","Source: newsnationnow.com (newsnationnow.com)."],"numeric_claims":[],"primary_claim":"Stocks surged as oil prices plunged amid an Iran ceasefire deal.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"The headline reports a broad stock market surge alongside a sharp drop in oil prices, attributed to an Iran ceasefire deal. The near-term catalyst implied is the ceasefire agreement driving oil lower and stocks higher.","topics":["Iran ceasefire deal","oil price plunge","stock market surge","risk sentiment","energy prices"]},"source":"newsnationnow.com","source_domain":"newsnationnow.com","source_url":"https://www.newsnationnow.com","summary":"Stocks surge as oil plunges amid Iran ceasefire deal newsnationnow.com","title":"Stocks surge as oil plunges amid Iran ceasefire deal - newsnationnow.com","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 6486 in events