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/CBMiggFBVV95cUxQM3drMlp3aHBmczNad04wSS00NXhWMlFmeEJzZlBOZzBUU2d2SzV4Z3Q3eXZIVzVwVVhieWtZa2I3TUJ2dXJCTk1wWFlZRkFZY1JuR0VwcE9zSTM0Z2huTTVsQUVSMXBYS0w2czRzd0VRTktRRDNlZ2V1Yl9CdG9XQnln?oc=5","as_of":"2026-04-09T18:49:37.282205+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/CBMiggFBVV95cUxQM3drMlp3aHBmczNad04wSS00NXhWMlFmeEJzZlBOZzBUU2d2SzV4Z3Q3eXZIVzVwVVhieWtZa2I3TUJ2dXJCTk1wWFlZRkFZY1JuR0VwcE9zSTM0Z2huTTVsQUVSMXBYS0w2czRzd0VRTktRRDNlZ2V1Yl9CdG9XQnln?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c01307886258f06d","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:20:46.480067+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQM3drMlp3aHBmczNad04wSS00NXhWMlFmeEJzZlBOZzBUU2d2SzV4Z3Q3eXZIVzVwVVhieWtZa2I3TUJ2dXJCTk1wWFlZRkFZY1JuR0VwcE9zSTM0Z2huTTVsQUVSMXBYS0w2czRzd0VRTktRRDNlZ2V1Yl9CdG9XQnln?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/CBMiggFBVV95cUxQM3drMlp3aHBmczNad04wSS00NXhWMlFmeEJzZlBOZzBUU2d2SzV4Z3Q3eXZIVzVwVVhieWtZa2I3TUJ2dXJCTk1wWFlZRkFZY1JuR0VwcE9zSTM0Z2huTTVsQUVSMXBYS0w2czRzd0VRTktRRDNlZ2V1Yl9CdG9XQnln?oc=5","source_event_id":"evt_6f9ddd49f34b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"39467b3b01f99a38","published_at":"2026-04-09T12:15:56+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran\u2019s leaders","relevance":"high","symbol":"","type":"political actors"},{"asset_class":"sovereign","name":"Donald Trump","relevance":"medium","symbol":"","type":"political actor"},{"asset_class":"sovereign","name":"United States","relevance":"medium","symbol":"","type":"country"},{"asset_class":"media","name":"The New York Times","relevance":"low","symbol":"","type":"media outlet"}],"event_type":"geopolitical_risk","information_gaps":["No specific details are provided about what the \u201cnew cards\u201d are (e.g., policy changes, negotiations, military posture, or diplomatic offers).","No concrete cease-fire terms, start/end dates, or verification mechanisms are included in the provided text.","The excerpt does not specify which Iranian leaders are referenced or their exact roles/titles.","The provided text does not state the market/economic implications directly; any directional impact is inferred from geopolitical framing only."],"key_facts":["The New York Times headline states that Iran\u2019s \u201cbattered leaders\u201d are emerging from war \u201cconfident\u201d and \u201cwith new cards.\u201d","The provided source summary mentions \u201cA Cease-Fire for Now in Iran\u201d (timing described as temporary/for now).","The provided source summary characterizes the cease-fire as \u201ca blow to American credibility.\u201d","The provided source summary includes a claim that after Trump pauses the war, Iranians \u201cfly flags of victory, not surrender.\u201d"],"numeric_claims":[],"primary_claim":"Iran\u2019s leaders are emerging from the war confident and with new leverage, according to a New York Times headline.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The New York Times headline indicates that Iran\u2019s leadership is emerging from a period of war with renewed confidence and leverage (\u201cnew cards\u201d). The provided source summary also suggests a temporary cease-fire and frames it as a credibility blow for the U.S., implying near-term diplomatic/messaging impact rather than a definitive end to hostilities.","topics":["Iran","U.S.-Iran conflict","cease-fire","diplomacy","political messaging","leadership confidence"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Iran\u2019s Battered Leaders Emerge From War Confident \u2014 and With New Cards The New York Times A Cease-Fire for Now in Iran, but a Blow to American Credibility The New York Times After Trump pauses war, Iranians fly flags of victory, not surrender The Washington Post Donald Trump is the war\u2019s biggest loser The Economist MORNING GLORY: President Trump leads the West to a big win against Iran Fox News","title":"Iran\u2019s Battered Leaders Emerge From War Confident \u2014 and With New Cards - 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_529aa1f4db09 in signals