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/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

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_990486688972 in signals