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/CBMizgFBVV95cUxPbTJQR3N1VWw2dXc3bm5YbUQ1NkQwakVtMHNkbUtjVWU1VDlRWTdiSHhVNndZQk1nd3RXZm5RdjJnNE1OMmRZaFhNeF9TaWc2V2lNX1lLMmM3R080RTRlaVBfajZMQ09QQWVvcnRwWDkzQmFCSEZOMjE4LU9LWkxtaHQ4MlY4UFZJRUU2R3lGcU5Tdm1jTEgzMWdfYW00UG5xRjhWcks0aGZEcWFsam1VYWZSS3JUNzJVaWdsbXh3MFRNWWhPaTVhcmJOVU1OZw?oc=5","as_of":"2026-04-09T18:00:22.102745+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/CBMizgFBVV95cUxPbTJQR3N1VWw2dXc3bm5YbUQ1NkQwakVtMHNkbUtjVWU1VDlRWTdiSHhVNndZQk1nd3RXZm5RdjJnNE1OMmRZaFhNeF9TaWc2V2lNX1lLMmM3R080RTRlaVBfajZMQ09QQWVvcnRwWDkzQmFCSEZOMjE4LU9LWkxtaHQ4MlY4UFZJRUU2R3lGcU5Tdm1jTEgzMWdfYW00UG5xRjhWcks0aGZEcWFsam1VYWZSS3JUNzJVaWdsbXh3MFRNWWhPaTVhcmJOVU1OZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d57288864a9389f3","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-10T00:13:06.932867+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizgFBVV95cUxPbTJQR3N1VWw2dXc3bm5YbUQ1NkQwakVtMHNkbUtjVWU1VDlRWTdiSHhVNndZQk1nd3RXZm5RdjJnNE1OMmRZaFhNeF9TaWc2V2lNX1lLMmM3R080RTRlaVBfajZMQ09QQWVvcnRwWDkzQmFCSEZOMjE4LU9LWkxtaHQ4MlY4UFZJRUU2R3lGcU5Tdm1jTEgzMWdfYW00UG5xRjhWcks0aGZEcWFsam1VYWZSS3JUNzJVaWdsbXh3MFRNWWhPaTVhcmJOVU1OZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizgFBVV95cUxPbTJQR3N1VWw2dXc3bm5YbUQ1NkQwakVtMHNkbUtjVWU1VDlRWTdiSHhVNndZQk1nd3RXZm5RdjJnNE1OMmRZaFhNeF9TaWc2V2lNX1lLMmM3R080RTRlaVBfajZMQ09QQWVvcnRwWDkzQmFCSEZOMjE4LU9LWkxtaHQ4MlY4UFZJRUU2R3lGcU5Tdm1jTEgzMWdfYW00UG5xRjhWcks0aGZEcWFsam1VYWZSS3JUNzJVaWdsbXh3MFRNWWhPaTVhcmJOVU1OZw?oc=5","source_event_id":"evt_1395012ba8c5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4853e849e36bf4c3","published_at":"2026-04-09T15:05:02+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"primary actor issuing warnings","symbol":"","type":"country"},{"asset_class":"geography","name":"Strait of Hormuz","relevance":"location of disruption","symbol":"","type":"maritime chokepoint"},{"asset_class":"transportation","name":"Ships/tanker traffic","relevance":"directly affected by the warning","symbol":"","type":"shipping activity"},{"asset_class":"media","name":"Reuters","relevance":"source of the headline report","symbol":"","type":"news outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no readable Reuters content beyond page markup, so details (timing, exact wording, enforcement mechanism, and which waters are referenced) cannot be verified from the supplied text.","No quantitative measure of traffic reduction (e.g., % of normal flow) is included in the provided headline/summary.","The signal does not specify whether the warning is new or part of an ongoing policy, nor how long it is expected to last."],"key_facts":["Reuters headline indicates Hormuz is at near standstill.","Reuters headline indicates Iran warned ships to keep to its waters.","The warning is associated with disruption to passage through the Strait of Hormuz."],"numeric_claims":[],"primary_claim":"Iran has warned ships to keep to its waters, leaving the Strait of Hormuz at near standstill.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Reuters reports that the Strait of Hormuz is operating at near standstill as Iran warns ships to remain within its waters. The development suggests continued disruption to tanker traffic in the near term.","topics":["Strait of Hormuz","Iran maritime warnings","shipping disruption","tanker traffic","Middle East geopolitical risk"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Hormuz at near standstill as Iran warns ships to keep to its waters Reuters Iran Tightens Its Grip on Hormuz Despite Cease-Fire WSJ Former JAG officer: Strait of Hormuz toll would be \u2018illegal\u2019 The Hill \u2018Weeks, if not months\u2019: Strait of Hormuz tanker traffic won't normalize anytime soon CNBC Hormuz traffic still blocked as Iran tries to formalize control Fortune","title":"Hormuz at near standstill as Iran warns ships to keep to its waters - Reuters","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_c05ca86d41ce in signals