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-06T20:42:08.491719+00:00","dedupe_key":"signal_enriched:news_delta:869a4fdd4577435f","evidence_event_ids":["evt_e59f15c72cf5"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE1XRU5zRDhWZTY4WkdHWWVfVGVUdGUwdXJvXzJPcDFva3pwbGoxZVliUk1LOFBGeFhXWDNIY2Jla3p0VlF2bUE4Y0ZHWmtTRlVzVWRsZ0N1SWU3UC1wbnFUMUN4bjd2dElPbmFRcTRsUHdPT2N2ZlJfb2FKb2xmUdIBfkFVX3lxTE5VR0llTHFqMkxCdGxrWGFqQjY3NzY4WnVXWUhTMGJVdEJHTno3MVBRSV9BQldfSUxWQXhOZlFsTExDQlBKZWpYY2pzeTZCSlhPdjZDQ1UzbWRYV3ZuNm1FUGRfMElyaVZoVlYweFJkaG1PelJPUlFtblNXTEdxQQ?oc=5","as_of":"2026-04-06T20:42:08.491719+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/CBMifkFVX3lxTE1XRU5zRDhWZTY4WkdHWWVfVGVUdGUwdXJvXzJPcDFva3pwbGoxZVliUk1LOFBGeFhXWDNIY2Jla3p0VlF2bUE4Y0ZHWmtTRlVzVWRsZ0N1SWU3UC1wbnFUMUN4bjd2dElPbmFRcTRsUHdPT2N2ZlJfb2FKb2xmUdIBfkFVX3lxTE5VR0llTHFqMkxCdGxrWGFqQjY3NzY4WnVXWUhTMGJVdEJHTno3MVBRSV9BQldfSUxWQXhOZlFsTExDQlBKZWpYY2pzeTZCSlhPdjZDQ1UzbWRYV3ZuNm1FUGRfMElyaVZoVlYweFJkaG1PelJPUlFtblNXTEdxQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_422faac6b32cb976","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-07T11:16:17.420191+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE1XRU5zRDhWZTY4WkdHWWVfVGVUdGUwdXJvXzJPcDFva3pwbGoxZVliUk1LOFBGeFhXWDNIY2Jla3p0VlF2bUE4Y0ZHWmtTRlVzVWRsZ0N1SWU3UC1wbnFUMUN4bjd2dElPbmFRcTRsUHdPT2N2ZlJfb2FKb2xmUdIBfkFVX3lxTE5VR0llTHFqMkxCdGxrWGFqQjY3NzY4WnVXWUhTMGJVdEJHTno3MVBRSV9BQldfSUxWQXhOZlFsTExDQlBKZWpYY2pzeTZCSlhPdjZDQ1UzbWRYV3ZuNm1FUGRfMElyaVZoVlYweFJkaG1PelJPUlFtblNXTEdxQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"newsobserver.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE1XRU5zRDhWZTY4WkdHWWVfVGVUdGUwdXJvXzJPcDFva3pwbGoxZVliUk1LOFBGeFhXWDNIY2Jla3p0VlF2bUE4Y0ZHWmtTRlVzVWRsZ0N1SWU3UC1wbnFUMUN4bjd2dElPbmFRcTRsUHdPT2N2ZlJfb2FKb2xmUdIBfkFVX3lxTE5VR0llTHFqMkxCdGxrWGFqQjY3NzY4WnVXWUhTMGJVdEJHTno3MVBRSV9BQldfSUxWQXhOZlFsTExDQlBKZWpYY2pzeTZCSlhPdjZDQ1UzbWRYV3ZuNm1FUGRfMElyaVZoVlYweFJkaG1PelJPUlFtblNXTEdxQQ?oc=5","source_event_id":"evt_e59f15c72cf5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"95bb1befe890919a","published_at":"2026-04-06T18:23:00+00:00","publisher_domain":"newsobserver.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"sports","name":"UNC Men's Basketball","relevance":"high","symbol":"UNC","type":"team"},{"asset_class":"sports","name":"Michael Malone","relevance":"high","symbol":"N/A","type":"person"}],"event_type":"other","information_gaps":["No specific date mentioned for the official hiring announcement."],"key_facts":["Michael Malone is a former NBA coach.","Hubert Davis was recently fired as head coach of UNC.","The hiring is reported by multiple sources including ESPN and Fox News."],"numeric_claims":[],"primary_claim":"UNC will hire Michael Malone as the new head coach for their men's basketball team.","relevance_score":0.8,"sentiment":"positive","source_quality":"high","summary":"UNC men's basketball is set to hire Michael Malone as their next head coach following the firing of Hubert Davis.","topics":["coaching change","college basketball","UNC","Michael Malone"]},"source":"Raleigh News & Observer","source_domain":"newsobserver.com","source_url":"https://www.newsobserver.com","summary":"UNC men\u2019s basketball to hire Michael Malone as next head coach Raleigh News & Observer UNC to hire ex-NBA coach Michael Malone as HC, sources say ESPN UNC set to hire Michael Malone as next men's basketball coach after firing Hubert Davis: report Fox News North Carolina to reportedly hire former Nuggets coach Mike Malone as Hubert Davis' replacement Yahoo Sports Mike Krzyzewski says North Carolina's Michael Malone will have 'learning curve' USA Today","title":"UNC men\u2019s basketball to hire Michael Malone as next head coach - Raleigh News & Observer","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 37020 in events