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/CBMimAFBVV95cUxOcy1WVklPLW8teTJ2b0Zrd3dRY2FBYnV0dFYtbUUwNV9qcEpieUFIQXFaUHMycS15cEVVcGJoNXdHOHU1MW9xYXVLcWdsbHJoQVFrUm9WLVR5V3NEQ3hCbG1PSng5MGhSbnVPSi1ncTR6UHllMUxpMjlWVGI5T2ZRdEJURUxkcVdxVUt5NFY1ZXlfNXFMZUgxOA?oc=5","as_of":"2026-04-09T12:52:04.630213+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/CBMimAFBVV95cUxOcy1WVklPLW8teTJ2b0Zrd3dRY2FBYnV0dFYtbUUwNV9qcEpieUFIQXFaUHMycS15cEVVcGJoNXdHOHU1MW9xYXVLcWdsbHJoQVFrUm9WLVR5V3NEQ3hCbG1PSng5MGhSbnVPSi1ncTR6UHllMUxpMjlWVGI5T2ZRdEJURUxkcVdxVUt5NFY1ZXlfNXFMZUgxOA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1375532285dc5abf","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-09T23:19:58.961458+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxOcy1WVklPLW8teTJ2b0Zrd3dRY2FBYnV0dFYtbUUwNV9qcEpieUFIQXFaUHMycS15cEVVcGJoNXdHOHU1MW9xYXVLcWdsbHJoQVFrUm9WLVR5V3NEQ3hCbG1PSng5MGhSbnVPSi1ncTR6UHllMUxpMjlWVGI5T2ZRdEJURUxkcVdxVUt5NFY1ZXlfNXFMZUgxOA?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/CBMimAFBVV95cUxOcy1WVklPLW8teTJ2b0Zrd3dRY2FBYnV0dFYtbUUwNV9qcEpieUFIQXFaUHMycS15cEVVcGJoNXdHOHU1MW9xYXVLcWdsbHJoQVFrUm9WLVR5V3NEQ3hCbG1PSng5MGhSbnVPSi1ncTR6UHllMUxpMjlWVGI5T2ZRdEJURUxkcVdxVUt5NFY1ZXlfNXFMZUgxOA?oc=5","source_event_id":"evt_18191584682e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5a913edb6c526f38","published_at":"2026-04-09T12:33:34+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity_etf","name":"Vanguard S&P 500 ETF","relevance":"high","symbol":"","type":"etf"},{"asset_class":"equity_etf","name":"Vanguard Total Stock Market ETF","relevance":"high","symbol":"","type":"etf"},{"asset_class":"media","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No article body text was provided, so the specific conclusion (which ETF is favored) and the reasoning are unknown.","No ETF ticker symbols (e.g., fund tickers) are present in the provided text.","No details are provided about methodology, metrics (e.g., fees, diversification, historical drawdowns), or time horizon."],"key_facts":["Headline states a comparison: \u201cVanguard S&P 500 ETF vs. Vanguard Total Stock Market ETF.\u201d","Headline asks which ETF is \u201cmore likely to survive a Stock Market Crash or Recession.\u201d"],"numeric_claims":[],"primary_claim":"The article poses a comparison between the Vanguard S&P 500 ETF and the Vanguard Total Stock Market ETF regarding which is more likely to survive a stock market crash or recession.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The Motley Fool headline compares two Vanguard ETFs and frames the question of which is more likely to withstand a stock market crash or recession.","topics":["ETF comparison","market crash resilience","recession risk","U.S. equity index funds"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Vanguard S&P 500 ETF vs. Vanguard Total Stock Market ETF: Which Is More Likely to Survive a Stock Market Crash or Recession? - 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_8e25cc3e7450 in signals