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-09T13:30:33.057507+00:00","dedupe_key":"signal_enriched:news_delta:b7f7a9c6ab620f6b","evidence_event_ids":["evt_0cb0e4fdec37"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQZlU0XzItMTUzTUZjeUNFYTFLQUVEcmZLbW8zUDEydUZGSWkyS1NuMHROd3I4QVhQU1hRRU1mbHFMUE5abHJyeEZtZ3Npbkk4RTdLSk4xbnBfSWRpMXVrNElDSF9mQWFYWHhPQWFyamdCX3ZTN3gtNU9Ta0tSNG5sUTg5R3l0TzFrX2ZvT1NKMkU1N0JHVFVUajYwSDBjdUFOWFZ3UWlpSQ?oc=5","as_of":"2026-04-09T13:30:33.057507+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/CBMipwFBVV95cUxQZlU0XzItMTUzTUZjeUNFYTFLQUVEcmZLbW8zUDEydUZGSWkyS1NuMHROd3I4QVhQU1hRRU1mbHFMUE5abHJyeEZtZ3Npbkk4RTdLSk4xbnBfSWRpMXVrNElDSF9mQWFYWHhPQWFyamdCX3ZTN3gtNU9Ta0tSNG5sUTg5R3l0TzFrX2ZvT1NKMkU1N0JHVFVUajYwSDBjdUFOWFZ3UWlpSQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2118b55cc298bdc3","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:31:19.942849+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQZlU0XzItMTUzTUZjeUNFYTFLQUVEcmZLbW8zUDEydUZGSWkyS1NuMHROd3I4QVhQU1hRRU1mbHFMUE5abHJyeEZtZ3Npbkk4RTdLSk4xbnBfSWRpMXVrNElDSF9mQWFYWHhPQWFyamdCX3ZTN3gtNU9Ta0tSNG5sUTg5R3l0TzFrX2ZvT1NKMkU1N0JHVFVUajYwSDBjdUFOWFZ3UWlpSQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"phonearena.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxQZlU0XzItMTUzTUZjeUNFYTFLQUVEcmZLbW8zUDEydUZGSWkyS1NuMHROd3I4QVhQU1hRRU1mbHFMUE5abHJyeEZtZ3Npbkk4RTdLSk4xbnBfSWRpMXVrNElDSF9mQWFYWHhPQWFyamdCX3ZTN3gtNU9Ta0tSNG5sUTg5R3l0TzFrX2ZvT1NKMkU1N0JHVFVUajYwSDBjdUFOWFZ3UWlpSQ?oc=5","source_event_id":"evt_0cb0e4fdec37","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"384b29e9918e5ac4","published_at":"2026-04-09T02:40:20+00:00","publisher_domain":"phonearena.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["September"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"consumer_electronics","name":"iPhone Fold","relevance":"high","symbol":"","type":"product"},{"asset_class":"media","name":"PhoneArena","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The excerpt does not include the actual leaked-photo details beyond the qualitative claim (\u201chorrible\u201d).","No specific evidence/technical reasons for the \u201chorrible\u201d assessment are provided in the excerpt.","The excerpt does not provide the magnitude of Apple\u2019s stock move (percent/price) or the exact timing of the market reaction.","The excerpt does not confirm whether the dummies/photos are authentic or final hardware versus prototypes.","The excerpt does not specify the nature of the reported delay (which milestone slipped, by how long, and by whom)."],"key_facts":["PhoneArena headline states Apple\u2019s iPhone Fold dummies look \u201chorrible\u201d in leaked photos.","The provided source summary references multiple outlets discussing foldable iPhone launch timing (e.g., September debut expectations and reports of delays).","The provided source summary also references Apple shares moving/declining in connection with foldable-iPhone delay reports (directional stock impact mentioned, but exact figures/timing not included in the excerpt)."],"numeric_claims":[],"primary_claim":"Leaked photos show Apple\u2019s iPhone Fold dummies that PhoneArena says look \u201chorrible.\u201d","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"PhoneArena reports leaked photos of Apple\u2019s purported iPhone Fold dummies, claiming they look poor. The broader coverage referenced in the source summary also ties foldable-iPhone timing concerns to Apple\u2019s stock volatility.","topics":["leaked photos","foldable iPhone","iPhone Fold dummies","product appearance","launch timing","Apple stock reaction"]},"source":"PhoneArena","source_domain":"phonearena.com","source_url":"https://www.phonearena.com","summary":"Apple\u2019s iPhone Fold dummies look horrible in these leaked photos PhoneArena Apple\u2019s Foldable iPhone Remains on Track for September Debut (AAPL) Bloomberg.com Apple\u2019s stock pares losses. Here\u2019s how to think about the latest saga with foldable iPhones. MarketWatch Apple shares sink on report of foldable iPhone delays CNBC Apple's iPhone Fold launch might happen later than we thought. Here\u2019s why. Mashable","title":"Apple\u2019s iPhone Fold dummies look horrible in these leaked photos - PhoneArena","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 10141 in events