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/CBMiwgFBVV95cUxQSjZDM096SkpzZG9JbUR6OU5HUFNHRUd5YVo4dEhlUlhNSmdaTHRWZWc3dFp1a1NnS1RJS29oU1A5ZlMyMWFtQ0o0RzBUSzllNDYzYjduS0dYOURneks4ZWdWbXQyN2xIQm9JYjZlRGoyTUs4NmV3c3FPei1yZEFTZUJKZmk1akNBNHd4anh0aklEVEZhdHFDTXZUcEh2a052UFNSRmwyV2hjUEUxTnhYcEdhdi1PZjY2TVZWNnpwc3ZIQQ?oc=5","as_of":"2026-04-09T03:57:11.205724+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/CBMiwgFBVV95cUxQSjZDM096SkpzZG9JbUR6OU5HUFNHRUd5YVo4dEhlUlhNSmdaTHRWZWc3dFp1a1NnS1RJS29oU1A5ZlMyMWFtQ0o0RzBUSzllNDYzYjduS0dYOURneks4ZWdWbXQyN2xIQm9JYjZlRGoyTUs4NmV3c3FPei1yZEFTZUJKZmk1akNBNHd4anh0aklEVEZhdHFDTXZUcEh2a052UFNSRmwyV2hjUEUxTnhYcEdhdi1PZjY2TVZWNnpwc3ZIQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4c3aed199fcf35a5","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:32:46.675117+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxQSjZDM096SkpzZG9JbUR6OU5HUFNHRUd5YVo4dEhlUlhNSmdaTHRWZWc3dFp1a1NnS1RJS29oU1A5ZlMyMWFtQ0o0RzBUSzllNDYzYjduS0dYOURneks4ZWdWbXQyN2xIQm9JYjZlRGoyTUs4NmV3c3FPei1yZEFTZUJKZmk1akNBNHd4anh0aklEVEZhdHFDTXZUcEh2a052UFNSRmwyV2hjUEUxTnhYcEdhdi1PZjY2TVZWNnpwc3ZIQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketwatch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxQSjZDM096SkpzZG9JbUR6OU5HUFNHRUd5YVo4dEhlUlhNSmdaTHRWZWc3dFp1a1NnS1RJS29oU1A5ZlMyMWFtQ0o0RzBUSzllNDYzYjduS0dYOURneks4ZWdWbXQyN2xIQm9JYjZlRGoyTUs4NmV3c3FPei1yZEFTZUJKZmk1akNBNHd4anh0aklEVEZhdHFDTXZUcEh2a052UFNSRmwyV2hjUEUxTnhYcEdhdi1PZjY2TVZWNnpwc3ZIQQ?oc=5","source_event_id":"evt_beffd16756b3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ad3b325fbd98ef18","published_at":"2026-04-08T20:35:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.78,"dates_mentioned":["Wednesday"],"entities":[{"asset_class":"equity","name":"Teck Resources Ltd. Cl B","relevance":"high","symbol":"","type":"company_security"}],"event_type":"price_action","information_gaps":["No percentage move, price level, or time window is provided in the provided text.","No market index or benchmark used for 'outperforms market' is specified.","No additional drivers (earnings, guidance, news catalyst) are included in the provided text."],"key_facts":["MarketWatch headline states that Teck Resources Ltd. Cl B stock rose Wednesday.","MarketWatch headline states that Teck Resources Ltd. Cl B stock outperformed the market."],"numeric_claims":[],"primary_claim":"Teck Resources Ltd. Cl B stock rose Wednesday and outperformed the market.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Teck Resources Ltd. Class B shares rose on Wednesday and reportedly outperformed the broader market, per a MarketWatch headline.","topics":["stock price","market outperformance","equities"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"","tickers":[],"title":"Teck Resources Ltd. Cl B stock rises Wednesday, outperforms market - MarketWatch","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_4d2b49edf4be in signals