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-08T14:43:46.182955+00:00","dedupe_key":"signal_enriched:news_delta:466c0ef54a144ee7","evidence_event_ids":["evt_97760d8f98ce"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPX01SNXA5NG9mRUJXSXhuOERzTEtueVIwZThtQVF6a0VBaW5wUzgxcHhmaGRSNmIzdms3X3ZqRWJ0dFdqMWlGMmkwdFVOY1BkX3VRTHB2MV93SmxWQ0JyWDM4V19pWHZGUmN6dUFIS2REeTFqNUJZR0hLU1VNQjlyRGo0bVFqNTBqX3djNkF3?oc=5","as_of":"2026-04-08T14:43:46.182955+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/CBMijgFBVV95cUxPX01SNXA5NG9mRUJXSXhuOERzTEtueVIwZThtQVF6a0VBaW5wUzgxcHhmaGRSNmIzdms3X3ZqRWJ0dFdqMWlGMmkwdFVOY1BkX3VRTHB2MV93SmxWQ0JyWDM4V19pWHZGUmN6dUFIS2REeTFqNUJZR0hLU1VNQjlyRGo0bVFqNTBqX3djNkF3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_93114cb0fce228fc","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:21:17.686712+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPX01SNXA5NG9mRUJXSXhuOERzTEtueVIwZThtQVF6a0VBaW5wUzgxcHhmaGRSNmIzdms3X3ZqRWJ0dFdqMWlGMmkwdFVOY1BkX3VRTHB2MV93SmxWQ0JyWDM4V19pWHZGUmN6dUFIS2REeTFqNUJZR0hLU1VNQjlyRGo0bVFqNTBqX3djNkF3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"chicagotribune.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPX01SNXA5NG9mRUJXSXhuOERzTEtueVIwZThtQVF6a0VBaW5wUzgxcHhmaGRSNmIzdms3X3ZqRWJ0dFdqMWlGMmkwdFVOY1BkX3VRTHB2MV93SmxWQ0JyWDM4V19pWHZGUmN6dUFIS2REeTFqNUJZR0hLU1VNQjlyRGo0bVFqNTBqX3djNkF3?oc=5","source_event_id":"evt_97760d8f98ce","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ece79cffa2b91915","published_at":"2026-04-08T12:00:29+00:00","publisher_domain":"chicagotribune.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Chicago Bears","relevance":"high","symbol":"","type":"sports_team"},{"asset_class":"other","name":"Dexter Lawrence","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Tyson Bagent","relevance":"high","symbol":"","type":"person"},{"asset_class":"equity","name":"New York Giants","relevance":"medium","symbol":"","type":"sports_team"},{"asset_class":"other","name":"John Harbaugh","relevance":"low","symbol":"","type":"person"},{"asset_class":"other","name":"Kayvon Thibodeaux","relevance":"low","symbol":"","type":"person"},{"asset_class":"other","name":"ESPN","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"equity","name":"New England Patriots","relevance":"low","symbol":"","type":"sports_team"},{"asset_class":"equity","name":"Jaguars","relevance":"low","symbol":"","type":"sports_team"}],"event_type":"other","information_gaps":["The cleaned article text provided is mostly HTML/CSS and does not contain the actual Q&A content; only the headline and the separate source summary are usable here.","No concrete trade terms (teams, picks, players) for Dexter Lawrence or Tyson Bagent are included in the provided excerpt\u2014only the questions/possibility framing.","The specific timing (e.g., draft vs. trade deadline) for the Bears-related trade questions is not stated in the provided text.","The identities of the \u201cthree-time Pro Bowler\u201d and the \u201cPro Bowl defensive tackle\u201d referenced in the summary are not included, limiting grounded extraction beyond the existence of those mentions."],"key_facts":["The Chicago Tribune headline frames a Bears Q&A around whether a deal for Dexter Lawrence is possible and what about a Tyson Bagent trade.","The source summary states Dexter Lawrence was absent from Giants workouts.","The source summary states John Harbaugh is optimistic (context not fully specified in the provided text).","The source summary mentions an ESPN Patriots trade idea involving swapping picks for a three-time Pro Bowler (player identity not included in the provided excerpt).","The source summary mentions a Yahoo Sports note naming the Jaguars as a landing spot for a Pro Bowl defensive tackle in a trade (player identity not included in the provided excerpt).","The source summary includes a quote attributed to John Harbaugh on Kayvon Thibodeaux: \u201cEverybody's tradable, but I'm thinking about him in our defense.\u201d"],"numeric_claims":[],"primary_claim":"The Chicago Tribune Q&A asks whether a trade for Dexter Lawrence is possible and what a Tyson Bagent trade could look like for the Chicago Bears.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The Chicago Tribune Q&A discusses whether the Bears could pursue a trade for Dexter Lawrence and separately raises the possibility of trading Tyson Bagent. The provided source summary also includes unrelated NFL trade/workout notes involving other teams and players.","topics":["NFL trade rumors","Chicago Bears roster moves","Dexter Lawrence trade possibility","Tyson Bagent trade possibility","Giants workouts","NFL offseason news"]},"source":"chicagotribune.com","source_domain":"chicagotribune.com","source_url":"https://www.chicagotribune.com","summary":"Chicago Bears Q&A: Is a deal for Dexter Lawrence possible? What about a Tyson Bagent trade? chicagotribune.com Lawrence absent from Giants workouts, but Harbaugh optimistic ESPN Patriots Trade Idea Swaps Three Picks For Three-Time Pro Bowler Amid Trade Request NESN Jaguars named landing spot for Pro Bowl defensive tackle in trade Yahoo Sports John Harbaugh on Kayvon Thibodeaux: Everybody's tradable, but I'm thinking about him in our defense NBC Sports","title":"Chicago Bears Q&A: Is a deal for Dexter Lawrence possible? What about a Tyson Bagent trade? - chicagotribune.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 7423 in events