SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"case_id":"case_3e401195fdff6105","confidence":0.5,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":355,"score":0.5,"up_count":0},"base_score":0.755,"claim_graph":{"case_signal_families":["market","smart_money","news","research"],"case_source_domains":["news.bitcoin.com","nasdaq.com","variety.com","cnbc.com","zacks.com","apnews.com","reuters.com","finance.yahoo.com","post-gazette.com","msn.com","marketbeat.com","washingtonpost.com","fool.com","wsj.com","uk.finance.yahoo.com","stockstory.org","investing.com","fxstreet.com","facebook.com","cryptorank.io"],"claims":[{"agreement_score":0.6,"claim_id":"claim_401a33c612c196a3","conflict":false,"direction":"neutral","evidence_count":29,"family_coverage":1,"quality_score":0.6874,"source_coverage":16,"source_trust":0.6737,"statement":"Are Energy Stocks and ETFs Still a Buy After the Rally? - Zacks Investment Research","strength":0.6602},{"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.6167},{"agreement_score":0.6,"claim_id":"claim_32d42fb9e0f2e0e4","conflict":false,"direction":"neutral","evidence_count":24,"family_coverage":1,"quality_score":0.678,"source_coverage":10,"source_trust":0.58,"statement":"Crude Prices Fluctuate on Iran War Headlines","strength":0.637},{"agreement_score":0.6,"claim_id":"claim_693d0b7f7e0c097e","conflict":false,"direction":"neutral","evidence_count":2,"family_coverage":1,"quality_score":0.4413,"source_coverage":1,"source_trust":0.58,"statement":"Pre-market futures are mixed, with the Dow down 0.14% and the Nasdaq up 0.39%.","strength":0.54}],"coverage":{"claim_count":4,"conflicting_claims":0,"dominant_claim_id":"claim_401a33c612c196a3","multi_family_claims":0,"multi_source_claims":3},"score":0.5736},"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.6731,"signal_family_coverage":4,"source_trust":{"avg_score":0.6134,"domains":[{"count":3,"domain":"reuters.com","score":0.9,"source":"Reuters"},{"count":1,"domain":"bloomberg.com","score":0.89,"source":"Bloomberg.com"},{"count":1,"domain":"ft.com","score":0.87,"source":"Financial Times"},{"count":9,"domain":"apnews.com","score":0.86,"source":"AP News"},{"count":1,"domain":"wsj.com","score":0.86,"source":"WSJ"},{"count":11,"domain":"cnbc.com","score":0.82,"source":"CNBC"},{"count":1,"domain":"marketwatch.com","score":0.77,"source":"MarketWatch"},{"count":17,"domain":"investing.com","score":0.74,"source":"web_search"},{"count":12,"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":1,"domain":"zacks.com","score":0.67,"source":"Zacks Investment Research"},{"count":57,"domain":"facebook.com","score":0.58,"source":"web_search"},{"count":25,"domain":"instagram.com","score":0.58,"source":"web_search"},{"count":22,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Investing"},{"count":20,"domain":"ad-hoc-news.de","score":0.58,"source":"web_search"},{"count":18,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":18,"domain":"bitget.com","score":0.58,"source":"web_search"},{"count":15,"domain":"aol.com","score":0.58,"source":"web_search"},{"count":10,"domain":"discoveryalert.com.au","score":0.58,"source":"web_search"},{"count":9,"domain":"fool.com","score":0.58,"source":"The Motley Fool"},{"count":9,"domain":"fxstreet.com","score":0.58,"source":"web_search"},{"count":8,"domain":"cryptorank.io","score":0.58,"source":"web_search"},{"count":8,"domain":"ainvest.com","score":0.58,"source":"web_search"},{"count":7,"domain":"alcircle.com","score":0.58,"source":"web_search"},{"count":7,"domain":"mexc.com","score":0.58,"source":"web_search"},{"count":5,"domain":"washingtonpost.com","score":0.58,"source":"The Washington Post"},{"count":5,"domain":"globalbankingandfinance.com","score":0.58,"source":"web_search"},{"count":5,"domain":"nytimes.com","score":0.58,"source":"The New York Times"},{"count":4,"domain":"marketbeat.com","score":0.58,"source":"MarketBeat"},{"count":4,"domain":"tradingeconomics.com","score":0.58,"source":"web_search"},{"count":4,"domain":"allianz.com","score":0.58,"source":"web_search"},{"count":3,"domain":"msn.com","score":0.58,"source":"MSN"},{"count":3,"domain":"energynews.oedigital.com","score":0.58,"source":"web_search"},{"count":2,"domain":"variety.com","score":0.58,"source":"Variety"},{"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":"acredia.at","score":0.58,"source":"web_search"},{"count":2,"domain":"theenergynewsbeat.substack.com","score":0.58,"source":"web_search"}],"high_trust_domains":["apnews.com","bloomberg.com","cnbc.com","ft.com","marketwatch.com","reuters.com","wsj.com"],"independent_high_trust_sources":53,"low_trust_domains":[]},"source_trust_score":0.7748},"decision":"monitor","entity_key":"commodity:us_oil_wti","evidence_event_count":60,"headline":"The market is reacting cautiously to mixed signals regarding economic recovery.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Recent economic indicators show conflicting trends, necessitating close observation."}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

{"_evidence_event_ids":["evt_7cc08e7b1688","evt_0ca8619fc458","evt_95c22ccfadaa","evt_faff5adacfe4","evt_ebcd93f64117","evt_01d9a4dfaa76","evt_29ef9992f882","evt_1fd2702456d8","evt_703633285b0c","evt_2676f2d1df7e","evt_96c2e62977f1","evt_c2c9201496f6","evt_a7abfd766a8e","evt_0bdf993effd4","evt_7d9ac9f9a4d3","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"],"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')

event_store.db — signals

Update row sig_ef93db767458 in signals