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-07T22:13:54.601479+00:00","dedupe_key":"opportunity_case_memory:case_790d41e05c34f1f4:monitor:2026-04-07T22","evidence_event_ids":["evt_c73d3eed2942","evt_7d9b56c43659"],"reason_trace":{"case_id":"case_790d41e05c34f1f4","decision":"monitor","entity_key":"macro:bitcoin","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_type":"opportunity_case_memory","source":"opportunity_finder","throttle_s":3600,"value":{"case_id":"case_790d41e05c34f1f4","confidence":0.3,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":20,"score":0.5,"up_count":0},"base_score":0.405,"claim_graph":{"case_signal_families":["market"],"case_source_domains":["coindesk.com","marketbeat.com","benzinga.com","zacks.com","moomoo.com","uk.finance.yahoo.com","news.bitcoin.com","decrypt.co","cryptoslate.com","coingecko.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_f9ebc11956b714b1","conflict":false,"direction":"neutral","evidence_count":2,"family_coverage":1,"quality_score":0.5915,"source_coverage":10,"source_trust":0.615,"statement":"Trending: Bitcoin (BTC)","strength":0.6175}],"coverage":{"claim_count":1,"conflicting_claims":0,"dominant_claim_id":"claim_f9ebc11956b714b1","multi_family_claims":0,"multi_source_claims":1},"score":0.6166},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":["single_family_evidence"],"evidence_event_count":2,"high_precision_pass":false,"high_trust_source_coverage":1,"independent_source_coverage":10,"low_trust_source_coverage":0,"score":0.5066,"signal_family_coverage":1,"source_trust":{"avg_score":0.5975,"domains":[{"count":1,"domain":"coindesk.com","score":0.78,"source":"coindesk.com"},{"count":1,"domain":"zacks.com","score":0.67,"source":"Zacks Investment Research"},{"count":1,"domain":"benzinga.com","score":0.64,"source":"Benzinga"},{"count":6,"domain":"decrypt.co","score":0.58,"source":"Decrypt RSS"},{"count":5,"domain":"news.bitcoin.com","score":0.58,"source":"Bitcoin.com News"},{"count":2,"domain":"cryptoslate.com","score":0.58,"source":"CryptoSlate RSS"},{"count":1,"domain":"marketbeat.com","score":0.58,"source":"MarketBeat"},{"count":1,"domain":"moomoo.com","score":0.58,"source":"Moomoo"},{"count":1,"domain":"uk.finance.yahoo.com","score":0.58,"source":"Yahoo Finance UK"},{"count":1,"domain":"coingecko.com","score":0.58,"source":"CoinGecko Trending"}],"high_trust_domains":["coindesk.com"],"independent_high_trust_sources":10,"low_trust_domains":[]},"source_trust_score":0.5747},"decision":"monitor","entity_key":"macro:bitcoin","evidence_event_count":2,"headline":"Trending: Bitcoin (BTC)","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Signal convergence: Trending: Bitcoin (BTC) [neutral] Near-term catalyst: Trending: Bitcoin (BTC) (2026-04-07T22:12:52Z)."}}

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