SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T21:31:27.208457+00:00","dedupe_key":"signal_enriched:news_delta:65da7b4239cf7737","evidence_event_ids":["evt_250290340571"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 11370 in events