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-07T23:23:38.933193+00:00","dedupe_key":"signal_enriched:news_delta:ea6926949a8dd7ac","evidence_event_ids":["evt_8b40ed3599a8"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5","as_of":"2026-04-07T23:23:38.933193+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/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b1c8325a0355f8c6","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-08T00:35:32.159385+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcsports.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi1AFBVV95cUxQUUpWRjRqQjlpTnA5a3dlOVozSC1VZTVLRDdXOGNicEhvTVBCRDJQQ21hX081bG9qWHdHbWlGeWFMVkZUSW9WZ1ZtY1VkbVM5NEZmOG5lbUpMZHc0eWVkUzloVDQxM2dsOV81N3F4b0ZXNW0xYzlZdjlERDU1dENkT25sbzQxbXBTLTVjWWw3dXQyclg0bWJDLWhxdUIwMUJ1ZkYteUNfOF9EU2FMMnVPemxnUWFBNjRpaHRDT2IyODhEbThmczFmSkVwLWpjd1liT1U3MA?oc=5","source_event_id":"evt_8b40ed3599a8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"29b49d8b09c0a105","published_at":"2026-04-07T17:51:02+00:00","publisher_domain":"nbcsports.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sports_person","name":"John Harbaugh","relevance":"high","symbol":"","type":"person"},{"asset_class":"sports_person","name":"Dexter Lawrence","relevance":"high","symbol":"","type":"person"},{"asset_class":"sports_team","name":"New York Giants","relevance":"high","symbol":"NYG","type":"organization"},{"asset_class":"media_outlet","name":"NBC Sports","relevance":"medium","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not contain the actual quote content; only the headline and the provided source summary were usable.","No specific timing (e.g., trade deadline date) is stated in the provided material.","No details are provided on Lawrence\u2019s salary demands beyond a mention in the source summary; exact figures are not included.","It is not confirmed from the provided text that Lawrence will definitively remain; Harbaugh\u2019s statement is predictive/optimistic rather than a confirmation."],"key_facts":["NBC Sports headline states: \u201cJohn Harbaugh: I think prospects are high Dexter Lawrence remains with Giants.\u201d","The provided source summary indicates Lawrence was absent from Giants workouts.","The provided source summary indicates Harbaugh is optimistic about Lawrence remaining with the Giants."],"numeric_claims":[],"primary_claim":"John Harbaugh said he thinks the prospects are high that Dexter Lawrence remains with the Giants.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"NBC Sports reports that John Harbaugh said he believes the prospects are high that Dexter Lawrence will remain with the New York Giants. The context suggests Lawrence has been absent from Giants workouts, but Harbaugh is optimistic about his staying.","topics":["NFL","player contract/trade speculation","Dexter Lawrence","Giants roster","workouts/availability","public comments"]},"source":"NBC Sports","source_domain":"nbcsports.com","source_url":"https://www.nbcsports.com","summary":"John Harbaugh: I think prospects are high Dexter Lawrence remains with Giants NBC Sports Lawrence absent from Giants workouts, but Harbaugh optimistic ESPN New York Giants\u2019 star defender Dexter Lawrence salary demands revealed sports.yahoo.com Dexter Lawrence landing spots: Eight potential destinations for Giants star DT NFL.com What's next for Dexter Lawrence and Giants following trade request? Opposing teams weigh in sny.tv","title":"John Harbaugh: I think prospects are high Dexter Lawrence remains with Giants - NBC Sports","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 2287 in events