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-11T09:52:41.549144+00:00","dedupe_key":"signal_enriched:news_delta:babceb3a962691bb","evidence_event_ids":["evt_3d9d8096621f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNTkJRdkQydmFvWVFsWTMzR2ZEY3lUMjlzWDlMTGpodjdIZzlvM2FIMU1HUk5wRlRQd1ZtSFVZWExadHlXbHJqUUMxSVNWazRBUGFrM093c0VrcjYxU2tfTWV6amZ6OHVNaGZLVDl5aF9UR1BqZjFmdE55T21vLUVQZnN6MUpTbVNwU3ROUzU2X1lTQjZNOXAwLTMyWFZ0M2s2ek5Xbk5DUHNpOUlqalpCSXlpTlAzTlpjelp3VURvY0ltb2w1QkFEaWlwT2w?oc=5","as_of":"2026-04-11T09:52:41.549144+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/CBMizAFBVV95cUxNTkJRdkQydmFvWVFsWTMzR2ZEY3lUMjlzWDlMTGpodjdIZzlvM2FIMU1HUk5wRlRQd1ZtSFVZWExadHlXbHJqUUMxSVNWazRBUGFrM093c0VrcjYxU2tfTWV6amZ6OHVNaGZLVDl5aF9UR1BqZjFmdE55T21vLUVQZnN6MUpTbVNwU3ROUzU2X1lTQjZNOXAwLTMyWFZ0M2s2ek5Xbk5DUHNpOUlqalpCSXlpTlAzTlpjelp3VURvY0ltb2w1QkFEaWlwT2w?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b2799b4feaaa986f","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-11T18:01:51.978565+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNTkJRdkQydmFvWVFsWTMzR2ZEY3lUMjlzWDlMTGpodjdIZzlvM2FIMU1HUk5wRlRQd1ZtSFVZWExadHlXbHJqUUMxSVNWazRBUGFrM093c0VrcjYxU2tfTWV6amZ6OHVNaGZLVDl5aF9UR1BqZjFmdE55T21vLUVQZnN6MUpTbVNwU3ROUzU2X1lTQjZNOXAwLTMyWFZ0M2s2ek5Xbk5DUHNpOUlqalpCSXlpTlAzTlpjelp3VURvY0ltb2w1QkFEaWlwT2w?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ksl.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMizAFBVV95cUxNTkJRdkQydmFvWVFsWTMzR2ZEY3lUMjlzWDlMTGpodjdIZzlvM2FIMU1HUk5wRlRQd1ZtSFVZWExadHlXbHJqUUMxSVNWazRBUGFrM093c0VrcjYxU2tfTWV6amZ6OHVNaGZLVDl5aF9UR1BqZjFmdE55T21vLUVQZnN6MUpTbVNwU3ROUzU2X1lTQjZNOXAwLTMyWFZ0M2s2ek5Xbk5DUHNpOUlqalpCSXlpTlAzTlpjelp3VURvY0ltb2w1QkFEaWlwT2w?oc=5","source_event_id":"evt_3d9d8096621f","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"f1231ac31c4beabe","published_at":"2026-04-10T17:36:44+00:00","publisher_domain":"ksl.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":["Sunday"],"entities":[{"asset_class":"","name":"Peruvians in Utah","relevance":"directly affected","symbol":"","type":"voter_group"},{"asset_class":"","name":"Peru presidential election","relevance":"context/event","symbol":"","type":"political_event"},{"asset_class":"","name":"KSL.com","relevance":"source of headline","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No article text is provided beyond the headline and brief source summary.","No specific candidate names, vote totals, or election outcome details are included in the provided text.","The exact mechanism/timing of how Utah-based voters will vote (e.g., polling location, absentee process) is not specified."],"key_facts":["KSL.com states that Peruvians in Utah will count among the voters weighing in Sunday in Peru's presidential election."],"numeric_claims":[],"primary_claim":"Peruvians in Utah will vote on Sunday in Peru\u2019s presidential election.","relevance_score":0.35,"sentiment":"neutral","source_quality":"unknown","summary":"KSL.com reports that Peruvians living in Utah will be among the voters participating on Sunday in Peru\u2019s presidential election.","topics":["Peru presidential election","voting","diaspora voting","Utah","Sunday voting"]},"source":"KSL.com","source_domain":"ksl.com","source_url":"https://www.ksl.com","summary":"Peruvians in Utah will count among the voters weighing in Sunday in Peru's presidential election KSL.com In Peru\u2019s presidential race, a pro-Trump frontrunner sinks in final stretch Al Jazeera Peru's election: A battle for the Presidency amid political chaos and crime NPR US pushes to renew ties with Peru ahead of uncertain election Reuters Peruvians to go to polls hoping to break cycle of instability The Guardian","title":"Peruvians in Utah will count among the voters weighing in Sunday in Peru's presidential election - KSL.com","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 23931 in events