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/CBMisgFBVV95cUxQSW9wdlhDVUN2RG9JbUV1cE1iNjNKN19qc0RZUVZZZjkxYUVjRUZZZF9uSnhDRFVlRHhsT3dDOHZ3Mi1FS2ZNQVZCaHl6b0xUVTBUQVlqTFZwbHlMdkE4SEJnSElMemRVZUlBUzdoQ2MzRkxCV3RWU1gtdlNOTVpuZnJEaVhmalZsZWRBN0xRUElmb2lnTF9mR2dnVFdoQ2tjVWZkbkV6MXhlc1V5Vloxd3VR?oc=5","as_of":"2026-04-10T13:59:13.920004+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/CBMisgFBVV95cUxQSW9wdlhDVUN2RG9JbUV1cE1iNjNKN19qc0RZUVZZZjkxYUVjRUZZZF9uSnhDRFVlRHhsT3dDOHZ3Mi1FS2ZNQVZCaHl6b0xUVTBUQVlqTFZwbHlMdkE4SEJnSElMemRVZUlBUzdoQ2MzRkxCV3RWU1gtdlNOTVpuZnJEaVhmalZsZWRBN0xRUElmb2lnTF9mR2dnVFdoQ2tjVWZkbkV6MXhlc1V5Vloxd3VR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7296953291c6b97a","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-10T14:05:08.361116+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxQSW9wdlhDVUN2RG9JbUV1cE1iNjNKN19qc0RZUVZZZjkxYUVjRUZZZF9uSnhDRFVlRHhsT3dDOHZ3Mi1FS2ZNQVZCaHl6b0xUVTBUQVlqTFZwbHlMdkE4SEJnSElMemRVZUlBUzdoQ2MzRkxCV3RWU1gtdlNOTVpuZnJEaVhmalZsZWRBN0xRUElmb2lnTF9mR2dnVFdoQ2tjVWZkbkV6MXhlc1V5Vloxd3VR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"euronews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxQSW9wdlhDVUN2RG9JbUV1cE1iNjNKN19qc0RZUVZZZjkxYUVjRUZZZF9uSnhDRFVlRHhsT3dDOHZ3Mi1FS2ZNQVZCaHl6b0xUVTBUQVlqTFZwbHlMdkE4SEJnSElMemRVZUlBUzdoQ2MzRkxCV3RWU1gtdlNOTVpuZnJEaVhmalZsZWRBN0xRUElmb2lnTF9mR2dnVFdoQ2tjVWZkbkV6MXhlc1V5Vloxd3VR?oc=5","source_event_id":"evt_2aaec0845aa0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"178f298199a2c415","published_at":"2026-04-10T08:41:00+00:00","publisher_domain":"euronews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"security_alliance","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"geopolitical_chokepoint","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"location"},{"asset_class":"sovereign_state","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["The article text provided is not available beyond page styling/HTML, so details of the ultimatum (exact wording, conditions, enforcement, and which NATO members are targeted) are not verifiable here.","No confirmation is provided in the supplied text about whether the ultimatum is tied to specific actions (e.g., naval escort, sanctions, ceasefire, or military operations).","No explicit near-term date (calendar day) is given\u2014only the relative timeframe 'within days'.","No direct market/transport impact metrics (shipping rates, oil price moves, insurance premiums) are included in the supplied content."],"key_facts":["Euronews headline states Trump issued a NATO ultimatum to reopen the Strait of Hormuz.","The ultimatum is described as requiring action 'within days'.","The provided source summary text characterizes the move as pressure/bullying toward NATO (framing)."],"numeric_claims":[{"label":"timeframe","value":"within days"}],"primary_claim":"Trump issued a NATO ultimatum demanding the Strait of Hormuz be reopened within days.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Euronews reports that Trump issued an ultimatum to NATO to reopen the Strait of Hormuz within days. The headline frames this as renewed pressure on NATO amid ongoing Iran-related security concerns.","topics":["NATO","Middle East security","Strait of Hormuz","Iran war","maritime chokepoint","US foreign policy ultimatum"]},"source":"Euronews.com","source_domain":"euronews.com","source_url":"https://www.euronews.com","summary":"Trump issues NATO ultimatum to reopen Strait of Hormuz 'within days' Euronews.com Trump is bullying NATO again. But Americans like the alliance CNN \u2018Closer to a break than ever\u2019: Can NATO survive if Trump pulls the US out? Al Jazeera What Trump\u2019s blowup with Rutte was really about Politico Amid Trump\u2019s Threats, NATO Labors to Survive the Iran War The New York Times","title":"Trump issues NATO ultimatum to reopen Strait of Hormuz 'within days' - Euronews.com","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_7d6e066b5fa2 in signals