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-09T13:30:32.803493+00:00","dedupe_key":"signal_enriched:news_delta:725f897198e3f255","evidence_event_ids":["evt_3b97380002ba"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNc09HTVZ0blJNTEhsUlNnQ2htWC1HRURBRFRpLTJrVWNzZlFNX1BjV3RxZF9VN0ZjYndnVFVXWnlxZTdudEdUbG1KTnhnV2I1U0o4SUVEMmRrTU1CTGNiaFFqZ25uTV9YdEJqekNlXzJzejFZRkd5bmdiODdkMzIzb2lFZExCazA3RWZj?oc=5","as_of":"2026-04-09T13:30:32.803493+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/CBMiiwFBVV95cUxNc09HTVZ0blJNTEhsUlNnQ2htWC1HRURBRFRpLTJrVWNzZlFNX1BjV3RxZF9VN0ZjYndnVFVXWnlxZTdudEdUbG1KTnhnV2I1U0o4SUVEMmRrTU1CTGNiaFFqZ25uTV9YdEJqekNlXzJzejFZRkd5bmdiODdkMzIzb2lFZExCazA3RWZj?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_26fcab784772db93","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-09T23:26:50.329465+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNc09HTVZ0blJNTEhsUlNnQ2htWC1HRURBRFRpLTJrVWNzZlFNX1BjV3RxZF9VN0ZjYndnVFVXWnlxZTdudEdUbG1KTnhnV2I1U0o4SUVEMmRrTU1CTGNiaFFqZ25uTV9YdEJqekNlXzJzejFZRkd5bmdiODdkMzIzb2lFZExCazA3RWZj?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNc09HTVZ0blJNTEhsUlNnQ2htWC1HRURBRFRpLTJrVWNzZlFNX1BjV3RxZF9VN0ZjYndnVFVXWnlxZTdudEdUbG1KTnhnV2I1U0o4SUVEMmRrTU1CTGNiaFFqZ25uTV9YdEJqekNlXzJzejFZRkd5bmdiODdkMzIzb2lFZExCazA3RWZj?oc=5","source_event_id":"evt_3b97380002ba","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9c38931b3d59e190","published_at":"2026-04-09T12:58:53+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"geography","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_chokepoint"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"media","name":"Russia (TASS)","relevance":"medium","symbol":"","type":"news_agency"},{"asset_class":"media","name":"CNBC","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"The Wall Street Journal","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"The Times of Israel","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"media","name":"Reuters","relevance":"medium","symbol":"","type":"news_agency"},{"asset_class":"media","name":"New York Times","relevance":"medium","symbol":"","type":"news_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML fragments and does not include the substantive article content; extraction is therefore based on the user-provided headline and source summary snippets.","No specific cease-fire start date, duration, or enforcement details are included in the provided text.","The \u201cvirtual standstill\u201d metric (e.g., percentage reduction, baseline comparison period) is not specified in the provided summary.","The 15-vessels/day figure is attributed to TASS in the summary, but the underlying primary source details are not present here."],"key_facts":["The New York Times article frames the Strait of Hormuz situation \u201cunder the cease-fire.\u201d","Reuters data cited in the provided source summary indicates shipping traffic through Hormuz is at a \u201cvirtual standstill\u201d despite the cease-fire.","CNBC reports that tanker traffic through the Strait of Hormuz will not normalize for \u201cweeks, if not months.\u201d","WSJ (per the provided source summary) says Iran is tightening its grip on Hormuz despite the cease-fire.","TASS (per the provided source summary) reports Iran will allow up to 15 vessels per day through the Strait of Hormuz.","The Times of Israel (per the provided source summary) also references Iran\u2019s continued control of Hormuz under the cease-fire."],"numeric_claims":[{"label":"vessels allowed per day","value":"up to 15"}],"primary_claim":"Shipping traffic through the Strait of Hormuz is at a virtual standstill even under a cease-fire, with Iran still restricting passage.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Despite a cease-fire, shipping traffic through the Strait of Hormuz remains near-stalled, with multiple reports citing Iran\u2019s continued control measures and limited vessel passage. Near-term normalization is described as unlikely for weeks to months.","topics":["cease-fire","maritime shipping","Strait of Hormuz","Iranian control","tanker traffic","vessel passage limits","energy shipping risk"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"What to Know About the Strait of Hormuz Under the Cease-Fire The New York Times Shipping traffic through Hormuz at virtual standstill despite ceasefire, data shows Reuters \u2018Weeks, if not months\u2019: Strait of Hormuz tanker traffic won't normalize anytime soon CNBC Iran Tightens Its Grip on Hormuz Despite Cease-Fire WSJ Russia\u2019s TASS: Iran to allow up to 15 vessels a day through Strait of Hormuz The Times of Israel","title":"What to Know About the Strait of Hormuz Under the Cease-Fire - The New York Times","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 10010 in events