SQLite Web: event_store.db

Update row sig_93b9b43d3b29 in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"case_id":"case_dffc79a4ef311c33","confidence":0.5,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":117,"score":0.5,"up_count":0},"base_score":0.6583,"claim_graph":{"case_signal_families":["news","market"],"case_source_domains":["zacks.com","cbsnews.com","post-gazette.com","bloomberg.com","wsj.com","marketwatch.com","journal-news.com","2news.com","cbs19news.com","cnn.com","finance.yahoo.com","reuters.com","realeconomy.rsmus.com","nasdaq.com","dailynews.com","breakingthenews.net","cnbc.com","axios.com","stockstory.org","spglobal.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_be2914c8cafbc30b","conflict":false,"direction":"neutral","evidence_count":26,"family_coverage":1,"quality_score":0.6937,"source_coverage":4,"source_trust":0.7375,"statement":"VDE, SLB, KMI, BKR: ETF Inflow Alert","strength":0.6288},{"agreement_score":0.6,"claim_id":"claim_786da505a8732ec4","conflict":false,"direction":"neutral","evidence_count":19,"family_coverage":1,"quality_score":0.6869,"source_coverage":16,"source_trust":0.6694,"statement":"KOIL Energy's Q4 Earnings Down Y/Y Dented by Costs, Mix Shift - Zacks Investment Research","strength":0.6282}],"coverage":{"claim_count":2,"conflicting_claims":0,"dominant_claim_id":"claim_be2914c8cafbc30b","multi_family_claims":0,"multi_source_claims":2},"score":0.6561},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":[],"evidence_event_count":45,"high_precision_pass":true,"high_trust_source_coverage":7,"independent_source_coverage":20,"low_trust_source_coverage":0,"score":0.6814,"signal_family_coverage":2,"source_trust":{"avg_score":0.7662,"domains":[{"count":12,"domain":"reuters.com","score":0.9,"source":"Reuters"},{"count":32,"domain":"bloomberg.com","score":0.89,"source":"Bloomberg.com"},{"count":17,"domain":"wsj.com","score":0.86,"source":"wsj.com"},{"count":1,"domain":"apnews.com","score":0.86,"source":"AP News"},{"count":1,"domain":"spglobal.com","score":0.84,"source":"S&P Global"},{"count":6,"domain":"cnbc.com","score":0.82,"source":"CNBC"},{"count":1,"domain":"barrons.com","score":0.82,"source":"barrons.com"},{"count":3,"domain":"axios.com","score":0.77,"source":"Axios"},{"count":1,"domain":"marketwatch.com","score":0.77,"source":"MarketWatch"},{"count":2,"domain":"stockstory.org","score":0.68,"source":"StockStory"},{"count":1,"domain":"zacks.com","score":0.67,"source":"Zacks Investment Research"},{"count":14,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Markets"},{"count":4,"domain":"cnn.com","score":0.58,"source":"CNN"},{"count":3,"domain":"nytimes.com","score":0.58,"source":"The New York Times"},{"count":2,"domain":"cbsnews.com","score":0.58,"source":"CBS News"},{"count":2,"domain":"post-gazette.com","score":0.58,"source":"Pittsburgh Post-Gazette"},{"count":2,"domain":"2news.com","score":0.58,"source":"KTVN"},{"count":2,"domain":"cbs19news.com","score":0.58,"source":"cbs19news.com"},{"count":2,"domain":"fool.com","score":0.58,"source":"The Motley Fool"},{"count":1,"domain":"journal-news.com","score":0.58,"source":"Journal-News.com"},{"count":1,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":1,"domain":"realeconomy.rsmus.com","score":0.58,"source":"The Real Economy Blog"},{"count":1,"domain":"dailynews.com","score":0.58,"source":"Los Angeles Daily News"},{"count":1,"domain":"breakingthenews.net","score":0.58,"source":"Breakingthenews.net"},{"count":1,"domain":"news.bitcoin.com","score":0.58,"source":"Bitcoin.com News"},{"count":1,"domain":"global.morningstar.com","score":0.58,"source":"Morningstar Canada"},{"count":1,"domain":"washingtonpost.com","score":0.58,"source":"The Washington Post"},{"count":1,"domain":"sg.finance.yahoo.com","score":0.58,"source":"Yahoo Finance Singapore"}],"high_trust_domains":["apnews.com","axios.com","barrons.com","bloomberg.com","cnbc.com","marketwatch.com","reuters.com","spglobal.com","wsj.com"],"independent_high_trust_sources":28,"low_trust_domains":[]},"source_trust_score":0.7913},"decision":"monitor","entity_key":"commodity:us_oil_wti","evidence_event_count":45,"headline":"Ongoing developments in the tech sector are creating uncertainty in market performance.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Recent fluctuations in tech stocks indicate potential instability."}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

{"_evidence_event_ids":["evt_848d6e965e8d","evt_63afae387021","evt_29c70b2dcd1f","evt_61aab57dfafe","evt_a677ce0ab890","evt_064d3ecefaae","evt_3d9cf2f1bb3c","evt_d8592a9b6934","evt_1dd8d71ffbee","evt_1417a6e940f0","evt_3b6fb87c198d","evt_8d978f740025","evt_6e3098717f94","evt_b622d56901d6","evt_0e11f176a22a","evt_9e859414cfa2","evt_9f00a12aa383","evt_f0dcb46a7435","evt_e8d8c390e190","evt_5c9bb8354528","evt_7902db6041b2","evt_a5a2d037c8d1","evt_7793c5efb49e","evt_7b30dcf9133b","evt_876dcc2c0f12","evt_63fca2b81bba","evt_57e3edc18e63","evt_5d870f1de9be","evt_7eafa940369b","evt_af6d70ff6826","evt_1676d0f7a5e4","evt_d577826b26a3","evt_6cfc5d95d81f","evt_b48a4ebe5767","evt_de908cbbc650","evt_d2f035b524c6","evt_630a0563ecb4","evt_499087051c3b","evt_b06494229835","evt_38e0f51d7144","evt_6e8b4027737e","evt_204db2ba28a0","evt_fc8908b21ec8","evt_c371b8374f62","evt_8fc1f1e45992"],"case_id":"case_dffc79a4ef311c33","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