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-09T00:58:20.508429+00:00","dedupe_key":"signal_enriched:news_delta:46c37bd6b7b04c33","evidence_event_ids":["evt_b99644459c95"],"signal_type":"news_headline_delta","source":"news_rss","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

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 8649 in events