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/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5","as_of":"2026-04-09T06:55:02.633556+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/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2d75c6681184fce3","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:49:25.179385+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQaXlSU2o4bVc4R2ZEM2hNNEdQRFlpRXM4RWNlOV8zTlpsWl92MUxVSHFnNWc4UlUzOVZoS3pvdFcwRmZBeXFpM3NUaFhJMUM1NFExbTNfOG42Mm5FVXZSbFZtV010SFdFNzFXMkFST2tLdHJFaFZkMmdVX3hqbDZORkN3?oc=5","source_event_id":"evt_9bcfb9f695f5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a002ce5db1d54cb5","published_at":"2026-04-09T02:09:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"NATO chief","relevance":"high","symbol":"","type":"organization_role"},{"asset_class":"other","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"US allies (unspecified)","relevance":"high","symbol":"","type":"group"},{"asset_class":"other","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"The Guardian","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The specific NATO chief\u2019s name is not provided in the provided text.","Which US allies refused to join the Iran war is not specified.","Whether the remarks are about a current active conflict or a proposed/conditional scenario is not specified.","The timeline/catalyst timing (exact date of remarks, when policy decisions may follow) is not provided in the provided text.","No direct quote beyond \u201cclearly disappointed\u201d is included in the provided content."],"key_facts":["The Guardian headline reports that the NATO chief said Trump is \u201cclearly disappointed\u201d by US allies\u2019 refusal to join an Iran war.","The refusal by allies is framed as contributing to a NATO rift over Iran policy (as indicated by the provided source summary context)."],"numeric_claims":[],"primary_claim":"The NATO chief said Trump is \u201cclearly disappointed\u201d by US allies\u2019 refusal to join a US-led Iran war.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"NATO\u2019s chief said Donald Trump is \u201cclearly disappointed\u201d that some US allies refused to join the US in an Iran war, highlighting strain within NATO over Iran policy. The near-term catalyst is the ongoing diplomatic fallout from these remarks and related NATO-US disagreements.","topics":["NATO","US allies","Iran war","transatlantic relations","diplomatic tensions"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Nato chief says Trump \u2018clearly disappointed\u2019 by US allies\u2019 refusal to join Iran war The Guardian '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 slams NATO over Iran after meeting Rutte, renews Greenland threat Al Jazeera NATO chief says some European allies were tested and failed in Iran war Reuters","title":"Nato chief says Trump \u2018clearly disappointed\u2019 by US allies\u2019 refusal to join Iran war - The Guardian","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_60c3beaae9b1 in signals