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-12T07:35:05.814929+00:00","dedupe_key":"signal_enriched:news_delta:0dda9193767dd0f6","evidence_event_ids":["evt_4ebcd6ce8e43"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNSE85Q05RaDlfWGpaUUxTRjJONC11VTBWaGZTUzN3c0preW9KN1UwOUJvbE83TlNQLUJwdEFGbVZzWnBLdENYdndRWEFpVHRIR2FnZUx0RGx2Nmt0Y0xQUnFFWm1xUEtUcVd6YTNKUnpDcDU0S2FvZlNIN3RPOFVnVENoZXBLVUNtN0RyeTVB?oc=5","as_of":"2026-04-12T07:35:05.814929+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/CBMijgFBVV95cUxNSE85Q05RaDlfWGpaUUxTRjJONC11VTBWaGZTUzN3c0preW9KN1UwOUJvbE83TlNQLUJwdEFGbVZzWnBLdENYdndRWEFpVHRIR2FnZUx0RGx2Nmt0Y0xQUnFFWm1xUEtUcVd6YTNKUnpDcDU0S2FvZlNIN3RPOFVnVENoZXBLVUNtN0RyeTVB?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3471fce3745e1255","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-12T07:35:16.162004+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNSE85Q05RaDlfWGpaUUxTRjJONC11VTBWaGZTUzN3c0preW9KN1UwOUJvbE83TlNQLUJwdEFGbVZzWnBLdENYdndRWEFpVHRIR2FnZUx0RGx2Nmt0Y0xQUnFFWm1xUEtUcVd6YTNKUnpDcDU0S2FvZlNIN3RPOFVnVENoZXBLVUNtN0RyeTVB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"uk.finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNSE85Q05RaDlfWGpaUUxTRjJONC11VTBWaGZTUzN3c0preW9KN1UwOUJvbE83TlNQLUJwdEFGbVZzWnBLdENYdndRWEFpVHRIR2FnZUx0RGx2Nmt0Y0xQUnFFWm1xUEtUcVd6YTNKUnpDcDU0S2FvZlNIN3RPOFVnVENoZXBLVUNtN0RyeTVB?oc=5","source_event_id":"evt_4ebcd6ce8e43","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"c8679700d8bc71e6","published_at":"2026-04-12T07:10:06+00:00","publisher_domain":"uk.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.35,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Apple Hospitality REIT","relevance":"high","symbol":"APLE","type":"company"},{"asset_class":"other","name":"Yahoo Finance UK","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["No article body text is available, so the specific nature of the \u201cupgraded earnings views\u201d (who upgraded, when, and what changes) is unknown.","No quantitative details (targets, estimates, revisions, guidance, or valuation metrics) are provided.","No explicit confirmation is given that the value story has actually changed\u2014only a framing question in the headline."],"key_facts":["Headline asks whether APLE\u2019s upgraded earnings views are changing Apple Hospitality REIT\u2019s value story.","No supporting article text, figures, or specific upgrades are included in the provided input."],"numeric_claims":[],"primary_claim":"Yahoo Finance UK is framing a question that APLE\u2019s upgraded earnings views could be rewriting Apple Hospitality REIT\u2019s value story.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"The Yahoo Finance UK headline suggests that upgraded earnings views for APLE may be changing how investors view the value of Apple Hospitality REIT (APLE). No article details are provided to confirm what was upgraded or the magnitude of any impact.","topics":["earnings outlook","valuation narrative","investor expectations"]},"source":"Yahoo Finance UK","source_domain":"uk.finance.yahoo.com","source_url":"https://uk.finance.yahoo.com","summary":"Are APLE\u2019s Upgraded Earnings Views Quietly Rewriting Apple Hospitality REIT\u2019s Value Story? Yahoo Finance UK","title":"Are APLE\u2019s Upgraded Earnings Views Quietly Rewriting Apple Hospitality REIT\u2019s Value Story? - Yahoo Finance UK","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 28110 in events