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/CBMi1gFBVV95cUxPbTFzQVJESHQ4UEFnUmF6bWEzLUFyVVhZNDhIbWEwUGFONXplbXFJUlFZMWhYc3AtX0dCdWNaTGJKM0Z2OVBENnpodEI4VFhid09TSzZVbTFjZWk1X3FxTXdJWWtGb1J6Q1lic29KRkhJMGpGTVJSU1dLbVY4ZC02QnE0Y05rbnROVmI4bmxGTjNlMTB1SG9nMlo4SExhYUpLczdOUUFrTTdTMXFCYVNVdjhyMTdGbHA1RHFfb3MtakcyWEwzandvOWhNdmc2MFpINVVzZHVn?oc=5","as_of":"2026-04-09T12:52:06.199824+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/CBMi1gFBVV95cUxPbTFzQVJESHQ4UEFnUmF6bWEzLUFyVVhZNDhIbWEwUGFONXplbXFJUlFZMWhYc3AtX0dCdWNaTGJKM0Z2OVBENnpodEI4VFhid09TSzZVbTFjZWk1X3FxTXdJWWtGb1J6Q1lic29KRkhJMGpGTVJSU1dLbVY4ZC02QnE0Y05rbnROVmI4bmxGTjNlMTB1SG9nMlo4SExhYUpLczdOUUFrTTdTMXFCYVNVdjhyMTdGbHA1RHFfb3MtakcyWEwzandvOWhNdmc2MFpINVVzZHVn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d1ec51cd6bfd42c5","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:25:39.754887+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxPbTFzQVJESHQ4UEFnUmF6bWEzLUFyVVhZNDhIbWEwUGFONXplbXFJUlFZMWhYc3AtX0dCdWNaTGJKM0Z2OVBENnpodEI4VFhid09TSzZVbTFjZWk1X3FxTXdJWWtGb1J6Q1lic29KRkhJMGpGTVJSU1dLbVY4ZC02QnE0Y05rbnROVmI4bmxGTjNlMTB1SG9nMlo4SExhYUpLczdOUUFrTTdTMXFCYVNVdjhyMTdGbHA1RHFfb3MtakcyWEwzandvOWhNdmc2MFpINVVzZHVn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"forbes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi1gFBVV95cUxPbTFzQVJESHQ4UEFnUmF6bWEzLUFyVVhZNDhIbWEwUGFONXplbXFJUlFZMWhYc3AtX0dCdWNaTGJKM0Z2OVBENnpodEI4VFhid09TSzZVbTFjZWk1X3FxTXdJWWtGb1J6Q1lic29KRkhJMGpGTVJSU1dLbVY4ZC02QnE0Y05rbnROVmI4bmxGTjNlMTB1SG9nMlo4SExhYUpLczdOUUFrTTdTMXFCYVNVdjhyMTdGbHA1RHFfb3MtakcyWEwzandvOWhNdmc2MFpINVVzZHVn?oc=5","source_event_id":"evt_ef764a229d56","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8c39617d308d7a05","published_at":"2026-04-08T23:56:00+00:00","publisher_domain":"forbes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"N/A","name":"Donald Trump","relevance":"primary actor behind the reported consideration","symbol":"","type":"person"},{"asset_class":"N/A","name":"NATO","relevance":"target of the reported punitive measure","symbol":"","type":"organization"},{"asset_class":"N/A","name":"United States (U.S. troops)","relevance":"potentially withdrawn as the punishment mechanism","symbol":"","type":"country/military"},{"asset_class":"N/A","name":"Forbes","relevance":"publisher of the exclusive report referenced in the signal","symbol":"","type":"media outlet"},{"asset_class":"N/A","name":"WSJ (The Wall Street Journal)","relevance":"additional referenced coverage about NATO and the Iran war","symbol":"","type":"media outlet"},{"asset_class":"N/A","name":"Reuters","relevance":"additional referenced coverage quoting NATO chief and allied performance in Iran war","symbol":"","type":"media outlet"},{"asset_class":"N/A","name":"Rutte","relevance":"referenced in other cited coverage as facing a test regarding NATO and Trump","symbol":"","type":"person"},{"asset_class":"N/A","name":"CNBC","relevance":"referenced in the signal as covering related NATO/Trump tensions","symbol":"","type":"media outlet"},{"asset_class":"N/A","name":"Military.com","relevance":"referenced in the signal as covering NATO/Trump tensions","symbol":"","type":"media outlet"}],"event_type":"geopolitical_risk","information_gaps":["The provided content is largely a headline/signal summary; the full Forbes article details (e.g., which countries, whether this is a formal proposal vs. exploratory discussion, and any conditions/timing) are not included.","No specific timeline for when troop removal would occur is stated in the provided text.","The signal does not specify the criteria used to label a NATO country as \u201cunsupportive.\u201d","No direct confirmation from NATO or the U.S. administration is included in the provided excerpt\u2014only \u201creportedly\u201d language."],"key_facts":["Forbes reports Trump is considering punishing NATO countries described as \u201cunsupportive\u201d by removing U.S. troops.","The reported rationale is that some NATO allies did not support the Iran war (as characterized in the signal).","The signal indicates this is occurring amid or contributing to a NATO rift related to the Iran war (per the referenced coverage snippets)."],"numeric_claims":[],"primary_claim":"Trump reportedly considers punishing NATO countries that did not support the Iran war by removing U.S. troops.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"Forbes reports that Trump is considering a punitive approach toward NATO countries deemed \u201cunsupportive,\u201d including removing U.S. troops as leverage. The proposal is framed as part of a broader NATO rift tied to the Iran war and allied support.","topics":["NATO","U.S. troop deployment","U.S.-allies relations","Iran war","transatlantic security","geopolitical risk"]},"source":"Forbes","source_domain":"forbes.com","source_url":"https://www.forbes.com","summary":"Trump Reportedly Considers Punishing Unsupportive NATO Countries By Removing U.S. Troops Forbes Exclusive | Trump Team Explores Punishment for NATO Countries That Didn\u2019t Support Iran War WSJ NATO chief says some European allies were tested and failed in Iran war Reuters 'Poorly run, piece of ice': Trump targets Greenland again as Iran war deepens NATO rift CNBC Rutte the 'Trump Whisperer' Faces a Fresh Test as Trump Turns on NATO over Iran Military.com","title":"Trump Reportedly Considers Punishing Unsupportive NATO Countries By Removing U.S. Troops - Forbes","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_430861de7e23 in signals