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/CBMimAFBVV95cUxPdjdXZE1jV0hWU2QtdUwtNFVtXzhHMWdCUEQ4TWhuYTNYM3hqMkpZbWFYb3BkVThxWWZKbE5zYzcycVdzTU8yN0l0cEQwSG5fcjE5bTdLc3FIQ3BLU2xFVEd2bzBKa2REUHB2OWw1bVFSYXA4Xy1xeXVEd2NIWnRPSmlpV2x4Qnc5WVZPX0lHNERBYUJtMDBqMQ?oc=5","as_of":"2026-04-11T09:02:27.833572+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/CBMimAFBVV95cUxPdjdXZE1jV0hWU2QtdUwtNFVtXzhHMWdCUEQ4TWhuYTNYM3hqMkpZbWFYb3BkVThxWWZKbE5zYzcycVdzTU8yN0l0cEQwSG5fcjE5bTdLc3FIQ3BLU2xFVEd2bzBKa2REUHB2OWw1bVFSYXA4Xy1xeXVEd2NIWnRPSmlpV2x4Qnc5WVZPX0lHNERBYUJtMDBqMQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_bedfd4289fc5d678","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-11T16:32:13.234237+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPdjdXZE1jV0hWU2QtdUwtNFVtXzhHMWdCUEQ4TWhuYTNYM3hqMkpZbWFYb3BkVThxWWZKbE5zYzcycVdzTU8yN0l0cEQwSG5fcjE5bTdLc3FIQ3BLU2xFVEd2bzBKa2REUHB2OWw1bVFSYXA4Xy1xeXVEd2NIWnRPSmlpV2x4Qnc5WVZPX0lHNERBYUJtMDBqMQ?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/CBMimAFBVV95cUxPdjdXZE1jV0hWU2QtdUwtNFVtXzhHMWdCUEQ4TWhuYTNYM3hqMkpZbWFYb3BkVThxWWZKbE5zYzcycVdzTU8yN0l0cEQwSG5fcjE5bTdLc3FIQ3BLU2xFVEd2bzBKa2REUHB2OWw1bVFSYXA4Xy1xeXVEd2NIWnRPSmlpV2x4Qnc5WVZPX0lHNERBYUJtMDBqMQ?oc=5","source_event_id":"evt_0a376b172650","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"4895f8edd351ed86","published_at":"2026-04-11T08:09:09+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Dividend stock (unspecified)","relevance":"high","symbol":"","type":"equity"}],"event_type":"price_action","information_gaps":["The specific dividend stock name and ticker are not provided.","No dividend yield, payout ratio, or financial figures are provided.","No market index or timeframe for \"the market falls again\" is specified.","No evidence from article text is available to validate the recommendation."],"key_facts":["The Motley Fool headline states: \"No-Brainer Dividend Stock to Buy if the Market Falls Again.\"","The stock name/ticker and dividend metrics are not included in the provided text."],"numeric_claims":[],"primary_claim":"A dividend stock is recommended to buy if the market falls again.","relevance_score":0.35,"sentiment":"positive","source_quality":"unknown","summary":"The headline promotes a dividend stock as a buy opportunity if the market declines again. No specific stock, ticker, or dividend details are provided in the provided text.","topics":["dividends","buy recommendation","market decline scenario"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"1 No-Brainer Dividend Stock to Buy if the Market Falls Again - The Motley Fool","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_eeaaa8e2d194 in signals