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-08T01:58:44.232493+00:00","dedupe_key":"signal_enriched:news_delta:14260653f6ce3fd6","evidence_event_ids":["evt_ce1f329201b4"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxQMVJETTNtbV9zblFOZV9pMF9ZSUk3YU8tT3pFeUhfSEo2VlpfNnZiYVVkSXBDejQ1OTllMi1lSDd1a0VCSEphQVdtcGpmcHZ0TTNybGFpQk44YnVSanBtT0lTWDkxQkl4MWpDTUxZYnBRNWdGTWk4eG9SV05raFVsM2ctZlc2VWV5Q2c?oc=5","as_of":"2026-04-08T01:58:44.232493+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/CBMiigFBVV95cUxQMVJETTNtbV9zblFOZV9pMF9ZSUk3YU8tT3pFeUhfSEo2VlpfNnZiYVVkSXBDejQ1OTllMi1lSDd1a0VCSEphQVdtcGpmcHZ0TTNybGFpQk44YnVSanBtT0lTWDkxQkl4MWpDTUxZYnBRNWdGTWk4eG9SV05raFVsM2ctZlc2VWV5Q2c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0d94719995cc7747","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-08T01:59:32.790933+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxQMVJETTNtbV9zblFOZV9pMF9ZSUk3YU8tT3pFeUhfSEo2VlpfNnZiYVVkSXBDejQ1OTllMi1lSDd1a0VCSEphQVdtcGpmcHZ0TTNybGFpQk44YnVSanBtT0lTWDkxQkl4MWpDTUxZYnBRNWdGTWk4eG9SV05raFVsM2ctZlc2VWV5Q2c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"kansascity.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxQMVJETTNtbV9zblFOZV9pMF9ZSUk3YU8tT3pFeUhfSEo2VlpfNnZiYVVkSXBDejQ1OTllMi1lSDd1a0VCSEphQVdtcGpmcHZ0TTNybGFpQk44YnVSanBtT0lTWDkxQkl4MWpDTUxZYnBRNWdGTWk4eG9SV05raFVsM2ctZlc2VWV5Q2c?oc=5","source_event_id":"evt_ce1f329201b4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0ce79b6499bf28db","published_at":"2026-04-07T23:00:00+00:00","publisher_domain":"kansascity.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Kansas City Star","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"","name":"Kansas City-area election","relevance":"high","symbol":"","type":"event"}],"event_type":"other","information_gaps":["The provided text does not include the actual election winners/losers, vote totals, or which specific jurisdictions are covered.","No details are provided on whether the earnings tax or bond measures passed or failed.","No information is provided on timing of implementation or market/financial impact beyond the topics named in the headline."],"key_facts":["A Kansas City Star article/report provides full Kansas City-area election results.","The results include an earnings tax outcome.","The results include mayoral outcomes.","The results include bond-related outcomes."],"numeric_claims":[],"primary_claim":"Full Kansas City-area election results were published, including outcomes related to an earnings tax, mayors, and bonds.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The Kansas City Star published a report with full election results for the Kansas City area, covering items such as an earnings tax, mayoral races, and bond measures.","topics":["elections","local government","tax policy","mayoral races","bond measures"]},"source":"Kansas City Star","source_domain":"kansascity.com","source_url":"https://www.kansascity.com","summary":"Full Kansas City-area election results: Earnings tax, mayors, bonds & more Kansas City Star","title":"Full Kansas City-area election results: Earnings tax, mayors, bonds & more - Kansas City Star","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 3376 in events