SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_4bd358001b9d in signals