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-08T02:16:57.800905+00:00","dedupe_key":"signal_enriched:market_headline_delta:23c9a01671ba7cea","evidence_event_ids":["evt_8275f6b25e4e"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNS2lfbVJ4UmpVOHFIaUc4eVhZdnRWcnU3cC1JYUJPRlFVTGNON3REVmdpeHFBM3BtU0g2cFpuM1haUVl6dURkU2VWYXV1RW5pWXVreFdyYVZkWDFoYXNUdllYbHFWa0lKUVk2VllhaWhJU1RNcUxsUEk4WjI3eldfdXdwbHdZdExLSWh6VDRrZkpvSjJhR2JOLUxrTlhEQUMwUlVKXzNPNWExSTk5Ti1nbHVOemdGSGFBWGRKYmQ1THBCVm44b0dMZFRR?oc=5","as_of":"2026-04-08T02:16:57.800905+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNS2lfbVJ4UmpVOHFIaUc4eVhZdnRWcnU3cC1JYUJPRlFVTGNON3REVmdpeHFBM3BtU0g2cFpuM1haUVl6dURkU2VWYXV1RW5pWXVreFdyYVZkWDFoYXNUdllYbHFWa0lKUVk2VllhaWhJU1RNcUxsUEk4WjI3eldfdXdwbHdZdExLSWh6VDRrZkpvSjJhR2JOLUxrTlhEQUMwUlVKXzNPNWExSTk5Ti1nbHVOemdGSGFBWGRKYmQ1THBCVm44b0dMZFRR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3392da577be0a1fb","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T02:17:32.930079+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNS2lfbVJ4UmpVOHFIaUc4eVhZdnRWcnU3cC1JYUJPRlFVTGNON3REVmdpeHFBM3BtU0g2cFpuM1haUVl6dURkU2VWYXV1RW5pWXVreFdyYVZkWDFoYXNUdllYbHFWa0lKUVk2VllhaWhJU1RNcUxsUEk4WjI3eldfdXdwbHdZdExLSWh6VDRrZkpvSjJhR2JOLUxrTlhEQUMwUlVKXzNPNWExSTk5Ti1nbHVOemdGSGFBWGRKYmQ1THBCVm44b0dMZFRR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNS2lfbVJ4UmpVOHFIaUc4eVhZdnRWcnU3cC1JYUJPRlFVTGNON3REVmdpeHFBM3BtU0g2cFpuM1haUVl6dURkU2VWYXV1RW5pWXVreFdyYVZkWDFoYXNUdllYbHFWa0lKUVk2VllhaWhJU1RNcUxsUEk4WjI3eldfdXdwbHdZdExLSWh6VDRrZkpvSjJhR2JOLUxrTlhEQUMwUlVKXzNPNWExSTk5Ti1nbHVOemdGSGFBWGRKYmQ1THBCVm44b0dMZFRR?oc=5","source_event_id":"evt_8275f6b25e4e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"58e260778e2b41e6","published_at":"2026-04-07T22:17:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["April 7"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"index","name":"Stock market (overall)","relevance":"medium","symbol":"","type":"market"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond page styling/HTML, so the magnitude of Apple\u2019s move (percent/points) and the specific index/market benchmark described as \"muted\" are not available.","No additional drivers (earnings, guidance, macro data, news catalyst) are included in the provided text.","No confirmation of whether the move is intraday vs. close is available from the provided content."],"key_facts":["Headline states: \"Stock Market Today, April 7: Apple Slides Against Muted Market Backdrop\".","The claim explicitly links Apple\u2019s decline to a \"muted market backdrop\" on April 7."],"numeric_claims":[],"primary_claim":"Apple slides on April 7 against a muted market backdrop.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"On April 7, Apple was reported to be declining while the broader market was described as muted.","topics":["equities","stock market","Apple","market sentiment"]},"source":"fool.com","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Stock Market Today, April 7: Apple Slides Against Muted Market Backdrop - fool.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 3482 in events