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/CBMirwFBVV95cUxNa2hWMGhOVlBUaWNQNVlaWUtWeWwyaC05WXVraGdZS3FNbkRQWlBUTkQxWFdLdVMtOGpYeXo3cWVxOW1DcUp3cm5zUmdaTWtFQlNNeEx5Y1VnNTkzYzVBWHVCVEZXWm5WanU5anBtTm1wcy10dm5DUWVMVDRoWUtMeHBkcnRrVG9xREpYTFZNc0N4WnIyYVZlT21SUXFpa1lCRE51M0NoZGVUUVFwY2JB?oc=5","as_of":"2026-04-08T01:28:20.756554+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNa2hWMGhOVlBUaWNQNVlaWUtWeWwyaC05WXVraGdZS3FNbkRQWlBUTkQxWFdLdVMtOGpYeXo3cWVxOW1DcUp3cm5zUmdaTWtFQlNNeEx5Y1VnNTkzYzVBWHVCVEZXWm5WanU5anBtTm1wcy10dm5DUWVMVDRoWUtMeHBkcnRrVG9xREpYTFZNc0N4WnIyYVZlT21SUXFpa1lCRE51M0NoZGVUUVFwY2JB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a84d3985cf0e1611","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:28:48.001455+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNa2hWMGhOVlBUaWNQNVlaWUtWeWwyaC05WXVraGdZS3FNbkRQWlBUTkQxWFdLdVMtOGpYeXo3cWVxOW1DcUp3cm5zUmdaTWtFQlNNeEx5Y1VnNTkzYzVBWHVCVEZXWm5WanU5anBtTm1wcy10dm5DUWVMVDRoWUtMeHBkcnRrVG9xREpYTFZNc0N4WnIyYVZlT21SUXFpa1lCRE51M0NoZGVUUVFwY2JB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bloomberg.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNa2hWMGhOVlBUaWNQNVlaWUtWeWwyaC05WXVraGdZS3FNbkRQWlBUTkQxWFdLdVMtOGpYeXo3cWVxOW1DcUp3cm5zUmdaTWtFQlNNeEx5Y1VnNTkzYzVBWHVCVEZXWm5WanU5anBtTm1wcy10dm5DUWVMVDRoWUtMeHBkcnRrVG9xREpYTFZNc0N4WnIyYVZlT21SUXFpa1lCRE51M0NoZGVUUVFwY2JB?oc=5","source_event_id":"evt_374f40ee34e8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b43a2c2444764a9f","published_at":"2026-04-07T23:37:37+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equities (banking sector)","name":"China bank stocks","relevance":"primary","symbol":"","type":"asset_class_or_sector"},{"asset_class":"geopolitical","name":"Iran war","relevance":"trigger","symbol":"","type":"geopolitical_event"},{"asset_class":"financial_markets","name":"Markets","relevance":"affected","symbol":"","type":"market"},{"asset_class":"news","name":"Bloomberg.com","relevance":"source","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["No specific bank tickers or index names are provided in the provided text.","No details are given on the mechanism for the \u201chaven\u201d characterization (e.g., yields, flows, policy expectations).","No timing details (exact date/time of the move) are included beyond the general \u201cjolts markets\u201d framing.","No magnitude of price moves, performance metrics, or comparative benchmarks are included in the provided text."],"key_facts":["Bloomberg headline states that China bank stocks are emerging as a haven.","Bloomberg headline states that an Iran war is jolting markets.","The signal is presented as a headline delta with article-based basis."],"numeric_claims":[],"primary_claim":"China bank stocks are emerging as a haven as an Iran war jolts markets, according to Bloomberg.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Bloomberg reports that China bank stocks are being treated as a \u201chaven\u201d during market turmoil triggered by the Iran war. The headline indicates a near-term risk-off shock from Iran that is coinciding with relative strength in China banks.","topics":["haven bid","China banking sector","Iran war","risk-off","market volatility"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"China Bank Stocks Emerge as Haven as Iran War Jolts Markets Bloomberg.com","title":"China Bank Stocks Emerge as Haven as Iran War Jolts Markets - Bloomberg.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_c9b0bdd59986 in signals