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/CBMihwFBVV95cUxQYkdtODhCWk54LVp3dmljcTJVNDFNU0NhNUFOamloUWxXN0JXYjJLcWxZU05mTXVic2FRVVV0RENadGxHcks4UXF3TFM0TUlPUkI0dDRJZElXNTg0enB4VWZxSVV5SjRYZDF1UmRDTWFEMUFqOFYxcmx0LUEycXNkYURUc3lxR2c?oc=5","as_of":"2026-04-10T19:36:11.745819+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/CBMihwFBVV95cUxQYkdtODhCWk54LVp3dmljcTJVNDFNU0NhNUFOamloUWxXN0JXYjJLcWxZU05mTXVic2FRVVV0RENadGxHcks4UXF3TFM0TUlPUkI0dDRJZElXNTg0enB4VWZxSVV5SjRYZDF1UmRDTWFEMUFqOFYxcmx0LUEycXNkYURUc3lxR2c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b895be1c7e3e4e65","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-10T19:59:50.352387+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQYkdtODhCWk54LVp3dmljcTJVNDFNU0NhNUFOamloUWxXN0JXYjJLcWxZU05mTXVic2FRVVV0RENadGxHcks4UXF3TFM0TUlPUkI0dDRJZElXNTg0enB4VWZxSVV5SjRYZDF1UmRDTWFEMUFqOFYxcmx0LUEycXNkYURUc3lxR2c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ca.finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxQYkdtODhCWk54LVp3dmljcTJVNDFNU0NhNUFOamloUWxXN0JXYjJLcWxZU05mTXVic2FRVVV0RENadGxHcks4UXF3TFM0TUlPUkI0dDRJZElXNTg0enB4VWZxSVV5SjRYZDF1UmRDTWFEMUFqOFYxcmx0LUEycXNkYURUc3lxR2c?oc=5","source_event_id":"evt_ab5306720dcf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"99b2d8b7f8596ac0","published_at":"2026-04-10T19:02:44+00:00","publisher_domain":"ca.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Yahoo! Finance Canada","relevance":"source of the headline/article","symbol":"","type":"publisher"},{"asset_class":"equities","name":"Restaurant stocks (unspecified)","relevance":"the subject of the \u201cavoid\u201d recommendation","symbol":"","type":"asset_group"}],"event_type":"other","information_gaps":["The three specific restaurant stocks (company names and ticker symbols) are not present in the provided text.","The article\u2019s rationale (e.g., valuation, earnings risk, leverage, guidance) is not included in the provided text.","No timing/catalyst information is provided beyond the existence of the article."],"key_facts":["Headline states: \u201c3 Restaurant Stocks We Steer Clear Of - Yahoo! Finance Canada.\u201d","No specific stock tickers or company names are included in the provided text."],"numeric_claims":[],"primary_claim":"The article identifies three restaurant stocks that Yahoo! Finance Canada recommends investors avoid.","relevance_score":0.35,"sentiment":"negative","source_quality":"high","summary":"Yahoo! Finance Canada published an article titled \u201c3 Restaurant Stocks We Steer Clear Of,\u201d indicating three restaurant-related stocks the publication advises avoiding.","topics":["restaurant industry","stock selection","avoidance/negative screening"]},"source":"Yahoo! Finance Canada","source_domain":"ca.finance.yahoo.com","source_url":"https://ca.finance.yahoo.com","summary":"3 Restaurant Stocks We Steer Clear Of Yahoo! Finance Canada","title":"3 Restaurant Stocks We Steer Clear Of - Yahoo! Finance Canada","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_5bda0177cd7c in signals