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-04T20:56:15.728385+00:00","dedupe_key":"signal_enriched:news_delta:75e3533c30c52035","evidence_event_ids":["evt_0c0a8f31c083"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxQM1lMbk93M2VJeFAyQjVfZTBPc2dDYjBPdlVmSkFWajVyMlJqUmtQVkdRSVpVMjdjUGhBaEJhajZBRjVHOE1TZmN2bFVfb1JCcGpUS1BabW5ia21xZXhfbFhLLWdfZlFFVHplbTMyc0h0bzk4VEhsOG85cWJxWUp4Nms5WWZXbW5WRy1LYl9YTlhBZzBsZmxLajkxM3ozdUU0Z3NaaEl0TjVNVTRvelJJZUx2ZjVyZ1ZBbGJRSUVJT2Vtd0VD?oc=5","as_of":"2026-04-04T20:56:15.728385+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxQM1lMbk93M2VJeFAyQjVfZTBPc2dDYjBPdlVmSkFWajVyMlJqUmtQVkdRSVpVMjdjUGhBaEJhajZBRjVHOE1TZmN2bFVfb1JCcGpUS1BabW5ia21xZXhfbFhLLWdfZlFFVHplbTMyc0h0bzk4VEhsOG85cWJxWUp4Nms5WWZXbW5WRy1LYl9YTlhBZzBsZmxLajkxM3ozdUU0Z3NaaEl0TjVNVTRvelJJZUx2ZjVyZ1ZBbGJRSUVJT2Vtd0VD?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9dc65ffcc8c6263e","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T21:20:44.997684+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxQM1lMbk93M2VJeFAyQjVfZTBPc2dDYjBPdlVmSkFWajVyMlJqUmtQVkdRSVpVMjdjUGhBaEJhajZBRjVHOE1TZmN2bFVfb1JCcGpUS1BabW5ia21xZXhfbFhLLWdfZlFFVHplbTMyc0h0bzk4VEhsOG85cWJxWUp4Nms5WWZXbW5WRy1LYl9YTlhBZzBsZmxLajkxM3ozdUU0Z3NaaEl0TjVNVTRvelJJZUx2ZjVyZ1ZBbGJRSUVJT2Vtd0VD?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"on3.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxQM1lMbk93M2VJeFAyQjVfZTBPc2dDYjBPdlVmSkFWajVyMlJqUmtQVkdRSVpVMjdjUGhBaEJhajZBRjVHOE1TZmN2bFVfb1JCcGpUS1BabW5ia21xZXhfbFhLLWdfZlFFVHplbTMyc0h0bzk4VEhsOG85cWJxWUp4Nms5WWZXbW5WRy1LYl9YTlhBZzBsZmxLajkxM3ozdUU0Z3NaaEl0TjVNVTRvelJJZUx2ZjVyZ1ZBbGJRSUVJT2Vtd0VD?oc=5","source_event_id":"evt_0c0a8f31c083","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e32cbc7b413ccba2","published_at":"2026-04-04T19:47:33+00:00","publisher_domain":"on3.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"education","name":"UNC","relevance":"high","symbol":"UNC","type":"university"},{"asset_class":"sports","name":"Tommy Lloyd","relevance":"high","symbol":"N/A","type":"coach"},{"asset_class":"education","name":"Arizona","relevance":"medium","symbol":"AZ","type":"university"}],"event_type":"other","information_gaps":["Uncertainty about the final decision on the coaching position at UNC.","Details on other candidates being considered are not fully disclosed."],"key_facts":["Tommy Lloyd has agreed to a new 5-year deal with Arizona.","The UNC coaching position is highly sought after, especially after the recent Final Four.","Speculation includes other candidates like Billy Donovan and Todd Golden."],"numeric_claims":[],"primary_claim":"Tommy Lloyd is a significant name in the UNC coaching search.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"The UNC coaching search has intensified with speculation around potential candidates, including a notable mention of Tommy Lloyd, who recently secured a new contract with Arizona.","topics":["coaching search","college basketball","UNC","Tommy Lloyd"]},"source":"On3","source_domain":"on3.com","source_url":"https://www.on3.com","summary":"Pete Thamel drops bombshell name into UNC coaching search On3 Tommy Lloyd agrees to new 5-year deal with Arizona ESPN Coaches to leave team after Final Four: UNC job creates March Madness intrigue USA Today If North Carolina Doesn\u2019t Land Billy Donovan, Is Blueblood Power Slipping? Sports Illustrated UNC coaching search: Florida coach Todd Golden pressed on if he was offered Tar Heels job On3","title":"Pete Thamel drops bombshell name into UNC coaching search - On3","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/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 16708 in events