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":"Strong corroboration from multiple independent sources indicates a rising trend in oil prices and related stock performance.\nThis case presents a timely investment opportunity based on current market conditions.","candidate_refs":[{"id":"sig_c08a41157a0b","kind":"signal"}],"channel":"C0A8Q869CNL","cta":["review","ignore","save"],"delivery_fp":"attn:C0A8Q869CNL:0a9eb2b5a10256c8bd52:2026-04-07T10","next_eligible_at":null,"nudge_kind":"opportunity","reason_trace":{"age_min":0.9,"dedupe_key":"opportunity_case:case_dffc79a4ef311c33:2026-04-07","personalization":{"fields_sample":[],"mode":"bootstrap","owner_fact_count":0},"reason_trace":{"_evidence_event_ids":["evt_7b30dcf9133b","evt_6beea3db668e","evt_876dcc2c0f12","evt_011e8bdd8a28","evt_63fca2b81bba","evt_57e3edc18e63","evt_5d870f1de9be","evt_7eafa940369b","evt_af6d70ff6826","evt_1676d0f7a5e4","evt_d577826b26a3","evt_6cfc5d95d81f","evt_b48a4ebe5767","evt_de908cbbc650","evt_d2f035b524c6","evt_630a0563ecb4","evt_499087051c3b","evt_b06494229835","evt_38e0f51d7144","evt_6e8b4027737e"],"case_id":"case_dffc79a4ef311c33","decision":"surface","entity_key":"commodity:us_oil_wti","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":186.5946423083333,"score_breakdown":{"base":32.0,"confidence":0.85,"corroboration":0.679,"freshness":119.09,"magnitude":0.731,"novelty":0.0,"personal_relevance":0.1,"risk_score":0.28,"severity_weight":75},"suppression_rules_applied":[],"thread_id":null,"title":"Opportunity: Investors should consider buying specific stocks as oil prices rise, indicating a potential shift in market dynamics.","topic_key":"opportunity:case_dffc79a4ef311c33","why_now":"Recent market signals suggest a convergence of factors influencing oil's value, including geopolitical tensions and stock performance."}

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