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-10T07:34:03.630095+00:00","dedupe_key":"signal_enriched:news_delta:6abb35f6c8284d22","evidence_event_ids":["evt_ab7ef6a0f67c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxPM0hpVTJ0dV96YURCQjY3RTZGTFk4MjZRU05iUXpveFZNcUNSOHpIQkVyanRZbGJYRWQtWkVOTGhzQjd0aUktWklMbXlxdm1mR2RJTmtSQU5pWEsxTjlkakRrOXVCQ2YyNk1pOVNpeWtycGJhMkZhc3YwVTV5U0dXTXFsUUxnY2FLN2luRWR1c3hMX0IzVFFFdV9HSE04WGs?oc=5","as_of":"2026-04-10T07:34:03.630095+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/CBMinwFBVV95cUxPM0hpVTJ0dV96YURCQjY3RTZGTFk4MjZRU05iUXpveFZNcUNSOHpIQkVyanRZbGJYRWQtWkVOTGhzQjd0aUktWklMbXlxdm1mR2RJTmtSQU5pWEsxTjlkakRrOXVCQ2YyNk1pOVNpeWtycGJhMkZhc3YwVTV5U0dXTXFsUUxnY2FLN2luRWR1c3hMX0IzVFFFdV9HSE04WGs?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9bba2e0f74f969c5","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-10T07:34:59.414198+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxPM0hpVTJ0dV96YURCQjY3RTZGTFk4MjZRU05iUXpveFZNcUNSOHpIQkVyanRZbGJYRWQtWkVOTGhzQjd0aUktWklMbXlxdm1mR2RJTmtSQU5pWEsxTjlkakRrOXVCQ2YyNk1pOVNpeWtycGJhMkZhc3YwVTV5U0dXTXFsUUxnY2FLN2luRWR1c3hMX0IzVFFFdV9HSE04WGs?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinwFBVV95cUxPM0hpVTJ0dV96YURCQjY3RTZGTFk4MjZRU05iUXpveFZNcUNSOHpIQkVyanRZbGJYRWQtWkVOTGhzQjd0aUktWklMbXlxdm1mR2RJTmtSQU5pWEsxTjlkakRrOXVCQ2YyNk1pOVNpeWtycGJhMkZhc3YwVTV5U0dXTXFsUUxnY2FLN2luRWR1c3hMX0IzVFFFdV9HSE04WGs?oc=5","source_event_id":"evt_ab7ef6a0f67c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"55d70ceb5f5c9af8","published_at":"2026-04-10T07:05:08+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Springfield Properties","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"2 Other UK Penny Stocks","relevance":"medium","symbol":"","type":"group"}],"event_type":"other","information_gaps":["The two other penny stock company names are not provided in the supplied text.","No stock tickers/symbols are provided for Springfield Properties or the other companies.","The article\u2019s specific reasons for \u201cto watch\u201d (e.g., earnings, contracts, guidance, regulatory items) are not included in the provided text.","No timing/catalyst dates are included in the provided text."],"key_facts":["The headline indicates an article listing Springfield Properties and two other UK penny stocks to watch.","The publisher domain is finance.yahoo.com.","No additional company names, tickers, or specific catalysts are present in the provided text."],"numeric_claims":[],"primary_claim":"The Yahoo Finance article titled \u201cSpringfield Properties And 2 Other UK Penny Stocks To Watch\u201d features Springfield Properties plus two additional UK penny stocks.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"Yahoo Finance published a watchlist-style article highlighting Springfield Properties and two other UK penny stocks to watch.","topics":["UK penny stocks","stock watchlist","Yahoo Finance"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"Springfield Properties And 2 Other UK Penny Stocks To Watch Yahoo Finance","title":"Springfield Properties And 2 Other UK Penny Stocks To Watch - Yahoo Finance","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 14789 in events