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/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?oc=5","as_of":"2026-04-10T13:23:11.045624+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/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3f1ee0fca5b2fb38","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-10T13:23:57.930981+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?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/CBMid0FVX3lxTFBBaER6cWZ1UHo4SjlFWU9JbFpOSUR3eXBEcW0ycnZHcDhvRE5XUXlYRWhyQUM1aWZsZVVUYWlwc1dfSVZZNVg1WHBmcHBadGJDOFAxLTh2Z1BEMFlHaE5PWmUxckh6c0Z2MW1yX0tkaldxanYzOUpz?oc=5","source_event_id":"evt_0bb8f7cfb7bf","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"36f37442f3a02860","published_at":"2026-04-10T09:03:38+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"political_official","name":"JD Vance","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign_state","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign_state","name":"United States (Vance administration context)","relevance":"medium","symbol":"","type":"country_or_government"},{"asset_class":"chokepoint","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geographic_location"},{"asset_class":"political_official","name":"Trump (referenced in source summary)","relevance":"medium","symbol":"","type":"person"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is not usable for extracting the NYT article\u2019s specific details (it appears to be page styling/boilerplate rather than article content).","No specific date/time, location, or agenda items for the Iran talks are included in the provided headline and summaries.","No concrete terms of any ceasefire or negotiation outcomes are stated in the provided material.","Directional market/operational impact (e.g., oil price moves) is not explicitly stated in the provided text; only geopolitical risk framing is implied."],"key_facts":["The headline states that JD Vance faces a high-profile test of his negotiating skills with Iran talks (The New York Times).","The provided source summary includes that Trump casts doubt on an Iran war ceasefire due to continued closure of the Strait of Hormuz (The Guardian).","The provided source summary includes that Trump sends his team to Pakistan for high-stakes Iran talks (WSJ).","The provided source summary includes that Vance warns Iran not to \"play us\" as he leaves for talks (Reuters)."],"numeric_claims":[],"primary_claim":"JD Vance is facing a high-profile test of his negotiating skills with Iran talks, according to The New York Times.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The New York Times reports that JD Vance is heading into a high-stakes negotiation test involving Iran talks, framed as a test of his negotiating skills. The broader provided source set also indicates contemporaneous uncertainty around an Iran-related ceasefire and heightened attention to the Strait of Hormuz.","topics":["Iran talks","US-Iran negotiations","JD Vance","Strait of Hormuz","ceasefire uncertainty","Middle East crisis"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Vance Faces a High-Profile Test of His Negotiating Skills With Iran Talks The New York Times Middle East crisis live: Trump casts doubt on Iran war ceasefire over continued closure of strait of Hormuz The Guardian \u2018Afraid of being on the outs\u2019: Inside JD Vance\u2019s tightrope walk on Iran MS NOW Trump Sends His Team to Pakistan for High-Stakes Iran Talks WSJ Vance warns Iran not to \"play us\" as he leaves for talks Reuters","title":"Vance Faces a High-Profile Test of His Negotiating Skills With Iran Talks - 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_84e532207c49 in signals