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

{"body":"Multiple independent sources confirm the closure's impact on oil prices and global supply, with no significant contradictions noted.\nThis case is critical for understanding market dynamics and potential investment risks.","candidate_refs":[{"id":"sig_1906337b8439","kind":"signal"}],"channel":"C0A8Q869CNL","cta":["review","ignore","save"],"delivery_fp":"attn:C0A8Q869CNL:85aa778efa14612bc899:2026-04-06T17","next_eligible_at":null,"nudge_kind":"opportunity","reason_trace":{"age_min":0.9,"dedupe_key":"opportunity_case:case_eb4818945adbf2af:2026-04-06","personalization":{"fields_sample":[],"mode":"bootstrap","owner_fact_count":0},"reason_trace":{"_evidence_event_ids":["evt_8eebc8c9a2f1","evt_cf274330c843","evt_43ad011ee152","evt_357030a80b4b","evt_f9f6e0b2e27c","evt_2dc2e3af2dcc","evt_6eba025ca89d","evt_d00559ed346d","evt_287c869e9c29","evt_8dfbfb3079c9","evt_61bd2194f90f","evt_0dcb1a59697c","evt_a2bb1f3158d4","evt_2ff3ff0c52f8","evt_2c2de6165488","evt_88853284fa66","evt_0354cb61d44a","evt_0291015fceda","evt_8cfff01a8959","evt_9f96efcfa8ae"],"case_id":"case_eb4818945adbf2af","decision":"surface","entity_key":"equity:IR","severity":"high","signal_type":"opportunity_signal","source":"opportunity_finder","theme_key":"entity_development"},"severity":"high","signal_type":"opportunity_signal","source":"opportunity_finder","throttle_s":21600},"score":189.09967325916665,"score_breakdown":{"base":32.0,"confidence":0.9,"corroboration":0.686,"freshness":119.05,"magnitude":1.0,"novelty":0.0,"personal_relevance":0.1,"risk_score":0.36,"severity_weight":75},"suppression_rules_applied":[],"thread_id":null,"title":"Opportunity: The closure of the Strait of Hormuz by Iran has significantly impacted global oil prices and supply chains, leading to a 40% increase in oil prices.","topic_key":"opportunity:case_eb4818945adbf2af","why_now":"The situation is urgent due to Trump's impending deadline for a deal with Iran and the new transit fee requirements for ships, which could further escalate tensions."}

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