SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"case_id":"case_11c2f28a44862b00","confidence":0.38,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":199,"score":0.5,"up_count":0},"base_score":0.7544,"claim_graph":{"case_signal_families":["news","market","smart_money","research"],"case_source_domains":["barrons.com","wsj.com","apnews.com","fool.com","fidelity.com","timesofisrael.com","outkick.com","isonewswire.com","tradingview.com","marketbeat.com","finance.yahoo.com","gizmodo.com","reuters.com","decrypt.co","cryptoslate.com","nasdaq.com","axios.com","msn.com","theguardian.com","stocktitan.net"],"claims":[{"agreement_score":0.6,"claim_id":"claim_eb63f04a05318718","conflict":false,"direction":"neutral","evidence_count":32,"family_coverage":1,"quality_score":0.6874,"source_coverage":15,"source_trust":0.674,"statement":"United Airlines raises bag fees amid rising fuel costs and introduces tiered premium fares - AP News","strength":0.6708},{"agreement_score":0.6,"claim_id":"claim_d2a131e960ac19f7","conflict":false,"direction":"neutral","evidence_count":11,"family_coverage":1,"quality_score":0.682,"source_coverage":8,"source_trust":0.62,"statement":"Inside Binance\u2019s Gold And Oil Rush \u2014 Are Whales Bracing For A Crypto Shock? - TradingView","strength":0.6599},{"agreement_score":0.6,"claim_id":"claim_fd58142e5b877fc3","conflict":false,"direction":"neutral","evidence_count":23,"family_coverage":1,"quality_score":0.6797,"source_coverage":16,"source_trust":0.5975,"statement":"WTI crude is set to settle higher than Brent crude for the first time.","strength":0.6273},{"agreement_score":0.6,"claim_id":"claim_5ab6665853dcd932","conflict":false,"direction":"neutral","evidence_count":1,"family_coverage":1,"quality_score":0.3963,"source_coverage":1,"source_trust":0.58,"statement":"Analyzing the Energy Sector's Strong Earnings Outlook","strength":0.4346}],"coverage":{"claim_count":4,"conflicting_claims":0,"dominant_claim_id":"claim_eb63f04a05318718","multi_family_claims":0,"multi_source_claims":3},"score":0.5695},"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":true,"high_trust_source_coverage":5,"independent_source_coverage":20,"low_trust_source_coverage":0,"score":0.6866,"signal_family_coverage":4,"source_trust":{"avg_score":0.6817,"domains":[{"count":2,"domain":"reuters.com","score":0.9,"source":"Reuters"},{"count":20,"domain":"wsj.com","score":0.86,"source":"WSJ"},{"count":1,"domain":"apnews.com","score":0.86,"source":"AP News"},{"count":48,"domain":"barrons.com","score":0.82,"source":"Barron's"},{"count":1,"domain":"morningstar.com","score":0.82,"source":"Morningstar"},{"count":3,"domain":"axios.com","score":0.77,"source":"Axios"},{"count":3,"domain":"investing.com","score":0.74,"source":"web_search"},{"count":6,"domain":"oilprice.com","score":0.7,"source":"web_search"},{"count":1,"domain":"npr.org","score":0.68,"source":"NPR"},{"count":1,"domain":"tradingview.com","score":0.66,"source":"TradingView"},{"count":17,"domain":"facebook.com","score":0.58,"source":"web_search"},{"count":9,"domain":"bitget.com","score":0.58,"source":"web_search"},{"count":7,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Investing"},{"count":7,"domain":"cryptorank.io","score":0.58,"source":"web_search"},{"count":7,"domain":"ad-hoc-news.de","score":0.58,"source":"web_search"},{"count":6,"domain":"ainvest.com","score":0.58,"source":"web_search"},{"count":6,"domain":"discoveryalert.com.au","score":0.58,"source":"web_search"},{"count":5,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":5,"domain":"stocktitan.net","score":0.58,"source":"Stock Titan"},{"count":5,"domain":"vtmarkets.com","score":0.58,"source":"web_search"},{"count":4,"domain":"msn.com","score":0.58,"source":"MSN"},{"count":3,"domain":"mitrade.com","score":0.58,"source":"web_search"},{"count":3,"domain":"instagram.com","score":0.58,"source":"web_search"},{"count":2,"domain":"fool.com","score":0.58,"source":"The Motley Fool"},{"count":2,"domain":"fidelity.com","score":0.58,"source":"fidelity.com"},{"count":2,"domain":"timesofisrael.com","score":0.58,"source":"The Times of Israel"},{"count":2,"domain":"outkick.com","score":0.58,"source":"OutKick"},{"count":2,"domain":"isonewswire.com","score":0.58,"source":"isonewswire.com"},{"count":2,"domain":"politico.com","score":0.58,"source":"Politico"},{"count":2,"domain":"fxstreet.com","score":0.58,"source":"web_search"},{"count":2,"domain":"mexc.com","score":0.58,"source":"web_search"},{"count":2,"domain":"mansfield.energy","score":0.58,"source":"web_search"},{"count":2,"domain":"allianz.com","score":0.58,"source":"web_search"},{"count":1,"domain":"marketbeat.com","score":0.58,"source":"MarketBeat"},{"count":1,"domain":"gizmodo.com","score":0.58,"source":"Gizmodo"},{"count":1,"domain":"decrypt.co","score":0.58,"source":"Decrypt RSS"},{"count":1,"domain":"cryptoslate.com","score":0.58,"source":"CryptoSlate RSS"},{"count":1,"domain":"theguardian.com","score":0.58,"source":"The Guardian"},{"count":1,"domain":"trig-ltd.com","score":0.58,"source":"web_search"},{"count":1,"domain":"techi.com","score":0.58,"source":"web_search"}],"high_trust_domains":["apnews.com","axios.com","barrons.com","morningstar.com","reuters.com","wsj.com"],"independent_high_trust_sources":42,"low_trust_domains":[]},"source_trust_score":0.7722},"decision":"monitor","entity_key":"commodity:us_oil_wti","evidence_event_count":60,"headline":"Oil prices have surged toward $150 per barrel due to the closure of the Strait of Hormuz, impacting global demand and economies reliant on oil imports.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"Signal convergence: United Airlines raises bag fees amid rising fuel costs and introduces tiered premium fares - AP News [neutral]; Inside Binance\u2019s Gold And Oil Rush \u2014 Are Whales Bracing For A Crypto Shock? - Trading..."}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

{"_evidence_event_ids":["evt_82f5e87349c1","evt_e828462f707a","evt_702cec62f41d","evt_0016cfac9515","evt_3bf7697adf79","evt_0bdb6e05a0d1","evt_8d573117939e","evt_4587e2658c82","evt_b9739a107a40","evt_3835a7dcaf66","evt_ae1ea97e7159","evt_fbac1a0e1636","evt_8ee2fa878972","evt_d519ddaff24e","evt_86cfdf292af1","evt_f48af1a146fd","evt_6695d3b1fe05","evt_f3b29bcf7225","evt_e74d35e52dc4","evt_27f9e8fdad4b","evt_3e35ea82d60c","evt_36465582aab6","evt_a5c4f33010c8","evt_3a2b62499656","evt_f8cf9e1c4118","evt_32a7fd8755de","evt_476213e6df0d","evt_fe9fba5e9150","evt_689eeba1d0d4","evt_9910f7a1dfa5","evt_81685455264f","evt_a0dd4850877f","evt_ca3808dcfdd8","evt_de26e205c4db","evt_8563e030cddb","evt_770c75e7b91d","evt_2e0e2ae32de1","evt_23482fb1db88","evt_684adb493de2","evt_d5e4556a506e","evt_1033efd7dd3c","evt_3f0ea0afa05b","evt_db0be0f28361","evt_ae0bc79681c0","evt_986089c985cf","evt_9afe30cf53da","evt_bc9766bc40de","evt_8ff7823dde8a","evt_229091d34c1a","evt_891b86cd84ac","evt_7358d8f4ed78","evt_c3b576849c75","evt_19528bd836b1","evt_50c2763717e8","evt_ae90e6fdd026","evt_fa9646798b61","evt_fd8b24038f21","evt_55ea73005574","evt_b23d250b2ec3","evt_c1350eb1804e"],"case_id":"case_11c2f28a44862b00","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_0376ee6f4dea in signals