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-21T23:02:26.216285+00:00","dedupe_key":"signal_enriched:news_delta:ef3793b16a42817c","evidence_event_ids":["evt_3556558b9b2f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAJBVV95cUxQWVV4SG5TeWNfWDR6a1cxd19ucDVNeG5xN2J3aERNSzdOWjVrNHcycTNTZ2JGZ05KYU5zZUhaZmJhNnBQZTlGdkREWjJ1UEJKdy00TWktcFdrZV9VdkpEZTZHaDU0MXBWZVlPcldiSFpPZHJlQTdselZkeXRpUk9YZHN2eFhBYkRrdGl3N0hwMkpFVXlLSzdaSUpCQTNpSDZ1OUViX1FseEdIbDNLWDQzdjNrZmFEUEVPOTlqLXVlRUN2VUdtVDhFeERyNUtQM2I0eWtCY29JV3BybXNfc0ttRmZ2WHcyZEpRYTRWcm9uREtfeUJuaDdxOUpPX2pERWhFZDNNVXR6MDQ?oc=5","as_of":"2026-04-21T23:02:26.216285+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiAJBVV95cUxQWVV4SG5TeWNfWDR6a1cxd19ucDVNeG5xN2J3aERNSzdOWjVrNHcycTNTZ2JGZ05KYU5zZUhaZmJhNnBQZTlGdkREWjJ1UEJKdy00TWktcFdrZV9VdkpEZTZHaDU0MXBWZVlPcldiSFpPZHJlQTdselZkeXRpUk9YZHN2eFhBYkRrdGl3N0hwMkpFVXlLSzdaSUpCQTNpSDZ1OUViX1FseEdIbDNLWDQzdjNrZmFEUEVPOTlqLXVlRUN2VUdtVDhFeERyNUtQM2I0eWtCY29JV3BybXNfc0ttRmZ2WHcyZEpRYTRWcm9uREtfeUJuaDdxOUpPX2pERWhFZDNNVXR6MDQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3cf35bd5a63e4596","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:14:24.834080+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAJBVV95cUxQWVV4SG5TeWNfWDR6a1cxd19ucDVNeG5xN2J3aERNSzdOWjVrNHcycTNTZ2JGZ05KYU5zZUhaZmJhNnBQZTlGdkREWjJ1UEJKdy00TWktcFdrZV9VdkpEZTZHaDU0MXBWZVlPcldiSFpPZHJlQTdselZkeXRpUk9YZHN2eFhBYkRrdGl3N0hwMkpFVXlLSzdaSUpCQTNpSDZ1OUViX1FseEdIbDNLWDQzdjNrZmFEUEVPOTlqLXVlRUN2VUdtVDhFeERyNUtQM2I0eWtCY29JV3BybXNfc0ttRmZ2WHcyZEpRYTRWcm9uREtfeUJuaDdxOUpPX2pERWhFZDNNVXR6MDQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sports.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAJBVV95cUxQWVV4SG5TeWNfWDR6a1cxd19ucDVNeG5xN2J3aERNSzdOWjVrNHcycTNTZ2JGZ05KYU5zZUhaZmJhNnBQZTlGdkREWjJ1UEJKdy00TWktcFdrZV9VdkpEZTZHaDU0MXBWZVlPcldiSFpPZHJlQTdselZkeXRpUk9YZHN2eFhBYkRrdGl3N0hwMkpFVXlLSzdaSUpCQTNpSDZ1OUViX1FseEdIbDNLWDQzdjNrZmFEUEVPOTlqLXVlRUN2VUdtVDhFeERyNUtQM2I0eWtCY29JV3BybXNfc0ttRmZ2WHcyZEpRYTRWcm9uREtfeUJuaDdxOUpPX2pERWhFZDNNVXR6MDQ?oc=5","source_event_id":"evt_3556558b9b2f","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"24357f4f6b2f5fb1","published_at":"2026-04-21T21:38:52+00:00","publisher_domain":"sports.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Duke lands ex-Wisconsin star John Blackwell in huge transfer portal get for the Blue Devils - Yahoo Sports","Source summary: Duke lands ex-Wisconsin star John Blackwell in huge transfer portal get for the Blue Devils Yahoo Sports Duke lands John Blackwell, top guard in transfer portal ESPN Duke lands Wisconsin transfer John Blackwell, cementing likely top-5 team entering season The New York Times Portaling: John Blackwell To Duke! Duke Basketball Report On3 Report: Illinois out of John Blackwell sweepstakes The Champaign Room"],"numeric_claims":[],"primary_claim":"Duke lands ex-Wisconsin star John Blackwell in huge transfer portal get for the Blue Devils - Yahoo Sports","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Duke lands ex-Wisconsin star John Blackwell in huge transfer portal get for the Blue Devils Yahoo Sports Duke lands John Blackwell, top guard in transfer portal ESPN Duke lands Wisconsin transfer John Blackwell, cementing likely top-5 team entering season The New York Times Portaling: John Blackwell To Duke! Duke Basketball Report On3 Report: Illinois out of John Blackwell sweepstakes The Champaig","topics":["news headline"]},"source":"Yahoo Sports","source_domain":"sports.yahoo.com","source_url":"https://sports.yahoo.com","summary":"Duke lands ex-Wisconsin star John Blackwell in huge transfer portal get for the Blue Devils Yahoo Sports Duke lands John Blackwell, top guard in transfer portal ESPN Duke lands Wisconsin transfer John Blackwell, cementing likely top-5 team entering season The New York Times Portaling: John Blackwell To Duke! Duke Basketball Report On3 Report: Illinois out of John Blackwell sweepstakes The Champaign Room","title":"Duke lands ex-Wisconsin star John Blackwell in huge transfer portal get for the Blue Devils - Yahoo Sports","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/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 475583 in events