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/CBMiqgFBVV95cUxNRC13cjVXa3NfY3NpR2p0UTg4XzQzLUZzdFdLZkkwZU5KNVFkVWE1azFLX25YLUVSQm9sWjJGTDVZQWdreGdPdGF6aVBkbTJuQV9XLTM0RloxUWplMUZLdDZaUDFyRXJSQW5PbXd5QS1YQnA5YVhoTDl1ckxWb2JNRGRyd0VkcjVsa1d2VWhkWklCOHNUZkxJWnZXRTVmVy00VzJmbGdBUTltQQ?oc=5","as_of":"2026-04-08T02:13:53.760335+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/CBMiqgFBVV95cUxNRC13cjVXa3NfY3NpR2p0UTg4XzQzLUZzdFdLZkkwZU5KNVFkVWE1azFLX25YLUVSQm9sWjJGTDVZQWdreGdPdGF6aVBkbTJuQV9XLTM0RloxUWplMUZLdDZaUDFyRXJSQW5PbXd5QS1YQnA5YVhoTDl1ckxWb2JNRGRyd0VkcjVsa1d2VWhkWklCOHNUZkxJWnZXRTVmVy00VzJmbGdBUTltQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8dcbe5df91964d3b","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-08T02:14:53.971935+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxNRC13cjVXa3NfY3NpR2p0UTg4XzQzLUZzdFdLZkkwZU5KNVFkVWE1azFLX25YLUVSQm9sWjJGTDVZQWdreGdPdGF6aVBkbTJuQV9XLTM0RloxUWplMUZLdDZaUDFyRXJSQW5PbXd5QS1YQnA5YVhoTDl1ckxWb2JNRGRyd0VkcjVsa1d2VWhkWklCOHNUZkxJWnZXRTVmVy00VzJmbGdBUTltQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxNRC13cjVXa3NfY3NpR2p0UTg4XzQzLUZzdFdLZkkwZU5KNVFkVWE1azFLX25YLUVSQm9sWjJGTDVZQWdreGdPdGF6aVBkbTJuQV9XLTM0RloxUWplMUZLdDZaUDFyRXJSQW5PbXd5QS1YQnA5YVhoTDl1ckxWb2JNRGRyd0VkcjVsa1d2VWhkWklCOHNUZkxJWnZXRTVmVy00VzJmbGdBUTltQQ?oc=5","source_event_id":"evt_5e4951e64e7e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4d1a003cdfc21fd7","published_at":"2026-04-07T23:12:01+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"University of Wisconsin System Board of Regents","relevance":"direct decision-maker","symbol":"","type":"governing body"},{"asset_class":"other","name":"Jay Rothman","relevance":"fired system president","symbol":"","type":"person"},{"asset_class":"other","name":"University of Wisconsin System","relevance":"institution affected","symbol":"","type":"organization"},{"asset_class":"other","name":"Republicans (Wisconsin)","relevance":"called for regents to testify","symbol":"","type":"political group"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the substantive article content; extraction is therefore based on the provided headline and source summary rather than full article text.","The specific vote count, timing (date of vote), and stated grounds beyond refusal to quit are not included in the provided material.","Whether an interim president will be appointed and when is not specified.","Market/financial impact is not directly indicated; any investment relevance would be indirect via public-sector governance."],"key_facts":["The University of Wisconsin System Board of Regents voted to fire system president Jay Rothman.","The reported reason is that Rothman refused to resign/quit.","The New York Times frames the event as a board action to remove the system president.","The Milwaukee Journal Sentinel and WPR are referenced as additional coverage sources.","Republicans called for the regents to testify while Rothman was poised to lose his job (as described in the provided source summary)."],"numeric_claims":[],"primary_claim":"The University of Wisconsin System Board of Regents fired President Jay Rothman after he refused to quit.","relevance_score":0.42,"sentiment":"negative","source_quality":"high","summary":"The University of Wisconsin System Board of Regents voted to fire system president Jay Rothman after he refused to resign. The decision is immediately actionable and is likely to trigger near-term leadership transition and political scrutiny.","topics":["leadership change","higher education governance","political oversight","Wisconsin state institutions"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Leader of University of Wisconsin System Is Fired by the Board The New York Times Universities of Wisconsin board votes to fire system president after he refused to quit Channel 3000 With UW president poised to lose job, Republicans call for regents to testify Milwaukee Journal Sentinel WMC Statement on UW President Jay Rothman Wisconsin Manufacturers & Commerce Universities of Wisconsin Board of Regents fires President Jay Rothman WPR","title":"Leader of University of Wisconsin System Is Fired by the Board - The New York Times","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_7e80b55d8d5a in signals