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/CBMifkFVX3lxTFAtU3Rwc2F0VHV1VzIycDJqTFJTeEZiWFo2eE5tajhJanhDdVp3VEM5NU5Ea2FrVDM3YXFRZUFkeWZKUGdxYUtlM2NJRURnVFFjOG9Bc1haamF2RFpCOUU0clJXUUJxZXRUNC1CZ084UWZJR05DUVRaYUktOTQyZw?oc=5","as_of":"2026-04-08T19:34:52.410459+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/CBMifkFVX3lxTFAtU3Rwc2F0VHV1VzIycDJqTFJTeEZiWFo2eE5tajhJanhDdVp3VEM5NU5Ea2FrVDM3YXFRZUFkeWZKUGdxYUtlM2NJRURnVFFjOG9Bc1haamF2RFpCOUU0clJXUUJxZXRUNC1CZ084UWZJR05DUVRaYUktOTQyZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a9c5929b874cc6bb","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:06:28.244022+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTFAtU3Rwc2F0VHV1VzIycDJqTFJTeEZiWFo2eE5tajhJanhDdVp3VEM5NU5Ea2FrVDM3YXFRZUFkeWZKUGdxYUtlM2NJRURnVFFjOG9Bc1haamF2RFpCOUU0clJXUUJxZXRUNC1CZ084UWZJR05DUVRaYUktOTQyZw?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/CBMifkFVX3lxTFAtU3Rwc2F0VHV1VzIycDJqTFJTeEZiWFo2eE5tajhJanhDdVp3VEM5NU5Ea2FrVDM3YXFRZUFkeWZKUGdxYUtlM2NJRURnVFFjOG9Bc1haamF2RFpCOUU0clJXUUJxZXRUNC1CZ084UWZJR05DUVRaYUktOTQyZw?oc=5","source_event_id":"evt_881727d2bcce","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1618ae333df9e7ea","published_at":"2026-04-08T15:11:29+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign_state","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign_state","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"","name":"New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Axios","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"The Atlantic","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"","name":"War on the Rocks","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Wall Street Journal","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the substantive article content, so specific \u201caccomplishments\u201d are not extractable from the provided text.","No concrete details are given about the ceasefire terms, parties involved, or what contradictions/confusion specifically refer to.","The signal does not specify the exact date of the five-week mark or the start date of the war referenced.","No measurable outcomes (e.g., policy changes, agreements, troop movements, sanctions changes) are stated in the provided text."],"key_facts":["The New York Times headline indicates an article assessing what Trump has accomplished in Iran after five weeks of war.","The provided source summary states that an Iran ceasefire is clouded by confusion and contradictions (attributed to Axios in the summary).","The provided source summary references additional commentary pieces about the Iran war\u2019s consensus and widening impacts (The Atlantic, War on the Rocks, WSJ, and an opinion piece)."],"numeric_claims":[{"label":"timeframe","value":"5 weeks"}],"primary_claim":"After five weeks of war, the New York Times examines what Trump has accomplished in Iran, amid a ceasefire that is unclear due to conflicting accounts.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The New York Times frames an assessment of what Donald Trump has achieved regarding Iran after five weeks of war, while noting that an Iran ceasefire is clouded by confusion and contradictions.","topics":["Iran war","ceasefire","U.S.-Iran relations","Trump foreign policy","Middle East conflict spillovers"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"After 5 Weeks of War, a Look at What Trump Has Accomplished in Iran The New York Times Iran ceasefire clouded by confusion, contradictions Axios Three Things the Consensus Gets Wrong About the Iran War The Atlantic The Iran War\u2019s Widening Impacts in the Middle East and North Africa War on the Rocks Opinion | The Iran War Around the World WSJ","title":"After 5 Weeks of War, a Look at What Trump Has Accomplished 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_f0fa82be69a6 in signals