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/CBMilwFBVV95cUxQZVZmMUo1LXJOb2JScWk1R3NWUVpPNmFOLWlHOWhURmhuekRfb0xoWTR5RThscHVPMUFmMVFQejZxT0RrbTFwSzE5d3ZBd0pVSWdlQnhxRTFrVENQT2lLenBwaHlGQ250ZEZuMDNSTnppWGNUU2VjMWc3N3JjUlFzanE5UUxwVHpiREQwaEhTUExMamxfZm9z?oc=5","as_of":"2026-04-12T01:29:55.239782+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxQZVZmMUo1LXJOb2JScWk1R3NWUVpPNmFOLWlHOWhURmhuekRfb0xoWTR5RThscHVPMUFmMVFQejZxT0RrbTFwSzE5d3ZBd0pVSWdlQnhxRTFrVENQT2lLenBwaHlGQ250ZEZuMDNSTnppWGNUU2VjMWc3N3JjUlFzanE5UUxwVHpiREQwaEhTUExMamxfZm9z?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_96ed2a32df30f768","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=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T01:30:42.203071+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxQZVZmMUo1LXJOb2JScWk1R3NWUVpPNmFOLWlHOWhURmhuekRfb0xoWTR5RThscHVPMUFmMVFQejZxT0RrbTFwSzE5d3ZBd0pVSWdlQnhxRTFrVENQT2lLenBwaHlGQ250ZEZuMDNSTnppWGNUU2VjMWc3N3JjUlFzanE5UUxwVHpiREQwaEhTUExMamxfZm9z?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/CBMilwFBVV95cUxQZVZmMUo1LXJOb2JScWk1R3NWUVpPNmFOLWlHOWhURmhuekRfb0xoWTR5RThscHVPMUFmMVFQejZxT0RrbTFwSzE5d3ZBd0pVSWdlQnhxRTFrVENQT2lLenBwaHlGQ250ZEZuMDNSTnppWGNUU2VjMWc3N3JjUlFzanE5UUxwVHpiREQwaEhTUExMamxfZm9z?oc=5","source_event_id":"evt_2e8cea367835","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"160c15d9f8a949d6","published_at":"2026-04-11T14:25:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"high","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The two specific consumer stocks (names and ticker symbols) are not provided.","No details are given on why the stocks are considered \u201covervalued.\u201d","No information is provided on what constitutes a \u201cmassive pullback\u201d or the expected timing.","No evidence from the article body is available to validate or quantify the claims."],"key_facts":["Headline states: \u201c2 Overvalued Consumer Stocks Investors Should Buy if a Massive Pullback Occurs.\u201d","The provided text does not include the names or ticker symbols of the two consumer stocks.","The provided text does not include any market data, dates, or catalysts beyond the conditional phrase \u201cif a massive pullback occurs.\u201d"],"numeric_claims":[],"primary_claim":"The Motley Fool claims there are two overvalued consumer stocks that investors should buy if a massive pullback occurs.","relevance_score":0.25,"sentiment":"mixed","source_quality":"unknown","summary":"The Motley Fool headline suggests two consumer stocks are described as overvalued and that investors should buy them only if a massive pullback occurs. No specific stock tickers or timing details are provided in the provided text.","topics":["consumer stocks","valuation","investing strategy","market pullback"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"2 Overvalued Consumer Stocks Investors Should Buy if a Massive Pullback Occurs The Motley Fool","title":"2 Overvalued Consumer Stocks Investors Should Buy if a Massive Pullback Occurs - The Motley Fool","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDigAAQ/d=1/ed=1/rs=ALs0n2PgsNZ_arG4AeWgZkaDfNEtTsUDTw/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_60d9e47f4354 in signals