SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T11:22:55.121255+00:00","dedupe_key":"signal_enriched:news_delta:e07687249ba0207c","evidence_event_ids":["evt_f5e787a92d77"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 9799 in events