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-19T18:00:50.483403+00:00","dedupe_key":"signal_enriched:news_delta:2a98f7c4864fdb45","evidence_event_ids":["evt_c48109821610"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxPT3Uyd2VuajZCQk1idTlrWWo5T2N2aXJsTG1QSzlpbFlkUG9HaVkwU1AtX0gtLU1KT0pucnBOU2xORHc0RUVFVW9XOUlwU2J0czJaYk9ZOU9yNGdrdnZpSEZzbE9YWEhJblhlLUMxdTZ6U0s4SEdfOFc2WjJfai1BYmQ5bDYzckVBTGlILUZzSnQ4cUQzdVE?oc=5","as_of":"2026-04-19T18:00:50.483403+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/CBMilgFBVV95cUxPT3Uyd2VuajZCQk1idTlrWWo5T2N2aXJsTG1QSzlpbFlkUG9HaVkwU1AtX0gtLU1KT0pucnBOU2xORHc0RUVFVW9XOUlwU2J0czJaYk9ZOU9yNGdrdnZpSEZzbE9YWEhJblhlLUMxdTZ6U0s4SEdfOFc2WjJfai1BYmQ5bDYzckVBTGlILUZzSnQ4cUQzdVE?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_8ccaa0b456484fd1","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-19T18:39:18.083251+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxPT3Uyd2VuajZCQk1idTlrWWo5T2N2aXJsTG1QSzlpbFlkUG9HaVkwU1AtX0gtLU1KT0pucnBOU2xORHc0RUVFVW9XOUlwU2J0czJaYk9ZOU9yNGdrdnZpSEZzbE9YWEhJblhlLUMxdTZ6U0s4SEdfOFc2WjJfai1BYmQ5bDYzckVBTGlILUZzSnQ4cUQzdVE?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/CBMilgFBVV95cUxPT3Uyd2VuajZCQk1idTlrWWo5T2N2aXJsTG1QSzlpbFlkUG9HaVkwU1AtX0gtLU1KT0pucnBOU2xORHc0RUVFVW9XOUlwU2J0czJaYk9ZOU9yNGdrdnZpSEZzbE9YWEhJblhlLUMxdTZ6U0s4SEdfOFc2WjJfai1BYmQ5bDYzckVBTGlILUZzSnQ4cUQzdVE?oc=5","source_event_id":"evt_c48109821610","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"81fdb57a1761941b","published_at":"2026-04-19T11:00:00+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: In wake of political violence, states use campaign cash for personal security - Politico","Source summary: In wake of political violence, states use campaign cash for personal security Politico With rising threats, MN lawmakers seek boost in security \u2018bridge\u2019 Pioneer Press Charlie Kirk\u2019s murder has changed how your campaign donations are spent Alternet Nebraska bolsters public official security as threats on the rise across the country Nebraska Public Media Lawmakers, officers weigh in on Capitol\u2019s new security measures I"],"numeric_claims":[],"primary_claim":"In wake of political violence, states use campaign cash for personal security - Politico","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"In wake of political violence, states use campaign cash for personal security Politico With rising threats, MN lawmakers seek boost in security \u2018bridge\u2019 Pioneer Press Charlie Kirk\u2019s murder has changed how your campaign donations are spent Alternet Nebraska bolsters public official security as threats on the rise across the country Nebraska Public Media Lawmakers, officers weigh in on Capitol\u2019s new","topics":["news headline"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"In wake of political violence, states use campaign cash for personal security Politico With rising threats, MN lawmakers seek boost in security \u2018bridge\u2019 Pioneer Press Charlie Kirk\u2019s murder has changed how your campaign donations are spent Alternet Nebraska bolsters public official security as threats on the rise across the country Nebraska Public Media Lawmakers, officers weigh in on Capitol\u2019s new security measures InForum","title":"In wake of political violence, states use campaign cash for personal security - 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 330620 in events