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/CBMi4wFBVV95cUxPWVBXbmtFb2N4bkRQMHkwMHJLeFZELUFYd3k4MmRRRGNha1Zlc21ka2VibExHTFR2SU1teE02NWFWekpsX3pnRm04MS1INVg2cGM2R0dBQW1zbldZaXBMem9QLURVWE5YNHlmXzNZaVpMWkVoa0NwZXhEYmV2dEtmTGVXSEttdml5eDM5bC15U25sdFhjaS1FeEtkbjdGNTJJUUpYMVBsYnVzYlQ1blAyV1RzS3NteHdTcjQyVEhVVVdCeExPR01BUnNMWmVaTlZ5MDloMXgtQTJ3OFV6WG02OGRNYw?oc=5","as_of":"2026-04-09T03:57:11.158412+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/CBMi4wFBVV95cUxPWVBXbmtFb2N4bkRQMHkwMHJLeFZELUFYd3k4MmRRRGNha1Zlc21ka2VibExHTFR2SU1teE02NWFWekpsX3pnRm04MS1INVg2cGM2R0dBQW1zbldZaXBMem9QLURVWE5YNHlmXzNZaVpMWkVoa0NwZXhEYmV2dEtmTGVXSEttdml5eDM5bC15U25sdFhjaS1FeEtkbjdGNTJJUUpYMVBsYnVzYlQ1blAyV1RzS3NteHdTcjQyVEhVVVdCeExPR01BUnNMWmVaTlZ5MDloMXgtQTJ3OFV6WG02OGRNYw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1f0b5356cde540fa","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:31:26.268290+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi4wFBVV95cUxPWVBXbmtFb2N4bkRQMHkwMHJLeFZELUFYd3k4MmRRRGNha1Zlc21ka2VibExHTFR2SU1teE02NWFWekpsX3pnRm04MS1INVg2cGM2R0dBQW1zbldZaXBMem9QLURVWE5YNHlmXzNZaVpMWkVoa0NwZXhEYmV2dEtmTGVXSEttdml5eDM5bC15U25sdFhjaS1FeEtkbjdGNTJJUUpYMVBsYnVzYlQ1blAyV1RzS3NteHdTcjQyVEhVVVdCeExPR01BUnNMWmVaTlZ5MDloMXgtQTJ3OFV6WG02OGRNYw?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/CBMi4wFBVV95cUxPWVBXbmtFb2N4bkRQMHkwMHJLeFZELUFYd3k4MmRRRGNha1Zlc21ka2VibExHTFR2SU1teE02NWFWekpsX3pnRm04MS1INVg2cGM2R0dBQW1zbldZaXBMem9QLURVWE5YNHlmXzNZaVpMWkVoa0NwZXhEYmV2dEtmTGVXSEttdml5eDM5bC15U25sdFhjaS1FeEtkbjdGNTJJUUpYMVBsYnVzYlQ1blAyV1RzS3NteHdTcjQyVEhVVVdCeExPR01BUnNMWmVaTlZ5MDloMXgtQTJ3OFV6WG02OGRNYw?oc=5","source_event_id":"evt_ca639f18b2e1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"46ca668371d995d6","published_at":"2026-04-08T21:12:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["Wednesday"],"entities":[{"asset_class":"equity","name":"Brown-Forman Corp. Cl B","relevance":"high","symbol":"BF.B","type":"company_security"}],"event_type":"price_action","information_gaps":["The article text provided contains only page styling/HTML fragments and does not include the actual MarketWatch content beyond the headline.","No percentage move, price level, or time window (e.g., intraday vs close) is provided in the supplied text.","\u201cUnderperforms market\u201d is not quantified (no benchmark index specified, e.g., S&P 500)."],"key_facts":["Brown-Forman Corp. Cl B stock rose on Wednesday.","Despite the rise, Brown-Forman Corp. Cl B still underperformed the market."],"numeric_claims":[],"primary_claim":"Brown-Forman Corp. Cl B stock rose Wednesday while still underperforming the market.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"Brown-Forman Corp. Class B shares rose on Wednesday but continued to lag the broader market.","topics":["stock price","market underperformance","daily performance"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"","tickers":[],"title":"Brown-Forman Corp. Cl B stock rises Wednesday, still underperforms 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_f880978884f9 in signals