SQLite Web: event_store.db

Update row sig_0bdc74365c6c in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"count":2,"day":"2026-04-03","digest_id":"opp_digest:2026-04-03","items":[{"case_id":"case_fb55316ecb0f6fdd","confidence":0.65,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":1,"score":0.5,"up_count":0},"base_score":0.392,"claim_graph":{"case_signal_families":["news"],"case_source_domains":["reuters.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_e389eab4a33edc01","conflict":false,"direction":"neutral","evidence_count":1,"family_coverage":1,"quality_score":0.4283,"source_coverage":1,"source_trust":0.9,"statement":"Wall St Week Ahead Inflation in focus for markets jostled by Middle East war signals - Reuters","strength":0.4116}],"coverage":{"claim_count":1,"conflicting_claims":0,"dominant_claim_id":"claim_e389eab4a33edc01","multi_family_claims":0,"multi_source_claims":0},"score":0.3313},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":["single_family_evidence","thin_independent_source_coverage","thin_evidence"],"evidence_event_count":1,"high_precision_pass":false,"high_trust_source_coverage":1,"independent_source_coverage":1,"low_trust_source_coverage":0,"score":0.4868,"signal_family_coverage":1,"source_trust":{"avg_score":0.9,"domains":[{"count":1,"domain":"reuters.com","score":0.9,"source":"Reuters"}],"high_trust_domains":["reuters.com"],"independent_high_trust_sources":1,"low_trust_domains":[]},"source_trust_score":0.76},"decision":"digest","decision_reason_codes":["developing_trends","medium_risk","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":6.3},{"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":["Analyze market reactions to recent news","Look for additional sources to corroborate claims"],"recommended_investigation_action":"Continue to analyze the situation as it develops and gather more evidence.","thesis":"There are emerging trends that warrant attention, but the evidence is still developing and requires further analysis.","uncertainty":{"band":"medium","reasons":["limited_corroboration","thin_claim_set"],"score":0.38},"why_now":"Recent developments suggest potential shifts in the market that could be significant."},{"case_id":"case_5cc23abea8c9c718","confidence":0.65,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":1,"score":0.5,"up_count":0},"base_score":0.3881,"claim_graph":{"case_signal_families":["news"],"case_source_domains":["ft.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_f2bef21a651dc1f5","conflict":false,"direction":"neutral","evidence_count":1,"family_coverage":1,"quality_score":0.4253,"source_coverage":1,"source_trust":0.87,"statement":"Prediction markets: the hunt for the new \u2018dumb money\u2019 - Financial Times","strength":0.4116}],"coverage":{"claim_count":1,"conflicting_claims":0,"dominant_claim_id":"claim_f2bef21a651dc1f5","multi_family_claims":0,"multi_source_claims":0},"score":0.3301},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":["single_family_evidence","thin_independent_source_coverage","thin_evidence"],"evidence_event_count":1,"high_precision_pass":false,"high_trust_source_coverage":1,"independent_source_coverage":1,"low_trust_source_coverage":0,"score":0.4779,"signal_family_coverage":1,"source_trust":{"avg_score":0.87,"domains":[{"count":1,"domain":"ft.com","score":0.87,"source":"Financial Times"}],"high_trust_domains":["ft.com"],"independent_high_trust_sources":1,"low_trust_domains":[]},"source_trust_score":0.7405},"decision":"digest","decision_reason_codes":["developing_trends","medium_risk","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":6.3},{"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":["Analyze market reactions to recent news","Look for additional sources to corroborate claims"],"recommended_investigation_action":"Continue to analyze the situation as it develops and gather more evidence.","thesis":"Emerging trends suggest potential significance, but the evidence is still developing.","uncertainty":{"band":"medium","reasons":["limited_corroboration","thin_claim_set"],"score":0.38},"why_now":"Recent developments indicate shifts that could impact the market."}],"text":"Opportunity digest 2026-04-03\n- There are emerging trends that warrant attention, but the evidence is still developing and requires further analysis. - Recent developments suggest potential shifts in the market that could be significant. [conf 0.65]\n- Emerging trends suggest potential significance, but the evidence is still developing. - Recent developments indicate shifts that could impact the market. [conf 0.65]"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

Cancel