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/CBMiggFBVV95cUxNT0p4dG5laWRkZHQ2Z3ktaVFxOWxvcDRyaTgyVC1MZU9vNlpCYTlqa0ptdm00azZMM3BOX0UzVmdRWGRnVlJnXzlKb1BkOHczSjVXWUlUMUNUeXRnTFV0YWNGemFoUFFUSUhCSWhPRWY4azd6WElES1l1SUczQWtqZ0JB?oc=5","as_of":"2026-04-08T21:48:34.531743+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/CBMiggFBVV95cUxNT0p4dG5laWRkZHQ2Z3ktaVFxOWxvcDRyaTgyVC1MZU9vNlpCYTlqa0ptdm00azZMM3BOX0UzVmdRWGRnVlJnXzlKb1BkOHczSjVXWUlUMUNUeXRnTFV0YWNGemFoUFFUSUhCSWhPRWY4azd6WElES1l1SUczQWtqZ0JB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0a94cf6d959e2b7c","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:14:54.913415+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxNT0p4dG5laWRkZHQ2Z3ktaVFxOWxvcDRyaTgyVC1MZU9vNlpCYTlqa0ptdm00azZMM3BOX0UzVmdRWGRnVlJnXzlKb1BkOHczSjVXWUlUMUNUeXRnTFV0YWNGemFoUFFUSUhCSWhPRWY4azd6WElES1l1SUczQWtqZ0JB?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/CBMiggFBVV95cUxNT0p4dG5laWRkZHQ2Z3ktaVFxOWxvcDRyaTgyVC1MZU9vNlpCYTlqa0ptdm00azZMM3BOX0UzVmdRWGRnVlJnXzlKb1BkOHczSjVXWUlUMUNUeXRnTFV0YWNGemFoUFFUSUhCSWhPRWY4azd6WElES1l1SUczQWtqZ0JB?oc=5","source_event_id":"evt_341a2426811b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8b6c7144c1226909","published_at":"2026-04-08T18:52:47+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["Saturday","April 8"],"entities":[{"asset_class":"","name":"J.D. Vance","relevance":"lead negotiator for U.S. delegation","symbol":"","type":"person"},{"asset_class":"sovereign","name":"United States (U.S. delegation)","relevance":"party sending delegation to talks","symbol":"US","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"counterparty in the peace/truce talks","symbol":"IRN","type":"country"},{"asset_class":"sovereign","name":"Pakistan","relevance":"host country for the talks in Islamabad","symbol":"PK","type":"country"},{"asset_class":"","name":"Islamabad","relevance":"city where talks will occur","symbol":"","type":"location"},{"asset_class":"","name":"White House","relevance":"source of the delegation-leadership information","symbol":"","type":"organization"}],"event_type":"geopolitical_risk","information_gaps":["The specific agenda/format of the talks (e.g., cease-fire terms, mediation structure) is not provided in the supplied text.","The year for \u201cSaturday\u201d is not explicitly stated (only \u201cApril 8\u201d appears in the source summary).","The source summary mentions market moves (stocks jump, oil plummets) tied to cease-fire news, but the cleaned article text provided here contains no such details; this linkage cannot be confirmed from the supplied content.","Whether Iran\u2019s delegation leadership is specified is not included in the provided material."],"key_facts":["J.D. Vance is designated to lead the U.S. delegation at talks with Iran.","The talks are scheduled for Saturday.","The talks will take place in Pakistan, in Islamabad (per the provided headline variants).","The information is attributed to the White House (per the provided source summary variants)."],"numeric_claims":[],"primary_claim":"J.D. Vance will lead the U.S. delegation at peace talks with Iran in Pakistan on Saturday.","relevance_score":0.78,"sentiment":"neutral","source_quality":"high","summary":"U.S. Vice President J.D. Vance will lead the U.S. delegation at peace/truce talks with Iran in Islamabad, Pakistan, scheduled for Saturday. The announcement is expected to be a near-term market catalyst given the cease-fire/truce framing reported alongside the news.","topics":["U.S.-Iran talks","cease-fire/truce negotiations","diplomacy","Middle East conflict","market reaction (implied by source summary)"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"Vance to lead U.S. delegation at peace talks with Iran in Pakistan on Saturday Axios Vance to lead US delegation to Iran talks on Saturday Reuters Middle East war live: JD Vance to lead US delegation in Islamabad talks Financial Times Vance to Take the Lead on Iran Talks, Stocks Jump and Oil Plummets on Cease-fire News | What\u2019s News for April 8 WSJ Vice president J D Vance will lead US team for truce talks with Iran in Pakistan: White House The Times of India","title":"Vance to lead U.S. delegation at peace talks with Iran in Pakistan on Saturday - 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_638f072afd8a in signals