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-09T19:28:46.022375+00:00","dedupe_key":"signal_enriched:news_delta:5a0b3800c0cff7cb","evidence_event_ids":["evt_028baf846673"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMickFVX3lxTE1hX2tQYnVJbUJjeXFvRHVGclZpa2VaOVV5U05YNUZiUW9Ma2F3ekdBaVEzc3A4aWRreTNMbTk2ZlVLaF9FMmJfM2pET1BkWFN0UHdFbml3R0xzbmM4Q25oRkZrWHhrZzl6SFdwb29FVDdFdw?oc=5","as_of":"2026-04-09T19:28:46.022375+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/CBMickFVX3lxTE1hX2tQYnVJbUJjeXFvRHVGclZpa2VaOVV5U05YNUZiUW9Ma2F3ekdBaVEzc3A4aWRreTNMbTk2ZlVLaF9FMmJfM2pET1BkWFN0UHdFbml3R0xzbmM4Q25oRkZrWHhrZzl6SFdwb29FVDdFdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3e3d256f23c10e4c","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:23:25.305391+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMickFVX3lxTE1hX2tQYnVJbUJjeXFvRHVGclZpa2VaOVV5U05YNUZiUW9Ma2F3ekdBaVEzc3A4aWRreTNMbTk2ZlVLaF9FMmJfM2pET1BkWFN0UHdFbml3R0xzbmM4Q25oRkZrWHhrZzl6SFdwb29FVDdFdw?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/CBMickFVX3lxTE1hX2tQYnVJbUJjeXFvRHVGclZpa2VaOVV5U05YNUZiUW9Ma2F3ekdBaVEzc3A4aWRreTNMbTk2ZlVLaF9FMmJfM2pET1BkWFN0UHdFbml3R0xzbmM4Q25oRkZrWHhrZzl6SFdwb29FVDdFdw?oc=5","source_event_id":"evt_028baf846673","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4d417c5c30aabd59","published_at":"2026-04-09T15:15:59+00:00","publisher_domain":"mlb.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"San Diego Padres","relevance":"primary","symbol":"","type":"sports_team"},{"asset_class":"media","name":"MLB.com","relevance":"source","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["No jersey design specifics (colors, logos, release date, or whether it\u2019s for 2026/another season) are present in the provided cleaned text.","The identities of the other 7 teams are not listed in the provided text.","No near-term catalyst timing (e.g., when the jerseys will debut in games) is included in the provided text."],"key_facts":["The headline states the Padres\u2019 new City Connect jerseys are \u201cas vibrant as city they call home.\u201d","The source summary indicates \u201c8 teams unveil new City Connect uniforms.\u201d","The provided source summary references additional City Connect uniform coverage from other outlets (ESPN, AJC.com, WBFF), but specific details are not included in the cleaned article text."],"numeric_claims":[],"primary_claim":"The Padres unveiled new City Connect jerseys, characterized as vibrant and tied to the city they call home.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"MLB.com reports that the San Diego Padres have unveiled new City Connect jerseys, described as vibrant and reflective of the city they represent. The broader context notes that multiple MLB teams are rolling out new City Connect uniforms.","topics":["MLB","City Connect uniforms","San Diego Padres","team branding","uniform unveiling"]},"source":"MLB.com","source_domain":"mlb.com","source_url":"https://www.mlb.com","summary":"Padres' new City Connect jerseys as vibrant as city they call home MLB.com 8 teams unveil new City Connect uniforms MLB.com Inside MLB's 2026 City Connect uniforms -- and what's next ESPN How the Braves\u2019 City Connect 2.0 uniforms came to life AJC.com Baltimore Orioles unveil new City Connect jerseys WBFF","title":"Padres' new City Connect jerseys as vibrant as city they call home - 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

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 11120 in events