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/CBMiWkFVX3lxTE9xSDhiVGVmWGEwQWUwblR0bEJTQU5TLWU2aEZqcFBDTlZVOWNHQmVPcjBFSUZKaUhMUDBrc1dKZTNiRERwYlQzRlU2azNuVnR6V0NkZ3pvQjd4QQ?oc=5","as_of":"2026-04-09T03:57:11.884494+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/CBMiWkFVX3lxTE9xSDhiVGVmWGEwQWUwblR0bEJTQU5TLWU2aEZqcFBDTlZVOWNHQmVPcjBFSUZKaUhMUDBrc1dKZTNiRERwYlQzRlU2azNuVnR6V0NkZ3pvQjd4QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4d9a15a9859b9793","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-09T22:34:40.317700+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9xSDhiVGVmWGEwQWUwblR0bEJTQU5TLWU2aEZqcFBDTlZVOWNHQmVPcjBFSUZKaUhMUDBrc1dKZTNiRERwYlQzRlU2azNuVnR6V0NkZ3pvQjd4QQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9xSDhiVGVmWGEwQWUwblR0bEJTQU5TLWU2aEZqcFBDTlZVOWNHQmVPcjBFSUZKaUhMUDBrc1dKZTNiRERwYlQzRlU2azNuVnR6V0NkZ3pvQjd4QQ?oc=5","source_event_id":"evt_456eb30805db","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a6a780e7f67b408c","published_at":"2026-04-09T01:46:04+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"political_actor","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_actor","name":"Mark Rutte","relevance":"high","symbol":"","type":"person"},{"asset_class":"defense_alliance","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"news_source","name":"BBC","relevance":"medium","symbol":"","type":"media"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no readable substantive content beyond page styling, so details from the BBC article body are not available here.","Specific claims Trump made about NATO (e.g., burden-sharing, spending, withdrawal) are not included in the provided BBC headline text.","Timing (exact date/time of the meeting and subsequent remarks) is not specified in the provided material.","Whether Trump\u2019s comments imply an imminent policy action (e.g., withdrawal) is not confirmed by the BBC headline alone; other outlet summaries mention withdrawal but are not part of the BBC text shown."],"key_facts":["BBC reports Trump continued attacking NATO after meeting with NATO Secretary General Mark Rutte.","The meeting with Mark Rutte occurred immediately prior to the continued attacks (as framed by the headline)."],"numeric_claims":[],"primary_claim":"Trump continued to attack NATO after meeting with NATO alliance chief Mark Rutte, per BBC.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"After meeting with NATO Secretary General Mark Rutte, Donald Trump continued publicly attacking NATO, according to BBC. The signal points to an ongoing NATO-US political rift as a near-term catalyst.","topics":["NATO","US politics","Trump","alliance relations","Iran war (context from provided source summaries)"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Trump continues to attack Nato after meeting with alliance chief Mark Rutte BBC 'Poorly run, piece of ice': Trump targets Greenland again as Iran war deepens NATO rift CNBC Exclusive | Trump Team Explores Punishment for NATO Countries That Didn\u2019t Support Iran War WSJ Trump vents at NATO but avoids rupture after meeting with alliance\u2019s leader The Washington Post Trump administration signals it is mulling NATO withdrawal after Iran war Al Jazeera","title":"Trump continues to attack Nato after meeting with alliance chief Mark Rutte - BBC","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_654fe3240006 in signals