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/CBMiwgFBVV95cUxPa0ZHVVlUZVU4SG56VTZ6bXRxRWxPcUxqOUEyVmV6eGlEMnR0YkxveTBYLUt6UWZDQWVYbkVEQTBxT1c1enBkZnNzNnBBdEp1bzZtcFdmY1VNVThaWkw3dTJ0NVlmWm15cXRKZjZjZ2ZHb3J3S0Zfd244SW9fX1Q2MkNVRDhSVEdWN2xPdVJqUEE3VGtOQUdiOVVWbms1SkpVbE5ZNVdOWE9odWtKRjVvU21hNXoyLXFSdmZvQVNXTENjQQ?oc=5","as_of":"2026-04-09T11:22:55.121255+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/CBMiwgFBVV95cUxPa0ZHVVlUZVU4SG56VTZ6bXRxRWxPcUxqOUEyVmV6eGlEMnR0YkxveTBYLUt6UWZDQWVYbkVEQTBxT1c1enBkZnNzNnBBdEp1bzZtcFdmY1VNVThaWkw3dTJ0NVlmWm15cXRKZjZjZ2ZHb3J3S0Zfd244SW9fX1Q2MkNVRDhSVEdWN2xPdVJqUEE3VGtOQUdiOVVWbms1SkpVbE5ZNVdOWE9odWtKRjVvU21hNXoyLXFSdmZvQVNXTENjQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9cd0335e53bc640b","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:14:55.027189+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxPa0ZHVVlUZVU4SG56VTZ6bXRxRWxPcUxqOUEyVmV6eGlEMnR0YkxveTBYLUt6UWZDQWVYbkVEQTBxT1c1enBkZnNzNnBBdEp1bzZtcFdmY1VNVThaWkw3dTJ0NVlmWm15cXRKZjZjZ2ZHb3J3S0Zfd244SW9fX1Q2MkNVRDhSVEdWN2xPdVJqUEE3VGtOQUdiOVVWbms1SkpVbE5ZNVdOWE9odWtKRjVvU21hNXoyLXFSdmZvQVNXTENjQQ?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/CBMiwgFBVV95cUxPa0ZHVVlUZVU4SG56VTZ6bXRxRWxPcUxqOUEyVmV6eGlEMnR0YkxveTBYLUt6UWZDQWVYbkVEQTBxT1c1enBkZnNzNnBBdEp1bzZtcFdmY1VNVThaWkw3dTJ0NVlmWm15cXRKZjZjZ2ZHb3J3S0Zfd244SW9fX1Q2MkNVRDhSVEdWN2xPdVJqUEE3VGtOQUdiOVVWbms1SkpVbE5ZNVdOWE9odWtKRjVvU21hNXoyLXFSdmZvQVNXTENjQQ?oc=5","source_event_id":"evt_f5e787a92d77","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4c96c4a4f1d525e0","published_at":"2026-04-09T08:47:02+00:00","publisher_domain":"stockstory.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"BWX (BWX Technologies)","relevance":"high","symbol":"BWXT","type":"company"},{"asset_class":"other","name":"StockStory","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The provided text contains only the headline and a generic cleaned HTML snippet; it does not include the article\u2019s actual earnings content.","No Q4 metrics (revenue, EPS, margins), management commentary, or forward guidance are provided.","No information is given about stock performance (e.g., reaction on earnings date) or analyst revisions.","The term \u201cBWX (NYSE:BWXT)\u201d is used, but the text does not explicitly state the company\u2019s full name beyond the ticker context."],"key_facts":["Headline indicates the piece is about defense contractor stocks\u2019 Q4 earnings.","The company explicitly mentioned is BWX (NYSE:BWXT).","No numeric earnings figures, guidance, or stock price movement are included in the provided text."],"numeric_claims":[],"primary_claim":"StockStory published an article reflecting on defense contractors\u2019 Q4 earnings with a focus on BWX (NYSE:BWXT).","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The article is a reflection/review of defense contractor stocks\u2019 Q4 earnings, specifically focusing on BWX (BWX Technologies, NYSE:BWXT). No additional Q4 results or market reaction details are present in the provided text.","topics":["Q4 earnings","defense contractors","BWX Technologies","stock analysis"]},"source":"StockStory","source_domain":"stockstory.org","source_url":"https://stockstory.org","summary":"Reflecting On Defense Contractors Stocks\u2019 Q4 Earnings: BWX (NYSE:BWXT) StockStory","title":"Reflecting On Defense Contractors Stocks\u2019 Q4 Earnings: BWX (NYSE:BWXT) - 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_58175c9ecabc in signals