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-20T01:17:56.239426+00:00","dedupe_key":"signal_enriched:news_delta:ab8b03702f4df827","evidence_event_ids":["evt_1700f0fb6c84"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?oc=5","as_of":"2026-04-20T01:17:56.239426+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_fc7daab6fa2edcce","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T01:18:14.484227+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxNOTV6Z0oweXNuV2ZkaW10aUJweWhHYjFRLVdiNjdJWFNvRHYyNTJwc1EzQ2QxTjBQbGhHaTdnZEsxWlp3Zmo0dGI1dy04bkdsajVMd2F1YzFrd216UVlSaU4zVDRjTXpKQkhxWXZ6cV9acXJOTmhGdzFsX25CLWRxM2RWa0RabVZiQ3RTSDBaZjRHaDhRczlXY1ZwS1E?oc=5","source_event_id":"evt_1700f0fb6c84","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"238d3a5f3f00b852","published_at":"2026-04-19T21:45:26+00:00","publisher_domain":"politico.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: Trump DOJ redoubling election scrutiny efforts - Politico","Source summary: Trump DOJ redoubling election scrutiny efforts Politico FBI Director says arrests \u2018coming soon\u2019 on 2020 rigged election conspiracy Democracy Docket Kash Patel Just Announced Live On Fox News: \u201cArrests Are Coming \u2014 And I Promise You, It\u2019s Coming Soon\u201d USA Herald Fox\u2019s Bartiromo Says \u2018Yep\u2019 After Trump Tells Her \u2018The Election Was Rigged\u2019 Yahoo News UK Fox's Maria Bartiromo Grills Kash Patel About 2020 Election Mediaite"],"numeric_claims":[],"primary_claim":"Trump DOJ redoubling election scrutiny efforts - Politico","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Trump DOJ redoubling election scrutiny efforts Politico FBI Director says arrests \u2018coming soon\u2019 on 2020 rigged election conspiracy Democracy Docket Kash Patel Just Announced Live On Fox News: \u201cArrests Are Coming \u2014 And I Promise You, It\u2019s Coming Soon\u201d USA Herald Fox\u2019s Bartiromo Says \u2018Yep\u2019 After Trump Tells Her \u2018The Election Was Rigged\u2019 Yahoo News UK Fox's Maria Bartiromo Grills Kash Patel About 202","topics":["news headline"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump DOJ redoubling election scrutiny efforts Politico FBI Director says arrests \u2018coming soon\u2019 on 2020 rigged election conspiracy Democracy Docket Kash Patel Just Announced Live On Fox News: \u201cArrests Are Coming \u2014 And I Promise You, It\u2019s Coming Soon\u201d USA Herald Fox\u2019s Bartiromo Says \u2018Yep\u2019 After Trump Tells Her \u2018The Election Was Rigged\u2019 Yahoo News UK Fox's Maria Bartiromo Grills Kash Patel About 2020 Election Mediaite","title":"Trump DOJ redoubling election scrutiny efforts - Politico","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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 360936 in events