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/CBMilwFBVV95cUxOMF9JbHUxdVlCZHNGUDd1S0JiVU5tbm9mNTM4TVdpM3BZZDNkQmdqdE12bzFIYWxOWDlrbEpPUE5NQTh4b2FDTVRfTnpUQ0RSZGdiWF9aQnp5OWJYZWNvR3JEU29MRkdfaUV1ZGxpZElhN3lINjgxd3NUcG1mSEZNUTJKajZiT1EzVnhYdG1meXp5YWpqVFA0?oc=5","as_of":"2026-04-11T18:52:10.803585+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/CBMilwFBVV95cUxOMF9JbHUxdVlCZHNGUDd1S0JiVU5tbm9mNTM4TVdpM3BZZDNkQmdqdE12bzFIYWxOWDlrbEpPUE5NQTh4b2FDTVRfTnpUQ0RSZGdiWF9aQnp5OWJYZWNvR3JEU29MRkdfaUV1ZGxpZElhN3lINjgxd3NUcG1mSEZNUTJKajZiT1EzVnhYdG1meXp5YWpqVFA0?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0e137d92e36acf28","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-11T22:39:49.231947+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOMF9JbHUxdVlCZHNGUDd1S0JiVU5tbm9mNTM4TVdpM3BZZDNkQmdqdE12bzFIYWxOWDlrbEpPUE5NQTh4b2FDTVRfTnpUQ0RSZGdiWF9aQnp5OWJYZWNvR3JEU29MRkdfaUV1ZGxpZElhN3lINjgxd3NUcG1mSEZNUTJKajZiT1EzVnhYdG1meXp5YWpqVFA0?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/CBMilwFBVV95cUxOMF9JbHUxdVlCZHNGUDd1S0JiVU5tbm9mNTM4TVdpM3BZZDNkQmdqdE12bzFIYWxOWDlrbEpPUE5NQTh4b2FDTVRfTnpUQ0RSZGdiWF9aQnp5OWJYZWNvR3JEU29MRkdfaUV1ZGxpZElhN3lINjgxd3NUcG1mSEZNUTJKajZiT1EzVnhYdG1meXp5YWpqVFA0?oc=5","source_event_id":"evt_762719df07b6","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a9df9f067753bb20","published_at":"2026-04-11T18:22:16+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 three dividend stocks\u2019 names and ticker symbols are not provided.","No dividend yield, payout ratio, valuation metrics, or performance data are provided.","No timing/catalyst details are provided beyond the general phrase \u201ctoday\u2019s uncertain market.\u201d","No evidence from the article body is available to validate the recommendation claims."],"key_facts":["Headline states: \u201c3 Dividend Stocks That Are Obvious Buys in Today's Uncertain Market.\u201d","Source summary repeats the same headline text.","No article body content is provided, so no specific stocks or tickers are identifiable from the given text."],"numeric_claims":[],"primary_claim":"The Motley Fool published an article claiming that three dividend stocks are \u201cobvious buys\u201d in today\u2019s uncertain market.","relevance_score":0.25,"sentiment":"mixed","source_quality":"unknown","summary":"The provided headline indicates an article from The Motley Fool recommending three dividend stocks as \u201cobvious buys\u201d amid an uncertain market. No specific stock names, tickers, or dividend/price details are included in the provided text.","topics":["dividend stocks","market uncertainty","stock recommendations"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"3 Dividend Stocks That Are Obvious Buys in Today's Uncertain Market The Motley Fool","title":"3 Dividend Stocks That Are Obvious Buys in Today's Uncertain Market - 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_e4aef5815e8b in signals