SQLite Web: event_store.db

Update row sig_03c7b156a944 in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"case_id":"case_3e401195fdff6105","confidence":0.3,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":429,"score":0.5,"up_count":0},"base_score":0.7513,"claim_graph":{"case_signal_families":["market","news","research"],"case_source_domains":["marketbeat.com","simplywall.st","bloomberg.com","costar.com","bbc.com","reuters.com","finance.yahoo.com","investing.com","nytimes.com","theguardian.com","fxstreet.com","facebook.com","cryptorank.io","aol.com","ad-hoc-news.de","bitget.com","oilprice.com","tradingeconomics.com","discoveryalert.com.au","instagram.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_401a33c612c196a3","conflict":false,"direction":"neutral","evidence_count":26,"family_coverage":1,"quality_score":0.6853,"source_coverage":16,"source_trust":0.6531,"statement":"Trading Open Shadowed by Trump Escalation Threats: Markets Wrap - Bloomberg.com","strength":0.6638},{"agreement_score":0.6,"claim_id":"claim_32d42fb9e0f2e0e4","conflict":false,"direction":"neutral","evidence_count":17,"family_coverage":1,"quality_score":0.6811,"source_coverage":9,"source_trust":0.6111,"statement":"Celsius Holdings Has Dropped 25% This Year. Generational Opportunity or Falling Knife?","strength":0.6746},{"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":"Gold rises as lower US yields lift bullion demand anew | FXStreet","strength":0.6157}],"coverage":{"claim_count":3,"conflicting_claims":0,"dominant_claim_id":"claim_401a33c612c196a3","multi_family_claims":0,"multi_source_claims":3},"score":0.6528},"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.692,"signal_family_coverage":3,"source_trust":{"avg_score":0.6069,"domains":[{"count":5,"domain":"reuters.com","score":0.9,"source":"Reuters"},{"count":5,"domain":"bloomberg.com","score":0.89,"source":"Bloomberg.com"},{"count":7,"domain":"wsj.com","score":0.86,"source":"web_search"},{"count":4,"domain":"apnews.com","score":0.86,"source":"AP News"},{"count":2,"domain":"ag.purdue.edu","score":0.84,"source":"web_search"},{"count":2,"domain":"axios.com","score":0.77,"source":"Axios"},{"count":16,"domain":"investing.com","score":0.74,"source":"Investing.com"},{"count":21,"domain":"oilprice.com","score":0.7,"source":"web_search"},{"count":3,"domain":"npr.org","score":0.68,"source":"npr.org"},{"count":3,"domain":"frontiersin.org","score":0.68,"source":"web_search"},{"count":2,"domain":"phys.org","score":0.68,"source":"Phys.org"},{"count":2,"domain":"seekingalpha.com","score":0.68,"source":"Seeking Alpha"},{"count":67,"domain":"facebook.com","score":0.58,"source":"web_search"},{"count":29,"domain":"bitget.com","score":0.58,"source":"web_search"},{"count":25,"domain":"cryptorank.io","score":0.58,"source":"web_search"},{"count":25,"domain":"ad-hoc-news.de","score":0.58,"source":"web_search"},{"count":17,"domain":"fxstreet.com","score":0.58,"source":"web_search"},{"count":17,"domain":"aol.com","score":0.58,"source":"web_search"},{"count":16,"domain":"ainvest.com","score":0.58,"source":"web_search"},{"count":15,"domain":"instagram.com","score":0.58,"source":"web_search"},{"count":14,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":14,"domain":"discoveryalert.com.au","score":0.58,"source":"web_search"},{"count":13,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq ETFs"},{"count":10,"domain":"nytimes.com","score":0.58,"source":"The New York Times"},{"count":9,"domain":"mexc.com","score":0.58,"source":"web_search"},{"count":6,"domain":"allianz.com","score":0.58,"source":"web_search"},{"count":4,"domain":"tradingeconomics.com","score":0.58,"source":"web_search"},{"count":4,"domain":"fool.com","score":0.58,"source":"fool.com"},{"count":4,"domain":"mdpi.com","score":0.58,"source":"web_search"},{"count":4,"domain":"fa.wellsfargoadvisors.com","score":0.58,"source":"web_search"},{"count":4,"domain":"stocktitan.net","score":0.58,"source":"web_search"},{"count":3,"domain":"theguardian.com","score":0.58,"source":"The Guardian"},{"count":3,"domain":"forex.com","score":0.58,"source":"web_search"},{"count":3,"domain":"acredia.at","score":0.58,"source":"web_search"},{"count":3,"domain":"vtmarkets.com","score":0.58,"source":"web_search"},{"count":2,"domain":"simplywall.st","score":0.58,"source":"simplywall.st"},{"count":2,"domain":"costar.com","score":0.58,"source":"CoStar"},{"count":2,"domain":"timesofisrael.com","score":0.58,"source":"The Times of Israel"},{"count":2,"domain":"economist.com","score":0.58,"source":"The Economist"},{"count":2,"domain":"columbiagorgenews.com","score":0.58,"source":"web_search"}],"high_trust_domains":["ag.purdue.edu","apnews.com","axios.com","bloomberg.com","reuters.com","wsj.com"],"independent_high_trust_sources":63,"low_trust_domains":["medium.com"]},"source_trust_score":0.7566},"decision":"monitor","entity_key":"commodity:us_oil_wti","evidence_event_count":60,"headline":"Savannah Guthrie's mother, Nancy, is currently missing, leading to significant emotional turmoil for Guthrie.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Signal convergence: Celsius Holdings Has Dropped 25% This Year. Generational Opportunity or Falling Knife? [neutral]; Trading Open Shadowed by Trump Escalation Threats: Markets Wrap - Bloomberg.com [neutral] Near-term..."}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

{"_evidence_event_ids":["evt_fe3ad2726735","evt_d4eb831b1a9d","evt_683f9e4f865e","evt_dd08f2f21220","evt_f5630d36b880","evt_1b49c6dad99b","evt_8bab8afd81f1","evt_7a08e8fcba59","evt_eadaf889e10f","evt_356d5d83d5ea","evt_3ee408b8f861","evt_adce916c4504","evt_7bd48878526e","evt_ffee6112c64f","evt_2f5ab348ee8b","evt_5a3b8e4a0398","evt_a77b596e14e4","evt_bb5d5bcbf949","evt_fbb4bff5f7f6","evt_c2e6d00c34a1","evt_b941304bdae6","evt_051c0a337c1f","evt_c365b1c91489","evt_6a62f23124d8","evt_043c39a87eaa","evt_cf672e97cd1b","evt_d3a04be753c9","evt_199db7c87f4b","evt_1a27eee8229b","evt_0c60c7724f37","evt_0799c14c9107","evt_d9dbdc74d323","evt_358bf1bbad6f","evt_b8909e4dd1b0","evt_f2ce78347669","evt_d1b86d168645","evt_45777bfa2ad1","evt_2bab5b4fa98b","evt_d7900231eeb7","evt_9e04582f151b","evt_00f50ab44c22","evt_197af75a3125","evt_5c32705bc917","evt_4dee0ee4d166","evt_034a6a2f3c92","evt_cbde3158832b","evt_bcf2556ff507","evt_a2d5a4b14a0b","evt_e5cf5d0bd2c4","evt_9367d50de3fd","evt_21fe94aa93b4","evt_871bf2a99254","evt_3841816675a0","evt_718eb748701d","evt_00acb6946394","evt_4b70ba22eed3","evt_c690e0e7ce9e","evt_34c27d689336","evt_dd278db30592","evt_40e71ccdb742"],"case_id":"case_3e401195fdff6105","decision":"monitor","entity_key":"commodity:us_oil_wti","memory_only":true,"theme_key":"entity_development"}

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