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/CBMie0FVX3lxTFB3akRac3NMODFCbW0zMWFIQVQxVU8wNGNRWkxzbGk2elRSTzU4ekFmaVlySmEzZnBSS25Yd2NjbGphSEItNThlcWhFQkR4U2dKRENURjVaZHZFNGtIemU5NFM4REhxSnlQcXNjVjc5cmdEY2hYUElhQUE5Zw?oc=5","as_of":"2026-04-09T13:37:34.641242+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/CBMie0FVX3lxTFB3akRac3NMODFCbW0zMWFIQVQxVU8wNGNRWkxzbGk2elRSTzU4ekFmaVlySmEzZnBSS25Yd2NjbGphSEItNThlcWhFQkR4U2dKRENURjVaZHZFNGtIemU5NFM4REhxSnlQcXNjVjc5cmdEY2hYUElhQUE5Zw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9c1fdc952a6065f0","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-10T02:20:08.767644+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFB3akRac3NMODFCbW0zMWFIQVQxVU8wNGNRWkxzbGk2elRSTzU4ekFmaVlySmEzZnBSS25Yd2NjbGphSEItNThlcWhFQkR4U2dKRENURjVaZHZFNGtIemU5NFM4REhxSnlQcXNjVjc5cmdEY2hYUElhQUE5Zw?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/CBMie0FVX3lxTFB3akRac3NMODFCbW0zMWFIQVQxVU8wNGNRWkxzbGk2elRSTzU4ekFmaVlySmEzZnBSS25Yd2NjbGphSEItNThlcWhFQkR4U2dKRENURjVaZHZFNGtIemU5NFM4REhxSnlQcXNjVjc5cmdEY2hYUElhQUE5Zw?oc=5","source_event_id":"evt_3f35749ed780","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"83545b0566271d64","kind":"ipo_calendar","published_at":"2026-04-09T06:54:00+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["Q1"],"entities":[{"asset_class":"equities","name":"UK IPO market","relevance":"high","symbol":"","type":"market"},{"asset_class":"","name":"Yahoo! Finance Canada","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["The article text provided contains only styling/HTML fragments and does not include the body content needed to verify additional details (e.g., which specific listings, dates, volumes, or performance metrics).","No quantitative measures beyond \u201cjust two listings\u201d are present in the provided text.","The specific meaning/extent of \u201cgeopolitical strain\u201d and \u201cAI sell-off\u201d is not defined in the provided text."],"key_facts":["The UK IPO market had just two listings in Q1.","The article links the weak IPO performance to geopolitical strain.","The article also links the weak IPO performance to an AI sell-off."],"numeric_claims":[{"label":"Q1 UK IPO listings","value":"2"}],"primary_claim":"In Q1, the UK IPO market recorded just two listings.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The UK IPO market had only two listings in Q1, indicating a weak start to the year. The article attributes the sluggishness to geopolitical strain and an AI-related sell-off.","topics":["IPO market","UK","Q1 listings","geopolitical strain","AI sell-off"]},"source":"Yahoo! Finance Canada","source_domain":"gstatic.com","summary":"UK IPO market limps through Q1 with just two listings as geopolitical strain and AI sell-off bite Yahoo! Finance Canada","tickers":[],"title":"UK IPO market limps through Q1 with just two listings as geopolitical strain and AI sell-off bite - Yahoo! Finance Canada","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_3b2f80091b52 in signals