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-08T06:25:07.625179+00:00","dedupe_key":"signal_enriched:market_headline_delta:adc31dbc6a41b2cf","evidence_event_ids":["evt_12902ea7013f"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxOV0FBWklBcEZUdnlWRFhxc0Y3M3RqRjk1VVROT0hTdEh6cXFXeWd1VjRzcUVzNGVZUmhKaXpXMEI0QV93R1dOa2FLRDRkWmJUX1Q2LUZEZ0FNM08zOGljZWRpRU53Vl9jVVJDVTkwNTJyWERtQ09maHh5Q09CUU5manU4blpabkh1S2xpdXpVNThrOF9iUVJlRVMwM0J6VG5VMlpyNmFtWUd5ZEJaaUpMMlpVMkxWTU0?oc=5","as_of":"2026-04-08T06:25:07.625179+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/CBMitwFBVV95cUxOV0FBWklBcEZUdnlWRFhxc0Y3M3RqRjk1VVROT0hTdEh6cXFXeWd1VjRzcUVzNGVZUmhKaXpXMEI0QV93R1dOa2FLRDRkWmJUX1Q2LUZEZ0FNM08zOGljZWRpRU53Vl9jVVJDVTkwNTJyWERtQ09maHh5Q09CUU5manU4blpabkh1S2xpdXpVNThrOF9iUVJlRVMwM0J6VG5VMlpyNmFtWUd5ZEJaaUpMMlpVMkxWTU0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7fc5e69265a67a36","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-08T06:25:54.699860+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxOV0FBWklBcEZUdnlWRFhxc0Y3M3RqRjk1VVROT0hTdEh6cXFXeWd1VjRzcUVzNGVZUmhKaXpXMEI0QV93R1dOa2FLRDRkWmJUX1Q2LUZEZ0FNM08zOGljZWRpRU53Vl9jVVJDVTkwNTJyWERtQ09maHh5Q09CUU5manU4blpabkh1S2xpdXpVNThrOF9iUVJlRVMwM0J6VG5VMlpyNmFtWUd5ZEJaaUpMMlpVMkxWTU0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gurufocus.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxOV0FBWklBcEZUdnlWRFhxc0Y3M3RqRjk1VVROT0hTdEh6cXFXeWd1VjRzcUVzNGVZUmhKaXpXMEI0QV93R1dOa2FLRDRkWmJUX1Q2LUZEZ0FNM08zOGljZWRpRU53Vl9jVVJDVTkwNTJyWERtQ09maHh5Q09CUU5manU4blpabkh1S2xpdXpVNThrOF9iUVJlRVMwM0J6VG5VMlpyNmFtWUd5ZEJaaUpMMlpVMkxWTU0?oc=5","source_event_id":"evt_12902ea7013f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"162704acc5537e65","published_at":"2026-04-07T17:24:30+00:00","publisher_domain":"gurufocus.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Alcoa","relevance":"high","symbol":"AA","type":"company"},{"asset_class":"other","name":"B. Riley Securities","relevance":"high","symbol":"","type":"analyst_firm"}],"event_type":"price_action","information_gaps":["No numeric price target value is provided in the provided text.","No details are provided on whether the Buy rating was newly initiated or reiterated.","No context is provided on the timing of the price target change (date/timeframe).","The provided article text appears to be mostly page styling/HTML and does not include the substantive content beyond the headline."],"key_facts":["The signal headline states: \"Alcoa (AA): B. Riley Securities Raises Price Target with Buy Rat\".","The headline explicitly links the action (raises price target) to B. Riley Securities.","The headline indicates a Buy rating (\"Buy Rat\")."],"numeric_claims":[],"primary_claim":"B. Riley Securities raised its price target for Alcoa (AA) and has a Buy rating.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"GuruFocus headline reports that B. Riley Securities raised its price target and reiterated a Buy rating on Alcoa (AA).","topics":["analyst_rating_change","price_target_raise","equity_research","Alcoa"]},"source":"GuruFocus","source_domain":"gurufocus.com","source_url":"https://www.gurufocus.com","summary":"","tickers":[],"title":"Alcoa (AA): B. Riley Securities Raises Price Target with Buy Rat - GuruFocus","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 4947 in events