Create
Query
event_store.db
—
artifacts
actions
approvals
artifacts
commitments
constraints
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row opp_digest:2026-04-05 in artifacts
id
opp_digest:2026-04-05
Primary key.
TEXT
kind
opportunity_digest
TEXT NOT NULL
status
ready
TEXT NOT NULL
title
Opportunity digest 2026-04-05
TEXT
summary
2 case(s)
TEXT
meta
{"count":2,"day":"2026-04-05"}
TEXT
output_json
{"items": [{"case_id": "case_3e401195fdff6105", "confidence": 0.6888, "corroboration": {"agreement": {"count_score": 0.5, "down_count": 0, "magnitude_weighted_score": 0.5, "majority_direction": "neutral", "neutral_count": 414, "score": 0.5, "up_count": 0}, "base_score": 0.7503, "claim_graph": {"case_signal_families": ["news", "market", "research"], "case_source_domains": ["cbsnews.com", "fool.com", "finance.yahoo.com", "bloomberg.com", "apnews.com", "global.morningstar.com", "msn.com", "firstbusiness.bank", "investing.com", "jpmorgan.com", "news.bitcoin.com", "nasdaq.com", "space.com", "botpopuli.net", "facebook.com", "mitrade.com", "fxstreet.com", "cryptorank.io", "ad-hoc-news.de", "bitget.com"], "claims": [{"agreement_score": 0.6, "claim_id": "claim_401a33c612c196a3", "conflict": false, "direction": "neutral", "evidence_count": 18, "family_coverage": 1, "quality_score": 0.6879, "source_coverage": 12, "source_trust": 0.6792, "statement": "Ousted Army Chief of Staff Gen. Randy George says U.S. soldiers deserve \"courageous leaders of character\" in outgoing email - CBS News", "strength": 0.6767}, {"agreement_score": 0.6, "claim_id": "claim_32d42fb9e0f2e0e4", "conflict": false, "direction": "neutral", "evidence_count": 11, "family_coverage": 1, "quality_score": 0.6797, "source_coverage": 6, "source_trust": 0.5967, "statement": "Why ExxonMobil Stock Soared More Than 11% in March", "strength": 0.6374}, {"agreement_score": 0.6, "claim_id": "claim_835f09d77341fe10", "conflict": false, "direction": "neutral", "evidence_count": 32, "family_coverage": 1, "quality_score": 0.6797, "source_coverage": 16, "source_trust": 0.5975, "statement": "Quarterly Market Review Q1 2026 - First Business Bank", "strength": 0.6127}], "coverage": {"claim_count": 3, "conflicting_claims": 0, "dominant_claim_id": "claim_401a33c612c196a3", "multi_family_claims": 0, "multi_source_claims": 3}, "score": 0.653}, "contradiction": {"flags": [], "has_unresolved_conflict": false, "resolved_claims": [], "resolved_count": 0, "score": 0.0, "unresolved_claims": [], "unresolved_count": 0}, "contradiction_flags": [], "evidence_event_count": 60, "high_precision_pass": false, "high_trust_source_coverage": 2, "independent_source_coverage": 20, "low_trust_source_coverage": 0, "score": 0.6888, "signal_family_coverage": 3, "source_trust": {"avg_score": 0.5945, "domains": [{"count": 2, "domain": "reuters.com", "score": 0.9, "source": "Reuters"}, {"count": 2, "domain": "bloomberg.com", "score": 0.89, "source": "Bloomberg.com"}, {"count": 2, "domain": "apnews.com", "score": 0.86, "source": "AP News"}, {"count": 1, "domain": "wsj.com", "score": 0.86, "source": "WSJ"}, {"count": 12, "domain": "investing.com", "score": 0.74, "source": "web_search"}, {"count": 18, "domain": "oilprice.com", "score": 0.7, "source": "web_search"}, {"count": 1, "domain": "seekingalpha.com", "score": 0.68, "source": "Seeking Alpha"}, {"count": 71, "domain": "facebook.com", "score": 0.58, "source": "web_search"}, {"count": 47, "domain": "ad-hoc-news.de", "score": 0.58, "source": "web_search"}, {"count": 41, "domain": "bitget.com", "score": 0.58, "source": "web_search"}, {"count": 26, "domain": "cryptorank.io", "score": 0.58, "source": "web_search"}, {"count": 24, "domain": "discoveryalert.com.au", "score": 0.58, "source": "web_search"}, {"count": 21, "domain": "ainvest.com", "score": 0.58, "source": "web_search"}, {"count": 19, "domain": "mexc.com", "score": 0.58, "source": "web_search"}, {"count": 17, "domain": "instagram.com", "score": 0.58, "source": "web_search"}, {"count": 16, "domain": "finance.yahoo.com", "score": 0.58, "source": "Yahoo Finance"}, {"count": 15, "domain": "fxstreet.com", "score": 0.58, "source": "web_search"}, {"count": 13, "domain": "mitrade.com", "score": 0.58, "source": "web_search"}, {"count": 11, "domain": "nasdaq.com", "score": 0.58, "source": "Nasdaq Markets"}, {"count": 9, "domain": "firstbusiness.bank", "score": 0.58, "source": "web_search"}, {"count": 8, "domain": "jpmorgan.com", "score": 0.58, "source": "web_search"}, {"count": 6, "domain": "aol.com", "score": 0.58, "source": "web_search"}, {"count": 5, "domain": "fool.com", "score": 0.58, "source": "The Motley Fool"}, {"count": 4, "domain": "global.morningstar.com", "score": 0.58, "source": "Morningstar Canada"}, {"count": 4, "domain": "allianz.com", "score": 0.58, "source": "web_search"}, {"count": 3, "domain": "ca.investing.com", "score": 0.58, "source": "web_search"}, {"count": 2, "domain": "cbsnews.com", "score": 0.58, "source": "CBS News"}, {"count": 2, "domain": "space.com", "score": 0.58, "source": "Space"}, {"count": 2, "domain": "thedailybeast.com", "score": 0.58, "source": "The Daily Beast"}, {"count": 1, "domain": "msn.com", "score": 0.58, "source": "MSN"}, {"count": 1, "domain": "news.bitcoin.com", "score": 0.58, "source": "Bitcoin.com News"}, {"count": 1, "domain": "botpopuli.net", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "islandpacket.com", "score": 0.58, "source": "Hilton Head Island Packet"}, {"count": 1, "domain": "news.google.com", "score": 0.58, "source": "seekingalpha.com"}, {"count": 1, "domain": "energynews.oedigital.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "mdpi.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "aljazeera.com", "score": 0.58, "source": "Al Jazeera"}, {"count": 2, "domain": "medium.com", "score": 0.44, "source": "web_search"}], "high_trust_domains": ["apnews.com", "bloomberg.com", "reuters.com", "wsj.com"], "independent_high_trust_sources": 37, "low_trust_domains": ["medium.com"]}, "source_trust_score": 0.7514}, "decision": "digest", "decision_reason_codes": ["high_impact_case", "signal_convergence", "market_reaction", "developing_case", "neutral_personalization_mode"], "personal_relevance": {"applied": false, "boost": 0.0, "explanations": ["No strong personal linkage detected."], "factors": [{"matched_assets": [], "max_exposure": 0.0, "name": "asset_linkage", "score": 0.0}, {"hits": [], "name": "theme_alignment", "score": 0.0}, {"hits": [], "name": "fallback_theme_alignment", "score": 0.0}, {"hits": [], "name": "role_alignment", "score": 0.0}, {"hits": [], "name": "location_alignment", "score": 0.0}, {"hits": [], "name": "goal_alignment", "score": 0.0}, {"hits": [], "name": "project_alignment", "score": 0.0}, {"hits": [], "name": "commitment_alignment", "score": 0.0}, {"name": "event_magnitude", "score": 0.1, "value": 10.0}, {"kind": "opportunity_case", "name": "urgency_context", "score": 0.0}], "kind": "boost_only", "matched_assets": [], "matched_keywords": [], "no_personalization_reason": "insufficient_profile_context", "profile_confidence": 0.0, "rationale": "No strong personal linkage detected.", "score": 0.1, "why_you": ""}, "personal_relevance_score": 0.1, "profile_confidence": 0.0, "recommended_checks": ["Monitor oil price trends closely", "Assess geopolitical developments in the region", "Evaluate potential impacts on global markets"], "recommended_investigation_action": "Investigate further developments in the Strait of Hormuz and their implications for oil supply.", "thesis": "Iran's attacks have significantly impacted oil supply routes, leading to a notable increase in oil prices.", "uncertainty": {"band": "low", "reasons": ["high_impact_case"], "score": 0.1}, "why_now": "The situation is evolving with ongoing military actions affecting global oil supply, prompting immediate attention."}, {"case_id": "case_eb4818945adbf2af", "confidence": 0.7, "corroboration": {"agreement": {"count_score": 0.5, "down_count": 0, "magnitude_weighted_score": 0.5, "majority_direction": "neutral", "neutral_count": 9, "score": 0.5, "up_count": 0}, "base_score": 0.7638, "claim_graph": {"case_signal_families": ["market", "news", "research"], "case_source_domains": ["news.bitcoin.com", "ft.com", "apnews.com", "reuters.com", "npr.org", "facebook.com", "yahoo.com"], "claims": [{"agreement_score": 0.6, "claim_id": "claim_db9e941ab23a9dae", "conflict": false, "direction": "neutral", "evidence_count": 7, "family_coverage": 1, "quality_score": 0.6978, "source_coverage": 5, "source_trust": 0.778, "statement": "Iran targeted an Israel-linked ship in the Strait of Hormuz.", "strength": 0.8142}, {"agreement_score": 0.6, "claim_id": "claim_9b4f602b7c9d5450", "conflict": false, "direction": "neutral", "evidence_count": 1, "family_coverage": 1, "quality_score": 0.3963, "source_coverage": 1, "source_trust": 0.58, "statement": "Traders have placed over $200 million in bets on the outcome of the 2026 Iran War, with U.S. entry into Iran carrying 90% odds and over $115 million in trading volume.", "strength": 0.635}, {"agreement_score": 0.6, "claim_id": "claim_a0fb6195f01ab838", "conflict": false, "direction": "neutral", "evidence_count": 1, "family_coverage": 1, "quality_score": 0.3963, "source_coverage": 1, "source_trust": 0.58, "statement": "Iran's crude oil stored at sea has hit record highs.", "strength": 0.6}], "coverage": {"claim_count": 3, "conflicting_claims": 0, "dominant_claim_id": "claim_db9e941ab23a9dae", "multi_family_claims": 0, "multi_source_claims": 1}, "score": 0.4321}, "contradiction": {"flags": [], "has_unresolved_conflict": false, "resolved_claims": [], "resolved_count": 0, "score": 0.0, "unresolved_claims": [], "unresolved_count": 0}, "contradiction_flags": [], "evidence_event_count": 9, "high_precision_pass": true, "high_trust_source_coverage": 3, "independent_source_coverage": 7, "low_trust_source_coverage": 0, "score": 0.6703, "signal_family_coverage": 3, "source_trust": {"avg_score": 0.7611, "domains": [{"count": 3, "domain": "reuters.com", "score": 0.9, "source": "Reuters"}, {"count": 1, "domain": "ft.com", "score": 0.87, "source": "Financial Times"}, {"count": 1, "domain": "apnews.com", "score": 0.86, "source": "AP News"}, {"count": 1, "domain": "npr.org", "score": 0.68, "source": "NPR"}, {"count": 1, "domain": "news.bitcoin.com", "score": 0.58, "source": "Bitcoin.com News"}, {"count": 1, "domain": "facebook.com", "score": 0.58, "source": "web_search"}, {"count": 1, "domain": "yahoo.com", "score": 0.58, "source": "Yahoo"}], "high_trust_domains": ["apnews.com", "ft.com", "reuters.com"], "independent_high_trust_sources": 7, "low_trust_domains": []}, "source_trust_score": 0.8189}, "decision": "digest", "decision_reason_codes": ["strong_evidence", "regulatory_changes", "developing_case", "neutral_personalization_mode"], "personal_relevance": {"applied": false, "boost": 0.0, "explanations": ["No strong personal linkage detected."], "factors": [{"matched_assets": [], "max_exposure": 0.0, "name": "asset_linkage", "score": 0.0}, {"hits": [], "name": "theme_alignment", "score": 0.0}, {"hits": [], "name": "fallback_theme_alignment", "score": 0.0}, {"hits": [], "name": "role_alignment", "score": 0.0}, {"hits": [], "name": "location_alignment", "score": 0.0}, {"hits": [], "name": "goal_alignment", "score": 0.0}, {"hits": [], "name": "project_alignment", "score": 0.0}, {"hits": [], "name": "commitment_alignment", "score": 0.0}, {"name": "event_magnitude", "score": 0.1, "value": 10.0}, {"kind": "opportunity_case", "name": "urgency_context", "score": 0.0}], "kind": "boost_only", "matched_assets": [], "matched_keywords": [], "no_personalization_reason": "insufficient_profile_context", "profile_confidence": 0.0, "rationale": "No strong personal linkage detected.", "score": 0.1, "why_you": ""}, "personal_relevance_score": 0.1, "profile_confidence": 0.0, "recommended_checks": ["Review regulatory updates", "Assess impacts on financial institutions", "Monitor market reactions"], "recommended_investigation_action": "Investigate the implications of new regulations on market participants and compliance requirements.", "thesis": "Recent regulatory changes in the financial sector could have significant implications for market participants.", "uncertainty": {"band": "low", "reasons": ["high_impact_case"], "score": 0.1}, "why_now": "New regulations are being implemented that may alter the landscape for financial institutions and investors."}]}
TEXT
output_mrkdwn
Opportunity digest 2026-04-05 - Iran's attacks have significantly impacted oil supply routes, leading to a notable increase in oil prices. - The situation is evolving with ongoing military actions affecting global oil supply, prompting immediate attention. [conf 0.69] - Recent regulatory changes in the financial sector could have significant implications for market participants. - New regulations are being implemented that may alter the landscape for financial institutions and investors. [conf 0.70]
TEXT
evidence_event_ids
["evt_64cb2acd5b4a","evt_7780a5a608da","evt_49eb84768abf","evt_163c8621c0a1","evt_32eac407ba07","evt_9da3d7575de0","evt_a3451bd96635","evt_9d564d7572cd","evt_109d207345fa","evt_bd2de808f8b8","evt_330371a6b376","evt_ea2eafbf9172","evt_3ca5142cddc0","evt_2cf5ced9b5d6","evt_ffca111c1742","evt_f36cebe6fb18","evt_118688f83682","evt_0c43bfbc87b0","evt_cdfb43ed70e8","evt_45ac61f89935","evt_f6004518bc52","evt_d93a2f29c382","evt_02c90c208554","evt_c687dd03abd9","evt_d2c499d4d331","evt_17bf9cf66e58","evt_76bbf4a964a4","evt_0bdc16070518","evt_e6cdd910cc1a","evt_72cddabeae73","evt_df3a4a21c64c","evt_4c108d855bbf","evt_b20516def7ba","evt_da998c9bb76d","evt_345b74d878b2","evt_4ad676b0cd3a","evt_042d488d492f","evt_99771f421570","evt_eca2afbe4318","evt_7c0409a4e74b","evt_5a4772ef139c","evt_ff1a8bfcbd1c","evt_aa236d62bc9e","evt_78befd79ba99","evt_2ec1d7ee11ab","evt_e5bd33cf55d5","evt_02e92cecd12e","evt_436ad1eef1f2","evt_fa3f9205d5f7","evt_b29ce0e3f4a3","evt_7fcef37e0190","evt_f322546b4807","evt_0737b0659152","evt_a0bf9bbaba72","evt_2d87b7bc3b55","evt_68384fedcc4c","evt_c07f98367b71","evt_d0253dea8a5a","evt_cbb95ff798f8","evt_5aa6b2a8ccb0","evt_797b64a40209","evt_8677dc4cad90","evt_69d0591d84cf","evt_1bb4682c7bd2","evt_a0f759030cce","evt_aea884ee02ec","evt_d87c82c78606","evt_89152778c2a6","evt_4a5ce093cd2d"]
TEXT
confidence
REAL
episode_id
NULL
TEXT
thread_id
NULL
TEXT
error
NULL
TEXT
attempt_count
INTEGER (default 0
created_at
2026-04-05T00:03:48.557447+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
updated_at
2026-04-05T00:02:55.463305+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
claimed_at
NULL
TEXT
claim_id
NULL
TEXT
ready_at
2026-04-05T00:02:55.463305+00:00
TEXT
discarded_at
NULL
TEXT
Update
Cancel