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/CBMic0FVX3lxTE9HcGVjODFONUk1b0pJRXdJelh3UGxPd0pOdzVyenFXY09SZDB6VmhlOVNlNFdwNDdKa3hpaFFUY2ZlU0Ryd0J3QTE5Y2NSMkFneWhNSmF3dUswZWtPY3lxX0NJenUyaDE2WWpmcm1ia1lJalk?oc=5","as_of":"2026-04-09T22:31:38.683651+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/CBMic0FVX3lxTE9HcGVjODFONUk1b0pJRXdJelh3UGxPd0pOdzVyenFXY09SZDB6VmhlOVNlNFdwNDdKa3hpaFFUY2ZlU0Ryd0J3QTE5Y2NSMkFneWhNSmF3dUswZWtPY3lxX0NJenUyaDE2WWpmcm1ia1lJalk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ed08ff05b91fa37c","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:43:51.754185+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE9HcGVjODFONUk1b0pJRXdJelh3UGxPd0pOdzVyenFXY09SZDB6VmhlOVNlNFdwNDdKa3hpaFFUY2ZlU0Ryd0J3QTE5Y2NSMkFneWhNSmF3dUswZWtPY3lxX0NJenUyaDE2WWpmcm1ia1lJalk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"mlb.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE9HcGVjODFONUk1b0pJRXdJelh3UGxPd0pOdzVyenFXY09SZDB6VmhlOVNlNFdwNDdKa3hpaFFUY2ZlU0Ryd0J3QTE5Y2NSMkFneWhNSmF3dUswZWtPY3lxX0NJenUyaDE2WWpmcm1ia1lJalk?oc=5","source_event_id":"evt_50b8f720956d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"412d947820e9a9f5","published_at":"2026-04-09T14:25:55+00:00","publisher_domain":"mlb.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"Baltimore Orioles","relevance":"primary","symbol":"","type":"sports_team"},{"asset_class":"media","name":"MLB.com","relevance":"source","symbol":"","type":"media_outlet"},{"asset_class":"equity","name":"Nike","relevance":"design_partner","symbol":"","type":"company"},{"asset_class":"other","name":"Camden Yards","relevance":"design_inspiration","symbol":"","type":"stadium_landmark"},{"asset_class":"media","name":"ESPN","relevance":"mentioned_in_summary","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The New York Times","relevance":"mentioned_in_summary","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"WBFF","relevance":"mentioned_in_summary","symbol":"","type":"media_outlet"}],"event_type":"listing","information_gaps":["The cleaned article text provided appears to be generic page markup rather than the actual article content; detailed design elements (colors, specific motifs, release date/timing) are not present in the provided text.","Near-term catalyst timing for on-field or financial impact is not specified; this signal is limited to uniform unveiling context.","The headline delta does not specify whether the Orioles\u2019 City Connects 2.0 replaces an earlier version or is a new iteration; that relationship is not explicit in the provided text."],"key_facts":["MLB.com reports the Orioles\u2019 \u201cCity Connects 2.0\u201d uniforms are a nod to Camden Yards\u2019 charms.","The MLB.com source summary indicates the article is about Inside MLB\u2019s 2026 City Connect uniforms and what\u2019s next.","The provided source summary also states Nike is launching 2026 MLB City Connect uniforms defined by each club\u2019s places, people, and stories.","The provided source summary mentions other related items (e.g., Konnor Griffin\u2019s deal and a \u201ccompromise\u201d), but these are not detailed in the headline delta text."],"numeric_claims":[],"primary_claim":"The Baltimore Orioles have unveiled their 2026 City Connects 2.0 uniforms, with the design nodding to Camden Yards.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The Baltimore Orioles are unveiling their 2026 \u201cCity Connects 2.0\u201d uniforms, designed as a tribute to Camden Yards. The MLB.com piece frames the release as part of Nike\u2019s broader 2026 City Connect uniform rollout across clubs.","topics":["MLB","uniforms","City Connect","Nike","Baltimore Orioles","Camden Yards"]},"source":"MLB.com","source_domain":"mlb.com","source_url":"https://www.mlb.com","summary":"O's City Connects 2.0 a nod to Camden Yards' charms MLB.com Inside MLB's 2026 City Connect uniforms -- and what's next ESPN Nike Launches 2026 MLB City Connect Uniforms Defined by the Places, People and Stories of Each Club About Nike Early City Connect jersey thoughts. Plus: Konnor Griffin\u2019s deal, a \u2018compromise\u2019 The New York Times Baltimore Orioles unveil new City Connect jerseys WBFF","title":"O's City Connects 2.0 a nod to Camden Yards' charms - MLB.com","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_e8d0dce17074 in signals