SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_728d9880f8ee in signals