SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T00:58:18.289561+00:00","dedupe_key":"signal_enriched:market_headline_delta:617e238226e5443d","evidence_event_ids":["evt_90697d20b202"],"signal_type":"market_headline_delta","source":"market_ingestor","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 8630 in events