Create
Query
event_store.db
—
events
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 23182 in events
seq
Primary key.
INTEGER
id
evt_f653d43c0242
TEXT NOT NULL
kind
signal_emitted
TEXT NOT NULL
ts
2026-04-05T19:00:07.348843+00:00
TEXT NOT NULL
actor
opportunity_finder
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-05T19:00:07.348843+00:00","dedupe_key":"opportunity_case_memory:case_d0a24cbd92304d8c:monitor:2026-04-05T19","evidence_event_ids":["evt_50503e8efc8e","evt_718eb748701d","evt_66112f978f6f","evt_26679f6defdf","evt_0e8f1832dd3f","evt_3f7bf3ceae4b","evt_0344e349d018","evt_a86e2479ca20","evt_e3842fe4b9de","evt_e4b8220e67ee","evt_17a733758edb","evt_1f7fb7806dc1","evt_3578adabc470","evt_a0ac5194e47f","evt_971fc6a2adc8","evt_0074b9ed395d","evt_13ebbb64a41b","evt_e0493e26857f","evt_d8ad78a6e41f","evt_3a097558a279","evt_a94a2f74e85e","evt_a3d02c0b27c3","evt_0519a293b110","evt_2dc062c02c23","evt_952d9c5a1b5b","evt_5545c56c8647","evt_7e70bb47147a","evt_8119c9472dd3","evt_145a5a8bb0ab","evt_3f5faad1da9e","evt_575cd2a1a7f4","evt_2d0c747ff5ac","evt_0105bac0ea49","evt_34045a08a372","evt_692904184dea","evt_dfd8523be502","evt_5f95856b4fc1","evt_05fcb5767f3f","evt_f5974cf9064c","evt_32fab7304fe4","evt_874c9423f2b9","evt_ab5ad902a171","evt_6451a574b0ca","evt_37c82ebf0cc9","evt_bf5515d847bc","evt_7331c1b4f8b6","evt_59093db52425","evt_97517be06852","evt_2c71eac6b5b1","evt_d16935d1a1e9","evt_755ad321d1dc","evt_4157ed7f16ad","evt_33e19f9d0c2a","evt_54063fad16b9","evt_eba27d7916bd","evt_7ba8426fe97f","evt_d6a41cd133db","evt_6cf68510612b","evt_52d022dcb5aa","evt_c923ce9ed7e3"],"reason_trace":{"case_id":"case_d0a24cbd92304d8c","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_d0a24cbd92304d8c","confidence":0.3,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":230,"score":0.5,"up_count":0},"base_score":0.7117,"claim_graph":{"case_signal_families":["market","research","news"],"case_source_domains":["news.bitcoin.com","cryptoslate.com","coingecko.com","marketbeat.com","aol.com","stocktwits.com","bitget.com","coinmarketcap.com","blockchair.com","mitrade.com","ainvest.com","fengyuan-yap.medium.com","facebook.com","kucoin.com","cryptohopper.com","mexc.com","investors.com","phemex.com","coindesk.com","cryptonews.net"],"claims":[{"agreement_score":0.6,"claim_id":"claim_f800fe27d673fb0c","conflict":false,"direction":"neutral","evidence_count":32,"family_coverage":1,"quality_score":0.6793,"source_coverage":15,"source_trust":0.5933,"statement":"Trending: Bitcoin (BTC)","strength":0.6599},{"agreement_score":0.6,"claim_id":"claim_c74fd428abf811f0","conflict":false,"direction":"neutral","evidence_count":28,"family_coverage":1,"quality_score":0.678,"source_coverage":16,"source_trust":0.58,"statement":"Bitcoin SV Gains 6% on AI Push and Supply Milestone | Top Stories","strength":0.6096},{"agreement_score":0.6,"claim_id":"claim_285b443376050c6d","conflict":false,"direction":"neutral","evidence_count":4,"family_coverage":1,"quality_score":0.6147,"source_coverage":2,"source_trust":0.68,"statement":"Bitcoin tends to outperform gold and stocks after global shocks, Mercado Bitcoin finds - CoinDesk","strength":0.6241}],"coverage":{"claim_count":3,"conflicting_claims":0,"dominant_claim_id":"claim_f800fe27d673fb0c","multi_family_claims":0,"multi_source_claims":3},"score":0.6429},"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":1,"independent_source_coverage":20,"low_trust_source_coverage":0,"score":0.6644,"signal_family_coverage":3,"source_trust":{"avg_score":0.5843,"domains":[{"count":5,"domain":"coindesk.com","score":0.78,"source":"CoinDesk"},{"count":26,"domain":"ainvest.com","score":0.58,"source":"web_search"},{"count":19,"domain":"news.bitcoin.com","score":0.58,"source":"Bitcoin.com News"},{"count":15,"domain":"coingecko.com","score":0.58,"source":"CoinGecko Trending"},{"count":15,"domain":"facebook.com","score":0.58,"source":"web_search"},{"count":13,"domain":"cryptoslate.com","score":0.58,"source":"CryptoSlate RSS"},{"count":13,"domain":"coinmarketcap.com","score":0.58,"source":"web_search"},{"count":13,"domain":"mitrade.com","score":0.58,"source":"web_search"},{"count":13,"domain":"cryptohopper.com","score":0.58,"source":"web_search"},{"count":13,"domain":"mexc.com","score":0.58,"source":"web_search"},{"count":11,"domain":"kucoin.com","score":0.58,"source":"web_search"},{"count":11,"domain":"phemex.com","score":0.58,"source":"web_search"},{"count":9,"domain":"blockchair.com","score":0.58,"source":"web_search"},{"count":8,"domain":"investors.com","score":0.58,"source":"web_search"},{"count":7,"domain":"aol.com","score":0.58,"source":"AOL.com"},{"count":5,"domain":"cryptorank.io","score":0.58,"source":"web_search"},{"count":4,"domain":"fengyuan-yap.medium.com","score":0.58,"source":"web_search"},{"count":3,"domain":"coinglass.com","score":0.58,"source":"web_search"},{"count":3,"domain":"moomoo.com","score":0.58,"source":"Moomoo"},{"count":3,"domain":"finbold.com","score":0.58,"source":"web_search"},{"count":3,"domain":"nftplazas.com","score":0.58,"source":"web_search"},{"count":2,"domain":"marketbeat.com","score":0.58,"source":"MarketBeat"},{"count":2,"domain":"bitget.com","score":0.58,"source":"Bitget"},{"count":2,"domain":"tradingkey.com","score":0.58,"source":"TradingKey"},{"count":2,"domain":"blog.bitfinex.com","score":0.58,"source":"web_search"},{"count":2,"domain":"en.bloomingbit.io","score":0.58,"source":"bloomingbit"},{"count":2,"domain":"barchart.com","score":0.58,"source":"Barchart"},{"count":1,"domain":"stocktwits.com","score":0.58,"source":"Stocktwits"},{"count":1,"domain":"cryptonews.net","score":0.58,"source":"Cryptonews.net"},{"count":1,"domain":"coingape.com","score":0.58,"source":"CoinGape"},{"count":1,"domain":"decrypt.co","score":0.58,"source":"web_search"},{"count":1,"domain":"simplywall.st","score":0.58,"source":"simplywall.st"},{"count":1,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"}],"high_trust_domains":["coindesk.com"],"independent_high_trust_sources":33,"low_trust_domains":[]},"source_trust_score":0.5585},"decision":"monitor","entity_key":"macro:bitcoin","evidence_event_count":60,"headline":"The quantum threat to Bitcoin has accelerated from 25 years to 7 years, requiring urgent action from the Bitcoin ecosystem.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Signal convergence: Trending: Bitcoin (BTC) [neutral]; Bitcoin tends to outperform gold and stocks after global shocks, Mercado Bitcoin finds - CoinDesk [neutral] Near-term catalyst: Bitcoin SV Gains 6% on AI Push and..."}}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
opportunity_case_memory:case_d0a24cbd92304d8c:monitor:2026-04-05T19
TEXT
episode_id
NULL
TEXT
created_at
2026-04-05T19:01:29.308955+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel