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/CBMifkFVX3lxTE5sY2hUZ05DNmtCMG5XaGhzWkJoVlpZZkwwd2xUQzVOUXh3WWVTb2ZCZGxuVlBXak1iakRFNzcwZER0NUFMUy1zclNibFZtdnZuZnFILTh4eE5iZHdPTzEzUURxQ2pxeU11T05tMHBKT3E4amt6eTgxcWI0UHYzUQ?oc=5","as_of":"2026-04-09T06:04:20.770582+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/CBMifkFVX3lxTE5sY2hUZ05DNmtCMG5XaGhzWkJoVlpZZkwwd2xUQzVOUXh3WWVTb2ZCZGxuVlBXak1iakRFNzcwZER0NUFMUy1zclNibFZtdnZuZnFILTh4eE5iZHdPTzEzUURxQ2pxeU11T05tMHBKT3E4amt6eTgxcWI0UHYzUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e1282300f0ca2bc0","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:45:16.808672+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE5sY2hUZ05DNmtCMG5XaGhzWkJoVlpZZkwwd2xUQzVOUXh3WWVTb2ZCZGxuVlBXak1iakRFNzcwZER0NUFMUy1zclNibFZtdnZuZnFILTh4eE5iZHdPTzEzUURxQ2pxeU11T05tMHBKT3E4amt6eTgxcWI0UHYzUQ?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/CBMifkFVX3lxTE5sY2hUZ05DNmtCMG5XaGhzWkJoVlpZZkwwd2xUQzVOUXh3WWVTb2ZCZGxuVlBXak1iakRFNzcwZER0NUFMUy1zclNibFZtdnZuZnFILTh4eE5iZHdPTzEzUURxQ2pxeU11T05tMHBKT3E4amt6eTgxcWI0UHYzUQ?oc=5","source_event_id":"evt_95a27e5bb9ae","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9480767760e2f3b9","published_at":"2026-04-09T01:51:08+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"geography","name":"Tehran","relevance":"medium","symbol":"","type":"city (Iran)"},{"asset_class":"political_actor","name":"Donald Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"media","name":"New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"AP News","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"Fox News","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Independent","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"conflict","information_gaps":["The provided text does not include the specific terms of the cease-fire (scope, start time, enforcement, or conditions).","The specific contents of Iran\u2019s 10-point plan are not enumerated in the provided material.","No explicit date of the cease-fire start/end is included in the provided excerpt.","The signal does not specify which US administration officials or Iranian counterparts directly negotiated the cease-fire.","Market/sector impacts are not stated; any directional economic implications would be speculative."],"key_facts":["Reporting describes a \u201c36 hours of chaos\u201d scramble for a cease-fire involving Iran and the US (New York Times headline).","Iran is reported to have revealed a \u201c10-point plan for peace with the US\u201d (Fox News referenced in provided source summary).","AP reporting characterizes a shift from Trump threatening Iran\u2019s \u201cannihilation\u201d to agreeing to a \u201c2-week ceasefire\u201d with Tehran.","The Independent frames the ceasefire as \u201crelief but not a cure\u201d for broader instability attributed to Trump\u2019s actions (opinion framing)."],"numeric_claims":[{"label":"ceasefire duration","value":"2 weeks"},{"label":"peace plan points","value":"10"},{"label":"time window described","value":"36 hours"}],"primary_claim":"Iran and the US agreed to a short ceasefire (reported as two weeks), following a chaotic 36-hour scramble, while Iran revealed a 10-point plan for peace with the US.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Multiple outlets report a rapidly negotiated cease-fire between Iran and the US, framed as a short-term relief amid broader instability. Iran is also said to have presented a 10-point peace plan, and reporting highlights a shift from earlier US threats to agreeing to a two-week ceasefire.","topics":["ceasefire","Iran-US relations","diplomacy","peace plan","US foreign policy","regional conflict risk"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"36 Hours of Chaos: The Scramble for a Cease-Fire in Iran The New York Times Iran reveals 10-point plan for peace with the US \u2013 here's what's in it Fox News After Cease-Fire, Iranians Are Left to Pick Up the Pieces The New York Times How Trump went from threatening Iran's annihilation to agreeing to a 2-week ceasefire with Tehran AP News The Iran ceasefire is a relief but not a cure for the madness Trump has brought to the world The Independent","title":"36 Hours of Chaos: The Scramble for a Cease-Fire in Iran - 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_f226556e28c9 in signals