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-11T07:33:20.077800+00:00","dedupe_key":"signal_enriched:market_headline_delta:1dc58e2011af31c1","evidence_event_ids":["evt_cf4bb8095e0b"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQd1pkVHlwSFVCdHlMXzZwalNhSk9XVWhSTHZnTS1nSWNZWjQzdGt2Z2txVklHeEF1a19jMkc4LUFabHFPdExuYTlhdmZxM1lhbzh0MFBBbkRUd3NjdGRDWG13NUlzbGJLWjQwcHJtSGd6RGV0MEhOZ3JpUXR0Ry1JMjFMVkQ?oc=5","as_of":"2026-04-11T07:33:20.077800+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/CBMihAFBVV95cUxQd1pkVHlwSFVCdHlMXzZwalNhSk9XVWhSTHZnTS1nSWNZWjQzdGt2Z2txVklHeEF1a19jMkc4LUFabHFPdExuYTlhdmZxM1lhbzh0MFBBbkRUd3NjdGRDWG13NUlzbGJLWjQwcHJtSGd6RGV0MEhOZ3JpUXR0Ry1JMjFMVkQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b8892172d2c57e42","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-11T15:04:34.404140+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQd1pkVHlwSFVCdHlMXzZwalNhSk9XVWhSTHZnTS1nSWNZWjQzdGt2Z2txVklHeEF1a19jMkc4LUFabHFPdExuYTlhdmZxM1lhbzh0MFBBbkRUd3NjdGRDWG13NUlzbGJLWjQwcHJtSGd6RGV0MEhOZ3JpUXR0Ry1JMjFMVkQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ft.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQd1pkVHlwSFVCdHlMXzZwalNhSk9XVWhSTHZnTS1nSWNZWjQzdGt2Z2txVklHeEF1a19jMkc4LUFabHFPdExuYTlhdmZxM1lhbzh0MFBBbkRUd3NjdGRDWG13NUlzbGJLWjQwcHJtSGd6RGV0MEhOZ3JpUXR0Ry1JMjFMVkQ?oc=5","source_event_id":"evt_cf4bb8095e0b","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a4a87e739d059948","published_at":"2026-04-11T04:01:57+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"UK retail investors","relevance":"high","symbol":"","type":"investor_group"},{"asset_class":"retail_investing","name":"ISA season","relevance":"high","symbol":"","type":"market_period"}],"event_type":"price_action","information_gaps":["No article text provided, so no details on which stock market index/market segment is referenced.","No specific tickers or asset symbols are mentioned in the provided text.","No quantitative data (flows, performance, percentages) is included in the provided text.","No timeframe for \u201cISA season\u201d or the \u201cfalling stock market\u201d is specified beyond the headline context."],"key_facts":["Financial Times headline states that \u201cISA season flops.\u201d","Headline attributes the flop to UK retail investors shunning the falling stock market."],"numeric_claims":[],"primary_claim":"UK retail investors are shunning the falling stock market during ISA season, causing ISA season to \u201cflop.\u201d","relevance_score":0.45,"sentiment":"negative","source_quality":"unknown","summary":"The Financial Times headline claims that UK retail investors are shunning the falling stock market during the ISA season, implying weak demand for UK equities via ISAs.","topics":["UK retail investors","ISA season","falling stock market","equity demand"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"","tickers":[],"title":"Isa season flops as UK retail investors shun falling stock market - Financial 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 23424 in events