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-07T23:23:38.541173+00:00","dedupe_key":"signal_enriched:news_delta:17f2c5b2978ac9a0","evidence_event_ids":["evt_c5496c6c0ed9"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPdEtYVUhfTjJEc1lDcmVHZlhhY3FTaEJjS1FDV3pGZ29MR21RSnFKNEF5VXVwX2RiQTVIMWxyb0pTZExuU1lnR3Z1b19uQU1Sem5DUER3UGVhR2N3UHk5dnZ2U3ZHZzdQQnJfbkxWNkFSOF9vbFBZNkhaZVJ3TGFBN0tzXzJmTWlScDluY2VRTGZaNjVRUXFDUDcwamNQNEV0M0xzV1pYNFZBOTY3TGsyZA?oc=5","as_of":"2026-04-07T23:23:38.541173+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/CBMisAFBVV95cUxPdEtYVUhfTjJEc1lDcmVHZlhhY3FTaEJjS1FDV3pGZ29MR21RSnFKNEF5VXVwX2RiQTVIMWxyb0pTZExuU1lnR3Z1b19uQU1Sem5DUER3UGVhR2N3UHk5dnZ2U3ZHZzdQQnJfbkxWNkFSOF9vbFBZNkhaZVJ3TGFBN0tzXzJmTWlScDluY2VRTGZaNjVRUXFDUDcwamNQNEV0M0xzV1pYNFZBOTY3TGsyZA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_82304d7d263aa32d","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-08T00:34:12.640425+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPdEtYVUhfTjJEc1lDcmVHZlhhY3FTaEJjS1FDV3pGZ29MR21RSnFKNEF5VXVwX2RiQTVIMWxyb0pTZExuU1lnR3Z1b19uQU1Sem5DUER3UGVhR2N3UHk5dnZ2U3ZHZzdQQnJfbkxWNkFSOF9vbFBZNkhaZVJ3TGFBN0tzXzJmTWlScDluY2VRTGZaNjVRUXFDUDcwamNQNEV0M0xzV1pYNFZBOTY3TGsyZA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisAFBVV95cUxPdEtYVUhfTjJEc1lDcmVHZlhhY3FTaEJjS1FDV3pGZ29MR21RSnFKNEF5VXVwX2RiQTVIMWxyb0pTZExuU1lnR3Z1b19uQU1Sem5DUER3UGVhR2N3UHk5dnZ2U3ZHZzdQQnJfbkxWNkFSOF9vbFBZNkhaZVJ3TGFBN0tzXzJmTWlScDluY2VRTGZaNjVRUXFDUDcwamNQNEV0M0xzV1pYNFZBOTY3TGsyZA?oc=5","source_event_id":"evt_c5496c6c0ed9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3e01d95f0d47b626","published_at":"2026-04-07T20:08:51+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["September"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"other","name":"Bloomberg","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Nikkei Asia","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"China patent battle","relevance":"medium","symbol":"","type":"legal/regulatory dispute"}],"event_type":"price_action","information_gaps":["The cleaned article text does not include the actual Bloomberg article content; only the headline and external source-summary snippets are available.","No specific date for the September debut beyond the month is provided.","No quantified delay duration, engineering issue details, or shipment timing window is included in the provided text.","The nature/outcome/timeline of the China patent battle is not specified here.","The magnitude of the AAPL move is only described qualitatively in the summary (e.g., \u201cdrops 5%\u201d is mentioned in the source summary but not confirmed within the provided Bloomberg text)."],"key_facts":["Bloomberg headline states Apple\u2019s foldable iPhone remains on track for a September debut (AAPL).","The provided source summary indicates foldable iPhone engineering snags and possible shipment delays (attributed to sources).","The provided source summary indicates Apple shares sank/dropped in response to the foldable iPhone delay report.","The provided source summary also references a China patent battle as part of the market narrative."],"numeric_claims":[],"primary_claim":"Apple\u2019s foldable iPhone remains on track for a September debut, though engineering snags could cause shipment delays.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Bloomberg reports Apple\u2019s foldable iPhone is still on track for a September debut, despite engineering snags that could lead to shipment delays. The same news cycle also coincides with Apple shares falling on the delay report and mentions a China patent battle.","topics":["foldable iPhone","product launch timeline","engineering snags","shipment delays","AAPL share price reaction","China patent battle"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Apple\u2019s Foldable iPhone Remains on Track for September Debut (AAPL) Bloomberg.com Foldable iPhone hits engineering snags, shipment delays possible: sources Nikkei Asia Apple shares sink on report of foldable iPhone delays CNBC iPhone Fold dimensions: Here\u2019s how the foldable iPhone sizes up next to the iPhone 18 Pro 9to5mac.com Apple Drops 5% as Foldable iPhone Delays and China Patent Battle Rattle Investor Confidence Yahoo Finance","title":"Apple\u2019s Foldable iPhone Remains on Track for September Debut (AAPL) - Bloomberg.com","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 2253 in events