SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T19:34:52.410459+00:00","dedupe_key":"signal_enriched:news_delta:47dd5b16c5b2e713","evidence_event_ids":["evt_881727d2bcce"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 8247 in events