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/CBMilAFBVV95cUxPUU1JckIzN2V4NFdnOTFSQ1R2SXlhV2t2cEQ4MzRoSHluOE5mcnU2eG1IbWVPSmFPb3I1UDc5OGhqa0ktM2RrYVJlM29hQWd5OHd5aGtqZGFtN2gtVGZ6MDd3VnVQa1lxdTVxOFE1bDBmN3hoc0k5dFZ4ZjdSc1g1akVKMmhDMGdXU3BWLXdoc0stRTRp?oc=5","as_of":"2026-04-10T01:40:58.842462+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/CBMilAFBVV95cUxPUU1JckIzN2V4NFdnOTFSQ1R2SXlhV2t2cEQ4MzRoSHluOE5mcnU2eG1IbWVPSmFPb3I1UDc5OGhqa0ktM2RrYVJlM29hQWd5OHd5aGtqZGFtN2gtVGZ6MDd3VnVQa1lxdTVxOFE1bDBmN3hoc0k5dFZ4ZjdSc1g1akVKMmhDMGdXU3BWLXdoc0stRTRp?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f59315b328e30125","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-10T01:42:09.908983+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxPUU1JckIzN2V4NFdnOTFSQ1R2SXlhV2t2cEQ4MzRoSHluOE5mcnU2eG1IbWVPSmFPb3I1UDc5OGhqa0ktM2RrYVJlM29hQWd5OHd5aGtqZGFtN2gtVGZ6MDd3VnVQa1lxdTVxOFE1bDBmN3hoc0k5dFZ4ZjdSc1g1akVKMmhDMGdXU3BWLXdoc0stRTRp?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/CBMilAFBVV95cUxPUU1JckIzN2V4NFdnOTFSQ1R2SXlhV2t2cEQ4MzRoSHluOE5mcnU2eG1IbWVPSmFPb3I1UDc5OGhqa0ktM2RrYVJlM29hQWd5OHd5aGtqZGFtN2gtVGZ6MDd3VnVQa1lxdTVxOFE1bDBmN3hoc0k5dFZ4ZjdSc1g1akVKMmhDMGdXU3BWLXdoc0stRTRp?oc=5","source_event_id":"evt_c809dcd19755","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5a5392d407921d8e","published_at":"2026-04-10T01:18:00+00:00","publisher_domain":"bloomberg.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"commodity","name":"Oil","relevance":"high","symbol":"WTI/Brent (not specified)","type":"commodity"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"equities/FX (not specified)","name":"Asia-Pacific markets","relevance":"medium","symbol":"","type":"market_region"}],"event_type":"geopolitical_risk","information_gaps":["Exact oil benchmark(s) (WTI vs Brent) and the magnitude of the opening move are not provided in the supplied text.","No specific timing for when the ceasefire outcome will be reassessed is stated.","The cleaned article text appears to contain mostly page styling/boilerplate; detailed factual content beyond the provided source summary is not available here."],"key_facts":["Bloomberg headline indicates oil opened higher with focus on the U.S.-Iran ceasefire.","Market coverage notes the ceasefire is fragile and keeps investors on edge.","Other cited snippets indicate oil prices edged higher but confidence in the ceasefire was wavering."],"numeric_claims":[],"primary_claim":"Oil opened higher while investors focused on a fragile U.S.-Iran ceasefire, though confidence in it was wavering.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Oil prices opened higher as markets focused on a fragile U.S.-Iran ceasefire. The ceasefire is described as not fully stable, keeping investors cautious.","topics":["oil prices","U.S.-Iran ceasefire","geopolitical risk","market sentiment","ceasefire stability"]},"source":"Bloomberg.com","source_domain":"bloomberg.com","source_url":"https://www.bloomberg.com","summary":"Oil Opens Higher With Focus on US-Iran Ceasefire: Markets Wrap Bloomberg.com Asia-Pacific markets open mostly higher as a fragile Iran-U.S. ceasefire keeps investors on edge CNBC Oil Prices Edge Higher as Confidence in Cease-Fire Wavers The New York Times Oil is plunging, but don\u2019t expect $3 gas anytime soon. Here\u2019s why | CNN Business CNN Will the Iran ceasefire quickly ease U.S. gas prices? Here's what experts think. CBS News","title":"Oil Opens Higher With Focus on US-Iran Ceasefire: Markets Wrap - Bloomberg.com","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_e1371ce3e46d in signals