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-09T09:54:21.355272+00:00","dedupe_key":"signal_enriched:news_delta:b054506e0c912b6b","evidence_event_ids":["evt_86469ca4e846"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQdmFwZVV2ZjRpVXdBNF93ekVpOVpjbzZadVhtanRwN1piWVhRRkxhVjY5OEItX29UX0ZBQjRrdzNlQWhWX25qZFJBejFTTXVCb3lBSENMa3Z0NkJwakVPVEgxVDVuRFBkSDlVNFZBMHZtUW93aENodGtfNzJPeG02cWRIaDc?oc=5","as_of":"2026-04-09T09:54:21.355272+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/CBMihAFBVV95cUxQdmFwZVV2ZjRpVXdBNF93ekVpOVpjbzZadVhtanRwN1piWVhRRkxhVjY5OEItX29UX0ZBQjRrdzNlQWhWX25qZFJBejFTTXVCb3lBSENMa3Z0NkJwakVPVEgxVDVuRFBkSDlVNFZBMHZtUW93aENodGtfNzJPeG02cWRIaDc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_186034cdb2e3a436","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:02:12.232465+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQdmFwZVV2ZjRpVXdBNF93ekVpOVpjbzZadVhtanRwN1piWVhRRkxhVjY5OEItX29UX0ZBQjRrdzNlQWhWX25qZFJBejFTTXVCb3lBSENMa3Z0NkJwakVPVEgxVDVuRFBkSDlVNFZBMHZtUW93aENodGtfNzJPeG02cWRIaDc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQdmFwZVV2ZjRpVXdBNF93ekVpOVpjbzZadVhtanRwN1piWVhRRkxhVjY5OEItX29UX0ZBQjRrdzNlQWhWX25qZFJBejFTTXVCb3lBSENMa3Z0NkJwakVPVEgxVDVuRFBkSDlVNFZBMHZtUW93aENodGtfNzJPeG02cWRIaDc?oc=5","source_event_id":"evt_86469ca4e846","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"94e6e885df5f0e02","published_at":"2026-04-09T09:02:27+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The New York Times","relevance":"primary source","symbol":"","type":"publisher"},{"asset_class":"equities/financial markets","name":"Markets","relevance":"subject of claim","symbol":"","type":"market"}],"event_type":"price_action","information_gaps":["No specific indices (e.g., S&P 500, Nasdaq), asset classes, or tickers are mentioned.","No timeframe beyond \u201ca year\u201d is specified (exact dates not provided).","No quantitative performance figures (returns, drawdowns, volatility) are included in the provided text.","No causal explanation or drivers of performance are included in the provided text.","The article body content is not available beyond page styling/HTML artifacts, limiting extraction to the headline/summary only."],"key_facts":["Headline states: \u201cMarkets Have Faced a Year of Chaos and Still Done Awfully Well.\u201d","The provided source summary repeats the same headline text."],"numeric_claims":[],"primary_claim":"Markets have faced a year of chaos yet still performed \u201cawfully well,\u201d according to The New York Times.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The New York Times argues that despite a year described as chaotic, markets have performed \u201cawfully well.\u201d No specific market index, asset, or mechanism is stated in the provided text.","topics":["market performance","volatility/chaos","financial markets","performance resilience"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Markets Have Faced a Year of Chaos and Still Done Awfully Well The New York Times","title":"Markets Have Faced a Year of Chaos and Still Done Awfully Well - The New York Times","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 9561 in events