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/CBMilwFBVV95cUxNMVFJWTlBTU9Xbm52TXBPQlVfRUEwX2E4MWVMM01WNnBvd3ptck1xUmw4M1pIZGo2Y0pvM0pMMVFRS2M4elZoX1g4SkcxTkc0QVlXcUFBemQ3Y01HellqZWV1WFUyNjQtcWF5NnZSdDdJODcybGpUdDBtYXZnMVBSLXFlMnRmRU9aakt5ZS1XTDV5QkRXbzRN?oc=5","as_of":"2026-04-10T16:36:01.333155+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/CBMilwFBVV95cUxNMVFJWTlBTU9Xbm52TXBPQlVfRUEwX2E4MWVMM01WNnBvd3ptck1xUmw4M1pIZGo2Y0pvM0pMMVFRS2M4elZoX1g4SkcxTkc0QVlXcUFBemQ3Y01HellqZWV1WFUyNjQtcWF5NnZSdDdJODcybGpUdDBtYXZnMVBSLXFlMnRmRU9aakt5ZS1XTDV5QkRXbzRN?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0d868cc7d992b3f7","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-10T17:16:27.405884+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxNMVFJWTlBTU9Xbm52TXBPQlVfRUEwX2E4MWVMM01WNnBvd3ptck1xUmw4M1pIZGo2Y0pvM0pMMVFRS2M4elZoX1g4SkcxTkc0QVlXcUFBemQ3Y01HellqZWV1WFUyNjQtcWF5NnZSdDdJODcybGpUdDBtYXZnMVBSLXFlMnRmRU9aakt5ZS1XTDV5QkRXbzRN?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxNMVFJWTlBTU9Xbm52TXBPQlVfRUEwX2E4MWVMM01WNnBvd3ptck1xUmw4M1pIZGo2Y0pvM0pMMVFRS2M4elZoX1g4SkcxTkc0QVlXcUFBemQ3Y01HellqZWV1WFUyNjQtcWF5NnZSdDdJODcybGpUdDBtYXZnMVBSLXFlMnRmRU9aakt5ZS1XTDV5QkRXbzRN?oc=5","source_event_id":"evt_f26c9b2fd447","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fd6ad3110bcfac00","published_at":"2026-04-10T13:25:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"JD Vance","relevance":"primary speaker","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"counterparty in negotiations","symbol":"","type":"country"},{"asset_class":"","name":"United States","relevance":"negotiating party","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The specific location, date/time, and agenda of the negotiations are not provided in the supplied text.","The identity of the other negotiation participants (e.g., which Iranian officials, intermediaries) is not provided.","Whether the warning is tied to a particular prior incident or condition is not provided.","The headline implies a \u201cwar\u201d but does not specify which conflict in the provided excerpt (e.g., Gaza/region/other) beyond \u201ctheir war.\u201d","No details are provided on expected outcomes, timelines, or cease-fire mechanics."],"key_facts":["JD Vance issued a warning to Iran not to \u201cplay\u201d the U.S. (wording as reported in the headline).","Vance is departing for negotiations intended to end the war between the U.S. and Iran (as framed by the headline).","The report is attributed to AP News (publisher/domain indicated in the prompt)."],"numeric_claims":[],"primary_claim":"JD Vance warned Iran not to \u201cplay\u201d the U.S. as he departed for negotiations aimed at ending their war.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"U.S. Vice President JD Vance is warning Iran not to \u201cplay\u201d the U.S. as he departs for negotiations aimed at ending the war. The near-term catalyst is the start of these talks, with an implied push for constructive engagement.","topics":["U.S.-Iran negotiations","war termination talks","diplomatic messaging","risk of escalation"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Vance warns Iran not to 'play' the US as he departs for negotiations aimed at ending their war AP News Iran War Live Updates: Vance Heads to Peace Talks as Lebanon Impasse Threatens Cease-Fire The New York Times Vance expects U.S. negotiations with Iran on war will be \u2018positive' CNBC Live updates: Don't try to play the U.S. in peace talks, Vance warns Iran, as Strait of Hormuz remains closed NBC News Iran War News Live Updates\u2014JD Vance Warns Iran: Don\u2019t \u2018Try to Play Us\u2019 WSJ","title":"Vance warns Iran not to 'play' the US as he departs for negotiations aimed at ending their war - AP News","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_aa7b9fd991e0 in signals