SQLite Web: event_store.db

Update row sig_c9f3172e3d16 in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"case_id":"case_1479ac6de2f7ce5c","confidence":0.46,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":39,"score":0.5,"up_count":0},"base_score":0.7126,"claim_graph":{"case_signal_families":["news","market","research"],"case_source_domains":["goldderby.com","investors.com","nasdaq.com","facebook.com","canadianminingreport.com","finance.yahoo.com","ainvest.com","discoveryalert.com.au","thestreet.com","advantagegold.com","goldsilver.com","cryptorank.io","wisdomtree.com","ssga.com","bbc.com","litefinance.org","charles-stanley.co.uk","lbma.org.uk","morningstar.com","stonex.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_d6a3a3bda632e8f7","conflict":false,"direction":"neutral","evidence_count":11,"family_coverage":1,"quality_score":0.6801,"source_coverage":16,"source_trust":0.6012,"statement":"Gold and silver are expected to remain range-bound with a ...","strength":0.6172},{"agreement_score":0.6,"claim_id":"claim_4bb86734603920ea","conflict":false,"direction":"neutral","evidence_count":4,"family_coverage":1,"quality_score":0.6047,"source_coverage":2,"source_trust":0.58,"statement":"Why Hycroft Mining Stock Sank 30% In March","strength":0.6237},{"agreement_score":0.6,"claim_id":"claim_378916cca7d1ad19","conflict":false,"direction":"neutral","evidence_count":2,"family_coverage":1,"quality_score":0.5147,"source_coverage":2,"source_trust":0.58,"statement":"\u2018American Idol\u2019 recap: Top 11 revealed after 3 eliminated in Judges\u2019 Song Contest \u2014 did Lionel save the right singer? - Gold Derby","strength":0.5016}],"coverage":{"claim_count":3,"conflicting_claims":0,"dominant_claim_id":"claim_d6a3a3bda632e8f7","multi_family_claims":0,"multi_source_claims":3},"score":0.6199},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":[],"evidence_event_count":17,"high_precision_pass":false,"high_trust_source_coverage":1,"independent_source_coverage":20,"low_trust_source_coverage":0,"score":0.6594,"signal_family_coverage":3,"source_trust":{"avg_score":0.5887,"domains":[{"count":1,"domain":"morningstar.com","score":0.82,"source":"web_search"},{"count":1,"domain":"litefinance.org","score":0.68,"source":"web_search"},{"count":5,"domain":"facebook.com","score":0.58,"source":"web_search"},{"count":4,"domain":"canadianminingreport.com","score":0.58,"source":"web_search"},{"count":4,"domain":"ainvest.com","score":0.58,"source":"web_search"},{"count":3,"domain":"investors.com","score":0.58,"source":"Investor's Business Daily"},{"count":3,"domain":"finance.yahoo.com","score":0.58,"source":"web_search"},{"count":3,"domain":"advantagegold.com","score":0.58,"source":"web_search"},{"count":2,"domain":"thestreet.com","score":0.58,"source":"web_search"},{"count":2,"domain":"goldsilver.com","score":0.58,"source":"web_search"},{"count":2,"domain":"cryptorank.io","score":0.58,"source":"web_search"},{"count":1,"domain":"goldderby.com","score":0.58,"source":"Gold Derby"},{"count":1,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Markets"},{"count":1,"domain":"discoveryalert.com.au","score":0.58,"source":"web_search"},{"count":1,"domain":"wisdomtree.com","score":0.58,"source":"web_search"},{"count":1,"domain":"ssga.com","score":0.58,"source":"web_search"},{"count":1,"domain":"bbc.com","score":0.58,"source":"BBC"},{"count":1,"domain":"charles-stanley.co.uk","score":0.58,"source":"web_search"},{"count":1,"domain":"lbma.org.uk","score":0.58,"source":"web_search"},{"count":1,"domain":"stonex.com","score":0.58,"source":"web_search"}],"high_trust_domains":["morningstar.com"],"independent_high_trust_sources":20,"low_trust_domains":[]},"source_trust_score":0.5631},"decision":"monitor","entity_key":"commodity:gold","evidence_event_count":17,"headline":"Investors should be aware of emerging trends in the energy sector that could impact stock performance.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Recent developments in energy markets suggest potential growth opportunities worth exploring."}

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