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-06T21:50:13.278947+00:00","dedupe_key":"signal_enriched:news_delta:3efd9eba60297163","evidence_event_ids":["evt_464e53b40ef1"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOR19ORkhRWkdHTnhnMGhiVEV4S2xhTC1qaF93QXMzbEZOUXNtWDFQYnU5eE1URXFaeWZtSnlIbFMxcDBkNFVOVUk5aGRZcHJPbkoxSHlLdUUwMUVNeWtaSUkxajBEM3laZXFSOGlLd0JNSi1zTjBLZTZXalBISnljSW5FZG5YXzJaS0Y3TmQxQXF5dw?oc=5","as_of":"2026-04-06T21:50:13.278947+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOR19ORkhRWkdHTnhnMGhiVEV4S2xhTC1qaF93QXMzbEZOUXNtWDFQYnU5eE1URXFaeWZtSnlIbFMxcDBkNFVOVUk5aGRZcHJPbkoxSHlLdUUwMUVNeWtaSUkxajBEM3laZXFSOGlLd0JNSi1zTjBLZTZXalBISnljSW5FZG5YXzJaS0Y3TmQxQXF5dw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e40ee0943f612a4d","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T11:20:42.234113+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOR19ORkhRWkdHTnhnMGhiVEV4S2xhTC1qaF93QXMzbEZOUXNtWDFQYnU5eE1URXFaeWZtSnlIbFMxcDBkNFVOVUk5aGRZcHJPbkoxSHlLdUUwMUVNeWtaSUkxajBEM3laZXFSOGlLd0JNSi1zTjBLZTZXalBISnljSW5FZG5YXzJaS0Y3TmQxQXF5dw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxOR19ORkhRWkdHTnhnMGhiVEV4S2xhTC1qaF93QXMzbEZOUXNtWDFQYnU5eE1URXFaeWZtSnlIbFMxcDBkNFVOVUk5aGRZcHJPbkoxSHlLdUUwMUVNeWtaSUkxajBEM3laZXFSOGlLd0JNSi1zTjBLZTZXalBISnljSW5FZG5YXzJaS0Y3TmQxQXF5dw?oc=5","source_event_id":"evt_464e53b40ef1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c64778748043e6aa","published_at":"2026-04-06T19:55:09+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Melania Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"geopolitical","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"other","information_gaps":["Details on Melania Trump's outfit and its significance are not provided.","The specific content of Trump's comments about Iran is not detailed."],"key_facts":["Melania Trump attended the White House Easter Egg Roll.","Donald Trump made comments about Iran during the event."],"numeric_claims":[],"primary_claim":"Melania Trump made an unexpected appearance during the Easter celebrations at the White House.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"Melania Trump's Easter appearance has drawn attention, coinciding with President Trump's comments about Iran during the White House Easter Egg Roll.","topics":["Easter","Melania Trump","Donald Trump","Iran"]},"source":"nytimes.com","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Melania Trump\u2019s Unexpected Easter Look nytimes.com With the Easter Bunny at his side, Trump won\u2019t stop talking about Iran CNN Between Easter Eggs and Bunny Hops, Trump Talks of War and Autopens nytimes.com WATCH: Trump sends warning to Iran at White House Easter Egg Roll PBS White House Easter Egg Roll 2026: President Trump, first lady welcome crowds to South Lawn FOX 5 DC","title":"Melania Trump\u2019s Unexpected Easter Look - nytimes.com","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 37103 in events