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/CBMieEFVX3lxTE52VTBDNXRXMGhVa1A5TGppMktITEZibnRHM0ZRSTJnLTg4U0wxdk5KZ2lmek13WTNpSkM0eTdZOE02RXNNYXRFajNsNFh6MTlkb3ZjbEM0RGIyMGdQRUlJVG9PbHRHakdKazNxbWc0cnp3Ynhqa2k0Zw?oc=5","as_of":"2026-04-08T20:43:08.418257+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/CBMieEFVX3lxTE52VTBDNXRXMGhVa1A5TGppMktITEZibnRHM0ZRSTJnLTg4U0wxdk5KZ2lmek13WTNpSkM0eTdZOE02RXNNYXRFajNsNFh6MTlkb3ZjbEM0RGIyMGdQRUlJVG9PbHRHakdKazNxbWc0cnp3Ynhqa2k0Zw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6dfcb5143702c0d1","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-09T22:11:27.728661+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE52VTBDNXRXMGhVa1A5TGppMktITEZibnRHM0ZRSTJnLTg4U0wxdk5KZ2lmek13WTNpSkM0eTdZOE02RXNNYXRFajNsNFh6MTlkb3ZjbEM0RGIyMGdQRUlJVG9PbHRHakdKazNxbWc0cnp3Ynhqa2k0Zw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE52VTBDNXRXMGhVa1A5TGppMktITEZibnRHM0ZRSTJnLTg4U0wxdk5KZ2lmek13WTNpSkM0eTdZOE02RXNNYXRFajNsNFh6MTlkb3ZjbEM0RGIyMGdQRUlJVG9PbHRHakdKazNxbWc0cnp3Ynhqa2k0Zw?oc=5","source_event_id":"evt_c266bc274c89","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ecd3bec41d24960d","published_at":"2026-04-08T18:59:38+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"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":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"high","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/boilerplate, not the substantive Axios article content; extraction relies on the supplied source summaries/headline.","No specific ceasefire agreement name, dates, or legal wording are provided in the signal.","Near-term timing (e.g., when the U.S. position was communicated or whether it changes operational tempo) is not specified in the provided text.","Market/sector impacts are not described; only geopolitical/diplomatic implications can be inferred."],"key_facts":["Axios reports the U.S. says an Iran ceasefire does not apply to Israeli strikes in Lebanon.","Iran accuses the U.S. of violating parts of the ceasefire deal framework and calls the ceasefire 'unreasonable' (per AP live updates summary).","Multiple outlets indicate Israeli attacks on Lebanon continue while the dispute over the ceasefire framework persists (per AP/CBS summaries).","CBS summary states Israel was informed late about the ceasefire deal and was not happy (per WSJ/CBS summary in provided text).","The Times of Israel summary says Pezeshkian stated that halting fighting in Lebanon was a key condition for the ceasefire with the U.S."],"numeric_claims":[],"primary_claim":"The U.S. says an Iran ceasefire does not apply to Israeli strikes in Lebanon.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The U.S. position is that an Iran-related ceasefire agreement does not constrain Israel\u2019s military strikes in Lebanon. Iran disputes this, alleging U.S. violations of the ceasefire framework while fighting in Lebanon continues.","topics":["ceasefire","Iran deal framework","Israel-Lebanon strikes","U.S. policy position","diplomatic dispute"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"U.S. says Iran ceasefire doesn't apply to Israeli strikes in Lebanon Axios Live updates: Iran accuses US of violating parts of deal framework, says ceasefire 'unreasonable' AP News Live Updates: Iran accuses U.S. of violating ceasefire deal framework as Israeli attacks on Lebanon continue CBS News Exclusive: Israel Was Informed Late About Cease-Fire Deal and Wasn\u2019t Happy WSJ Pezeshkian says halt to fighting in Lebanon was key condition for ceasefire with US The Times of Israel","title":"U.S. says Iran ceasefire doesn't apply to Israeli strikes in Lebanon - Axios","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_80cfdb8db48b in signals