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-10T07:49:15.243897+00:00","dedupe_key":"signal_enriched:news_delta:c517803a68250079","evidence_event_ids":["evt_a210a60b3c53"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxQdmVHREhSU0x6X21SYnliYUdwYlVXZEYxVHBRYlBMQzQ3OThhdlBsUDR3cDNEN1hQSWFaRnRjM3h5MXEtOTV1c0djRzliM0YzQzBibF9IUDJwbGJwaHZHZmh3NW9sMUxTa3AzT0xBTmJFZEZtdWFYQWpaSE12NHRGVlBiRmZQTUxHV1FNaG1R?oc=5","as_of":"2026-04-10T07:49:15.243897+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/CBMijgFBVV95cUxQdmVHREhSU0x6X21SYnliYUdwYlVXZEYxVHBRYlBMQzQ3OThhdlBsUDR3cDNEN1hQSWFaRnRjM3h5MXEtOTV1c0djRzliM0YzQzBibF9IUDJwbGJwaHZHZmh3NW9sMUxTa3AzT0xBTmJFZEZtdWFYQWpaSE12NHRGVlBiRmZQTUxHV1FNaG1R?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a9ca745b3f6cd16c","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-10T07:49:49.908205+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxQdmVHREhSU0x6X21SYnliYUdwYlVXZEYxVHBRYlBMQzQ3OThhdlBsUDR3cDNEN1hQSWFaRnRjM3h5MXEtOTV1c0djRzliM0YzQzBibF9IUDJwbGJwaHZHZmh3NW9sMUxTa3AzT0xBTmJFZEZtdWFYQWpaSE12NHRGVlBiRmZQTUxHV1FNaG1R?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/CBMijgFBVV95cUxQdmVHREhSU0x6X21SYnliYUdwYlVXZEYxVHBRYlBMQzQ3OThhdlBsUDR3cDNEN1hQSWFaRnRjM3h5MXEtOTV1c0djRzliM0YzQzBibF9IUDJwbGJwaHZHZmh3NW9sMUxTa3AzT0xBTmJFZEZtdWFYQWpaSE12NHRGVlBiRmZQTUxHV1FNaG1R?oc=5","source_event_id":"evt_a210a60b3c53","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"77c342744569de09","published_at":"2026-04-10T04:00:21+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"geopolitical_route","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_location"},{"asset_class":"sovereign_state","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign_state","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"shipping","name":"Tanker shipping","relevance":"high","symbol":"","type":"industry_activity"}],"event_type":"geopolitical_risk","information_gaps":["The provided content does not include the specific NYT details on what \u201cit will take to get things going again\u201d (e.g., exact political conditions, timelines, or mechanisms).","No quantitative measure of \u201cstandstill\u201d (e.g., % reduction in transits) is included in the supplied text.","The exact timing of the ceasefire and whether any partial corridor openings occurred is not specified in the provided excerpt.","The snippet references (CNN/NBC/CNBC/Al Jazeera) are not fully quoted here, so their exact wording and causality strength cannot be verified from the supplied material."],"key_facts":["NYT headline indicates the Strait of Hormuz remains politically thorny even though it is described as \u201cno longer off limits.\u201d","Multiple source snippets state ships are not going through the Strait of Hormuz and shipping traffic is effectively at a standstill.","The ceasefire is described as failing to boost tanker traffic via the Strait of Hormuz (per provided snippet references).","Oil prices are reported to rise in connection with the ceasefire not improving tanker traffic (per provided snippet references)."],"numeric_claims":[],"primary_claim":"Despite a U.S.-Iran ceasefire, shipping traffic through the Strait of Hormuz remains effectively at a standstill due to political thorniness.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"The New York Times reports that even after a U.S.-Iran ceasefire, shipping through the Strait of Hormuz remains politically constrained and tanker traffic is still effectively stalled. The near-term catalyst for improvement would require political/operational steps beyond the ceasefire itself.","topics":["Strait of Hormuz","U.S.-Iran ceasefire","tanker traffic","maritime chokepoint","oil market risk","political constraints"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"No Longer Off Limits, the Strait of Hormuz Remains Thorny Politically The New York Times Ships still aren\u2019t going through the Strait of Hormuz. Here\u2019s what it will take to get things going again CNN Strait of Hormuz shipping traffic is effectively at a standstill despite Iran ceasefire NBC News Oil prices rise as U.S.-Iran ceasefire fails to boost tanker traffic via Strait of Hormuz CNBC Shipping in Strait of Hormuz at a standstill despite US-Iran ceasefire Al Jazeera","title":"No Longer Off Limits, the Strait of Hormuz Remains Thorny Politically - 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 14826 in events