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/CBMilgFBVV95cUxQc1l1cWJqS0MxQ3A0ZHB5VVZXUHZ4Mnpoc3EwS0JVRFd4Wm85ZVFNRFp2dTZlRE5FaUtFVlc0WXNidVlEX0VjX214b3luakFuMjVIbTBRRVVUM1VUeS1iS3pIWDF1LW9UYkhZZHdWUmxMZXNKa3B4Tm5obWljQnhvcmJ5REZPTG1uUFRnSlY2aDE5bXdoc1E?oc=5","as_of":"2026-04-09T20:52:33.940270+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/CBMilgFBVV95cUxQc1l1cWJqS0MxQ3A0ZHB5VVZXUHZ4Mnpoc3EwS0JVRFd4Wm85ZVFNRFp2dTZlRE5FaUtFVlc0WXNidVlEX0VjX214b3luakFuMjVIbTBRRVVUM1VUeS1iS3pIWDF1LW9UYkhZZHdWUmxMZXNKa3B4Tm5obWljQnhvcmJ5REZPTG1uUFRnSlY2aDE5bXdoc1E?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8a44a64600835eb3","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-10T00:33:57.686937+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxQc1l1cWJqS0MxQ3A0ZHB5VVZXUHZ4Mnpoc3EwS0JVRFd4Wm85ZVFNRFp2dTZlRE5FaUtFVlc0WXNidVlEX0VjX214b3luakFuMjVIbTBRRVVUM1VUeS1iS3pIWDF1LW9UYkhZZHdWUmxMZXNKa3B4Tm5obWljQnhvcmJ5REZPTG1uUFRnSlY2aDE5bXdoc1E?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxQc1l1cWJqS0MxQ3A0ZHB5VVZXUHZ4Mnpoc3EwS0JVRFd4Wm85ZVFNRFp2dTZlRE5FaUtFVlc0WXNidVlEX0VjX214b3luakFuMjVIbTBRRVVUM1VUeS1iS3pIWDF1LW9UYkhZZHdWUmxMZXNKa3B4Tm5obWljQnhvcmJ5REZPTG1uUFRnSlY2aDE5bXdoc1E?oc=5","source_event_id":"evt_5bbb8a8c29e3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3f0b4eb544519c4d","published_at":"2026-04-09T16:00:39+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"White House","relevance":"high","symbol":"","type":"government_body"},{"asset_class":"sovereign_state","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"government_office","name":"Supreme Leader of Iran","relevance":"medium","symbol":"","type":"person_or_office"},{"asset_class":"media","name":"The Washington Post","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"CNN","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Times of Israel","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Wall Street Journal (WSJ)","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The provided article text is not actually the Washington Post content (it appears to be page boilerplate/CSS), so the extraction relies on the provided headline and source summary only.","No specific ceasefire terms, timelines, or dates are included in the provided signal.","The direction of market/operational impact is not explicitly stated; only geopolitical risk implications can be inferred.","It is unclear which exact \u201ccontradictions\u201d the Washington Post refers to (e.g., who said what, and when).","No confirmation is provided on whether the truce is currently holding versus failing; only that the White House is struggling to prop it up."],"key_facts":["The Washington Post headline states the White House is struggling to support an Iran truce due to confusion and contradictions.","The Washington Post framing includes the idea that \u201cThis War Isn\u2019t Over\u201d and discusses what has to happen next (as referenced in the provided source summary).","CNN is referenced as saying the two sides cannot even agree on what is in the Iran war ceasefire.","WSJ is referenced as reporting that Iran\u2019s president says the ceasefire was approved by Iran\u2019s supreme leader.","The Times of Israel is referenced as carrying the claim about supreme leader approval.","A WSJ-related reference mentions Iran\u2019s \u201c10 Demands\u201d and which the U.S. might accept (as included in the provided source summary)."],"numeric_claims":[{"label":"10 demands","value":"10"}],"primary_claim":"The White House is struggling to prop up an Iran truce because of confusion and contradictions about the ceasefire terms.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that the White House is having difficulty sustaining an Iran-related truce, citing confusion and contradictions about what the ceasefire entails. Other referenced coverage highlights disputes over the ceasefire terms and claims about approval by Iran\u2019s supreme leader.","topics":["Iran ceasefire","U.S.-Iran relations","truce/ceasefire terms","diplomatic confusion","supreme leader approval claim","media debate over next steps"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"White House struggles to prop up truce marked by confusion, contradictions The Washington Post \u2018This War Isn\u2019t Over\u2019: 3 Opinion Writers Debate What Has to Happen Next in Iran The New York Times What\u2019s in the Iran war ceasefire? The two sides can\u2019t seem to even agree on that. CNN A Closer Look at Iran\u2019s 10 Demands\u2014and Which the U.S. Might Accept WSJ Iran\u2019s president says ceasefire was approved by the supreme leader The Times of Israel","title":"White House struggles to prop up truce marked by confusion, contradictions - The Washington Post","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_2d9829695cf5 in signals