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/CBMixAFBVV95cUxQRGRDV0Zzb0YtTTJIclp2ZDY2cWdYV2VWeURnZ3RsRTNtdDZSSXdaRHJmM1czanYxRGlCbFFLbkdncW13X2JSMWpkazVWc2Z4cFdhQzJBT3FEZEJMQW92OGd3ZE1KOC1kTTZic0NPU0tOSERaNXYwU2dBRjNZN1dkckw4c2JYblN4aTN1bERlaVZabnJReW1rOU9WMHMxYmk5YTlMWVZibGdhTGg3X2QzaFRhSnZKQ0t2TUIyMm1mc2NNQm1f?oc=5","as_of":"2026-04-08T19:34:44.185627+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/CBMixAFBVV95cUxQRGRDV0Zzb0YtTTJIclp2ZDY2cWdYV2VWeURnZ3RsRTNtdDZSSXdaRHJmM1czanYxRGlCbFFLbkdncW13X2JSMWpkazVWc2Z4cFdhQzJBT3FEZEJMQW92OGd3ZE1KOC1kTTZic0NPU0tOSERaNXYwU2dBRjNZN1dkckw4c2JYblN4aTN1bERlaVZabnJReW1rOU9WMHMxYmk5YTlMWVZibGdhTGg3X2QzaFRhSnZKQ0t2TUIyMm1mc2NNQm1f?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a7326925849dd8e7","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-09T19:33:05.519714+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxQRGRDV0Zzb0YtTTJIclp2ZDY2cWdYV2VWeURnZ3RsRTNtdDZSSXdaRHJmM1czanYxRGlCbFFLbkdncW13X2JSMWpkazVWc2Z4cFdhQzJBT3FEZEJMQW92OGd3ZE1KOC1kTTZic0NPU0tOSERaNXYwU2dBRjNZN1dkckw4c2JYblN4aTN1bERlaVZabnJReW1rOU9WMHMxYmk5YTlMWVZibGdhTGg3X2QzaFRhSnZKQ0t2TUIyMm1mc2NNQm1f?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketbeat.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxQRGRDV0Zzb0YtTTJIclp2ZDY2cWdYV2VWeURnZ3RsRTNtdDZSSXdaRHJmM1czanYxRGlCbFFLbkdncW13X2JSMWpkazVWc2Z4cFdhQzJBT3FEZEJMQW92OGd3ZE1KOC1kTTZic0NPU0tOSERaNXYwU2dBRjNZN1dkckw4c2JYblN4aTN1bERlaVZabnJReW1rOU9WMHMxYmk5YTlMWVZibGdhTGg3X2QzaFRhSnZKQ0t2TUIyMm1mc2NNQm1f?oc=5","source_event_id":"evt_5bb33e1a8571","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b1f1a64676a9c264","published_at":"2026-04-08T18:51:56+00:00","publisher_domain":"marketbeat.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Wells Fargo & Company","relevance":"primary","symbol":"","type":"company"},{"asset_class":"equity","name":"Colgate-Palmolive","relevance":"primary","symbol":"CL","type":"company"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond CSS/HTML, so the rationale for the price target change is unknown.","No prior (previous) price target value is included, so the magnitude of the change cannot be quantified.","No mention of an accompanying rating change (e.g., buy/hold/sell) is present in the provided text."],"key_facts":["Headline states Wells Fargo & Company lowered Colgate-Palmolive\u2019s (NYSE: CL) price target to $92.00.","Source listed as MarketBeat (marketbeat.com)."],"numeric_claims":[{"label":"New price target (USD)","value":"92.00"}],"primary_claim":"Wells Fargo lowered its price target for Colgate-Palmolive (CL) to $92.00.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Wells Fargo & Company reduced its price target for Colgate-Palmolive (NYSE: CL) to $92.00, per the MarketBeat headline.","topics":["price target downgrade","equity research","analyst rating/target","consumer staples"]},"source":"MarketBeat","source_domain":"marketbeat.com","source_url":"https://www.marketbeat.com","summary":"","tickers":[],"title":"Wells Fargo & Company Lowers Colgate-Palmolive (NYSE:CL) Price Target to $92.00 - MarketBeat","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_99e56f869b6a in signals