SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_4765f387b072 in signals