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/CBMiygFBVV95cUxNR1E3RGJiZGNoVGxrdkl0U25nTE95RHlBdzhpUFM4MUo4cE5FZEJ0R0g2bENtX21PcXc2Zzg3NDRGd0dxMmpPVVdLeHJxX2phNEc5M2E4bThtdlFjWFN1clMyNWNvRnFCYVpEeFprYnRSS1pLMHJBSDJpTHFPX1BlOTd4c1FCU0Q0WHVQZ0xFY2lHejdMV0JBT1ZlSUdiZ2dHV0ZSb3gxMDNubDdkbUFkSU1EeHZEY3g4RFNiR2Q5T3pSOVpiVU5nTzdB?oc=5","as_of":"2026-04-09T17:20:48.562061+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/CBMiygFBVV95cUxNR1E3RGJiZGNoVGxrdkl0U25nTE95RHlBdzhpUFM4MUo4cE5FZEJ0R0g2bENtX21PcXc2Zzg3NDRGd0dxMmpPVVdLeHJxX2phNEc5M2E4bThtdlFjWFN1clMyNWNvRnFCYVpEeFprYnRSS1pLMHJBSDJpTHFPX1BlOTd4c1FCU0Q0WHVQZ0xFY2lHejdMV0JBT1ZlSUdiZ2dHV0ZSb3gxMDNubDdkbUFkSU1EeHZEY3g4RFNiR2Q5T3pSOVpiVU5nTzdB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_416f8e91437dd0e3","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-10T00:09:39.309139+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiygFBVV95cUxNR1E3RGJiZGNoVGxrdkl0U25nTE95RHlBdzhpUFM4MUo4cE5FZEJ0R0g2bENtX21PcXc2Zzg3NDRGd0dxMmpPVVdLeHJxX2phNEc5M2E4bThtdlFjWFN1clMyNWNvRnFCYVpEeFprYnRSS1pLMHJBSDJpTHFPX1BlOTd4c1FCU0Q0WHVQZ0xFY2lHejdMV0JBT1ZlSUdiZ2dHV0ZSb3gxMDNubDdkbUFkSU1EeHZEY3g4RFNiR2Q5T3pSOVpiVU5nTzdB?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/CBMiygFBVV95cUxNR1E3RGJiZGNoVGxrdkl0U25nTE95RHlBdzhpUFM4MUo4cE5FZEJ0R0g2bENtX21PcXc2Zzg3NDRGd0dxMmpPVVdLeHJxX2phNEc5M2E4bThtdlFjWFN1clMyNWNvRnFCYVpEeFprYnRSS1pLMHJBSDJpTHFPX1BlOTd4c1FCU0Q0WHVQZ0xFY2lHejdMV0JBT1ZlSUdiZ2dHV0ZSb3gxMDNubDdkbUFkSU1EeHZEY3g4RFNiR2Q5T3pSOVpiVU5nTzdB?oc=5","source_event_id":"evt_a2dfc9a00e34","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6a090e7ff141d934","published_at":"2026-04-09T11:55:43+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Iran\u2019s president","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Israel","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Lebanon","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"","name":"US and Iran (talks)","relevance":"medium","symbol":"","type":"process"},{"asset_class":"","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geographic chokepoint"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the Reuters story content; extraction is therefore based on the headline and the provided source summary/snippets.","The exact wording of the president\u2019s statement and whether it refers to specific negotiations (US-Iran, cease-fire talks, or another track) is not fully verifiable from the provided text.","Timing/catalyst details (when talks are scheduled, and whether the statement affects an imminent negotiation date) are not specified in the provided content.","The status of the Strait of Hormuz (restricted vs closed) and its direct linkage to this Reuters item cannot be confirmed from the provided Reuters text."],"key_facts":["Reuters reports Iran\u2019s president said Israeli strikes on Lebanon make negotiations meaningless.","The Reuters live-update context indicates US and Iran are preparing for talks.","Other provided source snippets indicate the Strait of Hormuz remains restricted/closed in the broader coverage context (exact details not confirmed from the cleaned Reuters text provided)."],"numeric_claims":[],"primary_claim":"Iran\u2019s president said Israeli strikes on Lebanon render negotiations meaningless.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Iran\u2019s president said Israeli strikes on Lebanon make ongoing negotiations meaningless, signaling increased skepticism toward any diplomatic track. The statement comes amid preparations for US-Iran talks and heightened regional tensions around Lebanon and the Strait of Hormuz.","topics":["Iran-Israel conflict","Lebanon strikes","US-Iran negotiations","diplomacy vs escalation","Strait of Hormuz disruption risk"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Iran's president says Israeli strikes on Lebanon render negotiations meaningless Reuters Live updates: US and Iran prepare for talks as Strait of Hormuz remains restricted CNN Iran War Live Updates: Israeli Strikes in Lebanon Threaten Shaky U.S.-Iran Cease-Fire The New York Times Iran closes strait, challenges U.S. to rein in Israel: 'the world is watching whether it will act on its commitments' Fortune Israel's war in Lebanon becomes a flashpoint as Iran says U.S. must choose \"between war and ceasefire\" CBS News","title":"Iran's president says Israeli strikes on Lebanon render negotiations meaningless - 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_8618a65a2966 in signals