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/CBMilgFBVV95cUxNMG4zQURaYUdsUnZRZTF4T1E3XzdnSHlPZC1zUnhkMTE2VXF4OUFka29vaTZBdUloVGowVjFNTVh6bWlPR0RKYUhHQl8xeGx4QU1RbkQ4REJGd2FSRkR2ZDduYmpQZDZRaW5XWndxaE9jazZDZElQYzNMeGlFR2tKbHVtY0Z5b1pMUWFSSjMxbURfV28xZ2c?oc=5","as_of":"2026-04-09T00:58:20.508429+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/CBMilgFBVV95cUxNMG4zQURaYUdsUnZRZTF4T1E3XzdnSHlPZC1zUnhkMTE2VXF4OUFka29vaTZBdUloVGowVjFNTVh6bWlPR0RKYUhHQl8xeGx4QU1RbkQ4REJGd2FSRkR2ZDduYmpQZDZRaW5XWndxaE9jazZDZElQYzNMeGlFR2tKbHVtY0Z5b1pMUWFSSjMxbURfV28xZ2c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3450f39a96140fb8","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-09T22:21:32.394931+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxNMG4zQURaYUdsUnZRZTF4T1E3XzdnSHlPZC1zUnhkMTE2VXF4OUFka29vaTZBdUloVGowVjFNTVh6bWlPR0RKYUhHQl8xeGx4QU1RbkQ4REJGd2FSRkR2ZDduYmpQZDZRaW5XWndxaE9jazZDZElQYzNMeGlFR2tKbHVtY0Z5b1pMUWFSSjMxbURfV28xZ2c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxNMG4zQURaYUdsUnZRZTF4T1E3XzdnSHlPZC1zUnhkMTE2VXF4OUFka29vaTZBdUloVGowVjFNTVh6bWlPR0RKYUhHQl8xeGx4QU1RbkQ4REJGd2FSRkR2ZDduYmpQZDZRaW5XWndxaE9jazZDZElQYzNMeGlFR2tKbHVtY0Z5b1pMUWFSSjMxbURfV28xZ2c?oc=5","source_event_id":"evt_b99644459c95","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"64c5b619abc162eb","published_at":"2026-04-08T20:29:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"geography","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"maritime chokepoint"},{"asset_class":"media","name":"AP News","relevance":"medium","symbol":"","type":"news outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the substantive AP News content needed to extract details (e.g., who is making the trade-norms claim, what specific norms/legal framework are cited, and whether any implementation timeline is stated).","No specific near-term catalyst timing (date of proposal, expected start of toll collection, or enforcement mechanism) is present in the provided text.","No quantified impact is provided (e.g., expected toll rates, affected shipping volumes, or estimated cost/price effects).","The signal includes other outlet headlines in the source summary, but those are not part of the AP News claim extracted here; their details are not verified from the provided AP content."],"key_facts":["AP News headline states that Iran\u2019s proposal to collect tolls in the Strait of Hormuz violates trade norms.","The signal references the Strait of Hormuz as a major shipping chokepoint where access/usage is a subject of reporting (context from provided source summary)."],"numeric_claims":[],"primary_claim":"Iran\u2019s proposal to collect tolls in the Strait of Hormuz violates trade norms, according to AP News.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"AP News reports that Iran\u2019s proposal to collect tolls in the Strait of Hormuz would violate trade norms. The development is framed as a potential escalation affecting shipping through a key chokepoint.","topics":["Iran","Strait of Hormuz","maritime shipping","tolls","trade norms","geopolitical risk"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Iran\u2019s proposal to collect tolls in the Strait of Hormuz violates trade norms AP News Is Strait of Hormuz Open Again? Maybe, but Few Ships Are Using It. The New York Times Is Hormuz open or closed? Shiptracking data reveals true picture Australian Broadcasting Corporation Oil industry pleads its Hormuz case with White House Politico Iran Tightens Its Grip on Hormuz Despite Cease-Fire WSJ","title":"Iran\u2019s proposal to collect tolls in the Strait of Hormuz violates trade norms - AP 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_698e953f4885 in signals