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-09T03:06:55.071362+00:00","dedupe_key":"signal_enriched:news_delta:2004939e18d95967","evidence_event_ids":["evt_2c433dbc668c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxOeE85eWFydE9mTmdtWk1SUVFMRGlOejFmVklvRk1pU05zM0JuNWdVTjIybWhVQ0Zhemt2dFJydW9BWVJ2NjNyTnpYd0RpTW5rTFpQa25ZclR5MXAtRlEzbXJfTk1sUUd4Ykw3NkpZQktna09CdHc0R2F3M0t1T0c3QVZ3TE0tQQ?oc=5","as_of":"2026-04-09T03:06:55.071362+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/CBMihgFBVV95cUxOeE85eWFydE9mTmdtWk1SUVFMRGlOejFmVklvRk1pU05zM0JuNWdVTjIybWhVQ0Zhemt2dFJydW9BWVJ2NjNyTnpYd0RpTW5rTFpQa25ZclR5MXAtRlEzbXJfTk1sUUd4Ykw3NkpZQktna09CdHc0R2F3M0t1T0c3QVZ3TE0tQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_069b0d1cbd77d8d7","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:29:36.240820+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxOeE85eWFydE9mTmdtWk1SUVFMRGlOejFmVklvRk1pU05zM0JuNWdVTjIybWhVQ0Zhemt2dFJydW9BWVJ2NjNyTnpYd0RpTW5rTFpQa25ZclR5MXAtRlEzbXJfTk1sUUd4Ykw3NkpZQktna09CdHc0R2F3M0t1T0c3QVZ3TE0tQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxOeE85eWFydE9mTmdtWk1SUVFMRGlOejFmVklvRk1pU05zM0JuNWdVTjIybWhVQ0Zhemt2dFJydW9BWVJ2NjNyTnpYd0RpTW5rTFpQa25ZclR5MXAtRlEzbXJfTk1sUUd4Ykw3NkpZQktna09CdHc0R2F3M0t1T0c3QVZ3TE0tQQ?oc=5","source_event_id":"evt_2c433dbc668c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7c5ca7e9f3232948","published_at":"2026-04-09T02:09:34+00:00","publisher_domain":"washingtonpost.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":"defense_alliance","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"political_actor","name":"NATO\u2019s leader (name not provided in provided text)","relevance":"medium","symbol":"","type":"person"},{"asset_class":"government_institution","name":"White House","relevance":"high","symbol":"","type":"institution"},{"asset_class":"news_source","name":"The Washington Post","relevance":"medium","symbol":"","type":"media_outlet"}],"event_type":"geopolitical_risk","information_gaps":["Meeting date/time is not provided in the supplied content.","The NATO leader\u2019s identity (e.g., name/title) is not provided in the supplied content.","The exact wording of what Trump will discuss (e.g., withdrawal vs. renegotiation) is not provided.","Whether this is a confirmed decision or exploratory discussion is not specified in the supplied content.","No direct quotes or document references from the White House are included in the supplied content."],"key_facts":["The Washington Post headline states that Trump will discuss leaving NATO in a meeting with NATO\u2019s leader.","The report attributes the planned discussion to the White House.","The provided text does not specify the date/time of the meeting or the NATO leader\u2019s name."],"numeric_claims":[],"primary_claim":"Trump is scheduled to discuss leaving NATO with NATO\u2019s leader in a meeting, according to the White House, as reported by The Washington Post.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"The Washington Post reports that Trump plans to discuss potentially leaving NATO with the alliance\u2019s leader in a White House meeting. The development signals an escalation of NATO-related tensions and could become a near-term diplomatic catalyst.","topics":["NATO","U.S. foreign policy","alliance cohesion","diplomacy","withdrawal threat"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Trump to discuss leaving NATO in meeting with alliance\u2019s leader, White House says The Washington Post 'Poorly run, piece of ice': Trump targets Greenland again as Iran war deepens NATO rift CNBC Trump vents frustation with Nato \u2013 as it happened The Guardian Exclusive | Trump Team Explores Punishment for NATO Countries That Didn\u2019t Support Iran War WSJ Trump administration signals it is mulling NATO withdrawal after Iran war Al Jazeera","title":"Trump to discuss leaving NATO in meeting with alliance\u2019s leader, White House says - The Washington Post","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 8770 in events