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/CBMiuAFBVV95cUxQYmtHMWlHVnZ5YW1rSC1GdFkzektkcF9rRDRycXJ0WlhrZmRjWTB1NWdCTTRSNElKdnVadDhncHhKcVBINDRCM1E2dHpwcEd5cms0dVlhZFlfT1RNZTF4ZEdxbzFWclRDZzBLYy1QVEZFMlZvSThPc0dOQWVZT2tkZTNnb29KRGNxS0FOc0ZIQzgwVWlxUUQ2bzdyekRkWHRVbE9YMXVWRG84R0pUdGJGbDBEdHpXTHNX0gG-AUFVX3lxTE9vLW5HNER4dWlIQ3haWGo2T1duN0RiQ09sRmdxX2tOQk9DY0NCa0thZzRBMS1aYlJSeHQxYW1QTnAwMXVmRHB4MHJLSlF1UWNWaERQdk9HRXNsSVVab1Izb0NMRmJUbW1NNDZmZlV3RXBLMVQ2d20yZkoxbW9uRW5Sakx4QXYzMmZoUXJmQndsQzd2c0hCbmZlVjZMNXRaOVF1X2lCbnZLdVI5YXhfcnlhbncxaUNqVy12UV9WRVE?oc=5","as_of":"2026-04-09T15:51:37.854947+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/CBMiuAFBVV95cUxQYmtHMWlHVnZ5YW1rSC1GdFkzektkcF9rRDRycXJ0WlhrZmRjWTB1NWdCTTRSNElKdnVadDhncHhKcVBINDRCM1E2dHpwcEd5cms0dVlhZFlfT1RNZTF4ZEdxbzFWclRDZzBLYy1QVEZFMlZvSThPc0dOQWVZT2tkZTNnb29KRGNxS0FOc0ZIQzgwVWlxUUQ2bzdyekRkWHRVbE9YMXVWRG84R0pUdGJGbDBEdHpXTHNX0gG-AUFVX3lxTE9vLW5HNER4dWlIQ3haWGo2T1duN0RiQ09sRmdxX2tOQk9DY0NCa0thZzRBMS1aYlJSeHQxYW1QTnAwMXVmRHB4MHJLSlF1UWNWaERQdk9HRXNsSVVab1Izb0NMRmJUbW1NNDZmZlV3RXBLMVQ2d20yZkoxbW9uRW5Sakx4QXYzMmZoUXJmQndsQzd2c0hCbmZlVjZMNXRaOVF1X2lCbnZLdVI5YXhfcnlhbncxaUNqVy12UV9WRVE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9cc43353cffc59a6","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-09T23:46:12.465441+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxQYmtHMWlHVnZ5YW1rSC1GdFkzektkcF9rRDRycXJ0WlhrZmRjWTB1NWdCTTRSNElKdnVadDhncHhKcVBINDRCM1E2dHpwcEd5cms0dVlhZFlfT1RNZTF4ZEdxbzFWclRDZzBLYy1QVEZFMlZvSThPc0dOQWVZT2tkZTNnb29KRGNxS0FOc0ZIQzgwVWlxUUQ2bzdyekRkWHRVbE9YMXVWRG84R0pUdGJGbDBEdHpXTHNX0gG-AUFVX3lxTE9vLW5HNER4dWlIQ3haWGo2T1duN0RiQ09sRmdxX2tOQk9DY0NCa0thZzRBMS1aYlJSeHQxYW1QTnAwMXVmRHB4MHJLSlF1UWNWaERQdk9HRXNsSVVab1Izb0NMRmJUbW1NNDZmZlV3RXBLMVQ2d20yZkoxbW9uRW5Sakx4QXYzMmZoUXJmQndsQzd2c0hCbmZlVjZMNXRaOVF1X2lCbnZLdVI5YXhfcnlhbncxaUNqVy12UV9WRVE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxQYmtHMWlHVnZ5YW1rSC1GdFkzektkcF9rRDRycXJ0WlhrZmRjWTB1NWdCTTRSNElKdnVadDhncHhKcVBINDRCM1E2dHpwcEd5cms0dVlhZFlfT1RNZTF4ZEdxbzFWclRDZzBLYy1QVEZFMlZvSThPc0dOQWVZT2tkZTNnb29KRGNxS0FOc0ZIQzgwVWlxUUQ2bzdyekRkWHRVbE9YMXVWRG84R0pUdGJGbDBEdHpXTHNX0gG-AUFVX3lxTE9vLW5HNER4dWlIQ3haWGo2T1duN0RiQ09sRmdxX2tOQk9DY0NCa0thZzRBMS1aYlJSeHQxYW1QTnAwMXVmRHB4MHJLSlF1UWNWaERQdk9HRXNsSVVab1Izb0NMRmJUbW1NNDZmZlV3RXBLMVQ2d20yZkoxbW9uRW5Sakx4QXYzMmZoUXJmQndsQzd2c0hCbmZlVjZMNXRaOVF1X2lCbnZLdVI5YXhfcnlhbncxaUNqVy12UV9WRVE?oc=5","source_event_id":"evt_31e7bcedbaf5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4627a4b0c074c153","published_at":"2026-04-09T14:07:40+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"n/a","name":"Mark Rutte","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"United States","relevance":"high","symbol":"","type":"country"},{"asset_class":"n/a","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"n/a","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"},{"asset_class":"n/a","name":"NATO allies","relevance":"medium","symbol":"","type":"group"},{"asset_class":"n/a","name":"diplomats","relevance":"medium","symbol":"","type":"source_type"}],"event_type":"geopolitical_risk","information_gaps":["Exact nature of the \u201cHormuz commitments\u201d (e.g., specific operational tasks, number/type of vessels, command arrangements) is not specified in the provided headline.","Whether the commitments are formal pledges, planning steps, or deployment orders is not explicit.","The ceasefire timing and terms are not provided in the supplied text.","CNBC\u2019s full article details are not included; only the headline and the provided source summary are available here."],"key_facts":["CNBC reports that NATO\u2019s Mark Rutte told allies that Trump wants Hormuz commitments within days.","The claim is attributed to diplomats (as reported by CNBC).","The broader context referenced in the provided source summary indicates the request is tied to securing Hormuz after an Iran-US ceasefire.","The provided source summary also mentions Trump saying NATO allies have days to send warships to Hormuz (this is not fully detailed in the CNBC headline text itself, but is included in the supplied multi-source summary)."],"numeric_claims":[{"label":"timeframe","value":"within days"}],"primary_claim":"Mark Rutte told NATO allies that Trump wants Hormuz-related commitments within days, diplomats say (CNBC).","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"NATO Secretary General Mark Rutte told allies that President Trump wants commitments related to securing the Strait of Hormuz within days, according to diplomats cited by CNBC. The request is framed as urgent planning following a ceasefire in the Iran-US conflict.","topics":["NATO coordination","Iran-US conflict","Strait of Hormuz security","urgent alliance commitments","naval deployments (implied)","ceasefire follow-on planning"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"NATO's Rutte told allies Trump wants Hormuz commitments within days, diplomats say CNBC Iran War: US Asks Allies for Quick Plans to Secure Hormuz After Ceasefire Bloomberg.com Iran-US war latest: Trump says Nato allies have days to send warships to Hormuz The Telegraph Frantic Trump Demands Allies Urgently Fix His Mess in Middle East The Daily Beast Nato \u2018very disappointing\u2019, says Trump, in fresh attack ahead of Rutte speech \u2013 Europe live The Guardian","title":"NATO's Rutte told allies Trump wants Hormuz commitments within days, diplomats say - CNBC","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_30fe92a0dd96 in signals