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:29:41.311693+00:00","dedupe_key":"signal_enriched:news_delta:68478e99055fe599","evidence_event_ids":["evt_cdf3c0a7246d"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi_wFBVV95cUxPYUo2eVVSZmthdmpGRVNBYi1IWVRudkl5clZseVcxNTdXMmlCYm81Q05leHZNQXhucHl4bVdHc0pHZVAzNTJ5TTh5TXY3SHE3RlAyZmRxa05sSnVnZGpiYkV4bTlqNzd0eDFVUEdBSkg4cThxQ1g0cUpWMk1GeTRTX2lWcXp4SXBmYVFVb3BIZTlVZDdBN0wwNXhUbXJLaGZ4cmsyZGgzY2dsU2NnSFRwTFh5ZGF1R0hoQVRKT1pPaU1KR2VxRnFWSUNoRXBiRkxqR3pKWm5uZEM1U2tvVmdiMURZMXN2b29CZ0ZCcWxNZ1FDLTF1VmtvRzhYYnRPblk?oc=5","as_of":"2026-04-08T02:29:41.311693+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/CBMi_wFBVV95cUxPYUo2eVVSZmthdmpGRVNBYi1IWVRudkl5clZseVcxNTdXMmlCYm81Q05leHZNQXhucHl4bVdHc0pHZVAzNTJ5TTh5TXY3SHE3RlAyZmRxa05sSnVnZGpiYkV4bTlqNzd0eDFVUEdBSkg4cThxQ1g0cUpWMk1GeTRTX2lWcXp4SXBmYVFVb3BIZTlVZDdBN0wwNXhUbXJLaGZ4cmsyZGgzY2dsU2NnSFRwTFh5ZGF1R0hoQVRKT1pPaU1KR2VxRnFWSUNoRXBiRkxqR3pKWm5uZEM1U2tvVmdiMURZMXN2b29CZ0ZCcWxNZ1FDLTF1VmtvRzhYYnRPblk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2d9f5c73048c63d1","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-08T03:52:11.238106+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi_wFBVV95cUxPYUo2eVVSZmthdmpGRVNBYi1IWVRudkl5clZseVcxNTdXMmlCYm81Q05leHZNQXhucHl4bVdHc0pHZVAzNTJ5TTh5TXY3SHE3RlAyZmRxa05sSnVnZGpiYkV4bTlqNzd0eDFVUEdBSkg4cThxQ1g0cUpWMk1GeTRTX2lWcXp4SXBmYVFVb3BIZTlVZDdBN0wwNXhUbXJLaGZ4cmsyZGgzY2dsU2NnSFRwTFh5ZGF1R0hoQVRKT1pPaU1KR2VxRnFWSUNoRXBiRkxqR3pKWm5uZEM1U2tvVmdiMURZMXN2b29CZ0ZCcWxNZ1FDLTF1VmtvRzhYYnRPblk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"channel3000.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi_wFBVV95cUxPYUo2eVVSZmthdmpGRVNBYi1IWVRudkl5clZseVcxNTdXMmlCYm81Q05leHZNQXhucHl4bVdHc0pHZVAzNTJ5TTh5TXY3SHE3RlAyZmRxa05sSnVnZGpiYkV4bTlqNzd0eDFVUEdBSkg4cThxQ1g0cUpWMk1GeTRTX2lWcXp4SXBmYVFVb3BIZTlVZDdBN0wwNXhUbXJLaGZ4cmsyZGgzY2dsU2NnSFRwTFh5ZGF1R0hoQVRKT1pPaU1KR2VxRnFWSUNoRXBiRkxqR3pKWm5uZEM1U2tvVmdiMURZMXN2b29CZ0ZCcWxNZ1FDLTF1VmtvRzhYYnRPblk?oc=5","source_event_id":"evt_cdf3c0a7246d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d4d6ded4cb654832","published_at":"2026-04-07T22:58:00+00:00","publisher_domain":"channel3000.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"institution","name":"University of Wisconsin System Board of Regents","relevance":"high","symbol":"","type":"governing body"},{"asset_class":"individual","name":"Jay Rothman","relevance":"high","symbol":"","type":"person"},{"asset_class":"institution","name":"University of Wisconsin System","relevance":"high","symbol":"","type":"institution"},{"asset_class":"political_group","name":"Republicans (Wisconsin)","relevance":"medium","symbol":"","type":"political group"},{"asset_class":"media","name":"Channel 3000","relevance":"low","symbol":"","type":"media outlet"},{"asset_class":"media","name":"Milwaukee Journal Sentinel","relevance":"low","symbol":"","type":"media outlet"},{"asset_class":"media","name":"The New York Times","relevance":"low","symbol":"","type":"media outlet"},{"asset_class":"organization","name":"Wisconsin Manufacturers & Commerce","relevance":"low","symbol":"","type":"organization"}],"event_type":"conflict","information_gaps":["The cleaned article text provided appears to be mostly HTML/CSS and does not include the substantive reporting details; only the provided source summary/headline were usable.","The exact vote count, date of the vote, and the stated reasons beyond refusal to quit are not present in the provided text.","Whether Rothman has an appeal process or interim replacement details are not included in the provided material."],"key_facts":["The UW System Board of Regents voted to fire system president Jay Rothman.","The firing followed Rothman\u2019s refusal to quit/resign.","The signal indicates Republicans called for regents to testify while Rothman was poised to lose his job."],"numeric_claims":[],"primary_claim":"The University of Wisconsin System Board of Regents voted to fire Jay Rothman after he refused to quit/resign.","relevance_score":0.72,"sentiment":"mixed","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 follows political pressure from Republicans as UW\u2019s president was poised to lose his job.","topics":["leadership change","university governance","board action","political pressure","personnel decision"]},"source":"Channel 3000","source_domain":"channel3000.com","source_url":"https://www.channel3000.com","summary":"Universities of Wisconsin board votes to fire system president after he refused to quit Channel 3000 Leader of University of Wisconsin System Is Fired by the Board The New York Times Universities of Wisconsin Board of Regents votes to fire Jay Rothman WISN 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","title":"Universities of Wisconsin board votes to fire system president after he refused to quit - Channel 3000","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 4358 in events