SQLite Web: event_store.db

Update row sig_12b49a552aab 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.65,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":375,"score":0.5,"up_count":0},"base_score":0.7544,"claim_graph":{"case_signal_families":["market","smart_money","news","research"],"case_source_domains":["nasdaq.com","post-gazette.com","finance.yahoo.com","cnbc.com","apnews.com","wsj.com","uk.finance.yahoo.com","reuters.com","fool.com","marketbeat.com","stockstory.org","investing.com","fxstreet.com","facebook.com","cryptorank.io","instagram.com","aol.com","bitget.com","ad-hoc-news.de","energynews.oedigital.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_401a33c612c196a3","conflict":false,"direction":"neutral","evidence_count":27,"family_coverage":1,"quality_score":0.6868,"source_coverage":16,"source_trust":0.6681,"statement":"S&P 500 rises as investors await possible Iran and U.S. ceasefire: Live updates - CNBC","strength":0.6601},{"agreement_score":0.6,"claim_id":"claim_835f09d77341fe10","conflict":false,"direction":"neutral","evidence_count":32,"family_coverage":1,"quality_score":0.679,"source_coverage":16,"source_trust":0.59,"statement":"US Jobs Report May Decide Whether the Oil Shock ...","strength":0.6168},{"agreement_score":0.6,"claim_id":"claim_32d42fb9e0f2e0e4","conflict":false,"direction":"neutral","evidence_count":21,"family_coverage":1,"quality_score":0.678,"source_coverage":9,"source_trust":0.58,"statement":"USO: ETF Outflow Alert","strength":0.6342},{"agreement_score":0.6,"claim_id":"claim_693d0b7f7e0c097e","conflict":false,"direction":"neutral","evidence_count":1,"family_coverage":1,"quality_score":0.3963,"source_coverage":1,"source_trust":0.58,"statement":"Fuel for a Recovery: Oil Relief & Robust Fundamentals","strength":0.4046}],"coverage":{"claim_count":4,"conflicting_claims":0,"dominant_claim_id":"claim_401a33c612c196a3","multi_family_claims":0,"multi_source_claims":3},"score":0.569},"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":4,"independent_source_coverage":20,"low_trust_source_coverage":0,"score":0.6705,"signal_family_coverage":4,"source_trust":{"avg_score":0.6092,"domains":[{"count":1,"domain":"reuters.com","score":0.9,"source":"Reuters"},{"count":2,"domain":"bloomberg.com","score":0.89,"source":"Bloomberg.com"},{"count":1,"domain":"ft.com","score":0.87,"source":"Financial Times"},{"count":7,"domain":"apnews.com","score":0.86,"source":"AP News"},{"count":1,"domain":"wsj.com","score":0.86,"source":"WSJ"},{"count":9,"domain":"cnbc.com","score":0.82,"source":"CNBC"},{"count":1,"domain":"marketwatch.com","score":0.77,"source":"MarketWatch"},{"count":19,"domain":"investing.com","score":0.74,"source":"web_search"},{"count":14,"domain":"oilprice.com","score":0.7,"source":"web_search"},{"count":3,"domain":"stockstory.org","score":0.68,"source":"StockStory"},{"count":1,"domain":"understandingwar.org","score":0.68,"source":"Institute for the Study of War"},{"count":65,"domain":"facebook.com","score":0.58,"source":"web_search"},{"count":28,"domain":"instagram.com","score":0.58,"source":"web_search"},{"count":24,"domain":"ad-hoc-news.de","score":0.58,"source":"web_search"},{"count":20,"domain":"bitget.com","score":0.58,"source":"web_search"},{"count":19,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq ETFs"},{"count":18,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":17,"domain":"aol.com","score":0.58,"source":"web_search"},{"count":11,"domain":"discoveryalert.com.au","score":0.58,"source":"web_search"},{"count":10,"domain":"fxstreet.com","score":0.58,"source":"web_search"},{"count":9,"domain":"fool.com","score":0.58,"source":"fool.com"},{"count":9,"domain":"cryptorank.io","score":0.58,"source":"web_search"},{"count":8,"domain":"ainvest.com","score":0.58,"source":"web_search"},{"count":8,"domain":"mexc.com","score":0.58,"source":"web_search"},{"count":8,"domain":"nytimes.com","score":0.58,"source":"The New York Times"},{"count":7,"domain":"alcircle.com","score":0.58,"source":"web_search"},{"count":5,"domain":"marketbeat.com","score":0.58,"source":"MarketBeat"},{"count":5,"domain":"tradingeconomics.com","score":0.58,"source":"web_search"},{"count":5,"domain":"globalbankingandfinance.com","score":0.58,"source":"web_search"},{"count":4,"domain":"allianz.com","score":0.58,"source":"web_search"},{"count":4,"domain":"washingtonpost.com","score":0.58,"source":"The Washington Post"},{"count":3,"domain":"energynews.oedigital.com","score":0.58,"source":"web_search"},{"count":3,"domain":"acredia.at","score":0.58,"source":"web_search"},{"count":2,"domain":"post-gazette.com","score":0.58,"source":"Pittsburgh Post-Gazette"},{"count":2,"domain":"pro.thestreet.com","score":0.58,"source":"TheStreet Pro"},{"count":2,"domain":"ocregister.com","score":0.58,"source":"Orange County Register"},{"count":2,"domain":"theenergynewsbeat.substack.com","score":0.58,"source":"web_search"},{"count":2,"domain":"macroagentdesk.com","score":0.58,"source":"web_search"},{"count":2,"domain":"forbes.com","score":0.58,"source":"web_search"},{"count":2,"domain":"simplywall.st","score":0.58,"source":"simplywall.st"}],"high_trust_domains":["apnews.com","bloomberg.com","cnbc.com","ft.com","marketwatch.com","reuters.com","wsj.com"],"independent_high_trust_sources":51,"low_trust_domains":[]},"source_trust_score":0.7718},"decision":"digest","entity_key":"commodity:us_oil_wti","evidence_event_count":60,"headline":"The impact of the Iran situation on global oil supply is evolving, with potential long-term implications.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Recent events have heightened awareness of the risks associated with oil supply disruptions."}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

{"_evidence_event_ids":["evt_c2c9201496f6","evt_fe12507c348d","evt_a7abfd766a8e","evt_0bdf993effd4","evt_7d9ac9f9a4d3","evt_d5f842a5244a","evt_9935809dee55","evt_7b75518e12e8","evt_55631ad93c22","evt_440fd969968c","evt_f92960f2de3b","evt_93ca82240031","evt_87a338892312","evt_e98c823d0100","evt_86b40d42e3f8","evt_c29c2eb10a4a","evt_4afa120da4ec","evt_61382659f020","evt_a72df0c87421","evt_da517ddf343e","evt_4e2c3769a1f8","evt_10cd1c295ca0","evt_86948402c3e8","evt_c450f951a33f","evt_b21273bc9a04","evt_5fa2a643230a","evt_7c7eef41a5ac","evt_5764cca33798","evt_f76b1c7f90c2","evt_984f30c62530","evt_e6401145fbc8","evt_e81174d13d84","evt_feaf81dec43e","evt_79df1836e40d","evt_c5aaf7842e36","evt_9ad271c53694","evt_dc0cb07e9068","evt_e4c80bd6cdeb","evt_fcc735be5842","evt_79fb877a593f","evt_935cd3d34d6b","evt_bb1d8e207fbd","evt_24a24b5875b4","evt_59608c0325e2","evt_037101221e77","evt_e7c2916f8e3b","evt_788be4dd3c84","evt_e1b04350e888","evt_0dbc3f251ede","evt_a14e60a46daf","evt_150c60bdfd93","evt_47e4b3350c6d","evt_5b0ac2cb1256","evt_eb086a64830e","evt_6c2f16323a52","evt_6abe4c75df18","evt_444d5c7907b3","evt_24ff97eab7df","evt_9eb2063a5c5b","evt_9ca0b1643b80"],"case_id":"case_3e401195fdff6105","decision":"digest","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