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/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

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_ebf0f0047970 in signals