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-08T15:55:25.561635+00:00","dedupe_key":"signal_enriched:news_delta:9ab78b561c6382d9","evidence_event_ids":["evt_f7afa1f556f7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxObE9VbTRsMzdIWHpKS2xqYlF1dERMcms3c0NDYk5XU0ctNHJHcjRLR3Vlc2cyZ2dDaWZRWUhia2xveUdGd2dTeGVheHJlM1BRaTVIMWZhYlZpYXlOcnBONktVcS1zY1hwWEtDbmF6Y20wWE92elpVakNJTXFpdFU0RWVWTXVSWml5TEE3UDV3RnFYLWhyaEhFZGtrOUp1UTJfa2FaR2dMZHlFUVlDUUVhV0doOHZHZFNISE1OWHFVTGU?oc=5","as_of":"2026-04-08T15:55:25.561635+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/CBMiwAFBVV95cUxObE9VbTRsMzdIWHpKS2xqYlF1dERMcms3c0NDYk5XU0ctNHJHcjRLR3Vlc2cyZ2dDaWZRWUhia2xveUdGd2dTeGVheHJlM1BRaTVIMWZhYlZpYXlOcnBONktVcS1zY1hwWEtDbmF6Y20wWE92elpVakNJTXFpdFU0RWVWTXVSWml5TEE3UDV3RnFYLWhyaEhFZGtrOUp1UTJfa2FaR2dMZHlFUVlDUUVhV0doOHZHZFNISE1OWHFVTGU?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2a046d17256cb932","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-08T17:24:38.337184+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxObE9VbTRsMzdIWHpKS2xqYlF1dERMcms3c0NDYk5XU0ctNHJHcjRLR3Vlc2cyZ2dDaWZRWUhia2xveUdGd2dTeGVheHJlM1BRaTVIMWZhYlZpYXlOcnBONktVcS1zY1hwWEtDbmF6Y20wWE92elpVakNJTXFpdFU0RWVWTXVSWml5TEE3UDV3RnFYLWhyaEhFZGtrOUp1UTJfa2FaR2dMZHlFUVlDUUVhV0doOHZHZFNISE1OWHFVTGU?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"post-gazette.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxObE9VbTRsMzdIWHpKS2xqYlF1dERMcms3c0NDYk5XU0ctNHJHcjRLR3Vlc2cyZ2dDaWZRWUhia2xveUdGd2dTeGVheHJlM1BRaTVIMWZhYlZpYXlOcnBONktVcS1zY1hwWEtDbmF6Y20wWE92elpVakNJTXFpdFU0RWVWTXVSWml5TEE3UDV3RnFYLWhyaEhFZGtrOUp1UTJfa2FaR2dMZHlFUVlDUUVhV0doOHZHZFNISE1OWHFVTGU?oc=5","source_event_id":"evt_f7afa1f556f7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ec08de845c83a504","published_at":"2026-04-08T15:10:56+00:00","publisher_domain":"post-gazette.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"sports_team","name":"Pittsburgh Pirates","relevance":"affected","symbol":"","type":"sports_team"},{"asset_class":"athlete","name":"Konnor Griffin","relevance":"affected","symbol":"","type":"person"},{"asset_class":"media","name":"Pittsburgh Post-Gazette","relevance":"source","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual article body, so details beyond the headline/source summary cannot be verified from the supplied text.","Exact effective date/when the extension begins (e.g., immediately vs. after current contract) is not stated in the provided material.","Whether the deal is officially finalized/announced by MLB or subject to any conditions is not specified in the provided text."],"key_facts":["Headline reports Pirates and Konnor Griffin agreed to the largest contract extension in franchise history.","Reported contract terms include a 9-year, $140M deal (as stated in the provided source summary).","Multiple outlets are referenced in the provided source summary as confirming the agreement and/or terms."],"numeric_claims":[{"label":"Contract length (years)","value":"9"},{"label":"Contract value (USD, millions)","value":"140"}],"primary_claim":"Konnor Griffin and the Pittsburgh Pirates agreed to a 9-year, $140M contract extension, the largest in Pirates franchise history.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"The Pittsburgh Pirates and top prospect Konnor Griffin agreed to a major contract extension, described as the largest in franchise history. The deal is reported as a 9-year, $140M agreement, signaling a near-term roster/competitive commitment around Griffin.","topics":["MLB contract extension","Konnor Griffin","Pittsburgh Pirates","player development","team payroll/commitment"]},"source":"Pittsburgh Post-Gazette","source_domain":"post-gazette.com","source_url":"https://www.post-gazette.com","summary":"Pirates, Konnor Griffin agree to the largest contract extension in franchise history Pittsburgh Post-Gazette Sources: Konnor Griffin agrees to 9-year, $140M deal with Pirates ESPN MLB top prospect Konnor Griffin agrees to team-record 9-year contract with Pirates - The Athletic The New York Times Griffin, Skenes give Pirates wide open window to win now TSN Pirates finalize nine-year deal with teenage shortstop Konnor Griffin Sportsnet","title":"Pirates, Konnor Griffin agree to the largest contract extension in franchise history - Pittsburgh Post-Gazette","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 7517 in events