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/CBMijgFBVV95cUxQXzFKVzU5NjJSZU1OTjhfOTh3NFVDbkp1UDBXQTczM0FtNGoyMVI4Rm8xNUtvNDltYzItUmhjRDU3NVJiek5CYTdYUlZka0NLQzRqb0hkM2FhX2pjOFY4V0hQc2hDSGZBcV90clBGU0pvMnE1b201OWhiY09fWHBlUVduNXRLekFvbjc3eU13?oc=5","as_of":"2026-04-08T04:18:54.921408+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxQXzFKVzU5NjJSZU1OTjhfOTh3NFVDbkp1UDBXQTczM0FtNGoyMVI4Rm8xNUtvNDltYzItUmhjRDU3NVJiek5CYTdYUlZka0NLQzRqb0hkM2FhX2pjOFY4V0hQc2hDSGZBcV90clBGU0pvMnE1b201OWhiY09fWHBlUVduNXRLekFvbjc3eU13?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8894a84a6070935d","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T04:19:22.361351+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxQXzFKVzU5NjJSZU1OTjhfOTh3NFVDbkp1UDBXQTczM0FtNGoyMVI4Rm8xNUtvNDltYzItUmhjRDU3NVJiek5CYTdYUlZka0NLQzRqb0hkM2FhX2pjOFY4V0hQc2hDSGZBcV90clBGU0pvMnE1b201OWhiY09fWHBlUVduNXRLekFvbjc3eU13?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxQXzFKVzU5NjJSZU1OTjhfOTh3NFVDbkp1UDBXQTczM0FtNGoyMVI4Rm8xNUtvNDltYzItUmhjRDU3NVJiek5CYTdYUlZka0NLQzRqb0hkM2FhX2pjOFY4V0hQc2hDSGZBcV90clBGU0pvMnE1b201OWhiY09fWHBlUVduNXRLekFvbjc3eU13?oc=5","source_event_id":"evt_0b1a05500242","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2aa73ad3e6a3fe96","published_at":"2026-04-08T00:03:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Bill Ackman","relevance":"primary","symbol":"","type":"person"},{"asset_class":"","name":"The Motley Fool","relevance":"secondary","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["No specific stocks, sectors, or valuation metrics are mentioned in the provided text.","No timing (e.g., when the statement was made) or catalyst details are provided beyond the headline.","No explanation of Ackman\u2019s rationale or whether he is buying/selling is included in the provided text."],"key_facts":["The Motley Fool headline reports that Bill Ackman said stocks are \u201cstupidly cheap.\u201d"],"numeric_claims":[],"primary_claim":"Bill Ackman stated that stocks are \u201cstupidly cheap.\u201d","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"Bill Ackman said stocks are \u201cstupidly cheap,\u201d as reported by The Motley Fool.","topics":["equities valuation","market commentary","stock pricing"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"Bill Ackman Says Stocks Are \u201cStupidly Cheap\u201d The Motley Fool","title":"Bill Ackman Says Stocks Are \u201cStupidly Cheap\u201d - The Motley Fool","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_da2282534462 in signals