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/CBMilwFBVV95cUxQSUpnSnFoTUt3TVBZUXpMNXNiVV9IV2JOU0h0SE9vdEtrRlBkWTZCVTdueGVlSkpnbXZzQWdPZFliMDUyU0k4NDNwell3NVlZSXR2RzVGaVQ1SkdqcC0xbk1mcm5hMkZBc0I2bWZyb0pERS12Y1ZKbzBCOV90SjAzMFNZWFBEMW9iQ2tiLXljc1JKcGFtajdZ?oc=5","as_of":"2026-04-08T19:34:52.105209+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/CBMilwFBVV95cUxQSUpnSnFoTUt3TVBZUXpMNXNiVV9IV2JOU0h0SE9vdEtrRlBkWTZCVTdueGVlSkpnbXZzQWdPZFliMDUyU0k4NDNwell3NVlZSXR2RzVGaVQ1SkdqcC0xbk1mcm5hMkZBc0I2bWZyb0pERS12Y1ZKbzBCOV90SjAzMFNZWFBEMW9iQ2tiLXljc1JKcGFtajdZ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2d3f40310a7c63d5","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-09T22:02:54.397658+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxQSUpnSnFoTUt3TVBZUXpMNXNiVV9IV2JOU0h0SE9vdEtrRlBkWTZCVTdueGVlSkpnbXZzQWdPZFliMDUyU0k4NDNwell3NVlZSXR2RzVGaVQ1SkdqcC0xbk1mcm5hMkZBc0I2bWZyb0pERS12Y1ZKbzBCOV90SjAzMFNZWFBEMW9iQ2tiLXljc1JKcGFtajdZ?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/CBMilwFBVV95cUxQSUpnSnFoTUt3TVBZUXpMNXNiVV9IV2JOU0h0SE9vdEtrRlBkWTZCVTdueGVlSkpnbXZzQWdPZFliMDUyU0k4NDNwell3NVlZSXR2RzVGaVQ1SkdqcC0xbk1mcm5hMkZBc0I2bWZyb0pERS12Y1ZKbzBCOV90SjAzMFNZWFBEMW9iQ2tiLXljc1JKcGFtajdZ?oc=5","source_event_id":"evt_f902798b52e7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ba75eec1f4b66342","published_at":"2026-04-08T18:22:42+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"The Motley Fool","relevance":"source of the headline/article","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The two tech stocks\u2019 company names and ticker symbols are not included in the provided text.","No rationale (e.g., earnings, growth, valuation, product, guidance) is provided in the extracted content.","No near-term catalyst timing (e.g., earnings date, product launch, regulatory decision) is provided.","No directional market impact (price action, analyst revisions, guidance changes) is stated in the provided text."],"key_facts":["A Motley Fool article headline states: \u201c2 Tech Stocks That Could Help Set You Up for Life.\u201d","The provided text does not include the names or ticker symbols of the two tech stocks.","The provided text does not include any financial metrics, catalysts, or timing details."],"numeric_claims":[],"primary_claim":"The Motley Fool published an article titled \u201c2 Tech Stocks That Could Help Set You Up for Life,\u201d claiming there are two tech stocks suitable for long-term setup.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article headline promotes two unspecified tech stocks as potential long-term investments. No stock tickers, company names, or market-impact details are present in the provided text.","topics":["tech stocks","long-term investing","stock picking"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"2 Tech Stocks That Could Help Set You Up for Life The Motley Fool","title":"2 Tech Stocks That Could Help Set You Up for Life - 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_a15586925cec in signals