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-07T00:26:15.574080+00:00","dedupe_key":"signal_enriched:news_delta:f25c3fa0583dd2f5","evidence_event_ids":["evt_eabf2bf132bd"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxObnNqUUhaS2ZubkhOcUVTc1JWN3VSZWNOS2VhZnNoMXNIcVRWTDBnMk5STlc4bExtQ2g1UnVoNEhXRjVrY01GRWxqRDlWbi1NYzRid2Y0cFF2MUMwemtWWm9qOHUtNGtUbG1NVzdEc1FVRk1zQi16bUlWMlpFUUFIYXVDRVBLcUsyNTNLT1lPcTdXZDlLNjdpYi1lcmR5LW5iYkZlQy0tZFg0RS1pZ0YtSWx3?oc=5","as_of":"2026-04-07T00:26:15.574080+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/CBMisgFBVV95cUxObnNqUUhaS2ZubkhOcUVTc1JWN3VSZWNOS2VhZnNoMXNIcVRWTDBnMk5STlc4bExtQ2g1UnVoNEhXRjVrY01GRWxqRDlWbi1NYzRid2Y0cFF2MUMwemtWWm9qOHUtNGtUbG1NVzdEc1FVRk1zQi16bUlWMlpFUUFIYXVDRVBLcUsyNTNLT1lPcTdXZDlLNjdpYi1lcmR5LW5iYkZlQy0tZFg0RS1pZ0YtSWx3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6abf6c7dc20ff9f2","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-07T14:20:00.449605+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxObnNqUUhaS2ZubkhOcUVTc1JWN3VSZWNOS2VhZnNoMXNIcVRWTDBnMk5STlc4bExtQ2g1UnVoNEhXRjVrY01GRWxqRDlWbi1NYzRid2Y0cFF2MUMwemtWWm9qOHUtNGtUbG1NVzdEc1FVRk1zQi16bUlWMlpFUUFIYXVDRVBLcUsyNTNLT1lPcTdXZDlLNjdpYi1lcmR5LW5iYkZlQy0tZFg0RS1pZ0YtSWx3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxObnNqUUhaS2ZubkhOcUVTc1JWN3VSZWNOS2VhZnNoMXNIcVRWTDBnMk5STlc4bExtQ2g1UnVoNEhXRjVrY01GRWxqRDlWbi1NYzRid2Y0cFF2MUMwemtWWm9qOHUtNGtUbG1NVzdEc1FVRk1zQi16bUlWMlpFUUFIYXVDRVBLcUsyNTNLT1lPcTdXZDlLNjdpYi1lcmR5LW5iYkZlQy0tZFg0RS1pZ0YtSWx3?oc=5","source_event_id":"evt_eabf2bf132bd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2ff830c3271e8ee9","published_at":"2026-04-06T21:56:23+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"sports","name":"North Carolina men's basketball","relevance":"high","symbol":"UNC","type":"team"},{"asset_class":"sports","name":"Michael Malone","relevance":"high","symbol":"","type":"person"}],"event_type":"other","information_gaps":["Exact timing of the hiring process is unclear.","Details on contract terms are not provided."],"key_facts":["Michael Malone is a former NBA coach.","He is set to replace Hubert Davis as head coach."],"numeric_claims":[],"primary_claim":"Michael Malone will be hired as the head coach of North Carolina men's basketball.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"North Carolina men's basketball is reportedly set to hire Michael Malone as their next head coach, replacing Hubert Davis.","topics":["coaching change","college basketball","North Carolina","Michael Malone"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"North Carolina men's basketball to hire Michael Malone as next head coach, per reports NBC News UNC to hire ex-NBA coach Michael Malone as HC, sources say ESPN North Carolina working to finalize deal to hire Michael Malone as basketball coach, AP source says WRAL North Carolina to reportedly hire former Nuggets coach Michael Malone as Hubert Davis' replacement Yahoo Sports Michael Malone\u2019s reported move to UNC stuns the college basketball world CNN","title":"North Carolina men's basketball to hire Michael Malone as next head coach, per reports - NBC News","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 37988 in events