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/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5","as_of":"2026-04-10T03:30:53.161018+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/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_37a1c1ebb9f4678a","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-10T03:39:16.568034+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxOSjVnU2MyTVRjaWpYcWNnS3pGQUNLUkxaYTlPOHVvdVBudl9DYmE0WEhBaXUyeDlQZ3RDeXFiQTUweU9oZ0NYWl8waGF4LWpCTHFPcmRyMTIwNy1VOFJMekpnVkRjeWQ5LTNhYlR6Tkd4c3EzV3E1ZG5USjViSDZjV3FPRHNFX011OGVGX1ViU0IyZ2tMVzJlOUgxckVnOTF6Rk1JS0RYUzF3MUVmSnBFVGg0aTVhSWZFRm5kUmlDX2hrcnNo?oc=5","source_event_id":"evt_9aa73827b237","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"388f9b9818e75600","published_at":"2026-04-10T01:12:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"medium","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"medium","symbol":"","type":"country"},{"asset_class":"energy_infrastructure","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"chokepoint"},{"asset_class":"commodity_flow","name":"Oil flows","relevance":"high","symbol":"","type":"market_flow"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the substantive Reuters content; extraction relies on the headline and the user-provided source summary/snippets.","No specific dates/timing for the \u201ctalks\u201d are included in the provided material.","The mechanism by which oil flows are \u201csqueezed\u201d (sanctions, shipping disruptions, production cuts, or routing) is not specified.","The exact terms/conditions of the ceasefire deal and what constitutes \u201cstrain\u201d are not detailed in the provided text.","The relationship between Israel\u2019s Lebanon attacks and the US-Iran ceasefire is asserted in snippets but not evidenced with specifics here."],"key_facts":["Reuters headline indicates the US-Iran ceasefire deal is showing strain ahead of talks.","Reuters headline indicates oil flows are being squeezed (near-term supply/flow risk).","Iran is described (via provided live-update snippets) as warning of strong responses (uncertainty: exact trigger not fully specified in provided text).","Provided snippets indicate Trump cautioned Iran against collecting tolls through the Strait of Hormuz (uncertainty: whether this is part of the same Reuters story or separate coverage).","Provided snippets indicate Israel\u2019s attacks on Lebanon are testing/affecting the ceasefire (uncertainty: causal linkage strength not specified).","Provided snippets indicate stocks are shaky as the situation tests Iran\u2019s ceasefire (uncertainty: which market/indices and timing not specified)."],"numeric_claims":[],"primary_claim":"The US-Iran ceasefire deal is showing strain ahead of talks, with oil flows squeezed and Iran warning of strong responses amid regional escalation.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports that a US-Iran ceasefire deal is under strain, with oil flows potentially squeezed ahead of upcoming talks. Iran warns of strong responses as Israel\u2019s attacks on Lebanon and US comments about Strait of Hormuz tolls add pressure.","topics":["US-Iran ceasefire","oil market risk","Strait of Hormuz tolls","Israel-Lebanon attacks","ceasefire stability","upcoming talks"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"US-Iran ceasefire deal shows strain ahead of talks with oil flows squeezed Reuters Live updates: Iran warns of 'strong responses' as Israel's attacks on Lebanon threaten ceasefire NBC News Iran live updates: Trump says Iran 'better not' collect Strait of Hormuz toll ABC News Live Updates: Trump cautions Iran against charging tolls through Strait of Hormuz as fragile ceasefire holds CBS News Stocks shaky as Israeli attacks on Lebanon tests Iran ceasefire Reuters","title":"US-Iran ceasefire deal shows strain ahead of talks with oil flows squeezed - Reuters","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_f9575b3b745f in signals