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-08T01:58:44.387457+00:00","dedupe_key":"signal_enriched:news_delta:97e8a88248c83ad1","evidence_event_ids":["evt_c3f2234cee3b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxNTWk0bVpseU1tNW9rall3SzNkX3ctZmUxQzJ1SFk5YWFPbVBmMnZmNzcxVnY3c1A4SnpSRWp0VmdtcURYTVZCcU5yQ1Bma204OGhNS1djNlFuR2wyeWpnb28zU00wakRjeWZMeEVnb0h5bzlaaVoyTlFZT0pTb3hybHFQU0Z3R3U0?oc=5","as_of":"2026-04-08T01:58:44.387457+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/CBMiiAFBVV95cUxNTWk0bVpseU1tNW9rall3SzNkX3ctZmUxQzJ1SFk5YWFPbVBmMnZmNzcxVnY3c1A4SnpSRWp0VmdtcURYTVZCcU5yQ1Bma204OGhNS1djNlFuR2wyeWpnb28zU00wakRjeWZMeEVnb0h5bzlaaVoyTlFZT0pTb3hybHFQU0Z3R3U0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c0d537e5ba9e0fa4","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-08T02:00:29.120341+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxNTWk0bVpseU1tNW9rall3SzNkX3ctZmUxQzJ1SFk5YWFPbVBmMnZmNzcxVnY3c1A4SnpSRWp0VmdtcURYTVZCcU5yQ1Bma204OGhNS1djNlFuR2wyeWpnb28zU00wakRjeWZMeEVnb0h5bzlaaVoyTlFZT0pTb3hybHFQU0Z3R3U0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxNTWk0bVpseU1tNW9rall3SzNkX3ctZmUxQzJ1SFk5YWFPbVBmMnZmNzcxVnY3c1A4SnpSRWp0VmdtcURYTVZCcU5yQ1Bma204OGhNS1djNlFuR2wyeWpnb28zU00wakRjeWZMeEVnb0h5bzlaaVoyTlFZT0pTb3hybHFQU0Z3R3U0?oc=5","source_event_id":"evt_c3f2234cee3b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b89ed2bba3e8363d","published_at":"2026-04-07T16:39:12+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"United States","relevance":"primary actor","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"targeted party","symbol":"","type":"country"},{"asset_class":"","name":"Kharg Island","relevance":"strike location","symbol":"","type":"location"},{"asset_class":"","name":"CNN","relevance":"source of headline","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Reuters (referenced in provided source summary)","relevance":"additional corroboration mentioned","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/boilerplate and does not include the actual CNN content, so details (time of strike, specific targets, damage assessment, casualties, and official statements) are not verifiable from the supplied text.","The numeric claim (\"More Than 50 Military Targets\") appears only in the provided source summary and is not confirmed within the supplied CNN article text.","No information is provided here about US assets used (air/sea), whether Kharg Island is specifically an oil-related site in this context, or any immediate Iranian response/escalation steps."],"key_facts":["CNN headline states the US struck Iranian military targets on Kharg Island.","The provided source summary indicates a US official said the strikes occurred on Kharg Island (attributed to Reuters in the summary)."],"numeric_claims":[{"label":"number_of_targets","value":"50+"}],"primary_claim":"The US has struck Iranian military targets on Kharg Island, according to CNN (citing US officials).","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"CNN reports that the US struck Iranian military targets on Kharg Island. The report frames it as an active US-Iran military development with near-term geopolitical and market implications.","topics":["US-Iran conflict","military strikes","Kharg Island","Iranian military targets","geopolitical risk"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"US has struck Iranian military targets on Kharg Island. Here\u2019s what we know about it CNN US strikes military targets on Iran's Kharg Island, US official says reuters.com Trump says he would \u2018take the oil\u2019 in Iran \u2014 except that Americans want the war to end Politico U.S. Strikes More Than 50 Military Targets on Kharg Island WSJ Trump revealed his objective in Iran \u2014 40 years ago Salon.com","title":"US has struck Iranian military targets on Kharg Island. Here\u2019s what we know about it - CNN","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 3396 in events