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.6738,"corroboration":{"agreement":{"count_score":0.5,"down_count":0,"magnitude_weighted_score":0.5,"majority_direction":"neutral","neutral_count":88,"score":0.5,"up_count":0},"base_score":0.7527,"claim_graph":{"case_signal_families":["market","smart_money","news"],"case_source_domains":["news.bitcoin.com","nasdaq.com","finance.yahoo.com","cnbc.com","indiewire.com","bbc.com","fool.com","wsj.com","ksn.com","jpost.com","marketbeat.com","futurism.com","thealbertan.com","thecut.com","dailymail.co.uk","theintelligencer.net","barrons.com","washingtonpost.com","zacks.com","apnews.com"],"claims":[{"agreement_score":0.6,"claim_id":"claim_401a33c612c196a3","conflict":false,"direction":"neutral","evidence_count":28,"family_coverage":1,"quality_score":0.6833,"source_coverage":16,"source_trust":0.6331,"statement":"Asia-Pacific markets trade mixed as investors assess Trump's hardened rhetoric on Iran war - cnbc.com","strength":0.6676},{"agreement_score":0.6,"claim_id":"claim_32d42fb9e0f2e0e4","conflict":false,"direction":"neutral","evidence_count":16,"family_coverage":1,"quality_score":0.682,"source_coverage":7,"source_trust":0.62,"statement":"Stock Market Today, April 6: Kosmos Energy Rises to 52-Week High as Shares Outpace Analyst Targets - fool.com","strength":0.6404},{"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":3,"conflicting_claims":0,"dominant_claim_id":"claim_401a33c612c196a3","multi_family_claims":0,"multi_source_claims":2},"score":0.5475},"contradiction":{"flags":[],"has_unresolved_conflict":false,"resolved_claims":[],"resolved_count":0,"score":0.0,"unresolved_claims":[],"unresolved_count":0},"contradiction_flags":[],"evidence_event_count":46,"high_precision_pass":true,"high_trust_source_coverage":4,"independent_source_coverage":20,"low_trust_source_coverage":0,"score":0.6738,"signal_family_coverage":3,"source_trust":{"avg_score":0.6551,"domains":[{"count":3,"domain":"reuters.com","score":0.9,"source":"Reuters"},{"count":1,"domain":"bloomberg.com","score":0.89,"source":"Bloomberg.com"},{"count":7,"domain":"apnews.com","score":0.86,"source":"apnews.com"},{"count":2,"domain":"wsj.com","score":0.86,"source":"WSJ"},{"count":6,"domain":"barrons.com","score":0.82,"source":"Barron's"},{"count":5,"domain":"cnbc.com","score":0.82,"source":"cnbc.com"},{"count":2,"domain":"zacks.com","score":0.67,"source":"Zacks Investment Research"},{"count":15,"domain":"finance.yahoo.com","score":0.58,"source":"Yahoo Finance"},{"count":14,"domain":"nasdaq.com","score":0.58,"source":"Nasdaq Investing"},{"count":5,"domain":"fool.com","score":0.58,"source":"The Motley Fool"},{"count":3,"domain":"bbc.com","score":0.58,"source":"BBC"},{"count":3,"domain":"msn.com","score":0.58,"source":"MSN"},{"count":2,"domain":"news.bitcoin.com","score":0.58,"source":"Bitcoin.com News"},{"count":2,"domain":"indiewire.com","score":0.58,"source":"indiewire.com"},{"count":2,"domain":"thealbertan.com","score":0.58,"source":"The Albertan"},{"count":2,"domain":"dailymail.co.uk","score":0.58,"source":"Daily Mail"},{"count":2,"domain":"theintelligencer.net","score":0.58,"source":"theintelligencer.net"},{"count":2,"domain":"variety.com","score":0.58,"source":"Variety"},{"count":2,"domain":"post-gazette.com","score":0.58,"source":"Pittsburgh Post-Gazette"},{"count":1,"domain":"ksn.com","score":0.58,"source":"KSN.com"},{"count":1,"domain":"jpost.com","score":0.58,"source":"The Jerusalem Post"},{"count":1,"domain":"marketbeat.com","score":0.58,"source":"MarketBeat"},{"count":1,"domain":"futurism.com","score":0.58,"source":"futurism.com"},{"count":1,"domain":"thecut.com","score":0.58,"source":"The Cut"},{"count":1,"domain":"washingtonpost.com","score":0.58,"source":"The Washington Post"},{"count":1,"domain":"cnn.com","score":0.58,"source":"CNN"},{"count":1,"domain":"uk.finance.yahoo.com","score":0.58,"source":"Yahoo Finance UK"}],"high_trust_domains":["apnews.com","barrons.com","bloomberg.com","cnbc.com","reuters.com","wsj.com"],"independent_high_trust_sources":27,"low_trust_domains":[]},"source_trust_score":0.7637},"decision":"digest","entity_key":"commodity:us_oil_wti","evidence_event_count":46,"headline":"Iran's rejection of ceasefire proposals amid U.S.-Israel military actions is impacting oil markets and investor sentiment.","personal_relevance_score":0.1,"theme_key":"entity_development","why_now":"The situation is critical as the U.S. military campaign against Iran intensifies, prompting market reactions."}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

{"_evidence_event_ids":["evt_36c7fde892d5","evt_845f692174ff","evt_af6d70ff6826","evt_6cfc5d95d81f","evt_b48a4ebe5767","evt_de908cbbc650","evt_630a0563ecb4","evt_b06494229835","evt_9f44cd423157","evt_cf3d4e184e68","evt_18b646a53194","evt_ee479b7f8175","evt_d2283a4d24c3","evt_3ebacf674847","evt_497248e12557","evt_04fe61bfc342","evt_c915bd435e15","evt_cb8cc1e3975e","evt_cc883e428d02","evt_d45910bb5a26","evt_c97cf5ad654f","evt_41909eeda90e","evt_9e3d5df23a84","evt_17cecccf19a9","evt_69e1e3a7500b","evt_8292f8db2675","evt_e2471cf8840c","evt_f179711d1336","evt_a3ad65497e0e","evt_41271395cf2e","evt_7ef0e915bdb8","evt_af1e2a386442","evt_e1b06c386b53","evt_edef8803b2f7","evt_95c22ccfadaa","evt_faff5adacfe4","evt_ebcd93f64117","evt_01d9a4dfaa76","evt_29ef9992f882","evt_1fd2702456d8","evt_2676f2d1df7e","evt_96c2e62977f1","evt_c2c9201496f6","evt_a7abfd766a8e","evt_0bdf993effd4","evt_7d9ac9f9a4d3"],"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')

event_store.db — signals

Update row sig_ec2b153f7d90 in signals