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/CBMikAFBVV95cUxOSlJDQkNFSVAyUThVdnhJbHhaTU9uNjV3NmxySFh2b2xHUm4tdTRndlRKdEdHZlJJdy02b3VDeGJ3b1o4V3R2WVMwM0hQTnNKXzBEMWt6WE5pakx1dUhBUXdaam90QjJDeDQtVUJIYmdDSFlwOVFkTU55QkJnNkgzdzBzTnk5bDVGVzRtQTQtSGbSAZYBQVVfeXFMTXVpZkVRcFFaRURsQ2FMcGtzOU1FLW9JU0JMcG9jY2dNc3VIcTJ4T2pLVUVybDNseXE4QkJOR0tVUHJlMy1LQjRHcGtrRk9lYXIyVC1JSC11cWx5aFROa1BNd2NhVW1kZk03SXZVU0l1LTVwcFAzZGJrc2hoZ2lady0wSjltM19qZnQ3UThmMDFSY1VyZXB3?oc=5","as_of":"2026-04-10T04:01:58.286800+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/CBMikAFBVV95cUxOSlJDQkNFSVAyUThVdnhJbHhaTU9uNjV3NmxySFh2b2xHUm4tdTRndlRKdEdHZlJJdy02b3VDeGJ3b1o4V3R2WVMwM0hQTnNKXzBEMWt6WE5pakx1dUhBUXdaam90QjJDeDQtVUJIYmdDSFlwOVFkTU55QkJnNkgzdzBzTnk5bDVGVzRtQTQtSGbSAZYBQVVfeXFMTXVpZkVRcFFaRURsQ2FMcGtzOU1FLW9JU0JMcG9jY2dNc3VIcTJ4T2pLVUVybDNseXE4QkJOR0tVUHJlMy1LQjRHcGtrRk9lYXIyVC1JSC11cWx5aFROa1BNd2NhVW1kZk03SXZVU0l1LTVwcFAzZGJrc2hoZ2lady0wSjltM19qZnQ3UThmMDFSY1VyZXB3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cd4400a1c4e6aba4","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-10T04:02:36.174247+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOSlJDQkNFSVAyUThVdnhJbHhaTU9uNjV3NmxySFh2b2xHUm4tdTRndlRKdEdHZlJJdy02b3VDeGJ3b1o4V3R2WVMwM0hQTnNKXzBEMWt6WE5pakx1dUhBUXdaam90QjJDeDQtVUJIYmdDSFlwOVFkTU55QkJnNkgzdzBzTnk5bDVGVzRtQTQtSGbSAZYBQVVfeXFMTXVpZkVRcFFaRURsQ2FMcGtzOU1FLW9JU0JMcG9jY2dNc3VIcTJ4T2pLVUVybDNseXE4QkJOR0tVUHJlMy1LQjRHcGtrRk9lYXIyVC1JSC11cWx5aFROa1BNd2NhVW1kZk03SXZVU0l1LTVwcFAzZGJrc2hoZ2lady0wSjltM19qZnQ3UThmMDFSY1VyZXB3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOSlJDQkNFSVAyUThVdnhJbHhaTU9uNjV3NmxySFh2b2xHUm4tdTRndlRKdEdHZlJJdy02b3VDeGJ3b1o4V3R2WVMwM0hQTnNKXzBEMWt6WE5pakx1dUhBUXdaam90QjJDeDQtVUJIYmdDSFlwOVFkTU55QkJnNkgzdzBzTnk5bDVGVzRtQTQtSGbSAZYBQVVfeXFMTXVpZkVRcFFaRURsQ2FMcGtzOU1FLW9JU0JMcG9jY2dNc3VIcTJ4T2pLVUVybDNseXE4QkJOR0tVUHJlMy1LQjRHcGtrRk9lYXIyVC1JSC11cWx5aFROa1BNd2NhVW1kZk03SXZVU0l1LTVwcFAzZGJrc2hoZ2lady0wSjltM19qZnQ3UThmMDFSY1VyZXB3?oc=5","source_event_id":"evt_354f0a0cfc65","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e03ffbb9b56b50a8","published_at":"2026-04-10T00:02:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_location"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"US-Iran ceasefire / Iran war ceasefire","relevance":"high","symbol":"","type":"political_agreement"},{"asset_class":"other","name":"Oil tankers / shipping traffic","relevance":"high","symbol":"","type":"vessel_activity"},{"asset_class":"other","name":"CBS News","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"supply_disruption","information_gaps":["The exact magnitude of the traffic reduction (e.g., percentage vs. baseline) is not included in the provided text.","The specific timing/date of the ceasefire relative to the reporting is not stated in the provided excerpt.","No concrete forecast or timeframe for when traffic will return is included in the provided text (only that it will take something to get things going again).","The excerpt does not specify whether the remaining low traffic is due to insurance/risk premiums, operational constraints, or residual security concerns (mechanism is not explicit)."],"key_facts":["CBS News reports that the Strait of Hormuz is still seeing significantly lower traffic despite an Iran war ceasefire.","The provided source summary indicates ships still are not going through the Strait of Hormuz (i.e., traffic remains suppressed).","Other referenced outlets in the source summary suggest traffic is at a \u201ctrickle\u201d and that even a single non-Iranian oil tanker crossing since the ceasefire is notable (implying very limited normalization)."],"numeric_claims":[],"primary_claim":"The Strait of Hormuz is still experiencing significantly lower traffic even after an Iran war ceasefire.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Despite an Iran war ceasefire, the Strait of Hormuz is still seeing much lower ship traffic than normal, with vessels largely not transiting the route. The near-term catalyst for improvement appears to be additional tanker crossings and broader normalization of shipping flows.","topics":["maritime shipping","oil transport","Strait of Hormuz traffic","Iran ceasefire","regional security risk"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Strait of Hormuz still seeing significantly lower traffic despite Iran war ceasefire CBS News Ships still aren\u2019t going through the Strait of Hormuz. Here\u2019s what it will take to get things going again CNN Shipping in Strait of Hormuz still at a trickle despite US-Iran ceasefire Al Jazeera Strait of Hormuz oil traffic way down after ceasefire; Hassett says even one tanker is big deal CNBC First non-Iranian oil tanker crosses Strait of Hormuz since ceasefire Le Monde.fr","title":"Strait of Hormuz still seeing significantly lower traffic despite Iran war ceasefire - CBS News","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_b7546d1b3871 in signals