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/CBMipgFBVV95cUxQSldYNndGNl9vZm9YLUZCa1BxMHA1cWYydUNGYmE5VlF6RTl5bEtBcmpLaXNlbkVRRFhaREVTWEY5ZW43ZW43RE5Xck81UW5qQmgzTVU1a3NiNWJkRzVvQ3JMRnJfcUd0OU5MNDRabDgtVHItWHYwaXJ6NWI3eWZqRXlMWkZnNnYtR3l3enlvNm1qemRvLXRGbV9DZUhMdkhjc0tqanhB?oc=5","as_of":"2026-04-09T09:54:21.986684+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/CBMipgFBVV95cUxQSldYNndGNl9vZm9YLUZCa1BxMHA1cWYydUNGYmE5VlF6RTl5bEtBcmpLaXNlbkVRRFhaREVTWEY5ZW43ZW43RE5Xck81UW5qQmgzTVU1a3NiNWJkRzVvQ3JMRnJfcUd0OU5MNDRabDgtVHItWHYwaXJ6NWI3eWZqRXlMWkZnNnYtR3l3enlvNm1qemRvLXRGbV9DZUhMdkhjc0tqanhB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b60983f83c0c81e9","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-09T23:05:17.763107+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQSldYNndGNl9vZm9YLUZCa1BxMHA1cWYydUNGYmE5VlF6RTl5bEtBcmpLaXNlbkVRRFhaREVTWEY5ZW43ZW43RE5Xck81UW5qQmgzTVU1a3NiNWJkRzVvQ3JMRnJfcUd0OU5MNDRabDgtVHItWHYwaXJ6NWI3eWZqRXlMWkZnNnYtR3l3enlvNm1qemRvLXRGbV9DZUhMdkhjc0tqanhB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"keepingitheel.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQSldYNndGNl9vZm9YLUZCa1BxMHA1cWYydUNGYmE5VlF6RTl5bEtBcmpLaXNlbkVRRFhaREVTWEY5ZW43ZW43RE5Xck81UW5qQmgzTVU1a3NiNWJkRzVvQ3JMRnJfcUd0OU5MNDRabDgtVHItWHYwaXJ6NWI3eWZqRXlMWkZnNnYtR3l3enlvNm1qemRvLXRGbV9DZUhMdkhjc0tqanhB?oc=5","source_event_id":"evt_36afc7cd03d4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f61bffa2bd2a17d0","published_at":"2026-04-08T21:18:24+00:00","publisher_domain":"keepingitheel.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Michael Malone","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"University of North Carolina (UNC)","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"UNC basketball program","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"Keeping It Heel","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["The article text provided is not actually present (only CSS/HTML boilerplate), so the specific staff hire details (name, role, timing) are not verifiable from the supplied content.","No date/timeframe for when the hire occurred is included in the provided text.","No confirmation is provided here of whether the hire is the first of multiple planned hires or the exact impact on recruiting/performance."],"key_facts":["The headline states Michael Malone made his first staff hire at UNC.","The source summary frames the hire as a \u201cgame-changer\u201d and suggests Malone sees a chance to be \u201cpart of something special\u201d at UNC."],"numeric_claims":[],"primary_claim":"Michael Malone has made his first UNC staff hire.","relevance_score":0.42,"sentiment":"positive","source_quality":"high","summary":"UNC basketball coach Michael Malone has made his first staff hire at the University of North Carolina, described as a major early step in building his program. The near-term catalyst implied is continued staffing/organizational moves following this first hire.","topics":["college basketball coaching staff","UNC athletics","Michael Malone","staff hiring","program building"]},"source":"Keeping It Heel","source_domain":"keepingitheel.com","source_url":"https://keepingitheel.com","summary":"Michael Malone just made his first UNC staff hire and it's a total game-changer Keeping It Heel Malone sees chance to be 'part of something special' at UNC ESPN Lucas: First And Last - University of North Carolina Athletics University of North Carolina Athletics UNC basketball coach Michael Malone nearing his first staff hire. The latest Raleigh News & Observer How North Carolina Turned Michael Malone\u2019s No Into a Yes 247Sports","title":"Michael Malone just made his first UNC staff hire and it's a total game-changer - Keeping It Heel","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_535f5a702772 in signals