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/CBMiswFBVV95cUxPT1E4TnljY2hpbVdmWGNiSFgwT2QwXzgzMjRkbUpyNy1QNlBGTWUxdEs2YV9qQzRsejd1amN6WlRVdGhOLUtzYmEzN1UxNFJEUGgydUtfUEVITmpCRUZyWnhtQVlQQ0ZZZGJIOVNsWmU4SUpqOWtWa2tlNWplWHpJWWdWNkZOaTllZkExYzVHTmFqVDhOdzZGNUNSYkhOTnlWYkFTWkQtS3pUeGd0cDZxbWhFUQ?oc=5","as_of":"2026-04-10T12:11:33.277556+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/CBMiswFBVV95cUxPT1E4TnljY2hpbVdmWGNiSFgwT2QwXzgzMjRkbUpyNy1QNlBGTWUxdEs2YV9qQzRsejd1amN6WlRVdGhOLUtzYmEzN1UxNFJEUGgydUtfUEVITmpCRUZyWnhtQVlQQ0ZZZGJIOVNsWmU4SUpqOWtWa2tlNWplWHpJWWdWNkZOaTllZkExYzVHTmFqVDhOdzZGNUNSYkhOTnlWYkFTWkQtS3pUeGd0cDZxbWhFUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e98b92028c8d77af","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-10T12:16:21.749306+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPT1E4TnljY2hpbVdmWGNiSFgwT2QwXzgzMjRkbUpyNy1QNlBGTWUxdEs2YV9qQzRsejd1amN6WlRVdGhOLUtzYmEzN1UxNFJEUGgydUtfUEVITmpCRUZyWnhtQVlQQ0ZZZGJIOVNsWmU4SUpqOWtWa2tlNWplWHpJWWdWNkZOaTllZkExYzVHTmFqVDhOdzZGNUNSYkhOTnlWYkFTWkQtS3pUeGd0cDZxbWhFUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPT1E4TnljY2hpbVdmWGNiSFgwT2QwXzgzMjRkbUpyNy1QNlBGTWUxdEs2YV9qQzRsejd1amN6WlRVdGhOLUtzYmEzN1UxNFJEUGgydUtfUEVITmpCRUZyWnhtQVlQQ0ZZZGJIOVNsWmU4SUpqOWtWa2tlNWplWHpJWWdWNkZOaTllZkExYzVHTmFqVDhOdzZGNUNSYkhOTnlWYkFTWkQtS3pUeGd0cDZxbWhFUQ?oc=5","source_event_id":"evt_d9efa5946f03","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e28bfc5ccb76c3cf","kind":"ipo_calendar","published_at":"2026-04-10T11:22:35+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Barrick Mining","relevance":"high","symbol":"B","type":"company"},{"asset_class":"other","name":"Seeking Alpha","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["The cleaned article text contains only HTML/CSS and no readable article content; therefore, the specific details behind the \u201croyalty shocker\u201d and \u201cmargin squeeze\u201d are not provided.","No quantitative figures (e.g., margin percentage change, royalty amount, timing, or guidance impact) are present in the provided text.","No confirmation is provided on whether an IPO/spinoff has been filed, approved, priced, or is merely speculative per the headline.","No additional context is available about what \u201croyalty\u201d refers to (counterparty, contract terms, or mechanism).","No date of the article or event is included in the provided text."],"key_facts":["Signal type is discovery_ipo_delta.","Headline references \u201cIPO Spinoff Dream\u201d for Barrick Mining.","Headline alleges a \u201croyalty shocker.\u201d","Headline alleges a \u201cmargin squeeze.\u201d","Headline includes ticker reference NYSE:B."],"numeric_claims":[],"primary_claim":"The Seeking Alpha headline states that Barrick Mining\u2019s IPO spinoff dream is hit by a \u201croyalty shocker\u201d and a margin squeeze (NYSE:B).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The provided signal contains only the Seeking Alpha headline about Barrick Mining\u2019s IPO spinoff hopes being undermined by a royalty-related issue and margin pressure. No article body details are available in the cleaned text to substantiate the claims.","topics":["IPO spinoff","royalties","margin squeeze","equity listing","market reaction (implied by headline)"]},"source":"Seeking Alpha","source_domain":"gstatic.com","summary":"Barrick Mining: IPO Spinoff Dream Hits Royalty Shocker And Margin Squeeze (NYSE:B) Seeking Alpha","tickers":[],"title":"Barrick Mining: IPO Spinoff Dream Hits Royalty Shocker And Margin Squeeze (NYSE:B) - Seeking Alpha","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_f06805c92dbf in signals