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-09T20:18:41.006128+00:00","dedupe_key":"signal_enriched:news_delta:4929e136ff256183","evidence_event_ids":["evt_154182f1fa1b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQdXl6UWMzc2V5eVpvcENJYXJfQmdRM0N1Vk9JX0NWQ3MwTjJENG84dzI0UHB5dzRjdWduRjhsNm5sZTFmOFFLRG1YQjNLb1VWbkY2Ymh3Tjd0RGVBd1NVc1BhbUtUaXdnc3VCMHk1VWl5NUZpcDhmNGFrYWsxSFFhOWRoYVZwdVJjdUNaVlA5VGdoVXlnOWM1WHZTTGViX3Nyclp6M3liM0h2c1h1?oc=5","as_of":"2026-04-09T20:18:41.006128+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/CBMirAFBVV95cUxQdXl6UWMzc2V5eVpvcENJYXJfQmdRM0N1Vk9JX0NWQ3MwTjJENG84dzI0UHB5dzRjdWduRjhsNm5sZTFmOFFLRG1YQjNLb1VWbkY2Ymh3Tjd0RGVBd1NVc1BhbUtUaXdnc3VCMHk1VWl5NUZpcDhmNGFrYWsxSFFhOWRoYVZwdVJjdUNaVlA5VGdoVXlnOWM1WHZTTGViX3Nyclp6M3liM0h2c1h1?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7b4abee6e166312e","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-10T00:27:07.901635+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQdXl6UWMzc2V5eVpvcENJYXJfQmdRM0N1Vk9JX0NWQ3MwTjJENG84dzI0UHB5dzRjdWduRjhsNm5sZTFmOFFLRG1YQjNLb1VWbkY2Ymh3Tjd0RGVBd1NVc1BhbUtUaXdnc3VCMHk1VWl5NUZpcDhmNGFrYWsxSFFhOWRoYVZwdVJjdUNaVlA5VGdoVXlnOWM1WHZTTGViX3Nyclp6M3liM0h2c1h1?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"dallasnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxQdXl6UWMzc2V5eVpvcENJYXJfQmdRM0N1Vk9JX0NWQ3MwTjJENG84dzI0UHB5dzRjdWduRjhsNm5sZTFmOFFLRG1YQjNLb1VWbkY2Ymh3Tjd0RGVBd1NVc1BhbUtUaXdnc3VCMHk1VWl5NUZpcDhmNGFrYWsxSFFhOWRoYVZwdVJjdUNaVlA5VGdoVXlnOWM1WHZTTGViX3Nyclp6M3liM0h2c1h1?oc=5","source_event_id":"evt_154182f1fa1b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"07ed03ff626e8158","published_at":"2026-04-09T18:09:10+00:00","publisher_domain":"dallasnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Texas Rangers","relevance":"high","symbol":"Rangers","type":"sports_team"},{"asset_class":"media","name":"Dallas News","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"geography","name":"North Texas","relevance":"medium","symbol":"","type":"region"},{"asset_class":"culture","name":"Mexican heritage","relevance":"medium","symbol":"","type":"cultural_group"}],"event_type":"listing","information_gaps":["No details from the provided text about specific uniform design elements (logos, colors beyond 'red', slogans, or imagery).","No explicit release date or whether the uniforms are already available for purchase is included in the provided headline/summaries.","No information on league-wide context (e.g., whether this is part of a 2026 City Connect rollout) is confirmed from the provided Dallas News headline alone."],"key_facts":["Dallas News headline states the Rangers\u2019 new City Connect uniforms are red.","The uniforms are described as offering a tribute to North Texas\u2019 Mexican heritage."],"numeric_claims":[],"primary_claim":"Texas Rangers have released new red City Connect uniforms that offer a tribute to North Texas\u2019 Mexican heritage.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The Dallas News headline reports that the Texas Rangers\u2019 new red City Connect uniforms are designed to pay tribute to North Texas\u2019 Mexican heritage.","topics":["MLB","City Connect uniforms","Texas Rangers","sports apparel","cultural tribute","North Texas Mexican heritage"]},"source":"Dallas News","source_domain":"dallasnews.com","source_url":"https://www.dallasnews.com","summary":"Viva Tejas! Rangers' new red City Connect uniforms offer tribute to North Texas' Mexican heritage Dallas News Inside MLB's 2026 City Connect uniforms -- and what's next ESPN Fans flock to Orioles Team Store after City Connect jerseys released WBAL-TV Padres' new City Connect jerseys as vibrant as city they call home MLB.com How the Braves\u2019 City Connect 2.0 uniforms came to life AJC.com","title":"Viva Tejas! Rangers' new red City Connect uniforms offer tribute to North Texas' Mexican heritage - Dallas News","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 11201 in events