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-12T19:10:36.485351+00:00","dedupe_key":"signal_enriched:news_delta:d5fbb1637c8e643e","evidence_event_ids":["evt_a29ef90172e3"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxQNWgxOFlWbVFOdVBDWG9IOHI5Sk9KVDY4enV4czJnXzg1cU5RSW93cnpYZF9abU56WUNGaWdnLUxQSDBhNEEwUmFaQ1RMekFhQ1VNRzBuaGNJZTdXRTlWYWg0cTFyUDlES0packtubFkxYzByVkFVLXZlVEFrZlFMMDRtNmVFUDRuR1FnTWpiTk15T0g3RlhRZjhHc055QQ?oc=5","as_of":"2026-04-12T19:10:36.485351+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/CBMingFBVV95cUxQNWgxOFlWbVFOdVBDWG9IOHI5Sk9KVDY4enV4czJnXzg1cU5RSW93cnpYZF9abU56WUNGaWdnLUxQSDBhNEEwUmFaQ1RMekFhQ1VNRzBuaGNJZTdXRTlWYWg0cTFyUDlES0packtubFkxYzByVkFVLXZlVEFrZlFMMDRtNmVFUDRuR1FnTWpiTk15T0g3RlhRZjhHc055QQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_51c98569874e2b02","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-12T19:12:55.066854+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxQNWgxOFlWbVFOdVBDWG9IOHI5Sk9KVDY4enV4czJnXzg1cU5RSW93cnpYZF9abU56WUNGaWdnLUxQSDBhNEEwUmFaQ1RMekFhQ1VNRzBuaGNJZTdXRTlWYWg0cTFyUDlES0packtubFkxYzByVkFVLXZlVEFrZlFMMDRtNmVFUDRuR1FnTWpiTk15T0g3RlhRZjhHc055QQ?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/CBMingFBVV95cUxQNWgxOFlWbVFOdVBDWG9IOHI5Sk9KVDY4enV4czJnXzg1cU5RSW93cnpYZF9abU56WUNGaWdnLUxQSDBhNEEwUmFaQ1RMekFhQ1VNRzBuaGNJZTdXRTlWYWg0cTFyUDlES0packtubFkxYzByVkFVLXZlVEFrZlFMMDRtNmVFUDRuR1FnTWpiTk15T0g3RlhRZjhHc055QQ?oc=5","source_event_id":"evt_a29ef90172e3","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"fcadb3daf1968d22","published_at":"2026-04-12T18:25:38+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":["FQ4 2026"],"entities":[{"asset_class":"equity","name":"BlackBerry Limited","relevance":"high","symbol":"BB","type":"company"}],"event_type":"earnings","information_gaps":["No article text is provided, so the specific earnings metrics, guidance, or magnitude of the results are unknown.","\u201cRising penny stocks\u201d criteria (e.g., price change, market cap, volume) are not defined in the provided text.","No timing details beyond \u201cafter strong FQ4 2026 results\u201d are available."],"key_facts":["Source is Yahoo Finance (finance.yahoo.com).","Headline mentions BlackBerry Limited (BB).","Headline claims BlackBerry is among the best rising penny stocks.","Headline attributes the move to strong FQ4 2026 results."],"numeric_claims":[],"primary_claim":"BlackBerry Limited (BB) is described as among the best rising penny stocks after strong FQ4 2026 results.","relevance_score":0.55,"sentiment":"positive","source_quality":"unknown","summary":"Yahoo Finance headline states that BlackBerry Limited (BB) is among the best rising penny stocks following strong FQ4 2026 results.","topics":["earnings","stock performance","penny stocks","Yahoo Finance"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"BlackBerry Limited (BB): Among the Best Rising Penny Stocks After Strong FQ4 2026 Results Yahoo Finance","title":"BlackBerry Limited (BB): Among the Best Rising Penny Stocks After Strong FQ4 2026 Results - 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 30669 in events