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-07T09:01:03.171519+00:00","dedupe_key":"opportunity_case_memory:case_861b71ce83e1a691:monitor:2026-04-07T09","evidence_event_ids":["evt_9dbf828cab69","evt_55949160f88b","evt_6e8b4027737e","evt_23c39abf927b","evt_c915bd435e15","evt_7056f8b3b14a","evt_9882d557c9d8","evt_7d9ac9f9a4d3","evt_9935809dee55","evt_010e497bd281","evt_440fd969968c","evt_a72df0c87421","evt_de10e1806ab3","evt_b21273bc9a04","evt_dd18c98e12f5","evt_bf2be3e0cb80","evt_dc0cb07e9068","evt_e97e0ba3222a","evt_775a69951983","evt_150c60bdfd93"],"reason_trace":{"case_id":"case_861b71ce83e1a691","decision":"monitor","entity_key":"macro:nasdaq","memory_only":true,"theme_key":"entity_development"},"severity":"low","signal_type":"opportunity_case_memory","source":"opportunity_finder","throttle_s":3600,"value":{"case_id":"case_861b71ce83e1a691","confidence":0.65,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":28,"score":0.5,"up_count":0},"base_score":0.6773,"claim_graph":{"case_signal_families":["market","news","research"],"case_source_domains":["news.google.com","nasdaq.com","finance.yahoo.com","fool.com","stockstory.org","stocktitan.net","ca.finance.yahoo.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_068c525982597ab2","conflict":false,"direction":"neutral","evidence_count":6,"family_coverage":1,"quality_score":0.6805,"source_coverage":4,"source_trust":0.605,"statement":"A Look Back at Software Development Stocks\u2019 Q4 Earnings: JFrog (NASDAQ:FROG) Vs The Rest Of The Pack - Yahoo Finance","strength":0.6216},{"agreement_score":0.6,"claim_id":"claim_ce7f7e7ff7c117ea","conflict":false,"direction":"neutral","evidence_count":10,"family_coverage":1,"quality_score":0.6047,"source_coverage":2,"source_trust":0.58,"statement":"Is Lam Research Stock a Smart Investment for 2025?","strength":0.5546},{"agreement_score":0.6,"claim_id":"claim_57f4bf5f826fea9b","conflict":false,"direction":"neutral","evidence_count":4,"family_coverage":1,"quality_score":0.5313,"source_coverage":1,"source_trust":0.58,"statement":"DeFi Technologies (Nasdaq: DEFT) files 2025 annual ...","strength":0.4876}],"coverage":{"claim_count":3,"conflicting_claims":0,"dominant_claim_id":"claim_068c525982597ab2","multi_family_claims":0,"multi_source_claims":2},"score":0.5489},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":[],"evidence_event_count":20,"high_precision_pass":false,"high_trust_source_coverage":0,"independent_source_coverage":7,"low_trust_source_coverage":0,"score":0.6215,"signal_family_coverage":3,"source_trust":{"avg_score":0.5871,"domains":[{"count":2,"domain":"stockstory.org","score":0.68,"source":"StockStory"},{"count":12,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Markets"},{"count":6,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":4,"domain":"stocktitan.net","score":0.58,"source":"web_search"},{"count":2,"domain":"news.google.com","score":0.58,"source":"stocktitan.net"},{"count":1,"domain":"fool.com","score":0.58,"source":"The Motley Fool"},{"count":1,"domain":"ca.finance.yahoo.com","score":0.58,"source":"Yahoo! Finance Canada"}],"high_trust_domains":[],"independent_high_trust_sources":7,"low_trust_domains":[]},"source_trust_score":0.3863},"decision":"monitor","entity_key":"macro:nasdaq","evidence_event_count":20,"headline":"Market reactions to global economic conditions are causing fluctuations in stock prices.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Recent global economic indicators are influencing investor sentiment and market stability."}}

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