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/CBMitwFBVV95cUxONmlUbW5aaVpvdU1zSGNFSG4zdm01Qkp2N0ROWXRoNHpkUVNqWVp5QW9QTGstZUhsbG56em80OE4yZ094RmIwOGUwb19zM284T0MtdHZtYURsSHJYYkp4TVN5VDdlWk5zQzVvdmItSWJEZkRvYkhvNGg3Z29pWmJPTXRqUzZkMEc4eDJsTmFLakVRRi0xN1ZrVTBsbGgtVFlxSnY0eUhZaWtfcDg5aFhRODdWNEpsRFE?oc=5","as_of":"2026-04-09T21:31:27.208457+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/CBMitwFBVV95cUxONmlUbW5aaVpvdU1zSGNFSG4zdm01Qkp2N0ROWXRoNHpkUVNqWVp5QW9QTGstZUhsbG56em80OE4yZ094RmIwOGUwb19zM284T0MtdHZtYURsSHJYYkp4TVN5VDdlWk5zQzVvdmItSWJEZkRvYkhvNGg3Z29pWmJPTXRqUzZkMEc4eDJsTmFLakVRRi0xN1ZrVTBsbGgtVFlxSnY0eUhZaWtfcDg5aFhRODdWNEpsRFE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4b670ef285a0a4f5","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-10T00:37:16.210530+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxONmlUbW5aaVpvdU1zSGNFSG4zdm01Qkp2N0ROWXRoNHpkUVNqWVp5QW9QTGstZUhsbG56em80OE4yZ094RmIwOGUwb19zM284T0MtdHZtYURsSHJYYkp4TVN5VDdlWk5zQzVvdmItSWJEZkRvYkhvNGg3Z29pWmJPTXRqUzZkMEc4eDJsTmFLakVRRi0xN1ZrVTBsbGgtVFlxSnY0eUhZaWtfcDg5aFhRODdWNEpsRFE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitwFBVV95cUxONmlUbW5aaVpvdU1zSGNFSG4zdm01Qkp2N0ROWXRoNHpkUVNqWVp5QW9QTGstZUhsbG56em80OE4yZ094RmIwOGUwb19zM284T0MtdHZtYURsSHJYYkp4TVN5VDdlWk5zQzVvdmItSWJEZkRvYkhvNGg3Z29pWmJPTXRqUzZkMEc4eDJsTmFLakVRRi0xN1ZrVTBsbGgtVFlxSnY0eUhZaWtfcDg5aFhRODdWNEpsRFE?oc=5","source_event_id":"evt_250290340571","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"597b30dc6c88f891","published_at":"2026-04-09T19:39:17+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity/none","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"none","name":"US troops","relevance":"high","symbol":"","type":"military_forces"},{"asset_class":"none","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"none","name":"Europe","relevance":"medium","symbol":"","type":"region"},{"asset_class":"none","name":"Reuters (official source)","relevance":"medium","symbol":"","type":"news_source"}],"event_type":"geopolitical_risk","information_gaps":["Which specific countries or bases in Europe would be affected is not stated in the provided text.","How many troops (or what proportion) is not specified.","Whether the consideration is tied to a particular timeline (e.g., weeks/months) is not provided.","The official\u2019s identity and whether they are speaking on behalf of the administration is not provided.","No details are given on the nature of the NATO strains beyond the general reference."],"key_facts":["Reuters (exclusive) says an official stated Trump is weighing pulling some US troops from Europe.","The stated rationale/context is NATO strains.","The report frames the action as a consideration/weighing, not a confirmed decision."],"numeric_claims":[],"primary_claim":"Trump is weighing pulling some US troops from Europe amid NATO strains, according to a Reuters official.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports that Trump is considering pulling some US troops from Europe amid NATO strains, according to an official. The development would likely heighten uncertainty within NATO and could weaken near-term alliance cohesion.","topics":["NATO","US troop deployment","Europe security","US foreign policy","alliance strains"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Exclusive: Trump weighs pulling some US troops from Europe amid NATO strains, official says Reuters Trump Again Hits Out at NATO Over Iran War The New York Times Trump threats toward NATO raise alarm bells for alliance supporters KOMO 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","title":"Exclusive: Trump weighs pulling some US troops from Europe amid NATO strains, official says - Reuters","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_30c9324561be in signals