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 sources indicates a shift in economic indicators that could impact investments.\nThis case presents important insights for investment strategies.","candidate_refs":[{"id":"sig_c23fcfc6304e","kind":"signal"}],"channel":"C0A8Q869CNL","cta":["review","ignore","save"],"delivery_fp":"attn:C0A8Q869CNL:5f5064c61c7724f388cf:2026-04-07T10","next_eligible_at":null,"nudge_kind":"opportunity","reason_trace":{"age_min":1.9,"dedupe_key":"opportunity_case:case_971aa9f87db94f19:2026-04-07","personalization":{"fields_sample":[],"mode":"bootstrap","owner_fact_count":0},"reason_trace":{"_evidence_event_ids":["evt_1bfcbd495ce8","evt_42d922be79e4","evt_d6e5b93a2f73","evt_b13a6888fb61","evt_2b2178168670","evt_5218e1e75907","evt_60c812090f99","evt_1dd82e873a9a","evt_1974e46275c3","evt_ab19cb921d1f","evt_e8c3d157b947","evt_af16659b1700","evt_d696515e4dd6","evt_100db29ffd11"],"case_id":"case_971aa9f87db94f19","decision":"surface","entity_key":"macro:index:gspc","severity":"medium","signal_type":"opportunity_signal","source":"opportunity_finder","theme_key":"entity_development"},"severity":"medium","signal_type":"opportunity_signal","source":"opportunity_finder","throttle_s":21600},"score":155.47899233916667,"score_breakdown":{"base":32.0,"confidence":0.8,"corroboration":0.685,"freshness":118.14,"magnitude":0.889,"novelty":0.0,"personal_relevance":0.1,"risk_score":0.36,"severity_weight":45},"suppression_rules_applied":[],"thread_id":null,"title":"Opportunity: Investors should consider the implications of recent economic reports on their investment strategies.","topic_key":"opportunity:case_971aa9f87db94f19","why_now":"Recent economic reports indicate significant changes that could affect market dynamics."}

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