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/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5","as_of":"2026-04-08T09:38:01.011171+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/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0179e58c15184357","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-08T09:38:37.869772+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMibkFVX3lxTE1zdWo2YzhXbFFWUy00S2ZTXzFSS2NNS1RROGtzM1JqOU9jUnQ1SmZNRGdlRGlQdGt3LUNvdzdUY3lKaHRlMjBXMS1yOTg4a0lSTzZ4Y2lxc3kyNC1OZ0JpNkduTm1oV1RVSkZnbHdR?oc=5","source_event_id":"evt_df865c4b9a15","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8c2b67307e88d4de","published_at":"2026-04-08T07:55:01+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"United States","relevance":"direct party to ceasefire agreement","symbol":"","type":"country"},{"asset_class":"","name":"Iran","relevance":"direct party to ceasefire agreement","symbol":"","type":"country"},{"asset_class":"","name":"Strait of Hormuz","relevance":"mentioned as a key unresolved issue","symbol":"","type":"geographic chokepoint"},{"asset_class":"","name":"Trump","relevance":"mentioned in source summary as backing down; questions remain","symbol":"","type":"person"},{"asset_class":"","name":"NPR","relevance":"headline source","symbol":"","type":"publisher"},{"asset_class":"","name":"Reuters","relevance":"included in source summary as reporting talks timing and reactions","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Times","relevance":"included in source summary","symbol":"","type":"publisher"},{"asset_class":"","name":"WSJ","relevance":"included in source summary","symbol":"","type":"publisher"},{"asset_class":"","name":"Al Jazeera","relevance":"included in source summary","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no substantive content beyond styling/HTML; therefore, details of the ceasefire terms, start/end dates, and enforcement mechanisms are not available in the provided text.","No specific date for when the two-week ceasefire begins is stated in the provided text.","No specific details of what \u201ctalks\u201d cover or when they will start are provided beyond \u201csoon.\u201d","The provided text does not specify which parties (e.g., specific governments/armed groups) are included in the ceasefire beyond the U.S. and Iran."],"key_facts":["U.S. and Iran agreed to a ceasefire lasting two weeks (per NPR headline).","Source summary indicates there are questions remaining over Iran and the Strait of Hormuz.","Source summary indicates Trump \u201cbacks down,\u201d but questions remain (as characterized in the provided text).","Source summary indicates Iran says talks to begin soon (timing described as soon, without a specific date).","Source summary indicates Gulf and Arab nations react to the ceasefire announcement."],"numeric_claims":[{"label":"ceasefire duration","value":"2 weeks"}],"primary_claim":"The U.S. and Iran agreed to a two-week ceasefire.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"The U.S. and Iran have agreed to a two-week ceasefire, with reporting noting uncertainty about Iran\u2019s position and issues involving the Strait of Hormuz. Multiple outlets frame the move as a near-term pause while talks are expected to begin soon.","topics":["U.S.-Iran ceasefire","Middle East conflict","diplomacy","Strait of Hormuz","ceasefire duration (two weeks)","talks timeline (soon)","regional reactions"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"U.S. and Iran agree to 2-week ceasefire NPR Trump Backs Down, but Questions Remain Over Iran and the Strait of Hormuz The New York Times What\u2019s in Iran\u2019s Proposed Peace Plan WSJ Iran war live: Trump announces two-week ceasefire as Iran says talks to begin soon Reuters Gulf, Arab nations react to Iran-US ceasefire announcement Al Jazeera","title":"U.S. and Iran agree to 2-week ceasefire - NPR","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_bf3724976a3a in signals