SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxQVmRnay1sRFE3MjJsMlBzLTZYcUFpWHlsVTNFU01IUlkwXzB4d0hjaXNTR29KVTZNT2VvTjdWSm1hdlV5endudDdLdFh5ZktzVWxuSVBfLS1BVmtwdXZpcWNXUGFSSHhIX2FpVVdpZDd2T1JNWC1GeTdHYmtfcnhLUzJOSUZ2STRzYkJOWDBGYW04dkZ2SDVHODBITEtIakpm?oc=5","as_of":"2026-04-09T00:58:18.289561+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxQVmRnay1sRFE3MjJsMlBzLTZYcUFpWHlsVTNFU01IUlkwXzB4d0hjaXNTR29KVTZNT2VvTjdWSm1hdlV5endudDdLdFh5ZktzVWxuSVBfLS1BVmtwdXZpcWNXUGFSSHhIX2FpVVdpZDd2T1JNWC1GeTdHYmtfcnhLUzJOSUZ2STRzYkJOWDBGYW04dkZ2SDVHODBITEtIakpm?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_23a13517f968c472","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:20:53.520591+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxQVmRnay1sRFE3MjJsMlBzLTZYcUFpWHlsVTNFU01IUlkwXzB4d0hjaXNTR29KVTZNT2VvTjdWSm1hdlV5endudDdLdFh5ZktzVWxuSVBfLS1BVmtwdXZpcWNXUGFSSHhIX2FpVVdpZDd2T1JNWC1GeTdHYmtfcnhLUzJOSUZ2STRzYkJOWDBGYW04dkZ2SDVHODBITEtIakpm?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investingnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxQVmRnay1sRFE3MjJsMlBzLTZYcUFpWHlsVTNFU01IUlkwXzB4d0hjaXNTR29KVTZNT2VvTjdWSm1hdlV5endudDdLdFh5ZktzVWxuSVBfLS1BVmtwdXZpcWNXUGFSSHhIX2FpVVdpZDd2T1JNWC1GeTdHYmtfcnhLUzJOSUZ2STRzYkJOWDBGYW04dkZ2SDVHODBITEtIakpm?oc=5","source_event_id":"evt_90697d20b202","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e7cbfe575523a799","published_at":"2026-04-08T21:30:00+00:00","publisher_domain":"investingnews.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.7,"dates_mentioned":["2026"],"entities":[{"asset_class":"equities","name":"Canadian crypto mining stocks (unspecified)","relevance":"high","symbol":"","type":"asset_group"}],"event_type":"price_action","information_gaps":["The three specific stocks are not named in the provided text.","No ticker symbols, price returns, or time window for \u201cbest-performing\u201d are provided.","No methodology or criteria for the ranking is included.","The provided article body content appears to be mostly page styling/HTML and does not include the actual list or performance figures."],"key_facts":["Headline states: \u201c3 Best-performing Canadian Crypto Mining Stocks of 2026 - Investing News Network.\u201d","No stock names or ticker symbols are included in the provided text."],"numeric_claims":[],"primary_claim":"Investing News Network lists \u201c3 Best-performing Canadian Crypto Mining Stocks of 2026.\u201d","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The headline claims that three Canadian crypto mining stocks were the best performers of 2026, as covered by Investing News Network. No specific tickers or performance metrics are provided in the provided text.","topics":["crypto mining","Canadian equities","2026 performance ranking"]},"source":"Investing News Network","source_domain":"investingnews.com","source_url":"https://investingnews.com","summary":"","tickers":[],"title":"3 Best-performing Canadian Crypto Mining Stocks of 2026 - Investing News Network","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

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_2acdd0a09a5d in signals