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-21T03:02:40.576414+00:00","dedupe_key":"signal_enriched:news_delta:3ce725ca811942cf","evidence_event_ids":["evt_ae80f1f4dec4"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMizgFBVV95cUxPZV9KZnkwWGFlaXNVaVduZG1HemVOa3pJTkJXX0x0VUYteHBpbHJNQVp4cGQzRkpnWnJJVWlxU3JfR0FWcExzbEN1QTFjOU0zX3czdzdXaGNYYUowd1VxcldzRndaYV9xUnM2RHplb21LUG1oamd1c05XVV9JVDhIWHNaYVR3S210dEMzLVdmakxTcUhLbnpQWlZ1SFVvNzN3elFPV194WDI0UEMtbGpkSnNyb2E0dHhPVndMVENoVVloMnY4UzRKS0lCbTNoQQ?oc=5","as_of":"2026-04-21T03:02:40.576414+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMizgFBVV95cUxPZV9KZnkwWGFlaXNVaVduZG1HemVOa3pJTkJXX0x0VUYteHBpbHJNQVp4cGQzRkpnWnJJVWlxU3JfR0FWcExzbEN1QTFjOU0zX3czdzdXaGNYYUowd1VxcldzRndaYV9xUnM2RHplb21LUG1oamd1c05XVV9JVDhIWHNaYVR3S210dEMzLVdmakxTcUhLbnpQWlZ1SFVvNzN3elFPV194WDI0UEMtbGpkSnNyb2E0dHhPVndMVENoVVloMnY4UzRKS0lCbTNoQQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_610577f6a429d325","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T15:48:54.432524+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizgFBVV95cUxPZV9KZnkwWGFlaXNVaVduZG1HemVOa3pJTkJXX0x0VUYteHBpbHJNQVp4cGQzRkpnWnJJVWlxU3JfR0FWcExzbEN1QTFjOU0zX3czdzdXaGNYYUowd1VxcldzRndaYV9xUnM2RHplb21LUG1oamd1c05XVV9JVDhIWHNaYVR3S210dEMzLVdmakxTcUhLbnpQWlZ1SFVvNzN3elFPV194WDI0UEMtbGpkSnNyb2E0dHhPVndMVENoVVloMnY4UzRKS0lCbTNoQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"latimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizgFBVV95cUxPZV9KZnkwWGFlaXNVaVduZG1HemVOa3pJTkJXX0x0VUYteHBpbHJNQVp4cGQzRkpnWnJJVWlxU3JfR0FWcExzbEN1QTFjOU0zX3czdzdXaGNYYUowd1VxcldzRndaYV9xUnM2RHplb21LUG1oamd1c05XVV9JVDhIWHNaYVR3S210dEMzLVdmakxTcUhLbnpQWlZ1SFVvNzN3elFPV194WDI0UEMtbGpkSnNyb2E0dHhPVndMVENoVVloMnY4UzRKS0lCbTNoQQ?oc=5","source_event_id":"evt_ae80f1f4dec4","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"181850c072e96e31","published_at":"2026-04-20T22:27:22+00:00","publisher_domain":"latimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Governor\u2019s race wildly unpredictable two weeks before Californians receive ballots - Los Angeles Times","Source summary: Governor\u2019s race wildly unpredictable two weeks before Californians receive ballots Los Angeles Times Democrat Betty Yee Leaves the California Governor\u2019s Race The New York Times California\u2019s Blue Armageddon The Atlantic Latest CA Dem Survey: GOP's Steve Hilton, Chad Bianco lead in CA governor race as Becerra gains ground ABC10 Opinion | With Eric Swalwell's scandalous implosion, Xavier Becerra surges in race for Calif"],"numeric_claims":[],"primary_claim":"Governor\u2019s race wildly unpredictable two weeks before Californians receive ballots - Los Angeles Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Governor\u2019s race wildly unpredictable two weeks before Californians receive ballots Los Angeles Times Democrat Betty Yee Leaves the California Governor\u2019s Race The New York Times California\u2019s Blue Armageddon The Atlantic Latest CA Dem Survey: GOP's Steve Hilton, Chad Bianco lead in CA governor race as Becerra gains ground ABC10 Opinion | With Eric Swalwell's scandalous implosion, Xavier Becerra surg","topics":["news headline"]},"source":"Los Angeles Times","source_domain":"latimes.com","source_url":"https://www.latimes.com","summary":"Governor\u2019s race wildly unpredictable two weeks before Californians receive ballots Los Angeles Times Democrat Betty Yee Leaves the California Governor\u2019s Race The New York Times California\u2019s Blue Armageddon The Atlantic Latest CA Dem Survey: GOP's Steve Hilton, Chad Bianco lead in CA governor race as Becerra gains ground ABC10 Opinion | With Eric Swalwell's scandalous implosion, Xavier Becerra surges in race for California governor CalMatters","title":"Governor\u2019s race wildly unpredictable two weeks before Californians receive ballots - Los Angeles Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/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 471724 in events