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.156730+00:00","dedupe_key":"signal_enriched:news_delta:6d114ae9191eb337","evidence_event_ids":["evt_750ec3e7a945"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxPdFlGLUFMeEFoT2dKa05EVElhVjZMS25OQjNoU2labnk1NVlNdTU2UVlXb1dSYjctbzhSOWsxdVNaMWh6S0JRMEFNY3hDX0M3ZUNLejJSMVFaS3hOck90VHNHeVZHaTBZdVE5VE5HZkNDTVR5Uk84V0t5RGN6M0ZGSXFnRE5vdGczeUhhOA?oc=5","as_of":"2026-04-08T01:58:44.156730+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/CBMijAFBVV95cUxPdFlGLUFMeEFoT2dKa05EVElhVjZMS25OQjNoU2labnk1NVlNdTU2UVlXb1dSYjctbzhSOWsxdVNaMWh6S0JRMEFNY3hDX0M3ZUNLejJSMVFaS3hOck90VHNHeVZHaTBZdVE5VE5HZkNDTVR5Uk84V0t5RGN6M0ZGSXFnRE5vdGczeUhhOA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_20ca29f4e126b497","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:16.480670+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxPdFlGLUFMeEFoT2dKa05EVElhVjZMS25OQjNoU2labnk1NVlNdTU2UVlXb1dSYjctbzhSOWsxdVNaMWh6S0JRMEFNY3hDX0M3ZUNLejJSMVFaS3hOck90VHNHeVZHaTBZdVE5VE5HZkNDTVR5Uk84V0t5RGN6M0ZGSXFnRE5vdGczeUhhOA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"firstalert4.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxPdFlGLUFMeEFoT2dKa05EVElhVjZMS25OQjNoU2labnk1NVlNdTU2UVlXb1dSYjctbzhSOWsxdVNaMWh6S0JRMEFNY3hDX0M3ZUNLejJSMVFaS3hOck90VHNHeVZHaTBZdVE5VE5HZkNDTVR5Uk84V0t5RGN6M0ZGSXFnRE5vdGczeUhhOA?oc=5","source_event_id":"evt_750ec3e7a945","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1f013c1fa4c5427d","published_at":"2026-04-08T01:47:00+00:00","publisher_domain":"firstalert4.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"St. Louis City","relevance":"affected jurisdiction","symbol":"","type":"government"},{"asset_class":"media","name":"KMOV","relevance":"source of headline","symbol":"","type":"media_publisher"},{"asset_class":"media","name":"firstalert4.com","relevance":"publisher domain in provided context","symbol":"","type":"media_publisher"}],"event_type":"regulation","information_gaps":["The specific name/number of the ballot measure is not provided.","Whether the tax is an existing tax being renewed vs. a proposed change is not specified beyond \u201ckeep.\u201d","The effective date and duration of the kept earnings tax are not provided.","No information is provided on expected fiscal impact or affected taxpayers/industries.","The article body content is not included; only headline-level text is available."],"key_facts":["The signal headline states that St. Louis City voters elected to keep an earnings tax.","No additional details (rate, duration, effective date, or ballot measure number) are provided in the supplied text."],"numeric_claims":[],"primary_claim":"St. Louis City voters elected to keep the city\u2019s earnings tax.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"St. Louis City voters voted to keep an earnings tax, according to KMOV/firstalert4.com.","topics":["earnings tax","voter referendum","local taxation","St. Louis City"]},"source":"KMOV","source_domain":"firstalert4.com","source_url":"https://www.firstalert4.com","summary":"St. Louis City voters elect to keep earnings tax KMOV","title":"St. Louis City voters elect to keep earnings tax - KMOV","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 3366 in events