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/CBMiqgFBVV95cUxOS2U3bmJSeG1UcWZwOTFJQmZ1U3lIalhYSDlnLXliRnVDeHc0T3hpcjJRWWJ4UllOUzZyNW1Ed3B3aXNPaHo5Nl8tWmM5QVF4UUxucXl5MmE4bVlJWGJ6SllWODRPV2RJdVRJODByb0tscDBWUjRDOTgtZ0hlbTdLdFdGa1ZrUFRabkFzcHNpaEp1V21lLThzM2t4STdMUDI5bDVtaTBHeUhRQQ?oc=5","as_of":"2026-04-09T12:52:06.070180+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/CBMiqgFBVV95cUxOS2U3bmJSeG1UcWZwOTFJQmZ1U3lIalhYSDlnLXliRnVDeHc0T3hpcjJRWWJ4UllOUzZyNW1Ed3B3aXNPaHo5Nl8tWmM5QVF4UUxucXl5MmE4bVlJWGJ6SllWODRPV2RJdVRJODByb0tscDBWUjRDOTgtZ0hlbTdLdFdGa1ZrUFRabkFzcHNpaEp1V21lLThzM2t4STdMUDI5bDVtaTBHeUhRQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_da3abf3e98650260","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:23:53.100586+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxOS2U3bmJSeG1UcWZwOTFJQmZ1U3lIalhYSDlnLXliRnVDeHc0T3hpcjJRWWJ4UllOUzZyNW1Ed3B3aXNPaHo5Nl8tWmM5QVF4UUxucXl5MmE4bVlJWGJ6SllWODRPV2RJdVRJODByb0tscDBWUjRDOTgtZ0hlbTdLdFdGa1ZrUFRabkFzcHNpaEp1V21lLThzM2t4STdMUDI5bDVtaTBHeUhRQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"stockstory.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxOS2U3bmJSeG1UcWZwOTFJQmZ1U3lIalhYSDlnLXliRnVDeHc0T3hpcjJRWWJ4UllOUzZyNW1Ed3B3aXNPaHo5Nl8tWmM5QVF4UUxucXl5MmE4bVlJWGJ6SllWODRPV2RJdVRJODByb0tscDBWUjRDOTgtZ0hlbTdLdFdGa1ZrUFRabkFzcHNpaEp1V21lLThzM2t4STdMUDI5bDVtaTBHeUhRQQ?oc=5","source_event_id":"evt_f7785839307f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4879f52593f71d90","published_at":"2026-04-09T08:53:06+00:00","publisher_domain":"stockstory.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Stryker","relevance":"high","symbol":"SYK","type":"company"},{"asset_class":"other","name":"StockStory","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The actual recommendation (buy/sell/hold) is not included in the provided text.","No Q4 earnings figures, guidance, or qualitative drivers are provided.","No timing details (e.g., when the recommendation is expected to impact the stock) are included beyond \u201cpost Q4 earnings.\u201d","No market reaction or price action is included in the provided text."],"key_facts":["Headline asks whether to buy, sell, or hold Stryker (SYK) after Q4 earnings.","The provided text includes only the headline and a matching source summary; it does not include the article\u2019s recommendation or supporting details."],"numeric_claims":[],"primary_claim":"StockStory published an article titled \u201cStryker (SYK): Buy, Sell, or Hold Post Q4 Earnings?\u201d","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The article headline discusses a post\u2013Q4 earnings investment stance for Stryker (SYK), asking whether to buy, sell, or hold. No additional Q4 results or rationale are present in the provided text.","topics":["earnings","investment rating","stock recommendation","Stryker"]},"source":"StockStory","source_domain":"stockstory.org","source_url":"https://stockstory.org","summary":"Stryker (SYK): Buy, Sell, or Hold Post Q4 Earnings? StockStory","title":"Stryker (SYK): Buy, Sell, or Hold Post Q4 Earnings? - StockStory","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_0c1446ce5629 in signals