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/CBMif0FVX3lxTE1TdTYtTGl2Q09qQTdacUpNVUlaN0Vncjg3dS1nMzF6cmo3OEpON0xkRWpJUEFnNWVjOFloQzNsT194ZVRoWW5MZHpsOFowbThfZlA0WkNnVXJlenljQkE1UUw1SG1GbFVIOFNLckMyVVBIV1NNYWpuTFdpT3pITzA?oc=5","as_of":"2026-04-09T10:33:00.428212+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/CBMif0FVX3lxTE1TdTYtTGl2Q09qQTdacUpNVUlaN0Vncjg3dS1nMzF6cmo3OEpON0xkRWpJUEFnNWVjOFloQzNsT194ZVRoWW5MZHpsOFowbThfZlA0WkNnVXJlenljQkE1UUw1SG1GbFVIOFNLckMyVVBIV1NNYWpuTFdpT3pITzA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6146ad2eb4f62cdc","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-09T23:07:17.336063+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE1TdTYtTGl2Q09qQTdacUpNVUlaN0Vncjg3dS1nMzF6cmo3OEpON0xkRWpJUEFnNWVjOFloQzNsT194ZVRoWW5MZHpsOFowbThfZlA0WkNnVXJlenljQkE1UUw1SG1GbFVIOFNLckMyVVBIV1NNYWpuTFdpT3pITzA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE1TdTYtTGl2Q09qQTdacUpNVUlaN0Vncjg3dS1nMzF6cmo3OEpON0xkRWpJUEFnNWVjOFloQzNsT194ZVRoWW5MZHpsOFowbThfZlA0WkNnVXJlenljQkE1UUw1SG1GbFVIOFNLckMyVVBIV1NNYWpuTFdpT3pITzA?oc=5","source_event_id":"evt_2b906f6dec36","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b6649d5d0dfab9f9","published_at":"2026-04-09T10:21:04+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["second day (relative timing; exact date not provided in signal)"],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","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":"geographic_chokepoint"},{"asset_class":"diplomacy","name":"Mediators","relevance":"medium","symbol":"","type":"group"},{"asset_class":"diplomacy_location","name":"Islamabad","relevance":"medium","symbol":"","type":"city"}],"event_type":"conflict","information_gaps":["Exact cease-fire start time/date is not provided in the signal.","The specific terms of the cease-fire and what constitutes a \u201cbreach\u201d are not included in the provided text.","Whether the cease-fire is bilateral or multilateral (and which actors are parties) is not specified in the signal.","The magnitude/direction of oil price moves (percent/level) is not provided\u2014only that prices \u201cresume gains.\u201d","The exact timing of the Islamabad talks (date/time) is not provided in the signal."],"key_facts":["Cease-fire is reported to have entered its second day (NYT headline).","Cease-fire durability is described as uncertain due to disagreements involving Lebanon and the Strait of Hormuz (NYT headline).","Iran is described as accusing the U.S. of breaching the ceasefire deal, and oil prices are reported to resume gains after that accusation (CNBC snippet in provided source summary).","Iran\u2019s position toward mediators and/or talks in Islamabad is described as conditional on a cease-fire in Lebanon (WSJ snippet in provided source summary).","There are \u201ckey sticking points\u201d between the U.S. and Iran related to uranium, sanctions, and the Strait of Hormuz ahead of talks in Islamabad (Independent snippet in provided source summary)."],"numeric_claims":[],"primary_claim":"The Iran war cease-fire has entered its second day, but uncertainty remains over issues including Lebanon and the Strait of Hormuz.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"A cease-fire in the Iran war has reached its second day, but its durability is uncertain due to disagreements involving Lebanon and the Strait of Hormuz. The near-term catalyst is ongoing mediation and related talks, with oil markets reacting to accusations about cease-fire compliance.","topics":["Iran war cease-fire","Lebanon cease-fire linkage","Strait of Hormuz risk","cease-fire compliance disputes","energy market sensitivity"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Iran War Live Updates: Cease-Fire Enters Second Day Despite Hormuz and Lebanon Uncertainty The New York Times Ceasefire in the Iran war teeters in the face of disagreements over Lebanon and the Strait of Hormuz WCVB Iran Tells Mediators Islamabad Meeting Is Conditional on a Cease-Fire in Lebanon WSJ Oil prices resume gains after Iran accuses U.S. of breaching ceasefire deal CNBC Uranium, sanctions and the Strait of Hormuz: The key sticking points between US and Iran ahead of talks in Islamabad The Independent","title":"Iran War Live Updates: Cease-Fire Enters Second Day Despite Hormuz and Lebanon Uncertainty - The New York Times","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_be0c2be850eb in signals