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-10T00:52:01.578640+00:00","dedupe_key":"signal_enriched:news_delta:e1a1c975302b17e8","evidence_event_ids":["evt_baa8ea611709"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNaFVRV2tNc3ZZWURCSWdzUndhdURYNGQ1U3NXSzRXSThROC1aXzZDOHZXdzZXbWJhaHdFLS0wM1FYTGVoV0RHNFJzdkZZYmExdmNtVGx3dHdlY2F4RUhNcnc2UngtYU90LUNDMHpGNVBnZmhlU0FoODh4S3RrNEZva1BSTFpPTVAySXU0Z3ln?oc=5","as_of":"2026-04-10T00:52:01.578640+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/CBMijgFBVV95cUxNaFVRV2tNc3ZZWURCSWdzUndhdURYNGQ1U3NXSzRXSThROC1aXzZDOHZXdzZXbWJhaHdFLS0wM1FYTGVoV0RHNFJzdkZZYmExdmNtVGx3dHdlY2F4RUhNcnc2UngtYU90LUNDMHpGNVBnZmhlU0FoODh4S3RrNEZva1BSTFpPTVAySXU0Z3ln?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6fd1014f03ab51e0","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:59:50.383936+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNaFVRV2tNc3ZZWURCSWdzUndhdURYNGQ1U3NXSzRXSThROC1aXzZDOHZXdzZXbWJhaHdFLS0wM1FYTGVoV0RHNFJzdkZZYmExdmNtVGx3dHdlY2F4RUhNcnc2UngtYU90LUNDMHpGNVBnZmhlU0FoODh4S3RrNEZva1BSTFpPTVAySXU0Z3ln?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxNaFVRV2tNc3ZZWURCSWdzUndhdURYNGQ1U3NXSzRXSThROC1aXzZDOHZXdzZXbWJhaHdFLS0wM1FYTGVoV0RHNFJzdkZZYmExdmNtVGx3dHdlY2F4RUhNcnc2UngtYU90LUNDMHpGNVBnZmhlU0FoODh4S3RrNEZva1BSTFpPTVAySXU0Z3ln?oc=5","source_event_id":"evt_baa8ea611709","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"86e6af104f53fff4","published_at":"2026-04-09T19:55:42+00:00","publisher_domain":"politico.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 (White House)","relevance":"high","symbol":"","type":"government_body"},{"asset_class":"","name":"Politico","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Washington Post","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Al Jazeera","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Wall Street Journal","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML fragments and does not include the substantive article content, so details of the ceasefire \u201ctest\u201d (what specific incident or breach) are not verifiable from the provided text.","No specific timeline/catalyst date for when the ceasefire will be tested is included in the provided headline and summary.","The exact nature of the \u201cconfusion\u201d and \u201ccontradictions\u201d (who said what, and when) is not specified in the provided material.","The specific items in Iran\u2019s 10-point proposal and the specific U.S. demands are not enumerated in the provided text, only that comparisons are discussed."],"key_facts":["Politico headline indicates Trump\u2019s ceasefire with Iran is being tested while the world watches.","Source summary states the White House is struggling to prop up the truce.","Source summary characterizes the situation as involving confusion and contradictions.","Other referenced coverage discusses Iran\u2019s 10 demands and which the U.S. might accept.","Other referenced coverage discusses what is in Iran\u2019s 10-point proposal and how it compares to U.S. demands."],"numeric_claims":[{"label":"Iran demands","value":"10"}],"primary_claim":"Trump\u2019s ceasefire with Iran is currently under strain and is being tested as the world watches closely, with the White House struggling to sustain the truce amid confusion and contradictions.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Politico reports that Trump\u2019s ceasefire with Iran is being stress-tested amid global scrutiny, with the White House facing difficulty maintaining the truce. Multiple outlets referenced in the source summary focus on confusion/contradictions and on Iran\u2019s proposed demands versus U.S. demands.","topics":["ceasefire","Iran-U.S. negotiations","White House messaging","demand comparison","truce stability","geopolitical risk"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump\u2019s ceasefire with Iran is tested as world anxiously watches Politico White House struggles to prop up truce marked by confusion, contradictions The Washington Post This is America Al Jazeera A Closer Look at Iran\u2019s 10 Demands\u2014and Which the U.S. Might Accept WSJ What Is In Iran\u2019s 10-Point Proposal, and How Does It Compare to U.S. Demands? The New York Times","title":"Trump\u2019s ceasefire with Iran is tested as world anxiously watches - Politico","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 11732 in events