SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_38246942e6f9 in signals