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-07T23:23:38.795607+00:00","dedupe_key":"signal_enriched:news_delta:ac7913584066aeb9","evidence_event_ids":["evt_ecfbb08e0650"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxObDdCWVRGdDc1UlNaU1d2MmtkN2NYamFhN1FuRWJNWllwRXZ0ZlZXOUt0UEpiTkFnZ3g4NXB1eEZFNjdPdkNUMHlJNG9udXpRcEwyMHBkWnZ0Z3lTeEhIMnpva0pCZmw1OUhYcmE5V0VlMlEyVlFXY040M20wVGdieXNPNS1ZRHVKVTA5RC1GUlExTnlxR0JCUE03a3JMNG9qM3k5SU1n?oc=5","as_of":"2026-04-07T23:23:38.795607+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/CBMipgFBVV95cUxObDdCWVRGdDc1UlNaU1d2MmtkN2NYamFhN1FuRWJNWllwRXZ0ZlZXOUt0UEpiTkFnZ3g4NXB1eEZFNjdPdkNUMHlJNG9udXpRcEwyMHBkWnZ0Z3lTeEhIMnpva0pCZmw1OUhYcmE5V0VlMlEyVlFXY040M20wVGdieXNPNS1ZRHVKVTA5RC1GUlExTnlxR0JCUE03a3JMNG9qM3k5SU1n?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_064fcbfb56d4df54","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-08T00:34:51.275558+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxObDdCWVRGdDc1UlNaU1d2MmtkN2NYamFhN1FuRWJNWllwRXZ0ZlZXOUt0UEpiTkFnZ3g4NXB1eEZFNjdPdkNUMHlJNG9udXpRcEwyMHBkWnZ0Z3lTeEhIMnpva0pCZmw1OUhYcmE5V0VlMlEyVlFXY040M20wVGdieXNPNS1ZRHVKVTA5RC1GUlExTnlxR0JCUE03a3JMNG9qM3k5SU1n?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"kctv5.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxObDdCWVRGdDc1UlNaU1d2MmtkN2NYamFhN1FuRWJNWllwRXZ0ZlZXOUt0UEpiTkFnZ3g4NXB1eEZFNjdPdkNUMHlJNG9udXpRcEwyMHBkWnZ0Z3lTeEhIMnpva0pCZmw1OUhYcmE5V0VlMlEyVlFXY040M20wVGdieXNPNS1ZRHVKVTA5RC1GUlExTnlxR0JCUE03a3JMNG9qM3k5SU1n?oc=5","source_event_id":"evt_ecfbb08e0650","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"879e632447dd6034","published_at":"2026-04-07T18:24:00+00:00","publisher_domain":"kctv5.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Kansas City voters","relevance":"primary","symbol":"","type":"voters"},{"asset_class":"","name":"Kansas City","relevance":"primary","symbol":"","type":"municipality"},{"asset_class":"","name":"Earnings tax (measure)","relevance":"primary","symbol":"","type":"ballot measure"}],"event_type":"regulation","information_gaps":["The article text provided contains only styling/HTML and does not include the actual article content beyond the headline/summary.","No election date/timeframe is stated in the provided text.","The direction of the measure (increase, decrease, repeal, or continuation) is not specified.","No polling numbers, vote totals, or expected timing for results are provided.","No affected companies/industries are named in the provided text."],"key_facts":["The story is about Kansas City voters deciding the fate of an earnings tax.","The reported turnout is \u201cslow but steady.\u201d","The source is KCTV (KCTV5)."],"numeric_claims":[],"primary_claim":"Kansas City voters are deciding the fate of an earnings tax measure, and voter turnout is \u201cslow but steady.\u201d","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"Kansas City voters are voting on an earnings tax measure, with turnout described as \u201cslow but steady.\u201d The near-term catalyst is the ongoing/ongoing-to-concluding election outcome.","topics":["elections","Kansas City","earnings tax","voter turnout"]},"source":"KCTV","source_domain":"kctv5.com","source_url":"https://www.kctv5.com","summary":"Slow but steady turnout as Kansas City voters decide earnings tax fate KCTV","title":"Slow but steady turnout as Kansas City voters decide earnings tax fate - KCTV","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 2273 in events