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/CBMihwFBVV95cUxON1RZaXV4Q01xMUFoYzJNWS1zTFE1MzBMOHlvTHNadHg3bkxWbVphMTVOdzhoWURXTUhyTXRoOTI3QmYyMzFoMk9ocng0bUpOWC16eWdVcUNzWlNqc1Uzb0hVdGR2LW5EWVJTcnprbFBCWTdHeVE2cTFWMGg0dDJFSHBrZDBuaGM?oc=5","as_of":"2026-04-08T19:34:52.356349+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/CBMihwFBVV95cUxON1RZaXV4Q01xMUFoYzJNWS1zTFE1MzBMOHlvTHNadHg3bkxWbVphMTVOdzhoWURXTUhyTXRoOTI3QmYyMzFoMk9ocng0bUpOWC16eWdVcUNzWlNqc1Uzb0hVdGR2LW5EWVJTcnprbFBCWTdHeVE2cTFWMGg0dDJFSHBrZDBuaGM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d95d9a051bbac9cf","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:05:26.410208+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxON1RZaXV4Q01xMUFoYzJNWS1zTFE1MzBMOHlvTHNadHg3bkxWbVphMTVOdzhoWURXTUhyTXRoOTI3QmYyMzFoMk9ocng0bUpOWC16eWdVcUNzWlNqc1Uzb0hVdGR2LW5EWVJTcnprbFBCWTdHeVE2cTFWMGg0dDJFSHBrZDBuaGM?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/CBMihwFBVV95cUxON1RZaXV4Q01xMUFoYzJNWS1zTFE1MzBMOHlvTHNadHg3bkxWbVphMTVOdzhoWURXTUhyTXRoOTI3QmYyMzFoMk9ocng0bUpOWC16eWdVcUNzWlNqc1Uzb0hVdGR2LW5EWVJTcnprbFBCWTdHeVE2cTFWMGg0dDJFSHBrZDBuaGM?oc=5","source_event_id":"evt_b9dd04ebfcd8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9133477f2f98e323","published_at":"2026-04-08T16:38:51+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"medium","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"medium","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Kuwait","relevance":"low","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/boilerplate, not the actual article content; extraction is therefore based on the headline and the provided source summary references.","\u201cMostly holds\u201d is not quantified (e.g., which strikes stopped, which continued, and on what timeline).","The specific terms of the ceasefire and the exact nature of alleged violations are not included in the provided text.","Near-term catalyst timing beyond the two-week window is not specified in the provided headline/summary."],"key_facts":["A two-week ceasefire between the U.S. and Iran was agreed (per Washington Post headline).","After the agreement, a halt in strikes is described as \u201cmostly\u201d holding (per Washington Post headline).","Other referenced live updates indicate continued Israel attacks in Lebanon (NYT/Reuters references in provided source summary).","Other referenced live updates indicate Iran accuses the U.S. of violating parts of the deal framework and calls the ceasefire \u201cunreasonable\u201d (AP reference in provided source summary).","Other referenced live updates indicate Iran strikes Kuwait after the U.S.-Iran ceasefire was agreed (Reuters reference in provided source summary)."],"numeric_claims":[{"label":"ceasefire duration","value":"2 weeks"}],"primary_claim":"Trump and Iran agreed to a two-week ceasefire, and the halt in strikes is mostly holding afterward.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that a mostly holding halt in strikes between the U.S. and Iran continues after President Trump and Iran agreed to a two-week ceasefire. The ceasefire\u2019s stability is implied but not guaranteed, given ongoing reports of related regional attacks and accusations in other live updates.","topics":["U.S.-Iran ceasefire","military strikes halt","Middle East conflict","regional escalation risk","ceasefire monitoring/violations"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Halt in strikes mostly holds after Trump, Iran agree to 2-week ceasefire The Washington Post Iran War Live Updates: U.S.-Iran Cease-Fire Shaky as Israel Strikes Lebanon and Confusion Grows Over Strait The New York Times Ceasefire In Iran And The State Of The US Job Market : 1A npr.org Live updates: Iran accuses US of violating parts of deal framework, says ceasefire 'unreasonable' AP News Iran war live: Israel continues to attack Lebanon and Tehran strikes Kuwait after US-Iran ceasefire agreed Reuters","title":"Halt in strikes mostly holds after Trump, Iran agree to 2-week ceasefire - 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_29e512334fdc in signals