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-08T02:13:53.760335+00:00","dedupe_key":"signal_enriched:news_delta:bb4cca9acc2d64df","evidence_event_ids":["evt_5e4951e64e7e"],"signal_type":"news_headline_delta","source":"news_rss","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

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 3465 in events